620
I have 1 sales order remaining in a batch that will not transfer to Invoice. The order comes via econnect with a CC deposit attached. Allocate and fulfill has been completed and when I try to transfer the batch, it shows '0 Transferred and 0 Errors'
Edit list doesn't show any errors. Customer record and inventory record (only 1 item) all look ok.
*This post is locked for comments
We ran reconcile and checklinks but could not get this fixed. Since it was only one transaction and it could not be duplicated or fixed, it was voided and recreated as an invoice.
Hello Dave, did you ever reach a resolution with your issue? We have the same open order issue where the order is open, but has been transferred to invoice and posted.
Was there a solution for the open order. I have this exact problem in GP 10 sp5 right now. Order was transferred to invoice and the order is still in open and the deposits did not go with the invoice. The invoice is posted and in history.
Hello Ryan
I would recommend you to try this check. Open the Sales Order in question and check the Master number by clicking the expansion button for the Order Number field.
In SQL Server, execute the following query on the SOP tables.
SELECT * FROM SOP10100 WHERE MSTRNMBR = XXX and ORIGNUMB = 'YYY' AND ORIGTYPE = 2
SELECT * FROM SOP30200 WHERE MSTRNMBR = XXX and ORIGNUMB = 'YYY' AND ORIGTYPE = 2
where XXX = Master Number and YYY = Order Number.
Check if the above query returns any results. If it does, it means the order was successfully transferred to another document.
This could happen if the order was initially transferred to an invoice without selecting the option "Transfer Totals and Deposits", which causes the order to still exist in the work table, and when you try to transfer this order again, you get the same message as you had mentioned and nothing would get transferred to an invoice.
Let us know if you need further assistance.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (