• create new Sales Order form where lines print in correct order

    I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order. The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as displayed…
  • Print List of All Jobs from 2015 - present -

    Please forgive me if already answered somewhere, but I could not find it. Sage 100C - I need to print a list of all jobs from 2015 - present. Just need the Job Number, Job Name, Job Address. This should be so simple, but I was not able to find…
  • Need help with Taxable vs Nontaxable discounts on invoices.

    Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…
  • Question regarding Invoice Table relationships.

    Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…
  • Unable to Preview - invalid index - Sage Preview / Crystal Reports Form Issue - Sage 100 ERP 2013

    Sage 100 ERP 2013 I've been struggling to create a panel I need for my small business and create a form in Crystal Reports for it - I've hardly had time to attempt this and I'm not having an easy time with the advice that's been offered. I don't have…
  • Custom Statement Printing and Sales order Invoice Printing

    Does anyone that knows how to control and allow salesperson to be able user lock the by the salesperson to be able to see only see their only their customer statement and sales order invoice but no other sales representative. Currently, the lookup is…
  • Need help deciphering Activity Log

    Hello, We went live with a new project yesterday and are having some issues. I spoke with support, but because we have so many modifications they said they were unable to help. I found the two below entries in the activity log that I believe may be…
  • Transaction Report Needed

    Hello I am new to SAGE and I am trying to find a report that will show me individual credit card transactions that were entered during a specific period. I can't seem to find anything, help is appreciated.
  • How to get Crystal Reports to Pull Data from 2 Unrelated Tables and Summarize Them

    I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…