In Sage 50 Professional, is it possible to group product line items on an invoice by the default sales nominal code associated with the product when updating invoices? A typical invoice in our company has 20-30 line items (products), currently, all the default sales nominal codes for products are the same (4000). To summarise the posted transaction after updating, we use the Global N/C option on the footer tab in the invoice. The result is a single transaction on the ledger per invoice for N/C 4000 instead of 20-30 transactions per product.
The problem we now face is the introduction of the Deposit Return Scheme (DRS), there will be a requirement for an additional product line added to an invoice per eligible DRS product for the deposit value. The Nominal Code for the Deposit Return Scheme (DRS) will differ from the products' Nominal Code (2305).
An invoice with 20 products may have 5 products that are eligible for DRS, resulting in a 25 lines invoice. 20 lines with the same sales nominal code (4000) and 5 lines with a different nominal code(2305) When updating the invoice, the requirement is for 2 grouped transactions for this invoice: one for N/C 4000 and one for 2305.
If the Global N/C option on the footer tab in the invoice is used, all 25 lines are grouped by the value entered in the Global N/C field.
