How do I force an invoice to be resent?

×

The B2B connector will send an invoice until it gets back a successful acknowledgment from B2B so you should not normally need to worry about resending an invoice. However, in rare circumstances, you could have an issue between B2B and your vendor and need to force an invoice to be resent. This is easily accomplished with a few sql queries:

  1. Find the ID of your B2B connector: select id, Description from BDConnectorAccounts
  2. Backup your linkages table: select * into BDConnectorLinkages{YYYYMMDD} (where YYYYMMDD is today's date)
  3. Delete the linkage for the invoice you want to resend
    1. delete from BDConnectorLinkages where ConnectorID='{B2B connector ID}' and LocalID='{invoice number to resend properly formatted}'
    2. Verify it says 1 record deleted
  4. Run connectors and verify that the invoice is resent

*Note on the invoice format

  • Macola Progression invoice numbers are always 8 characters long with leading zeros, so 1234 is '00001234'
  • Macola ES/M10 invoice numbers are always 8 characters long with leading spaces, so 1234 is '    1234'