Sage 100

 View Only
  • 1.  Sage 100 4.5, yep - Not kidding. How do I delete

    Posted 12-18-2018 08:35
    Sage 100 4.5, yep - Not kidding. How do I delete a duplicate AP Batch from the sub ledger? It did not post to the GL. It's a true duplicate. Same batch ID, date, $ amount.


  • 2.  RE: Sage 100 4.5, yep - Not kidding. How do I delete

    Posted 12-18-2018 09:22
    I would suggest that you reverse the batch in AP so it removes all the duplicate entries (AP_Vendor, AP_TransactionHitory, etc). Then just reinit the GL_DailyPosting file (or you could turn off GL Integration prior to reversing the AP batch.) Not sure if that is the best process, but it would for sure have the best audit trail.


  • 3.  RE: Sage 100 4.5, yep - Not kidding. How do I delete

    Posted 12-18-2018 09:49
    Interrupted update, repeated attempts, with multiple copies using different HeaderSeqNo values for the copies? No easy answer. DFDM, file by file, line by line, to remove what you need to remove. Make sure the open invoice file and transaction payment history file is linked properly to the HeaderSeqNo you keep in AP history. Bill for time... the customer will likely want you to fix ""everything"", but if they are paying by the hour, they may not worry about obscure summary tables.


  • 4.  RE: Sage 100 4.5, yep - Not kidding. How do I delete

    Posted 12-18-2018 10:09
    For AR I know which tables - which tables for AP?


  • 5.  RE: Sage 100 4.5, yep - Not kidding. How do I delete

    Posted 12-18-2018 10:26
    I check the file modified date, and look at anything modified after the interrupted batch was run.