Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Inventory Type and Posting setup

Posted on by

Dear All,

I am still learning NAV since its new to me.  My situation as follows on the new company.  All inventory items has been setup as Average and unticked with post to GL on items setup.  This is the first month after migration and posting done on production order and received items on purchase orders for first 3 weeks and at the moment we wanted to change the inventory type from average to FIFO and tick the box post to GL automatically.  Can you please let me know what will be implication if we do this now or suggest me the best way to achieve what we want.

*This post is locked for comments

  • RE: Inventory Type and Posting setup

    Hi Alex,

    Thanks for your kind reply, I will check the same and get back to you.

    I have a question in Production order costing.  While posting the production order following will happen.

    1) Material issued to the job and once job closed the total cost either average or FIFO will be calculated for this order

    2) Labor hours booked on the production journal.

    Depending on the rate of labor it will calculate total labor cost for the order.  How does NAV account if the direct labor is vary each month to capture the correct cost (please note that the actual direct labor cost will be calculated by payroll only at month end).  Also how does nave add the Burden cost in to the production order.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Inventory Type and Posting setup

    Please check this references:

    msdn.microsoft.com/.../hh168260%28v=nav.90%29.aspx;MSPPError=-2147217396

    msdn.microsoft.com/.../hh169387(v=nav.90).aspx

    If you have not ticked the posting option, you need to run the batch job for having that posted. The batch job will process only those transactions that have not yet been posted.

  • RE: Inventory Type and Posting setup

    Thank you very much for your kind reply Alex.  I will try one of this option and let you know.  Regarding ticking the posting to GL is doesn't have any implications can I do that now so that when I post production order it will get post to GL also.  But not sure what will happen to the production order which is already closed.

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Inventory Type and Posting setup

    If you have already entries posted with an item, you will not be able to switch it from Average to FIFO, the system will prevent this. One option is to wait until the ending quantity will be zeroed and you will close this item card and create a new one with FIFO costing method. If you want to change method for an item that still has quantity, you can create a new item card, write-off all the quantity to technical account to zero the quantity of old item, and receive the same quantity of item from this technical account to your new item card.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans