Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

amount posted in voucher not equal summary in trail balance

(0) ShareShare
ReportReport
Posted on by 145

HI

later get in details (posted voucher) for an account in trail balance, but I notice an amount not sum in trail balance form,

GL_5F00_E2.png

Debit in trail balance supposed to be more by one line did not calculated in trail balance.

  • Mounir Ahmad Profile Picture
    145 on at
    RE: amount posted in voucher not equal summary in trail balance

    Hello Ludwig

    thanks, your support was helpful, once delete main account set and create new one, summary report and trail balance form get right result.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: amount posted in voucher not equal summary in trail balance

    Hello Mounir,

    Can you run the trial balance with a dimension set that includes all of the financial dimensions that are used in this voucher?

    That is, don't use the one called 'main account set' but one that includes all findims.

    Many thanks,

    Ludwig

  • Mounir Ahmad Profile Picture
    145 on at
    RE: amount posted in voucher not equal summary in trail balance

    Good morning Ludwig,

    Thanks for concern, below screen shoots

    1- parameters in Trails balance Form

    GL_5F00_E2.4.png

    2- parameters in Trails balance Reports summary and details

    GL_5F00_E2.5.png

    3- when click on the debit amount in the online trial balance form, it back with right 5 lines, as expect details has no issue.

    4- issue is on trail balance summary , also no filter applied on voucher.

    5- No findim values is suspended.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: amount posted in voucher not equal summary in trail balance

    Good morning Mounir,

    Many thanks for the information shared, which is good but not sufficient to answer you question.

    Can you share details of the parameters selected when running the trial balance?

    Also, your first screenshot of the trial balance online form shows a single line only.

    Based on the vouchers that you shared, I would expect seeing more lines; in other words, there must have been a filter applied.

    What do you see when you click on the debit amount in the online trial balance form?

    In the form that opens is there a filter applied?

    What does the second and the third element in your accounting string stand for?

    Are some of those findim values possibly suspended?

    Best regards,

    Ludwig

  • Mounir Ahmad Profile Picture
    145 on at
    RE: amount posted in voucher not equal summary in trail balance

     voucher that has issue is below, and two reports for the voucher in summary and detail trail balance.

    account is 5542 and amounts is 5542.35 * 5

    GL_5F00_E2.2.png.

    GL_5F00_E2.3.png

  • André Arnaud de Calavon Profile Picture
    294,233 Super User 2025 Season 1 on at
    RE: amount posted in voucher not equal summary in trail balance

    Hi Mounir,

    It is hard to see what can cause this issue. You aren't showing that much on the screenshot. Are dimensions the same?

    What exactly do you mean with "unfortunately  Rebuild balances, and update balances, and AOT Synchronize does not work yet."? Do you get errors?

  • Mounir Ahmad Profile Picture
    145 on at
    RE: amount posted in voucher not equal summary in trail balance

    Hello Sourav Dam,

    yes, date is same, there  is no different between 5 lines in  GENERALJOURNALACCOUNTENTRY except RecId.

  • Suggested answer
    SouravDam Profile Picture
    11,723 on at
    RE: amount posted in voucher not equal summary in trail balance

    Hello Mounir Ahmad,

    What is the date of that journal line showing in voucher which you think is not posted? Is that date is same as in other lines in that voucher?

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Mounir Ahmad Profile Picture
    145 on at
    RE: amount posted in voucher not equal summary in trail balance

    it post from GL and all lines within same journal number and same voucher number, 4 lines has  calculated except 1 missed !

  • Suggested answer
    SouravDam Profile Picture
    11,723 on at
    RE: amount posted in voucher not equal summary in trail balance

    Hello Mounir Ahmad,

    Through your screen shot, this is not clear how this transaction is posted in system!

    Is that posted directly in the main account or through subledger? If this is through subledger, then it will appear in subledger voucher transactions and if not, then it will not appear in subledger voucher transaction.

    Appreciate if you share full screen shot if possible.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,233 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,982 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans