GL Inconsistency error for Inv Cost Post to GL

gemini_shooter

Hello all,

I am trying to solve a GL consistency error I am getting in a setup. Inventory Costing is has never been my cup of tea but I am stuck with it :-)

Item is set to FIFO cost

So here is the story
-- A purchase invoice was posted with unit cost of 28.385 with a quantity of 2 and line amount on the Purch line is 56.77
-- A second purchase invoice was posted with unit cost of 28.385 with a quantity of 2 and line amount on the Purch line is 56.77

-- One of the above item was sold for $30

-- A transfer is the 2 quantity is being made from one location to another and ends up recording a value entry change based on the new location when the warehouse shipment is shipped but gives a GL Inconsistency error

The entry produced overall is balanced
DR 28.38
DR 28.38
CR 56.77
CR 0.01
DR 0.01
DR 0.01

The sum of the above is zero but I believe the value entry posted to GL is processed in two layers which is causing trouble

Codeunit 5802 --> PostInvtPostBuf which then calls Codeunit 12 and starts the calculations for BalanceCheckAmount and BalanceCheckAmount2

However, at somewhere in the middle they are zeroed out and start the next layer; and and even though the above entry balances the balance check fails.

My questions are

--what is the best way to handle the 3 decimal cost and to avoid this?
--How does NAV handle the same scenario if a charge was applied across two invoices or cost layers, why doesn't it error out then, why in this case when I cross over from one invoice to another?

Sorry for the big story, but I am trying to understand and solve this problem, all comments appreciated.

davmac1

in g/l setup, do you have your inv. and app. rounding set to .01?

gemini_shooter

Yes both are st to .01

davmac1

Rashed had a post years ago about troubleshooting consistency problems.

http://www.mibuso.com/forum/viewtopic.php?f=5&t=22748

mgmutha

Hi Gameni,

Have you got the solution for the above issue. Because i am also facing same issue during posting Transfer Order Shipment.

vrushank

Comment the following line of code in codeunit 5802 :

PostTransferProfit(ValueEntry,DocNo,GenJnlLine.Description,"Dimension Entry No.");

The above line of code generates an additional unrealized profit line of 0.01 thus causing the inconsistency.