During a recent upgrade with one of our Sage 100cloud customers the question came up: Is it possible to process multiple sales orders on a single invoice. The answer is Yes on Sage 100 version 2018 Product Update 3: Here are some of the details:
In Invoice Data Entry, an Apply Sales Orders button has been added next to the Sales Order Number field on the Header tab. After selecting the first order for the invoice, click this button to select additional orders. You can apply multiple sales orders to invoices if the invoice type is either Standard or Cash Sale, and only if there has been no credit card deposit or credit card payment applied to the invoice before you apply the sales orders. Sales orders can be applied to an invoice if they have not been used for any other invoice, and if there has been no credit card deposit or credit card payment applied to the order. You can add a credit card payment or deposit to the invoice after applying all the sales orders.
For each order added to an invoice, the fields listed below must all contain the same value. The first order selected in Invoice Data Entry is used to determine whether additional orders are valid. Some fields may not be available depending on your settings.
- Terms code
- Ship-to code
- Discount rate
- Sales tax schedule
- Salesperson (or salespersons) and commission rate(s)
- Job number
- Ship-via shipping code and shipping zone
- Bill-to customer (Not National Accounts)
- ACH payment ID (The ACH payment IDs must match, or you can combine with an order that has no payment ID.)
- CRM person ID, CRM company ID, and CRM opportunity ID
Reports, Forms, and Registers
In the header section of the documents listed below, “Multiple” is printed in sales order number and customer purchase order number fields when applicable. The sales order number and customer purchase order number are printed in the line detail section.
- Sales Order invoice
- Sales Journal
- Gross Profit Journal
- Daily Deposit Recap Report
- Accounts Receivable Invoice History Report
When printing an invoice that includes multiple sales orders, the order date for the first order selected prints on the invoice.
Accounts Receivable Invoice History Inquiry
In Invoice History Inquiry, “Multiple” appears in the Order No. field and, on the Main tab, in the Customer PO field when applicable. To view a sales order number or customer purchase order number, select a line on the Lines tab, and click the Additional Information button. The order number and customer purchase order number are shown in the Additional Fields window.
If a deposit was entered for multiple orders, the total deposit amount appears on the Main tab in the Deposit field, and a Deposit Information button appears next to the field. Click the button to open the Deposit Inquiry window, which lists the individual deposits.
Sage has a Knowledgebase Article KB69145
If you have questions, please contact us at www.caserv.com or 760-618-1395. Please stay tuned for more helpful Sage 100cloud tips and tricks.
Mike Renner – Partner
WAC Solution Partners
local: 760.618.1395 | toll free: 866.400.0WAC (0922) | mobile: 253.861.3120
Single Source Provider of Turnkey Business Accounting & Management Software