Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Inventory Value with 0 stock issue in Inventory Valuation Report

Posted on by 15

Hello Experts,

One of client is using Average Method to calculate their item cost, where Calculation Type is Item per Location per Variant.

pastedimage1646409069673v1.png

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.

pastedimage1646409406423v2.png

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?

pastedimage1646409541403v3.png

Can anyone please help me out, how we can fix this issue in Business Central?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    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 Profile Picture
    Dallefeld 11,423 User Group Leader on at
    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. Profile Picture
    Rahul. 15 on at
    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 Profile Picture
    Dallefeld 11,423 User Group Leader on at
    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. Profile Picture
    Rahul. 15 on at
    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.

    pastedimage1646753395599v1.png

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    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. Profile Picture
    Rahul. 15 on at
    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.

    pastedimage1646734741619v1.png

    Below Value Entries for Location 01 and same entries created for Location 02

    pastedimage1646734804751v2.png

    is there any other suggestion or assistance to fix this out?

  • Rahul. Profile Picture
    Rahul. 15 on at
    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 Profile Picture
    Dallefeld 11,423 User Group Leader on at
    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 Profile Picture
    MahGah 15,419 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans