You’re offline. This is a read only version of the page.
470
Hello,
I have a backorder that I need to transfer to an Order. When the backorder was created, the backorder document type was not setup yet to allow transfer to Order. I did the setup after the back order has already been created. There is enough quantity available for the item and I have changed the Qty to Order to the qty I want to transfer to order which is the original back order qty. When I transfer, it doesn't create the order. I cannot delete the back order because I don't want to break the history as there are a lot of transfers that happened to this document already.
When I did this in Test and deleted the back order, then I changed the setup to allow transfer to order after that I created the back order again. I was able to transfer the back order to order without issues.
My question is, is there anything I need to update on my back order so I can transfer successfully to an invoice? Since in Production, I have the backorder created first then the back order setup was changed to allow transfer to order.
Your response is appreciated. Thanks!
*This post is locked for comments
HRF,
While creating the back order the setup details will be updated to the SOP header and line table based on the SOP setup in GP. If we change the setting after the order has been created, the SOP header and line details for the setup won't update. So, for your case you need to update the setup values to the header level and also need to verify the fields Back Order Qty & Qty to Order.
To resolve your issue, run the below code against to your company database in SQL.
SELECT USDOCID1,USDOCID2 FROM SOP10100 WHERE SOPTYPE = 5 AND SOPNUMBE = 'Enter your SOP number for the Backorder'
Run the below query if the above query return null value for the first two columns.
UPDATE SOP10100 SET USDOCID1 = 'XXXXX' , USDOCID2='YYYYY' WHERE SOPTYPE = 5 AND SOPNUMBE = 'Enter your SOP number for the Backorder'
Note:
XXXXX - Document ID for Transfer Back Order to Order in SOP Back Order setup window.
YYYYY - Document ID for Transfer Back Order to Invoice in SOP Back Order setup window.
After running the above query, verify the "Back Order Qty" & "Qty to Order" fields are having the same values.
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
