dynamicsusers: Why you have Negative Inventory Value – Navision 3.7b to Navision 4.0 SP3

[Blog bot]

Here are a couple of reasons why you would get inventory value if you have 0 quantities when you print Inventory Valuation report and Inventory to G/L Reconcile report as of a certain date.




Scenario 1:
If the adjust cost is processed on 7/31/07, and the Allow Posting From was 7/1/07 on General Ledger Setup, the following would occur:


6/15/07 - Purchase Receipt - $10


6/28/07 - Ship and Invoice - $10


7/15/07 - Purchase Invoice - $12


7/31/07 - Additional Cost for the sale made on 6/28/07 - $2


In this case, when you print the inventory valuation as of 6/30/07, the inventory quantity would be 0 and the inventory value would be 0.




Scenario 2:
If the adjust cost is processed on 7/31/07, and the Allow Posting From was 6/1/07 on General Ledger Setup, the following would occur:


6/15/07 - Purchase Receipt - $10


6/28/07 - Ship and Invoice - $10


7/15/07 - Purchase Invoice - $12


6/28/07 - Additional Cost for the sale made on 6/28/07 - $2


In this case, when you print the inventory valuation as of 6/30/07, the inventory quantity would be 0 and the inventory value would be -$2.00.


Explaination


Navision will automatically post the additional cost to the original invoicing entry because that’s where the cost originally applies to. If Navision detects that the Allow Posting From is before the adjusting date, then it will use whatever the Posting Date is when the adjust cost is ran.




Scenario 3:
If the adjust cost is processed on 8/31/07, and the Allow Posting From was 7/1/07 on General Ledger Setup, the following would occur:


6/15/07 - Purchase Receipt - $10


6/28/07 - Ship and Invoice - $10


7/15/07 - Purchase Invoice - $12


8/31/07 - Additional Cost for the sale made on 6/28/07 - $2


In this case, when you print the inventory valuation as of 6/30/07, the inventory quantity would be 0 and the inventory value would be 0. When you print the inventory valuation as of 7/31/07, the inventory quantity would be 0, but the inventory value would be $2.00.


Explaination


Navision will automatically post the additional cost to the original invoicing entry because that’s where the cost originally applies to. If Navision detects that the Allow Posting From is before the adjusting date, then it will use whatever the Posting Date is when the adjust cost is ran. In this example, since the Adjust Cost process posting date is 8/31/07, it will use this date as the Posting Date for the adjusting entry.






Подробнее... http://dynamicsuser.net/blogs/alexchow/arc...vision-5-0.aspx