Click "Design Mode" button on the "Invoice ribbon tab again to exit design mode.To deduct the discount amount from taxable amount, modify the first tax formula (cell address $K$36 to be "=ROUND(IF(oknTaxType=0,0, oknTax1Rate*(oknLineTotalTaxable - oknDiscountAmount+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost))),2)" modify the second tax formula (cell address $K$37 to be "=ROUND(IF(oknTaxType2,0,oknTax2Rate*(oknLineTotalTaxable - oknDiscountAmount+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost)+IF(oknTax2IsAppliedToTax1=0,0,oknTax1))),2)".Modify its formula to be "=SUM(oknLineTotal_1:oknLineTotal_12) - oknDiscountAmount". Click to select the cell next to the label "SUBTOTAL", i.e.By clearing the "Locked" property, the discount amount field will be manually fillable / edition when you are creating an invoice. On the Format Cells dialog box, go to the "Protection" page, clear the "Locked" property. Right-click the cell named "oknDiscountAmount" cell at $K$35, choose Format Cells from the shortcut menu.All cells names that work with Invoice Manager for Excel should start with the "okn" prefix, except "Print_Area" and "Print_Titltes". Enter the cell name "oknDiscountAmount" into the name box on the formula bar.Click to select the cell where the discount amount value should be entered.Enter "DISCOUNT (AMOUNT)" underneath the "SUBTOTAL" label, i.e. This inserts a new row above the first tax row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |