75,730
Is there a stored procedure that computes batch totals? I have been asked to create an automated routine that will take an input file full of sales orders and change the batch ID to a batch containing today's date. This will tell their people which orders need to be transferred to invoices on any given day.
Yes, this matches the code I inserted previously.
Not sure if this is what you are talking about, but I wrote some code to calculate the number of transactions and batch total for batches. I often move invoices to new batches for troubleshooting or selective posting so I often have to recalculate the batch totals.
Declare @NumofTrx int = 0
, @BchTotal numeric(19,5) = 0
Select @NumofTrx = count(*)
, @BchTotal = sum(DOCAMNT)
from SOP10100 s
where BACHNUMB = @BachNumb
group by bachnumb
Update SY00500 set NUMOFTRX = @NumofTrx, BCHTOTAL = @BchTotal where bachnumb = @BachNumb
Thanks for saving me the time looking for something that does not exist. The batch totals must be getting updated by Dexterity code. I will do the same thing.
Hello Richard,
Thank you for using Community Forums. My name is Becky.
When you are making changes in GP on the fly, the code adds and subtracts and doesn't actually recalculate the totals on the batch with a stored procedure.
When I captured this information in a trace, you can see that a stored procedure was not called.
You would need to create a procedure that would do look at the remaining subtotal or the document amount from the SOP10200.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (