Joined: 18 Feb 2016
Online Status: Offline
Posts: 16
Topic: How to override Invoice Total Posted: 13 Feb 2018 at 7:48am
I have a requirement where the ability to override a standard invoice output from the user system calculated based on an invoice template instructions is overridden by a manually entered parameter.
This is a situation where the user is providing a quote in Lump Sum but is pulling materials that are included in the sale which have standard sales prices which need to be suppressed.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 14 Feb 2018 at 3:42am
You need to use a parameter for this. I might call this {?Override Amount}. Set the default value to $0.00
Then there are a couple of ways you can go about swapping the two totals. Here is probably the easiest:
1. Insert a new section below the one where the current total is located.
2. If there are any objects in the total section that are not the total, copy them to the new section.
3. Place your parameter in the same location as where the total is in the previous section.
4. In the Section Expert, select the original total section and click on the formula button to the right of the Suppress checkbox (DO NOT check the checkbox!). Enter the following formula and then save:
{?Override Amount} > 0.00
5. Set the suppress formula for the new section following the steps in item 4 above, except the formula needs to be this:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
