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 AX (Archived)

Inventory Issue with AX 2012 R3

(0) ShareShare
ReportReport
Posted on by 105

Dear Team,

   We are facing an issue regarding the inventory and it is given below:

1). We have purchased some items from a vendor through purchase order and the product receipt is done in 2016, where as the invoice is done in 2017.

2). These materials are used in production and it is utilized in 2016.

3). In the costing sheet of the production, the cost for the raw materials are not updated.

4). Also in the Inventory value report the total cost for the raw materials is displayed with the amount which is created in the PO. But the quantity is deducted and the average cost is displayed based on this.

    Kindly need to know how can we move the value from Raw material to finished goods without changing the quantity. Expecting your solution asap.

Kind Regards,

Ramji M H

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Ramji M H

    Can you describe the underlying issue in more detail?

    You mentioned that the production order is not updated with the invoice raw material cost prices.

    - Are there price differences between the receipt and invoice price?

    - What is the status of your production order?

    - Have you run an inventory close/recalculation?

    About your inventory value Report

    - What item model valuation do you use for your raw materials (FIFO, LIFO,...)

    - Also here, has an inventory recalculation been done?

    When do you want to expect the adjustments to be recorded (2016 or 2017) and is your previous year still open?

    Best regards,

    Ludwig

  • Ramji M H Profile Picture
    105 on at

    Dear Mr.Ludwig,

      There is no price difference between the receipt and invoiced Price.

      Production order is ended.

      Inventory is not closed for 2016 and the recalculation is done till April 2017 by the implementer.

      Regarding Inventory Value report

      We are using Average model valuation for Raw Materials

      Inventory recalculation is done till April 2017.

      We need the adjustment to be recorded for the year 2016 and it is still open.

    Kind Regards,

    Ramji M H

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Hi Ramji,

    Which 'Average model'? One of the 'Weighted average' models, or the 'Moving average' model?

    If Weighted average, is 'Include physical value' ticked (on the Item model group)?

  • Ramji M H Profile Picture
    105 on at

    Dear Mr.Guy,

     We are using Weighted Average Model and it Include Physical Value ticked.

    Kind Regards,

    Ramji M H

  • Guy Terry Profile Picture
    28,924 Moderator on at

    To get the actual costs to flow through (according to the rules of the Weighted average model) you should financially update your orders and run Inventory close. This means Ending your production orders, Invoicing your Purchase and Sales orders and (normally) running Inventory close once per financial period.

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 AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans