Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Debit and credit do not balance in Batch Posting for a Sales Return that has been posted

(0) ShareShare
ReportReport
Posted on by 100

Dear Sir, 

While doing a Sales Batch posting we noticed that Debit and credit do not balance because the distributions was not correct. The Sales Return has two line items each having a discount of 35.400 so a total of 70.800 and it is posted. But while posting the Sales Batch, it cannot be posted as the Debit and credit do not balance. We are using GP 8 with SQL 2000 server.

Please let me know the SQL script to rectify this error as we are in the process of Year Ending. 

Thanks

Ashok

sqljournalerrorGP8.jpg

*This post is locked for comments

  • Ashok Affos Profile Picture
    Ashok Affos 100 on at
    RE: Debit and credit do not balance in Batch Posting for a Sales Return that has been posted

    Thanks Sandip, this solved my problem. I edited the batch and corrected the distributions.

  • Ashok Affos Profile Picture
    Ashok Affos 100 on at
    RE: Debit and credit do not balance in Batch Posting for a Sales Return that has been posted

    Thank you Sandip,

    We are using GP 8.0, how to go about to get Distributions.

    In GP 8 under Transactions there is no Distributions

    Thanks

    Ashok

  • Verified answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: Debit and credit do not balance in Batch Posting for a Sales Return that has been posted

    Hello Ashok,

    Please note down GL Distribution.  Goto Transactions--> Distributions--> Click on Default button to bring corrected distribution.   Verify it again make changes and try to post it.

    FYI- While making changes select correct "TYPE" or you can select "other" in type to enter additional distriubtions.

    Let me know how it goes.

    Thanks much

    Sandip

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…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

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,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans