"Sales document was in use and couldn't be updated. Please perform the sales reconcile to update quantities and/or costs."

(0) Share

Report

Posted on by Community Member

Hi! We have Drop-Ship Purchase Orders committed to sales order. We have fully received the items in PO but when trying to transfer the sales order committed to that purchase order, we CANNOT transfer the SALES ORDER to INVOICE. We got "0 Error(s) during transfer" "0 Document(s) transferred successfully" in SOP Transfer Log.

I tried to run the script: select QUANTITY, QTYORDER, QTYPRINV, * from SOP10200 where SOPNUMBE = 'XXX'

**Where XXX is the SOP Order document number.

This gave me the results:

A.) Sales Order 1

Qty: QtyOrder QtyPrinv

2 0 0

6 0 0

2 0 0

B.) Sales Order 2

Qty QtyOrder QtyPrinv

1 0 0

But haven't try yet to reconcile sales document.

What could be done and what is the reason behind this?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Richard Whaley 25,195 on at

Like (0)

Report

RE: "Sales document was in use and couldn't be updated. Please perform the sales reconcile to update quantities and/or costs."

How were the POs created? Automatically from the SOP Purchase option link or manually and then committed to the SO?

How was the receipt performed?

If you look at other (still open) Drop Ship POs committed to SOs, do you see a link between the PO and the SO on the Sales Transaction Entry window (or the inquiry) and also on the matching PO windows?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: "Sales document was in use and couldn't be updated. Please perform the sales reconcile to update quantities and/or costs."

Hi Richard!

Thanks for the feedback! I believe for both POs created from the SOP Purchase option link since the sales order used were also linked to quote. But the first sales order, there are 4 items. First 2 items were originally from issued quote and then the other 2 remaining items were just added manually to that sales order.

For receiving the PO, my colleague who currently do that, she used "Receive & Invoice Items".

For additional info., we issued the PO in RMB (Yen). Sales order in US Dollars then just assigned each items the RMB Currency.

Thanks!

Was this reply helpful? Yes No
Suggested answer

Josh P 2,895 on at

Like (0)

Report

RE: "Sales document was in use and couldn't be updated. Please perform the sales reconcile to update quantities and/or costs."

You receipted the PO which creates the AP transaction, but did you post the AP transaction, or is it sitting in a batch?

Also, make sure the PO and the AP Transaction's windows are both closed when moving them to an invoice.

Was this reply helpful? Yes No