Solved

Stored Procedure for SY00500

Posted on 2013-05-12
1
428 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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