Stock Rounding

atesas
atesas Member Posts: 10
edited 2001-01-05 in Navision Financials
We have a problem with the Navision Inventory. If you sell all the goods on your stock there is still a value for this item.
The customer has FIFO installed. Even if you do all the Batch jobs there is no change to remove the value or set it to zero which is supposed to be the correct value.

Pls. help

Thanks

Alexander Tesas

Comments

  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    Did you run the "Adjust Cost - Item entries" batch from General Ledger, Periodic Activities? This batch should balance out differences in cost-price.

    John
  • atesas
    atesas Member Posts: 10
    Yes we did all that periodic stuff. But the Article has still a value on stock
  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    Did you do Navigate and drilldown on the item to get the overview of Item Ledger Entries? This should give you insight on which entry isn't balanced. Then you should make a journal entry to correct the value.

    John
  • atesas
    atesas Member Posts: 10
    Is there no other possibility? This affects 10.000 articles!
    I do not understand, why the item still has a value on stock.
  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    Did you trace back *why* the items have a left over value? Is it a signficant amount? Can it be rounding differences only? Has somebody changed code (the posting routines?) perhaps? Something must have been done off standard, otherwise there would not be a remainder amount.

    John
  • atesas
    atesas Member Posts: 10
    I suggested the same!
    The problem is the rounding differences (not only but mostly).
    But I found no possibility to adjust the rounding correctly.
    The chief accountant changed the posting groups one time without asking for the consequences. But that only affects the General Ledger not the Item Granule.
  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    Well, if it concerns a few cents rounding differences per item only, I would suggest for now to make a one-time batch report that takes the remainder amount and then creates an item-journal line to balance it off against the "rounding differences G/L acount".

    To prevent future troubles, you will have to analyze the methods of posting used by the customer and get the real cause of the differences to surface.

    John

Categories