• How to find the cause of variance between invoice total and the number on income statement ?

    Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…
  • Paid invoice not showing in transactions or history

    I have discovered that I have some invoices that have been paid, but the invoice is no longer showing up in transactions or history. The payment is there though. I'm not sure what happened but it puts my expense GLs out of balance. What could have happened…
  • Report for revenue of all end customers in a certain date range?

    Hello everyone, I'd greatly appreciate help with generating a total revenue report for all customers within a certain date range. I've tried using the "Revenue by Customer" report and wasn't successful. I wasn't allowed to select all. I've tried…
  • Reprint a Large Number of Invoices

    Our company was just served with a subpoena that is requiring us to produce a very large number of old invoices. It appears our customer is suing one of their customers and the entity being sued is requesting invoices from a several year period for certain…
  • AP Invoices not showing in Invoice Payment Selection

    When opening AP > Check Printing & Electronic Payment > Invoice Payment Selection we are expecting to see many more invoices available in the selection list. We select the following options: We see about 25 invoices listed when we click select. However…
  • Suppress Printing on a Customer Invoice

    We do service work that in some instances calls for a "fixed" price per job. We will bill for the total cost of the project on one line item. We add additional items to the SO for costing purposes. Does anyone know of a way to suppress the print on the…
  • VI Import into AP_InvoiceHeader

    I'm attempting to import an invoice using VI import and encountering a "HS Record Invalid or Write Failed. The Vendor Number is Required" condition. I've confirmed that the Vendor record exists but it continues to fail on the import. This error also…
  • Generate Invoice from SO without Shipping Items - Down Payment Required

    We have some customers who are on credit hold. We require that they pay either a percentage of the order or the entire order before the items are shipped. How would we create an invoice from the sales order listing the items and their cost and then once…
  • Invoicing and Backorders

    Our sales department is trying to iron out a good process for backorders on sales order whether anticipated or unanticipated. Without knowing the accounting side of Sage I have come to a small bump in the process. When items on a sales order are moved…
  • How do you add a due date on invoices?

    When pulling the information in Accounts Receivable - Invoice Data Entry, I'm able to put in the terms under 'Terms Code' and it automatically generates a due date in the box above it. But when invoices are printed, the due date is nowhere to be found…