ACH payment type may be combined, but not Credit Card.
Summary
<content>
How to process multiple sales orders on a single invoice
Consolidate sales orders on one invoice
</content>
Resolution
<content>
Multiple sales order on one invoice is a new feature available on Sage 100 2018 Product Update 3:
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 of 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.
</content>
Keywords
<content>consolidate,sales order,invoice</content>
Additional information
<content>
Also available as SO-1121 multiple sales orders on a single invoice by DSD Systems.
Available only for Sage 100 subscription.
*** Also found that credit card payment ID must be unpopulated on the sales orders. Once combined on the invoice the credit card can be selected for payment processing.
</content>
------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
------------------------------
Original Message:
Sent: 03-18-2021 13:43
From: Doug Higgs
Subject: Is it Possible to Ship / Invoice Multiple Sales Orders
he answer is Yes! You have to enale it in shipping setup options. Enter the first order then click accept and you will get prompted to ship another sales order. yippee.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------