How do we export invoice transactions to sage 50 Quantum (Can) for multiple depots?

Our client is running a custom SQL solution for billing and exporting the Sales Ledger postings to sage 50 Quantum (Can). Their SDK does not have a field for branch or depot location. Is there a way to export the transactions with the appropriate branch or depot location? As of now, they are all being exported to the same account in sage. The original invoice created in the custom solution has a depot code in the invoice header.

Many thanks,

Marc T

  • MarcT said:
    exporting the Sales Ledger postings to sage 50 Quantum (Can). Their SDK does not have a field for branch or depot location.

    In the Sage 50 Canadian SDK, There appear to be methods SelectLocation and GetLocation in InvoiceJournal, that refer to the 'Location' (warehouse) for inventory purposes.

    MarcT said:
    The original invoice created in the custom solution has a depot code in the invoice header.

    SelectLocation takes a string, so presumably you could set up the 'depot code' as the location name in Sage 50 and use that, or did I miss what your question?

    MarcT said:
    Is there a way to export the transactions with the appropriate branch or depot location? As of now, they are all being exported to the same account in sage.

    The built-in Import functionality in Sage 50 was built several years before the Locations were added, it doesn't seem to be aware of locations, so would probably either record imported transactions to the default, or possibly to the default for that customer / vendor.