How do I resolve the "Stock Tables and FIFO cost Desynchronized" Error?

SOLVED

Can anyone please help me solve the following error when posting an inter-company Purchase Invoice in Sage ERP X3 v6.5 Patch 20.

The error message reads, "FT3 EC/WN: Stock Tables and FIFO cost Desynchronized ITV:3 / STP:1, FT31504PIH00000059 17000 EC/WN Error on the adjustment of the prices! (9)". The error highlights line 17 whose product is EC/WN. I decided to start by running the Stock Resynchronization and Control utility which produced another error as follows; "FT3 EC/WN: Stock Tables and FIFO cost Desynchronized STO:3 / STP:1". I ran this utility several times, but the error persisted.

The Sales side of this inter-company transaction posted with no errors. The valuation method in use is STD - Standard Cost whose "Adjustment of issue prices" option is set to No, and cannot be changed to Yes. Modifying the prices on the Purchase Invoice will put the document to Suspend status and would not be posted. I am at a loss as to how else i can get this transaction posted.

Any help is welcome.

Top Replies