You’re offline. This is a read only version of the page.
218
Dear Team,
How to Match Difference between 'Inventory Valuation Report' and 'stock Value Ledger' for an Item.
We are running 'Adjust Cost Item Entries' at the end of every month; and there is '0' Quantity of the item available at 'end of the month'
but
Valuation Report showing Qty as '0' and Value as 344
and
Stock Value ledger is showing closing value as 19,21,122.
All reports are processed for same period i.e. Last date of the month on which 'Adjust Cost Item Entries' was processed.
How to troubleshoot this error plz guide.
Best Regards,
Ashish
*This post is locked for comments
Thanks Roberts
Thanks paras mehan for your help.
I got a solution.
Costing Error Detection and Data Correction White Paper for Microsoft Dynamics NAV
It contains a program which will help you to identify the entries with errors.
It a good tool.
Plz check following link
Hi,
this is theoretically possible. Let's go through one of those possible scenarios (not saying that is exactly what happened, but it's just to illustrate how it can be 0 quantity with value). You have purchased goods for 1000 in January, so system puts expected value as 1000. The you have sold it in January, so system records 1000 as COGS and now the quantity is 0.
If you run Cost Adjustment at the end of the month, it will do nothing in this scenario. Then in the beginning of February, you have received the invoice for purchased goods, that was 1344, instead of 1000. Posting such invoice would increase the value of purchased stock, but will not increase the value goods sold until you run cost adjustment.
So, when you run the Stock Valuation report, it will show quantity 0, with remaining value for January.
Now, when you run Cost Adjustment for February (let's assume you haven't purchased that particular item in February), because January is closed, system will post adjustment in February, meaning that your February Stock valuation will show quantity = 0, and value = -344. Running 2 month stock valuation, will show zero quantity and zero value.
If that is something that happened in your case, not much can be done without changing figures of January/February. Going forward you need to make sure that Cost adjustment is run before closing the period, rather than at the end of the month.
Hope that helps.
Robertas
is location is mandatory for you? do you have some entries without location ?
Even take the one item and check if there(-or+) value showing also for location.
OK Thanks
this is when you calculate the inventory value, to create the revaluation journal. The error message is NAV-speak for "you have negative inventory on an item, probably by variant code, and by location code".
The only possible resolution is to not have negative stock on any item (by variant code, by location code). Negative stock breaks the valuation chains.
Hi Paras,
In Application Work sheet an Open Outbound Entry 19XXXXXX found for the same item.
how to post or treat that Open Outbound Entry.
In line please mention date, Document no., item no., apply to entry(Item Ledger entry page will open. please select any entry from that page for related period ).
Then in line do changes according to your difference amount and post.
After this please run 1001 report. i hope this will balanced.
In Revaluation General -> On Header -> in Process Group -> by pressing 'Calculate Inventory Value’ Button -> on window ‘Edit - Calculate Inventory Value’ after providing required Item information & pressing OK button->
System shows following Error:
Open Outbound Entry 19XXXXXX found.
at the time of posting ?
system shows following error:
Open Outbound Entry 19XXXXXX found.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (