Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Error While Posting th...
Supply chain | Supply Chain Management, Commerce
Unanswered

Error While Posting the Statement

(0) ShareShare
ReportReport
Posted on by Sunilkumar 96

I'm getting the below error message while posting a retail statement. Could anyone please help me to resolve this issue.

Kindly let me know if you need any information from my end

While processing the state Payments posted, generic exception encountered in retail statement SHOUSTON000058 in the controller : Posting results for journal batch number 25185 Voucher ARPM012533 0.06 for voucher ARPM012533 in company usrt will be posted as an overpayment or underpayment
Posting results for journal batch number 25189 Voucher ARPM012535 Posting without amount cannot be made
Posting results for journal batch number 25189 Voucher ARPM012535 Posting without amount cannot be made
Update has been canceled because of an error.

pastedimage1599642445223v1.png

GL Parameter

pastedimage1599642487813v2.png

Thanks

AR Parameter

pastedimage1599642522706v3.png

  • EeWee Profile Picture
    EeWee on at
    RE: Error While Posting the Statement

    Hi sunilkumar_R,

    Could you please execute the script below and let me know if it returns any results?

    begin transaction;

    -- Statement lines
    drop table if exists #PostingWithoutAmountCannotBeMade;

    select 
        rsl.STATEMENTID,
        rsl.RECID, 
        transamount as old_transamount, round(transamount,2) as new_transamount,
        transamountmst as old_transamountmst, round(transamountmst,2) as new_transamountmst,
        transamountstore as old_transamountstore, round(transamountstore,2) as new_transamountstore,
        differenceamount as old_differenceamount, round(differenceamount,2) as new_differenceamount,
        differenceamountmst as old_differenceamountmst, round(differenceamountmst,2) as new_differenceamountmst,
        differenceamountstore as old_differenceamountstore, round(differenceamountstore,2) as new_differenceamountstore
    into #PostingWithoutAmountCannotBeMade
    from retailstatementline rsl
    where (rsl.differenceamount % 0.01 != 0) OR (rsl.TRANSAMOUNTMST % 0.01 != 0);
    select * from #PostingWithoutAmountCannotBeMade;


    commit;

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 171 Super User 2025 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 140 Super User 2025 Season 1

#3
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 127 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans