• Serial Numbers Query in the Connector - JrnlSNum Table

    Hi all, I just got this all figured out and figured I'd document this here for future me and anyone else who might need it. I typically use the Sage 50 .dat file documentation when writing SQL queries in the connector: https://help-sage50.na.sage…
  • How to access attachment info?

    I'd like to create a customer list that shows the names of files that have been attached to each customer. But I can't figure out how to join the customer table and attachment table. I created a simple report listing all fields and records in the attachment…