web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP Batch Total Does Not Equal Actual Amount

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    KirkLivermont Profile Picture
    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

  • Verified answer
    Community Member Profile Picture
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans