Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

How can we adjust quantity date wise in AX 2012

Posted on by 419

I want to adjust quantity of an item on specific date, but system allow me to adjust quantity on current date.

Categories:
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How can we adjust quantity date wise in AX 2012

    Good morning Mohammad,

    Decreasing the quantity means that you have to record an inventory issue.

    For inventory issues, AX defines the price / value that is recorded; you cannot influence that at the time you post the decrease e.g. via an adjustment journal, counting journal, etc.

    Also, can you let us know if your monthly results for June have already completed and reported?

    What I could think of is that you are posting an inventory adjustment, run an inventory close and then adjust the value correspondingly to what you need/like.

    This will, however, have an impact on your financial inventory transactions and it seems that this is not what you would like.

    Can you possibly elaborate a bit on the underlying requirement?

    Many thanks,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    RE: How can we adjust quantity date wise in AX 2012

    Hi Mohammad,

    You can create an inventory journal with a line with the date in June. However, it should have cost impact as you are decreasing the quantity. Can you explain why there should not be a ledger transaction here?

  • RE: How can we adjust quantity date wise in AX 2012

    Item quantity is 8000 on current date 9/24/2020.

    I want to decrease quantity from 8000 to 4000 on 6/30/2020 with out any cost impact.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How can we adjust quantity date wise in AX 2012

    Hello Mohammad,

    Do you want to backdate a transaction?

    Can you provide more details and possibly a simplified example?

    Some screenprints would help as well.

    Many thanks and best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans