Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP Batch Total Does N...
Microsoft Dynamics GP (Archived)

SOP Batch Total Does Not Equal Actual Amount

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello:

We imported Sales Order Processing invoices into GP 2013 R2 (12.00.1920) through Scribe.  The batch ID's total dollar figure in Sales Batch Entry, however, does not match the total dollar figure of the data that we imported.

So, we decided to delete the batch and reimport.  Still, the total is off by $3,509.86.

I ran receivables batch reconcile but to no effect.  I, also, printed the edit list, closed the edit list, closed the batch window, and pulled up the batch ID.  Still, the dollar figure is incorrect.

I do not see any amounts in either the import file or SmartList matching the dollar figure that the total is off by.

I have not run check links on Sales Work.  I tested doing so, in a test environment, even though the test environment does not have this same batch in it.  Anyway, running check links in test generated 32 pages of changes.  So, I'm concerned about taking this step in production.

Too, when I run "SELECT SUM(DOCAMNT) from SOP10100 WHERE BACHNUMB = 'OUR BATCH ID', that amount does equal the amount in Sales Batch Entry, even though it's wrong.

In any case, is there anything else that can be done to fix this.

Thanks!  Much appreciated!

John

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP Batch Total Does Not Equal Actual Amount

    Hi Kirk:

    Thanks, for the quick response!  You make good points!

    Actually, overnight, someone from one of our overseas offices solved the mystery as follows:

    It is just the case of presentation in GP, not an integration issue or other kind of billing error.  The GP batch total is correct.

    Also the vlookup check between the import file and invoices integrated in GP show that these are equal.

    Batch total from the import file is 7,595,601.52, the Sales Batch Entry window shows $7,599,111.38, and the Edit list “top” Batch Total is $7,599,111.38.  But, the number we really should be interested in and compare to the import file's total is at the bottom of the Edit List Document Total -  7,595,601.52 and it equals the import file's total.

    The difference is caused by RETURN documents (Credits) integrated into GP in this batch for the amount of -1754.93 (half of -3509.86 difference)  – they are being taken into calculation in Sales Batch Entry window and the Edit list “top” Batch Total as positive amounts but in fact they are negative and they decrease actual batch total which is reflected at the bottom of the Edit List Document Total.

    John

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: SOP Batch Total Does Not Equal Actual Amount

    Hi John,

    How many transactions are we talking about? I am not familiar with Scribe but I would take a look at the table to see what is going on behind the scenes. Sorry if my syntax is off here. Run "select count(*) from sop10100 where bachnumb = 'Your Batch'". Does the number of transactions match the number in the batch number? I have also seen cases where "ghost" items have ended up in non-existent kits with values so it might be worth taking a look at sop10200 and comparing the number of items vs. the expected number.

    Regards,

    Kirk

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans