Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

FIFO COSTING METHOD

(1) ShareShare
ReportReport
Posted on by 160

Dear All,

Can someone answer if an item having a FIFO costing method will always suggest a the first Unit Cost at the sales entry regardless if I have succeeding purchases with different unit costs and it will just adjust the correct cost based on FIFO concept once Adjust Cost-Item Entries batch job is run?

YES OR NO?

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FIFO COSTING METHOD

    i guess yes,

    because the  operation  of Adjuste Cost-Item Entries  begin  from the last Adjuste date.

    for more information use this link :  

    bousaid-comptabilite.blogspot.com/.../adjust-cost-item-entries-batch-job.html

  • Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: FIFO COSTING METHOD

    Hi Angelito

    Hope below link will help you to understand the FIFO and other Costing Methods how they are calculate on NAV

    Design Details: Costing Methods https://msdn.microsoft.com/en-us/library/hh997373(v=nav.90).aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FIFO COSTING METHOD

    HI Alexander,

    Understood and I already check this.

    Thanks for your response.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: FIFO COSTING METHOD

    Actually, the job that adjusts the cost of items updates both purchasing entries and sales entries if the item already has been sold. That is, the G/L entries of cost of goods sold, made when you have posted the sales invoice, will be also adjusted. Related Value Entries are also updated.

    However in the posted sales invoice there is mainly information about sales price, but not the cost, thus it is nothing to adjust.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FIFO COSTING METHOD

    Hi Mahesh,

    Good point.

    Why NAV don´t update the G/L entries in the sales documents, are the G/L entries of the sale correctly posted?

    Is this because is designed as is or is there any other reason.

    Thank you and best regards!

  • mmv Profile Picture
    mmv 11,465 on at
    RE: FIFO COSTING METHOD

    Hi,

    No, not in the Sales Invoice Document.

  • algeloca Profile Picture
    algeloca 160 on at
    RE: FIFO COSTING METHOD

    "Once you run this batch job, system will update the Unit Cost at the Item Card and accordingly will update the latest updated unit cost at the sales entries."

    - The update pertains to the value entries or sales invoice document?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FIFO COSTING METHOD

    NO.

    You need to run the Adjust Cost Item Entries batch job on daily basis. Once you run this batch job, system will update the Unit Cost at the Item Card and accordingly will update the latest updated unit cost at the sales entries.

    However, please note that, if you are using LS retail, you need to run the JOB to replicate the latest Unit Cost to your stores, to have updated Unit Cost in store database as well.

    Hope this helps.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans