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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Item cost showing high...
Microsoft Dynamics AX (Archived)

Item cost showing high after closing

(0) ShareShare
ReportReport
Posted on by ASHOK.MBA18 347

Dear All,

I am facing one issue related to item cost.

X item cost was as of march-18  qty: 850,486  AMOUNT: 3,727,632.23  COST PRICE:4.38

X item cost as of April -18  qty : 140,543 amount : 1,011,040.42  cost price 7.19

Suddenly increased in April month  even we did not received any quantity in April just consumption happens.

User has uploaded charges for march posted  invoice(after closed march inventory) in April date   30k something.

Is it effected any where or any other reason?

We closing inventory monthly wise.

please help me to solve this one.

Thanks and regards,

Ashok

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,398 Super User 2026 Season 1 on at

    Hi Ashok,

    If someone did post the invoice with charges, they could be related to the item cost as per misc. charges settings. The closing job will then indeed allocate these charges into the cost of items.

  • ASHOK.MBA18 Profile Picture
    ASHOK.MBA18 347 on at

    Hi André Arnaud de Calavon,

    He posted invoice in march then closed inventory for march but loaded charges in April  for that invoice.

    Thanks

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,398 Super User 2026 Season 1 on at

    Hi Ashok,

    Indeed. When charges were applied in April, it will recalculate those in April on the items received.

  • ASHOK.MBA18 Profile Picture
    ASHOK.MBA18 347 on at

    Hi,

    Actually they did not receive items in April.

    Thanks

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    It does not matter. if there are costs to apply to the inventory and Mar is closed, then those can only apply to the Apr inventory on hand  - which may be very little if you shipped most of it out in Mar.

    So you may then see a big cost increase, but presumably for few items.

    Over the two months, your total COGS should be correct- Mar was understated by those  misc charges (which might have been spread over more pieces /transactions if they had been posted in Mar).

    If your accountants are familiar with average cost, and have been using it previously, then this will be well understood. Unless you can do all financial postings in the same period, then this will be a recurring issue that happens in  he real world.

    It is usually only noticed as a 'problem' when those costs are unusually high, and invoices are unposted /not received at month end,  and the quantity of remaining inventory  at period end is low.  

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,398 Super User 2026 Season 1 on at

    I was not suggesting that you received items, but that the inventory closing could recalculate based on updated miscellaneous charges. Have you checked the charges posted and the cost increment during the settlements?

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
Harisgillani Profile Picture

Harisgillani 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans