Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Remaining value in the stock ageing report dynamics AX

(0) ShareShare
ReportReport
Posted on by 85

Hi Gents,

I have two items has no quantities but the report shows value for each one, I tried to adjust the value for the items through the closing/adjustment screen, but it couldn't be possible since there is error appears shows that "You cannot cancel any stock closings prior to date".

So, what do you suggest

Thanks,
AhmadStock-Ageing-Report.png

*This post is locked for comments

  • Ahmadbarghouthi Profile Picture
    Ahmadbarghouthi 85 on at
    RE: Remaining value in the stock ageing report dynamics AX

    Hi Ludwig,

    I think the last point is to fix the issue through the AOT in the InventTrans to be reflected to the stock ageing report.

    And I would like to thank you for your continues support.

    Thanks,

    Ahmad.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Remaining value in the stock ageing report dynamics AX

    Hi Ahmad,

    I don't think that you can do something from the AX client if you have done a standard cost conversion before.

    If the amount that is shown for May is a problem for your accountants then they can probably do a GL adjustment posting.

    In case this is not sufficient you will need some technical help from a developer.

    Best regards,

    Ludwig

  • Ahmadbarghouthi Profile Picture
    Ahmadbarghouthi 85 on at
    RE: Remaining value in the stock ageing report dynamics AX

    Hi Ludwig,

    I'm sorry for being late to reply you, but i tried to reverse the closing transactions as mentioned in the previous thread, but unfortunately the system shows an error "You cannot cancel any stock closings prior to date '06/07/2018'. This is the date of the last standard cost conversion in the system.", this prevents me to do anything related to the inventory closing.

    Furthermore, I did the consistency check but this is didn't resolve my issue and made the stock ageing report nonworking, now I couldn't open the report on that environment.

    I don't have any extra ideas for this issue.

    What do you suggest.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Remaining value in the stock ageing report dynamics AX

    Can't you just test what happens if you reverse the previous inventory close and try to post a 0 quantity and $0 counting journal in May. Once that is done, run the close again. I'm wondering if this fixes your issue.

  • Ahmadbarghouthi Profile Picture
    Ahmadbarghouthi 85 on at
    RE: Remaining value in the stock ageing report dynamics AX

    Yes, I have

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Remaining value in the stock ageing report dynamics AX

    Hi,

    Do you have a test environment available that includes the same issue and where you can do some testing?

    Best regards

    Ludwig

  • Ahmadbarghouthi Profile Picture
    Ahmadbarghouthi 85 on at
    RE: Remaining value in the stock ageing report dynamics AX

    Does the consistency check resolve the issue, because it seems it talks long time, so if will not resolve it, i want to stop it to avoid wasting the time.

  • Ahmadbarghouthi Profile Picture
    Ahmadbarghouthi 85 on at
    RE: Remaining value in the stock ageing report dynamics AX

    No, the issue appears only if I run the report in any day in May 2018

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Remaining value in the stock ageing report dynamics AX

    Ok. If you run the report as of today does this make a difference?

  • Ahmadbarghouthi Profile Picture
    Ahmadbarghouthi 85 on at
    RE: Remaining value in the stock ageing report dynamics AX

    Hi,

    I just did your request, but still didn't resolve the issue, btw, I've posted the transaction with date today not in the issue date, because the inventory has been closed and couldn't reverse it as mentioned before.

    The report date that shows the issue is 19 May 2018.

    Thanks,

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans