Share
ReportI would like to move all open SOR's to one Batch is there a SQL script to do this?
*This post is locked for comments
You’re offline. This is a read only version of the page.
970
I would like to move all open SOR's to one Batch is there a SQL script to do this?
*This post is locked for comments
You can write a script to change the batch assignments of the documents involved. For sales orders, you simply update the SOP10100 table with the new batch ID. AFTER doing this, run reconcile against the sales tables to recalculate the batch totals.
I have never came across any update statement of that kind. Although, I would not consider doing it on the database level since several tables are included.
You could record a simple Macro to go through all your open transactions and update the "Bach number" field, and that can simply be done, no matter how many open transactions are to be updated.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (