Adding line discount to sales order in Report Designer

Question

Hi, 
 
 Is it possible in Report Designer to add the line discount and percentage so it is visible on a sales order? 
 I've added the discount by line to the sales order itself so I can add a discount for each line by percentage which is what I want but I can't figure out how to get this to show up on the layout. I'm using the default layout called A4 Sales Order - Plain Paper (Print or Email) and have just added our logo - there is a line for discount but it is the Net value discount and I want to deduct by percentage for each line so am not using that. Appreciate any help!

Sean White · Answer

Hi Rob, 
 Thanks for using Sage City. 
 In order to show the discount value and also the discount % you would need to add two separate variables to your layout. 
 The variables you need are SOP_ITEM.DISCOUNT_AMOUNT for the discount value and for the percentage SOP_ITEM.DISCOUNT_RATE 
 The guide below will show you how to add variables to your layout. 
 Add variables 
 If you require us to add these fields we can do this but there would be an additional charge as they class as report design requests. If you would like a quote please use the link below to book a consultation. 
 Report Design Request 
 If this has answered your question please click More > Verify Answer. 
 Kind regards, 
 Sean, Sage UKI

Sage 50 Accounts

Adding line discount to sales order in Report Designer

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING