Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Automatic cost posting...
Microsoft Dynamics NAV (Archived)

Automatic cost posting to GL

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

One of my client using Costing method as FIFO. in inventory cost setup automatic cost set up is not "ticked". They are not running the "inventory cost post to GL" report .so at the time of issuing (in item journal unit cost is calculated as average method) and in the inventory valuation report stock value is not correct 

But after running the "inventory cost post to GL" and Adjust cost item entries the unit cost and stock value are comming correctly .

but my client is saying we cant run the report "inventory cost post to GL" and and Adjust cost item entries every time .. we want the unit cost to be picked as per FIFO methodology while issuing item (in item journal)

I have given suggestion as (I will enable the Automatic cost posting to yes and automatic cost adjustment as always ) 

Will it solve my problem ?? or still i need to run the reports. after enabling the tick mark (Automatic cost posting to yes and automatic cost adjustment as always ) 

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Automatic cost posting to GL

    I support other members here - to setup the job on periodical basis, e.g. every night.

  • Suggested answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: Automatic cost posting to GL

    Please find related info here www.archerpoint.com/.../effects-inventory-setup-microsoft-dynamics-nav

    My suggestion is to setup automatic cost posting as periodic night activity

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automatic cost posting to GL

    hi,

    i could'nt able to enable the "Automatic cost post " in inventoy set up.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Automatic cost posting to GL

    If it is not run for previous year then you need to run it .It will take time based on your entries to be adjusted

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Automatic cost posting to GL

    You mean to say you have not run it for a year !

    My suggestion would be to take a fresh backup and restore it as test cost entries and run the Inventory cost post to GL in test database, see how much time it takes.

    If it posts successfully then check all the entries and accordingly do it in production server.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automatic cost posting to GL

    hi ,

    From this year i will check the tick mark . but for previous year posting (Weather i need to run the Inventory cost post to GL and Adjust item cost entries for all the Items?

    can you explain how to put this in job queue .

    Help is highly appreciated.

    Thank you.

  • Verified answer
    ManishS Profile Picture
    ManishS 6,578 on at
    RE: Automatic cost posting to GL

    Just enabling will take care, but it will slow down the system.

    We suggest put this in Job Queue and let it run via there in mid night every day.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans