50
Checklinks created a batch in financial without a BatchID. There are zero transactions in the batch. When I click to open the batch, it states " Please select a record first". I want to delete it. I ran checklinks on the entire financial series and clear data on the Transaction Work table. Any other ideas?
*This post is locked for comments
Cindy,
you are supposed to replace the "Dex_Row_Value" with the number retrieved from the first statement.
I mean, the first select will give you the Dex_Row_Id of the empty batch id. Suppose it says "543". Now you run the delete statement replacing the (Dex_Row_Value) with 543.
Your feedback is highly appreciated.
Get it deleted on the SQL level , SY00500
Run the following SQL statement,
SELECT BACHNUMB, DEX_ROW_ID, * FROM SY00500 WHERE BACHNUMB = ''
You can then proceed deleting this record by considering the Dex_Row_ID. Run the following SQL Statement;
DELETE FROM SY00500 WHERE DEX_ROW_ID = Dex_Row_Value
If you are not quite accustomed to using SQL, please contact you DB administrator.
Hope this helps,
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
Share
Report
All responses (
Answers (