One of our Great Plains 10 users posted batches in the GL under the wrong date, is there a way to un-post the batch, or change the date on the batch.
*This post is locked for comments
Thanks everyone. She talked with the our GP consultants, and I guess there is a "correct" button that allows you to backout and correct the transaction, also creates the audit for you.
Dear Ken,
you can run the following SQL statement to adjust the batch date:
USE company database
UPDATE GL20000
SET TRXDATE = 'mm/dd/yyyy'
WHERE (ORGNTSRC = 'batch name')
Note: try to run the statement on a test company first then back up the live company and run the SQL statement.
BR,
AHMED
Not to my knowledge other then one lump entryt o cover the 160+
She did 160+ entries, there is no better way to do this?
You should rely do a reversing entry for this. you need to have the audit trail in the GL for the Auditors.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156