Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Inventory Aging Report and Trial Balance Accounts are not matching from day first

(0) ShareShare
ReportReport
Posted on by 3,084

Hi Experts,

I have Inventory aging and Trial Balance Difference issue. Now i found that this issue is coming from the first month of this
Account creation "FEB 2017". If the company assign this task to me to fix this is it possible to fix if possible then how long time it will take.Further, what process i will do ?
Please advice!.

Shabir Ahmad

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi Shabir,

    I don't think so Services will be shown

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,084 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi Both,
    Thanks for sharing your valuable suggestions and Knowledge now, one thing i want to know, what about this services account."The Services are not showing in "Inventory Value Report". It will not be shown in the Inventory aging report as well ??. Can you please suggest me.

    Best Regards,
    Shabir Ahmad

  • Verified answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi Shabir,

    If inventory value report and TB are matching that means problem is in aging report and it is the reconciliation issue between TB and inventory.

    Now you should compare Qty and Value between Inventory value report and aging report and find out which Product+site+warehouse combination and in which month it has the difference.

    It is possible that aging report is not considering some transactions e.g. couniting or adjustment

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,511 User Group Leader on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi Shabir Ahmad

    You need to update your Report ID with detail as "Transaction" and run it.

    Regarding Aging report, try if your value column match with Value report and TB, unless you are trying to reconcile as on date, aging report can not match with previous / old month's TB.

    Please let us know if this helps.

    Thanks,

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,084 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi CA Gaurangkumar Jani,

    Which Transaction Report should i run to get vouchers and the same i do with inventory aging or Inventory Value Report to match these voucher and find out the Transactions which are not updating the inventory side.

    One thing i want to clear "Inventory Value and Trial balance values are matching" it is Inventory aging not matching with trial balance".

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,511 User Group Leader on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi Shabir Ahmad

    To get the voucher, you need to run a transaction level report and not balance.

    And Aging report provides the value as on today for the material quantity as on date of report, so it also includes financial values posted (adjustment) after report period.

    Please let us know if this helps.

    Thanks,

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,084 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    InventoryValueReport2.PNG

    Hi ,

    I don't see any column "voucher" or something else, on the basis of that i could track records from vourcher transaction "GL" Side. Cloud you please check the above columns.Which columns are missing and how to add if needed?

    Best regards,

    Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,084 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi ,

    But the Inventory Value Report and Trial Balance Values are matching It is "ok" ,only "Inventory Aging" VS Trial Balance Difference.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    Hi Shabir,

    As mentioned above , I think you should use Inventory value report and start with Month wise extract at transaction level.

    Once you know Month where  issue is you can compare Inventory value report transactions summarized by (Voucher) and GL voucher transactions , compare both and see which voucher has difference. Thats will help you to make correction.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,084 on at
    RE: Inventory Aging Report and Trial Balance Accounts are not matching from day first

    TrialBalanceAccounts.PNG3554.InventoryAgingValues.PNG

    Hi ,

    Please check the above image and difference.

    Only 4 months difference from Jan to April

    Total of 3 Trial Accounts is 11,409,232.87
    Inventory Aging Report Values is 11,356,742.66

    Total Difference 52,490.21

    Best regards,

    Shabir Ahmad

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans