Hello,
Looking for some answers to how I might chase down this issue. The Inventory Valuation report shows amounts remaining for three items that have a zero remaining quantity and a zero unit cost. Two of the amounts are for negative 1 cent. See attachment.
Any suggestions for figuring out how to fix this will be very much appreciated. Thank you.
*This post is locked for comments
After trying several adjustment options, the answer was in the fact that running the Inventory Valuation report with the current date now shows the inventory value back at zero for all three items. The original issue was that it did not show this as of the date at the end of the year. This means that there was a Cost Adjustment Value Entry that cleared the value correctly, but was posted after the period end date. So in effect, this was a timing issue.
I learned the following:
"If the Allow Posting From Date in G/L Setup is set to 01/01/2017 shortly after 12/31/2016 and before Adjust Cost Item Entries is run for all cost changes, the system will use the first available Posting Date after the close, which would for example be 1/1/2017."
have you try the Rounding Method ?
Hi Alex
Mainly I have noticed Valuation problem due to expected Cost & Multilocation transactions those not closed properly as I have explained in my suggested link.
if you to go to you item card then select the Item no. "HB50C" then click on the below item button and select Etnies & Value Entry just export those entries to excel and share it via dropbox then I'll let you know where is the problem and how to correct it.
or you can check the same and find out from which transaction the value remaining on the valuation report.
if you have gone through all my reply on the provided link I hope you could solve the problem but I think only you have gone through my last reply on that thread.
In this community lot of people don't do verification on the answer even if the got the right solution instead they start with one question and once that is loved they come up with may sub question and later on, they don't verify any suggestion.
Thanks
Indika
Indika, I tested your suggestion as found on the bottom of that other post, but it did not alter the value as shown on the Inventory Valuation Report. Is there a verified solution for this?
Hi Maneesha, are you talking about the 'Adjust Cost Item Entries'?
Just do the cost adjustment that's it :)
Hi Alex
Hope Below link will help you wich already have discussed the same issue.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156