Invoice variable

SOLVED

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

Parents
  • +1
    verified answer

    Hi Neville,

     

    Thanks for using Sage City.

     

    Is it Sage 50 / 50 cloud Accounts you’re using or Sage Business Cloud Accounting?

     

    Regards,

     

    Paul

    Sage UKI

  • +1 in reply to Paul Morgan
    verified answer

    Hi Paul

    It is Sage 50 accounts

    Thanks Neville

  • 0 in reply to Neville Bumby
    SUGGESTED

    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’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

  • +1 in reply to fiona wilson
    verified 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.

Reply
  • +1 in reply to fiona wilson
    verified 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.

Children
No Data