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)

Active new STD cost and inventory revaluation

(0) ShareShare
ReportReport
Posted on by

I have 1 item with "Standard Cost" that has many transactions from Mar,16

Then I update new active cost from 5.52 > 11.75 on May,16

Then I got new vouchers (Revaluation voucher and Receipt costing voucher) 

and auto settlement with original transaction. I think that is about Inventory revaluation

But I checked some transaction was settlement with new voucher(new cost price), same transaction was not.

Then I cannot group it how system selected transaction for settlement.

 

And another point I got vouchers with 'Rounding variance' posting type.

But I cannot find transactions that matched with this voucher.

My voucher transactions

Ledger account Posting type Amount in transaction currency Amount
7111401-S110---500-90-- Purchase, inventory receipt                          398,720.00      398,720.00
7111401-S110---500-90-- Product receipt                          218,050.00      218,050.00
9999999-- Rounding variance                         (218,050.00)     (218,050.00)
9999999-S110-500 Inventory cost revaluation                      (2,055,900.00)  (2,055,900.00)
9999999-S110-500 Production receipt                           80,990.00       80,990.00
9999999-S110-500 Inventory, inventory receipt                       1,358,140.00   1,358,140.00
9999999-S110-500 Rounding variance                          218,050.00      218,050.00
9999999-S110-500 Order packing slip                      (1,520,120.00)  (1,520,120.00)
9999999-S110-500 Order offset account packing slip                       1,520,120.00   1,520,120.00

I cannot find relation with rounding variance and how system selected transaction to settlement with voucher when active new cost price for standard cost

Thank you

*This post is locked for comments

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

    Hi,

    Does the following statement apply to your AX-system?

    KB 3029918Standard cost revaluation results in erroneous rounding variance postings when you use the Site Inventory/Financial dimension link

    In other words, have you activted the site inventory/financial dimension link?

    Ludwig

  • Community Member Profile Picture
    on at

    Sorry, I am quite not unserstand but all these transaction apply automatically to my AX-system when I active new cost price for standard cost item.

  • Community Member Profile Picture
    on at

    I checked dimension link and that is Inactive. I never touch this function

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi, can you check on LCS (fix.lcs.dynamics.com/) whether this Problem has already been reported before and whether a hotfix has already been provided? To me it sounds like a bug. Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    How was this issue resolved?  We are having a similar issue and if the rounding adjustment is a bug I would like to learn more about the hotfix.  Thank you.

  • Community Member Profile Picture
    on at

    No. I cannot found any reason to fit this question.

    But I just summary that

    1. It always happens for STD cost when updating new cost price.

    2. It happens for item transaction that has remaining while updating new cost price.

    3. Not yet found a hotfix for this point now then I am not sure that is a bug or not.

    This is just information that I found now.

  • Suggested answer
    Community Member Profile Picture
    on at

    Do you perform an inventory close at month end? That was suggested to us but I did not feel that I was completely sure we had a good reason why it was necessary if we are using the standard cost inventory valuation method.

  • Community Member Profile Picture
    on at

    I am not yet performing an inventory month end but I also do not have any good reason.

  • Community Member Profile Picture
    on at

    May I will investigate and will try to month end again when I have time.

    Do you have any idea for this?

  • Ashok Bishnoi Profile Picture
    185 on at

    Dear All,

    I'm also facing similar issue. Every time I update the cost of an item it post an inventory adjustment transaction. It also reference to the source document such as Purchase Order or Production Orders. For ex. I have invoice updated a PO on 1st June 2016 and then I changed the standard cost price of the item on 30th June 2016. Here system post two vouchers one to the original invoice updating the product receipt and inventory account and the other is updating the product receipt (reversing the update on original invoice) and inventory cost revaluation account. The below table shows the PO invoice voucher. The last two rows is due to activating a new standard cost for the item. Is it right for the system to make the changes in the invoice voucher on a later date ??

    Voucher Date Ledger account Transaction type Posting type Amount
    PINV-006338 29/06/2016 730550------ Purchase order Purchase, accrual 29500
    PINV-006338 29/06/2016 600991------ Purchase order Purchase expenditure, un-invoiced -29500
    PINV-006338 29/06/2016 660100------ Purchase order Sales tax 1770
    PINV-006338 29/06/2016 700100------ Purchase order Vendor balance -31270
    PINV-006338 29/06/2016 600992------ Purchase order Purchase expenditure for product 29500
    COST-000022651 29/06/2016 600100------ Purchase order Purchase, inventory receipt 30000
    COST-000022651 29/06/2016 600350------ Purchase order Product receipt -30000
    COST-000022651 29/06/2016 600991------ Purchase order Purchase expenditure, un-invoiced 29500
    COST-000022651 29/06/2016 600992------ Purchase order Purchase expenditure for product -29500
    COST-000022651 30/06/2016 600350------   Product receipt -1500
    COST-000022651 30/06/2016 600100------   Purchase, inventory receipt 1500

    The costing voucher is as below: The costing voucher also post to my production orders even if they are ended.

    Voucher Date Ledger account Transaction type Posting type Amount
    INVREV-000012131 30/06/2016 600350-------- Inventory Product receipt 1500
    INVREV-000012131 30/06/2016 220800-------- Inventory Inventory cost revaluation -7417.2
    INVREV-000012131 30/06/2016 600100-------- Inventory Production issue 287.7
    INVREV-000012131 30/06/2016 600100-------- Inventory Inventory, inventory receipt 529.2
    INVREV-000012131 30/06/2016 600100-------- Inventory Purchase, inventory receipt 5100.3
    INVREV-000012131 30/06/2016 600990-------- Inventory Production, picking list -304.2
    INVREV-000012131 30/06/2016 600400-------- Inventory Production offset account picking list 304.2

    The above is one kind of transaction system post while activating a new standard cost for an item. Sometime system also post to rounding variance too as Poonzz10 described earlier.

    Is there any report which can provide the information of all the posted vouchers with reference to the source document ? Also, Is there any document or white paper which describes all the scenarios of Inventory Adjustments carried out while activating a new standard cost for an item ?

    Thanks !

    Ashok

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
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans