17
Replies
I'm sorry guys but if I understood Anna's question correctly she has an PDF invoice that itemizes the Net Price for each individual item in the table.
Therefore, she needs to illustrate a breakdown of the Net Price for each product before it is totalize as the Total Net Price and Grand Total.
I think that we all missed the fact that Grand Total in an invoice is not the same as Gross Price in this context.
For example, the cutomer who will be receiving the invoice from the seller would like to see what are they paying for exactly.
As for the person who prepares the invoice should take care in providing a clear breakdown of these costs to avoid discrepancies during audits and inspections.
That said, Net Price is defined as the total price after comissions and other discounts are applied to the Gross Price of an item. So it is not a good business practice to hide a percent discount in the Total Net Price and expect that those number are open to interpretation.
For this purpose, below is a breakdown of how I worked around this PDF.
I still used Simplified Field Notation in the Net Price coulumn. I also added hidden checkboxes next to each quantity field and set an export value of ".1" to each Check Box.
In the Quantity fields I added a very simple custom calculation script, so when the user enters a value greater than one (1) it will check the checkbox and the Simplified Field Notation will reflect the correct arithmetic.
Here is what I did :
- The slide below shows how the 10 percent is applied automatically when the user enters a value greater than 1 in the quantity field(s)
- To make the form easier to understand and avoid confusion I also specified the appropriate terms for each column
See below the scripts that I used in this example:
//CUSTOM CALCULATION SCRIPTS FOR THE NET QUANTITY FIELDS
//CHECKBOXES ARE NAMED "discount.0", "discount.1", "discount.3", etc
// ilosc_val
var f = this.getField("discount.0");
if (event.target.value > 1) {
f.checkThisBox(0,true);
} else {
f.checkThisBox(0,false);
}
// ilosc_lol
var f = this.getField("discount.1");
if (event.target.value > 1) {
f.checkThisBox(0,true);
} else {
f.checkThisBox(0,false);
}
// ilosc_csgo
var f = this.getField("discount.2");
if (event.target.value > 1) {
f.checkThisBox(0,true);
} else {
f.checkThisBox(0,false);
}
// ilosc_fifa
var f = this.getField("discount.3");
if (event.target.value > 1) {
f.checkThisBox(0,true);
} else {
f.checkThisBox(0,false);
}
// ilosc_f1
var f = this.getField("discount.4");
if (event.target.value > 1) {
f.checkThisBox(0,true);
} else {
f.checkThisBox(0,false);
}
// ilosc_clash
var f = this.getField("discount.5");
if (event.target.value > 1) {
f.checkThisBox(0,true);
} else {
f.checkThisBox(0,false);
}
- Once these scripts were added then set the export value to the Check Boxes.
- And below is the Simplified Field Notations used to calculate the Net Price of each item:
// SIMPLIFIED FIELD NOTATIONS
// used this for suma_val
(ilosc\_val*kwota\_val)-((ilosc\_val*kwota\_val)*discount\.0)
// used this for suma_lol
(ilosc\_lol*kwota\_lol)-((ilosc\_lol*kwota\_lol)*discount\.1)
// used this for suma_csgo
(ilosc\_csgo*kwota\_csgo)-((ilosc\_csgo*kwota\_csgo)*discount\.2)
// used this for suma_fifa
(ilosc\_fifa*kwota\_fifa)-((ilosc\_fifa*kwota\_fifa)*discount\.3)
// used this for suma_f1
(ilosc\_f1*kwota\_f1)-((ilosc\_f1*kwota\_f1)*discount\.4)
// used this for suma_clash
(ilosc\_clash*kwota\_clash)-((ilosc\_clash*kwota\_clash)*discount\.5)
If you want to see this PDF in action with this method here's a link to it:
AdChoices