You’re offline. This is a read only version of the page.
3,945
Hi Friends,
I have some issue in my inventory value, as after recalculation i found some difference in the GL and module. Also i found after recalculation of the inventory some items have negative and positive amount against the quantity zero.
So i believe we have to make the amount zero for those items, As i have gone through some blogs and posts. Here i am taking the example of 1 item:
Inventory Value before recalculation
Inventory Value After Recalculation
Now when i go to the adjustment form from the "Closing and adjustment", i found the below form:
So how i will update the amount so that the amount for the item will be zero and by what amount as per the screen shots attached.
Please advise..
*This post is locked for comments
Hi Ludwig,
Can you please tell me what cost price i have to put while passing the +1 and -1 qty journals.
HI Imran,
Ok, if this did not work can you test
(a) posting +1 item no. 90311021 in a counting Journal
(b) posting -1 item no. 90311021 in a counting Journal
(c) do the recalculation again.
If (a)-(c) do not make a different, can you then run the potential conflicts report filtered for item 90311021 to make it run fast in order to see what error/warning message you get?
Many thanks,
Ludwig
Hi Ludwig,
I tried with the zero qty and zero cost, also with the zero qty and negative cost amount (refer the screenshot), but it didn't create any journal (Blank). Also i recalculate the inventory but no effect.
Hello Imran,
Do you have a test environment with comparable data that you showed above available?
If this is the case, please test to post a counting Journal with a counting quantity of 0.
This should be possible even if you have currently 0 on stock.
Before posting the journal please the the other tabs and the prices that you see and once that is done, please run an inventory recalculation.
It worked in my demo environment and it would be great if you could double check whether this also works for you.
Best regards,
Ludwig
Hi Ludwig,
But in this case my inventory count will increase by at least 1.
Hi Imran,
I understand your comment. Yet, probably just try to test in a demo environment posting a counting journal with a qty + price of $0. If you run the recalculation thereafter, your value should go down to $0.
Best regards,
Ludwig
Hi Ludwig,
My Inventory for this item is already zero, only problem with the value. In the inventory value report qty shows zero but with amount.
Hi Imran,
Ok, if this does not work, have you tried posting an item counting journal?
If you post it with a qty of 0 and run an inventory recalculation you should be able to bring down the financial values to $0.
Would be great if you could test this and let us know if this resolved your issue.
Best regards,
Ludwig
Hi Ludwig,
After recalculation "On Hand" option was grayed, so i close the inventory and then "on hand" option enabled. Then i went to Adjustment-On hand for and select my item and following form open, there i tries to enter the value but it is disabled.
And when tries to enter zero the amount or value from the Adjustment button on "On Hand" form getting the following message
"Current on-hand inventory value must be positive."
Please guide
Hi Imran,
In the closing and adjustment form that you show above, select your item and then select adjustment-on hand.
Enter the new value (of $0) and post the transaction.
Then run the inventory value report again.
If you have not done this before, please test it in a demo/test environment before doing this in Live.
Best regards,
Ludwig
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (