Monday, January 21, 2019

Display Discount Amount on Sales Order by Customer Report


1. Navigate to Reports > Sales Order > Sales Order by Customer > Customize Detail

2. On the Edit Columns tab > Bookings folder > click on Amount (Pre-Discount)


3. Click on Add Formula Fields button, on the Report Preview Pane and select the following:

Formula Type = select difference x-y
X=Amount(Pre-Discount)
Y=Amount(Net)

4. Enter Name and click on Save button

No comments:

Post a Comment