This is a technical question. I'm doing research on behalf of a client who is interested in integrating Sage 50 into another system of theirs.
Basically, we have a few processes where we import/export files to/from Sage 50. In the system we’re connecting too, we have custom invoice numbers we want to pass along to Sage 50 during a transaction import. Then after those invoices are paid in Sage 50, we want export the check information WITH the custom invoice number back out, to feed this into the other system.
From what I can see, there doesn’t seem to be a way to export information on checks used to pay transactions and also include additional fields from the invoice. The only field I can see is the Trans No which appears to be an auto-generated ID for transactions. I need a way to export check information with MY custom invoice number. Is there a way to accomplish this in Sage 50?
EDIT: So if you read the replies below, you can do everything I described above in the US version just fine. I'm not actively looking for help anymore on this. For anyone attempting to do a similar workflow in the Canadian version, more research may need done.
