web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Inventory zero, value non zero

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    Amol Salvi Profile Picture
    18,698 on at

    Hi Josep,

    Which costing method you are using ??

  • Community Member Profile Picture
    on at
  • Josep M Puigdollers Profile Picture
    on at

    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

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at

    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
    on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans