This is a fault with the stored procedure usp_Jiwa_GetBackOrderProcessList and the final query to return the list of backorders to process.
🤔 Problem
Process Back Orders database is not working for Warehouse Transfers. This is due to debtor being flagged as “On Hold”.
🌱 Solution
| Panel |
|---|
| panelIconId | atlassian-warning |
|---|
| panelIcon | :warning: |
|---|
| bgColor | #FFEBE6 |
|---|
|
Advanced SQL Server programming skills are required to complete this task. |
Script for 7.2.1 to work-around the issue. Download and run the attached script to update the required stored procedure.
| View file |
|---|
| name | usp_Jiwa_GetBackOrderProcessList_DEV-9780_7.2.1.sql |
|---|
|
Related articles
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 91fbcd9b-5d0b-3b97-a585-1a06ec62a231 |
|---|
| key | DEV-9780 |
|---|
|
...