Updating Invoices - Group line items by Nominal Code when creating Transactions

Suggested

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.

  • 0
    Suggested

    Hi Gavin, 

    I'm afraid this feature does not exist in Sage 50 Accounts - though it would be a good suggestion for our ideas board if it does not already exist. The developers check this board so by submitting your idea or voting for an existing one they will better identify if it is something they can add for the future 

     Sage 50 Accounts UKI Ideas Portal

    As a work around, you could create two different invoices and use the Global N/C option on each one to create two separate transactions on the audit trail with their respective nominal codes.  If you send your invoices to customers through sage, you may want to also create a third invoice which has all of the necessary lines on it so that you can email the complete invoice without updating ledgers and creating duplicate transactions. 

    We have a guide which has in-depth information on DRS in Ireland, I will link it as it could still offer some relevant insight and help you find a way to process these transactions that works for your business.  Ireland Only - Deposit Return Scheme

    If you found this reply helpful, please mark it as "verified", it helps the community out a lot!

    Many thanks,

    Eric,

    Sage UKI

  • 0 in reply to Eric I

    Eric,

    Thank you for your response, but the workaround of creating a separate invoice does not comply with the new legislation, as the DRS value must be on the invoice with the associated item.  Creating a third invoice is not practical and will generate duplicate stock transactions.  

    Creating a transaction line per line item will result in too many transactions for the system.  Clearing the audit trail before year-end could reduce the number of transactions, but this would not be feasible. 

    I will submit the idea for development.

  • 0
    Suggested

    Gavin

    Could you write a report that summarised the DRS lines of each invoice, and use that as the backing for a periodic nominal journal to debit 4000 and credit 2305?

    I have no idea whether that is legal Slight smile