Sage 100

 View Only
  • 1.  SO invoice batch number is "missing" but there are invoice and shipping records for 2 invoices

    Posted 09-23-2021 15:07
    v2016.5 Advanced. Shipping batch "froze".  The batch number is no longer present & there is no entry in GL_CompanyActiveBatch.  There are records for 2 invoices in a number of SO Invoice files (Header, Detail, Tax, Tracking, PackageTracking).  Can a batch record be recreated so the invoices can be "reattached" to it and then delete the batch cleanly?  Or will it be necessary to remove records from all those files?

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: SO invoice batch number is "missing" but there are invoice and shipping records for 2 invoices

    Posted 09-23-2021 15:10
    Hi Barbara. Just set up the batch and click 'Verify' and they will re-attach to the batch.

    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 3.  RE: SO invoice batch number is "missing" but there are invoice and shipping records for 2 invoices

    Posted 09-23-2021 15:15
    Thanks @Bill Pfahnl but it didn't reattach them.​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 4.  RE: SO invoice batch number is "missing" but there are invoice and shipping records for 2 invoices

    Posted 09-23-2021 15:17
    Is the batch number on the invoice header record? If not add it using DFDM. It should work.

    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 5.  RE: SO invoice batch number is "missing" but there are invoice and shipping records for 2 invoices

    Posted 09-23-2021 15:17
    My bad - yes it did!  Thanks!  Helps if you key in the right batch number.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------