Invoice variable

Question

Is there a variable available within report designer to total the quantity of the quantity entered when creating an invoice. I note the number of lines is shown but I need to check before the invoice is posted that the total quantity input is correct. Also is there a warning BEFORE update that advises a zero quantity and or zero price shown on an invoice. 
 Thanks Neville

Paul Morgan · Accepted Answer

Hi Neville, 
 
 Thanks for using Sage City. 
 
 Is it Sage 50 / 50 cloud Accounts you&rsquo;re using or Sage Business Cloud Accounting? 
 
 Regards, 
 
 Paul 
 Sage UKI

Neville Bumby · Answer

Hi Paul 
 It is Sage 50 accounts 
 Thanks Neville

Neville Bumby · Answer

Hi Fiona thanks for this. 
 I have used the variable and with he help of the SUM Expression can now see the total quantity on the invoice but only after it has been created and previewed prior to printing. However, and isn't there always a but somewhere, what I really would like is to see the variable as the invoice is being created. On the invoice creation screen, there is a box on the right which shows the number of lines entered in real time. Is there any way that I can get into the Invoice creation screen and add my new Quantity variable which will also show in real time as the invoice is created. I do understand the "off the shelf product" and this may be a programming screen, but ask the question nevertheless. Thank you, Neville.

fiona wilson · Answer

Hi Neville 
 The variable INVOICE_ITEM.QUANTITY will total if you add it into the Invoice Number Footer section of the layout when you edit it to open it in the Report Designer. I'm really sorry, unfortunately the functionality to give a warning that there is a zero quantity or price isn&rsquo;t available in Sage 50c Accounts. 
 As the software is an off the shelf product, sometimes it doesn't meet everyone's needs. 
 We're always very keen to understand our customer's needs for future development and I've logged your feedback with our Research and Development Team for consideration in future releases of our software. 
 Have you seen our roadmap for Sage 50 Accounts? We've created it to demonstrate to our customers our commitment to making Sage 50 Accounts even better. You can have a look at www.sage.co.uk/roadmap 
 Kind regards 
 Fiona, Sage UKI

Sage 50 Accounts

Invoice variable

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING