Announcements
Hello Experts,
One of client is using Average Method to calculate their item cost, where Calculation Type is Item per Location per Variant.
So, when we run Inventory Valuation report for month end/or by location code, system show an inventory value, even though stock = 0. I have already executed Adjust Cost Item Batch and make some +ve and -ve adjustments to drill down an issue, but there is NO GOOD LUCK. System process the entries and come up with more differences.
Also, when I looked in TAB5804 - Avg. Cost. Adjmt. Entry Point, it show me details with item wise and marked as adjusted.
is it advisable to delete the table content and re-execute Adjust Cost Item Batch again?
Can anyone please help me out, how we can fix this issue in Business Central?
No, it run on regular interval on every transaction post.
[/quote]You should still run it manually on a regular basis to be on the safe side.
Did you run Adjust Cost after making your item journal entries? If so, then contact your partner for assistance.
hmmm ok.. can you advice on it? or share expected program to design and what need to be edited?
Appreciate your help and inputs shared so far!!!!
It seems that you fall into the issue of needing data programmatically edited.
Yes Kim Dallefeld , I have selected positive entry in my Applies to Field, when I make negative adjustment through Item Journal.
Below is snapshot of applied entry with negative ILE.
Did you use the Applies-to field in the item journal? When this does not work, it generally takes programmatical fix. The steps that I gave you came directly from Microsoft and I've used them a number of times. Most of the time it's simple and it works but when it doesn't, I have another set of steps to edit data.
Hi Dallefeld / Kim Dallefeld
Above suggested corrections are not working and after +ve and -ve adjustment, it give me same figures.
Below Value Entries for Location 01 and same entries created for Location 02
is there any other suggestion or assistance to fix this out?
Hi,
Yes, I already went to the above link and followed the steps.. It does not work in step 3 and come up with negative unit cost on Item Card..
You will need to enter a positive item journal line to location with the negative value using the 415.04 (from your example) and quantity of 1. Post it. Then do a negative item journal using zero cost and quantity of 1 and make sure that you apply your negative entry to the positive entry in the journal.
For the location with the positive value; a positive entry (quantity one) for zero dollar. Post it, then enter a negative quantity one for 415.04 and post applying to the positive entry
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156