x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 145 subscribers
  • Views 12577 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
Fungai Chirongo

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

SOLVED
Posted By

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

Parents
  • 0
    Hi
    Have you tried the stock resynchronization process (stock/utilities/stock resynchro and control) ?
    Enter the stock site / item code (if one single item has the problem) + tick the check box 'FIFO cost and stock control'

    " FIFO and stock price control: This function is used to control the coherence between the quantity expressed in the stock and the quantity indicated in the FIFO stack.

    Comparison of the STOCOST file with respect to the STOCK file.

    When an anomaly is discovered, the error must be manually corrected."
  • 0 in reply to AM74
    Hi AM74,

    Thanks for your response.

    I have tried the Stock Resynchronization and Control utility with all check boxes selected several times and the log file will display an error, "FT3 EC/WN: Stock Tables and FIFO cost Desynchronized STO:3 / STP:1". It tells me clearly that the Stock Tables and FIFO Cost are out of sync but I don't know how to resolve this. When you say that "the error must be manually corrected", what do you mean? Do you mean to say that the utility will not be able to fix the error for me so i would have to manually correct in the tables? I could have deleted the transaction and start all over, but the problem may come back on the second attempt. And in any case, the transaction has posted successfully and reduced stock from the selling company in the Sales module.

    Any more ideas?
Reply
  • 0 in reply to AM74
    Hi AM74,

    Thanks for your response.

    I have tried the Stock Resynchronization and Control utility with all check boxes selected several times and the log file will display an error, "FT3 EC/WN: Stock Tables and FIFO cost Desynchronized STO:3 / STP:1". It tells me clearly that the Stock Tables and FIFO Cost are out of sync but I don't know how to resolve this. When you say that "the error must be manually corrected", what do you mean? Do you mean to say that the utility will not be able to fix the error for me so i would have to manually correct in the tables? I could have deleted the transaction and start all over, but the problem may come back on the second attempt. And in any case, the transaction has posted successfully and reduced stock from the selling company in the Sales module.

    Any more ideas?
Children

*Community Hub is the new name for Sage City