Check Links - Sales Work

[SpeedBWild]

When running check links on the sales work I get the following message on my File Maintenance Error Log Report
Sales Work
This file cannot be processed while other users are accessing it.

I am currently the only one in GP. I can I correct this so that I can run check links on it.

 

[barbola]

Check the table SY00800 in your Dynamics database.


Thanks!
Barb E.

 

[SpeedBWild]

Yes, I have one record in there. The batch source and the batch number is 'TRX ACTIVITY'. I have looked in SOP10100 and can not find that batch number. What table(s) can I look in to find what this reserved batch has in it?

Thank you,

 

[barbola]

You can delete that record from SY00800 if nobody is logged in - it is a stranded record.


Thanks!
Barb E.

 

[SpeedBWild]

I delete the record in SY00800 and then ran check links on sales work and sales history tables in the sales series. I got a bunch of log messages. Things like a record for invoice xxx was removed for the sales transaction amounts work table , no corresponding record was found in the sales transaction work table.

What does all of this mean. How do I fix these error. They are good records.

Thanks,

 

[Luvsql]

We have these errors all the time due to transactions not being saved correctly when a user gets bumped out of GP in our citrix environment (GP doesn't rollback the transaction, just leaves data all over the place). Typically, a record will exist in the Transaction Amounts Work, Tax Work and History, Distribution Work and History etc, but the main header transaction didn't get saved in the SOP10100 table. GP has to remove the transaction completely as it cannot just add information to the table (ie if it wasn't saved properly, it will have a blank customer ID, blank Batch ID etc). Before running check links again, use Smartlist or run a SELECT against the SOP10100 table and look for any documents with blank Cusotmer and Batch IDS (assuming no one is in the system) and these are the documents that would be removed.

If it is removing records from the Transaction Amounts Work, you must also run an inventory reconcile, as those items will still show as allocated, backordered etc.