Sage300 Order Entry - maximum number of lines per invoice

SUGGESTED

Does anyone know if there is a maximum number of shipments that can be on a single invoice, or maximum number of lines on a shipment.?

Parents Reply Children
  • 0 in reply to Jay Converse Acumen

    I hesitate to admit this, because I am astonished that we can process anywhere near this many.

    Using Tairox Productivity tools, Invoice Shipments customer has created (and processed) a number of invoices with over 10,000 lines.  The largest is from 1168 shipments and has 22,698 lines.


    We are trying to create an invoice from 1,972 shipments which would have 37,713 lines and it is failing with "record has been altered by another program".  I assume this message is not actually the cause of the problem, as we have run several times, including after all other users have logged out, and it always fails at the same point.

  • 0 in reply to MaryOC
    SUGGESTED

    Well, the "record has been modified" error can be caused by bad data, but figuring it out could be a nightmare.  Running RVSPY on a transaction that big could take days.   I think you need to do an A and a B invoice.