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?

I have the same question (0)

All responses (18)

Answers (0)

MahGah 15,529 on at

Like (0)

Report

Hi

This is a rare possibility but my quick question. When you run Adjust Cost Item Batch did you have enough allowable posting date in your general ledger to cover all invoices/activates. I mean if you allowable posting date was between 9/1..9/30 but you had invoice for 8/1 then you get inventory 0 for 8/1..8/30 inv valuation but negative value because Adjust Cost Item Batch could not post on 8/1.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Run the Inventory valuation report with a breakdown by location. What you might see is posi.tive entries in one location that offset a negative entry in another location. Corrections then for each location.

Was this reply helpful? Yes No
Rahul. 15 on at

Like (0)

Report

Thanks for your response Dallefeld. There are few items that show +ve and -ve inventory value, when report breakdown by location. How can I fix these value for both locations?

Was this reply helpful? Yes No
Rahul. 15 on at

Like (0)

Report

Thanks MahGah. How this can be fixed, if entries fall in off set dates?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Have you runned the "Post Inventory Cost to G/L" batch job recently?

Was this reply helpful? Yes No
Rahul. 15 on at

Like (0)

Report

No, it run on regular interval on every transaction post.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi Rahul

What is going to happen if you run the Inv Valuation for current date? Are they still negative?

What is going to happen if you expand your G/L posting date range then run Adjust Cost - Item Entries again?

Was this reply helpful? Yes No
Rahul. 15 on at

Like (0)

Report

Hi MahGah

For your 1st Q's : Yes, the values are still negative.

For 2ns Q's, I have expanded Allow Posting Date from 01/01/2021 and run Adjust Cost - Item Entries Batch, but there is no new adjustments are made and appear in the results.

Most of impacted entries are in 2021 year that lead to show the remaining inventory value with 0 stock...

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

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

Was this reply helpful? Yes No