Showing prices with discount on an invoice template

SUGGESTED

Hi,

The default invoice templates show a Unit Price (say £100.00) and then a Net Price column showing the total of however many products we have sold them (e.g. 5 x £100.00 = £500.00).

However most of our customers get discount, so the Unit Price they are shown appears to them as incorrect as the Unit Price is the price of the product before any discounts are applied. Any discounts we have applied are reflected in the Net Price column but a large proportion of our customers don't seem to realise this, we get multiple calls per month from customers saying we have forgot to apply discount and it's now pretty routine for our staff to reel off the usual "the discount is there but its only shown in the net price..." speech. At the moment we have a text box on there with a line of text trying to point this out but it's a bit crude and unprofessional!

Does anyone know if there is a data field or some way to show the individual price of an item with the discount included? So for instance if we sold an item listed at £100.00 and gave the customer 20% discount, the price shown on the invoice is £80.00. At the minute it still showing as £100.00 just makes the invoice look incorrect.

Thanks for any advice

Parents
  • 0
    SUGGESTED

    Hi Neil,

    Thanks for using Sage City. 

    You can edit your invoice layout and replace the INVOICE_ITEM.FOREIGN_UNIT_PRICE variables with the following expression which calculates the discounted unit price: 

    INVOICE_ITEM.FOREIGN_NET_AMOUNT / INVOICE_ITEM.QUANTITY

    To do this, you should select your invoice layout and click Edit, then in the Unit price column double-click each UNIT_PRICE variable and in the Expression Editor click Clear, then paste in the above expression and click OK. If using a standard layout there are 3 UNIT_PRICE variables you'll need to change. You can then save your layout with a new file name.

    The following Sage Knowledgebase articles provide more information:

    Report Designer - Expressions and Functions

    Common expressions for Sage 50 Accounts reports

    I hope this helps. If this has answered your question please click More > Verify Answer.

    Regards,

    ​Emma Watson

    Sage UKI

Reply
  • 0
    SUGGESTED

    Hi Neil,

    Thanks for using Sage City. 

    You can edit your invoice layout and replace the INVOICE_ITEM.FOREIGN_UNIT_PRICE variables with the following expression which calculates the discounted unit price: 

    INVOICE_ITEM.FOREIGN_NET_AMOUNT / INVOICE_ITEM.QUANTITY

    To do this, you should select your invoice layout and click Edit, then in the Unit price column double-click each UNIT_PRICE variable and in the Expression Editor click Clear, then paste in the above expression and click OK. If using a standard layout there are 3 UNIT_PRICE variables you'll need to change. You can then save your layout with a new file name.

    The following Sage Knowledgebase articles provide more information:

    Report Designer - Expressions and Functions

    Common expressions for Sage 50 Accounts reports

    I hope this helps. If this has answered your question please click More > Verify Answer.

    Regards,

    ​Emma Watson

    Sage UKI

Children
No Data