Sage 100

anyone seen this? JobOps - TimeTracker - periodic tables update to feed payroll - ""update cannot be run while invoices or make to stock closing entries are in process."" there are none in process but still get message. We've cleared the HDRWorkTicketInvoicecomplete flag in the work ticket table. thoughts? customer is still on 4.3

Could be a couple of things: 1) there are orphaned records in the SO Invoice Header and/or Detail file; 2) there are Work Tickets with their Being Invoiced flag not equal to Blank (JT_WorkTicket.m4t file, field 47). Delete orphaned records in invoice files if there are any. If none, then identify the open WT's with their Field 47 <>"""" (you will need to create a Crystal Report or an Excel Query to identify any Step 000 Work Ticket records with that value <>"""").

Add the SOInvoiceTierDistribution file to the list of files to check for orphaned records if they use lot/serial

I'd put money on the TierDistribution file having orphaned records - have run into this for a very long time.

good suggestions. I've cleared one field 47. still getting error so will look at the invoices for orpaned records next!