Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Inventory zero, value ...
Microsoft Dynamics NAV (Archived)

Inventory zero, value non zero

(0) ShareShare
ReportReport
Posted on by Josep M Puigdollers

Hi everybody,

I've got a zero inventory with value non zero.

To get this:

1 of june: a purchase order reception. Product cost= 100€

15 of june:  a sale delivery. Sales cost: -100

10 of july: purchase invoice. Product cost = 110

after running report 795, adjust cost item-entries,  there is a new value entry:

15 of june: sales cost adjust value= -10

The inventory valuation at 30 of june shows inventory 0 and value -10.

Why the report 795 fixes the posting date of the new value entry to the sales delivery posting date and not to the purchase invoice posting date?

If the inventory period was closed at 30 of june, the posting date of the new sales cost is the first of july. The inventory valuation still shows negative values until 9 of july.

using NAV2016

Josep M

*This post is locked for comments

  • Josep M Puigdollers Profile Picture
    Josep M Puigdollers on at
    RE: Inventory zero, value non zero

    Hi Alexander

    There's only one purchase: Item reception (without invoice), on 1 june 2016 and purchase invoice on 15 July 2016 and only one sales shipment on 15 june 2016.

    Item Ledger entry:

    Posting Date Entry Type Document Type Qty Invoiced Qty Cost Amount (actual) Item Item ledger entry No.
    1-June-2016 Purchase Purchase Receipt 1 1 138,90 1908-S 339
    15-June-2016 Sale Sales Shipment -1 -1 -138,90 1908-S 340

    Value Entries

    Posting Date Valuation Date Item ledger entry type Entry Type Document Type Cost Amount expected Cost amount (actual) ItemLedger Qty Item ledger entry No.

    Entry No.
    01-june-2016 01-June-2016 Purchase Direct Cost Purchase receipt 148,90 0 1 339 404
    15-june-2016 15-june-2016 Sale Direct Cost Sales Invoice -148,90 -1 340 405
    15-june-2016 15-june-2016 Sale Direct cost Sales invoice -10 0 340 407
    01-July-2016 01-june-2016 Purchase Direct cost Purchase invoice -148,90 158,90 0 339 406

    Th problem it the Value entry No. 407. This entry is created by same process thar inserts entry no. 406 on 1-July-206 but its Posting Date is 15-june-2016 

    JM

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Inventory zero, value non zero

    What are the quantities you are using in your sample? Also, your sample is incomplete - can you post the other sales transactions and their dates, as you had made two purchases and one sale and then refer to 0 inventory.

  • Josep M Puigdollers Profile Picture
    Josep M Puigdollers on at
    RE: Inventory zero, value non zero

    Hi Amol,

    I'm using FIFO as costing method. Tested in a CRONUS company using  Item code: 1908-S, as is. (Spanish localization)

    BR

    Josep

  • Community Member Profile Picture
    Community Member on at
    RE: Inventory zero, value non zero
  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,696 on at
    RE: Inventory zero, value non zero

    Hi Josep,

    Which costing method you are using ??

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans