No invoices are generated unless you click Yes at this prompt. After printing the listing, you are prompted to generate the invoice batch.To print the Auto Generate Invoice Selection Listing, click the Print button.The system selects the order based on the selection criteria but does not generate an invoice until you print and update the Auto Generate Invoice Selection Listing.After the selection criteria is defined for the orders to invoice, click Proceed.You can select expired orders and select sales orders by cycle code when generating invoices from repeating orders.You can select orders by order number, date, customer number, salesperson, ship date, or promise date.Invoicing Sales and Updating Orders in Sage 100Īutomatically Generating Invoices from Orders In either case, when you add the discount service product to the sales receipt, enter it as a negative amount and that will reduce the amount due from your customer and record that discount either as a reduction in revenue or an increase in expense depending on what account you selected when you set up the discount service product.Learn about Invoicing Sales and Updating Orders in Sage 100 in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS! It's up to you how you want to track those discounts and see them listed on your P&L. When you set up a service discount product, under 'Income account' select either a sales revenue account (if you want to see that on your P&L as a reduction in revenue) or an expense account (if you want to see that on your P&L as an expense). When using a sales receipt, you can create a service product called "Discount" or "Prize Discount" or "Store Credit" or whatever you want. Invoices are designed to be used when the payment date is in the future. A sales receipt is designed to be used when customers pay at the time of purchase which is better for a retail store. IMO, if you give the customer a credit or prize that does not need to be in QB it's best to use a sales receipt and not an invoice. Then, go to receive payment, apply the credit, and take payment for the balance if necessary. So, when you want to apply the credit to the customer's next purchase, create an invoice and save it. You can create a service product called "Prize Discount" (or something similar) and discount the invoice/sales receipt using you create a credit memo for the inventory trade, and you want that credit to be on the customer's account then, yes, you need to create an invoice to use the credit. Ideally, you would issue your customer a physical card for the store credit so you can wait to record that until they redeem their prize, if they ever do. In the case of store credit when someone wins a prize, there is no offsetting entry for the store credit because you have not received cash/inventory and you have not incurred any expense. The reason is that QB is a double-entry accounting system that affects two accounts with every entry. Therefore, it doesn't work well when issuing store credit when a customer wins a prize. It's important to understand that QB is an accounting system, not a point-of-sale system. "There are a few instances where we just give a person store credit, like if they won an event or something and they want store credit instead of a prize." Contact your own CPA if you need further guidance. non-inventory issue can get cloudy based on some new tax rules that went into effect in 2018 but, IMO, you should use inventory items. Hence why you should use inventory products. It sounds like creating a non-inventory product is the way to go, right? Well, the IRS has rules about that, and if inventory is a significant income-producing factor, then you should be using accrual accounting and capitalize (record as an asset) the cost of inventory when you bring it in on trade. If you use a non-inventory item, you expense it at the time you take it in on trade.
When you set up an inventory item, the item goes into inventory (asset) and is only expensed when you sell it. If you're tracking your inventory, you want to create an inventory product, not a non-inventory product. I set up the item, it gives me a choice to either do non-inventory or services.