AR – Multiple shipments posted but invoices were not generated (TranStatus = 3 in tsoShipmentLog)

Hello, 

We’re facing an issue in the Accounts Receivable (AR) module related to shipment and invoice generation for a group of P/S/C orders.

  • Multiple shipments were shipped and posted successfully.

  • However, no invoices were generated for any of them.

  • We cannot find the transactions in the invoice entry or commit/post screens.

  • This affects a range of transaction numbers, not just one.

Example:

  • 0000433561

  • 0000433562

  • ...

  • 0000433579 (full list shown in attached screenshot)

We checked the table tsoShipmentLog, and all affected records have:

  • TranStatus = 3

  • TranType = 810

Example query result:

What we want to understand:

  1. What does TranStatus = 3 mean in this situation?
  2. Why wasn’t the invoice created, even though the shipment was marked as posted?
  3. Is there a way to manually trigger invoice generation for these shipments?
  4. What are the recommended steps to recover or reprocess these shipments?

This only happened once, but we want to make sure it doesn’t affect other orders.

Any guidance would be greatly appreciated!

Thanks in advance,

Maria

Parents
  • +1
    Verified Answer

    Hi Maru,

    Apparently there was some kind of interruption during the specific batch processing. You can contact support or your Sage business partner for script: spDF_RebuildMissingPendInvcForDropShipment -- This script has a good chance of rebuilding the missing pending invoices for posting. You cannot simply change the tsoShipmentLog status to address this issue.

Reply
  • +1
    Verified Answer

    Hi Maru,

    Apparently there was some kind of interruption during the specific batch processing. You can contact support or your Sage business partner for script: spDF_RebuildMissingPendInvcForDropShipment -- This script has a good chance of rebuilding the missing pending invoices for posting. You cannot simply change the tsoShipmentLog status to address this issue.

Children
No Data