Checklinks - Created Batch without BatchID

(0) Share

Report

Posted on by Cindy E

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

All responses (3)

Answers (1)

Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Checklinks - Created Batch without BatchID

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.
Cindy E 50 on at

Like (0)

Report

RE: Checklinks - Created Batch without BatchID

First statement worked. After runninb second, it states that "Dex_Row_Value does not exist". Any ideas?
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Checklinks - Created Batch without BatchID

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,