Solved

Stored Procedure for SY00500

Posted on 2013-05-12
1
429 Views
Last Modified: 2013-05-13
Hello:


What is the name of the stored procedure or "else" runs that updates SY00500 table in the company database with the correct document and batch total count after you change the batch name in the Sales Transaction Entry window?

TBSupport
0
Comment
Question by:TBSupport
1 Comment
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 39160198
Hi,

I developed a customization for a client that allows them to move SOP documents from one batch to another.

Based on my research in SOP (and I suspect it is the same for other modules), there is no stored proc that updates the batch totals when a document is moved to a different batch.  It is typically done with an update statement.

Here is the update statement that I run for SOP that updates all SOP batch totals after a document is moved to a different batch:

'Update the batch totals for all sales trx batches
strSQL = "UPDATE SY00500 SET NUMOFTRX = ISNULL((SELECT COUNT(*) FROM SOP10100 WHERE BACHNUMB = SY00500.BACHNUMB), 0), BCHTOTAL = ISNULL((SELECT SUM(DOCAMNT) FROM SOP10100 WHERE BACHNUMB = SY00500.BACHNUMB), 0) WHERE SERIES = 3 AND BCHSOURC = 'Sales Entry'"

Open in new window


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question