Browse By Tags

  • Historical Item Sales by customer - using SQL

    Good morning, I am using the below SQL statement to get a sales per item number from my Sales History tables ( OESHHD and OESHDT ) as well as item cost in my Sales Posting Journal tables ( OEAUDH and OEAUDD ). However, when I compare my sql output my…

  • Proper way of importing sales invoices ?

    Hello community, It is been a week me trying to figure out the proper format of a .txt file that would be accepted by Sage 50 CA edition to import invoices. The error that I always get is : "The number of detail lines does not match the actual number…

  • Importing Invoices (.imp) does not contain compatible tax information

    I am getting above error that is Importing Invoices (.imp) does not contain compatible tax information

*Community Hub is the new name for Sage City