Small and medium business | Business Central, N...

Inventory Value with 0 stock issue in Inventory Valuation Report

(0) Share

Report

Posted on by Rahul.

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?

All responses (18)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

[quote user="Rahul."]
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.
Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

Did you run Adjust Cost after making your item journal entries? If so, then contact your partner for assistance.
Rahul. 15 on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

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!!!!
Dallefeld 11,425 User Group Leader on at

Like (1)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

It seems that you fall into the issue of needing data programmatically edited.
Rahul. 15 on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

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.
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

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.
Rahul. 15 on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

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?
Rahul. 15 on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

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..
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (1)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

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
Suggested answer

MahGah 15,428 on at

Like (0)

Report

RE: Inventory Value with 0 stock issue in Inventory Valuation Report

Hi

I see this tread that basically cover the same concept. Can you look into it. So far I could not find any method (except the one suggested in below article which seems like did not work) to fix this.

Maybe or TeddyH or Dallefeld or NorthW or JAngle have some method to fix this

www.navug.com/.../viewthread