How do I force an invoice to be resent?

The B2B connector will send an invoice for all orders that have a linkage 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. Verify that you have a linkage for the original sales order: select * from BDConnectorLinkages where ConnectorID='{B2B connector ID}' and Type='order' and LocalID='{order number from the invoice}'
3. Backup your linkages table: select * into BDConnectorLinkages{YYYYMMDD} (where YYYYMMDD is today's date)
4. 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
5. Run connectors and verify that the invoice is resent

*Note on the order / invoice format

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