| Description |
*Steps:*
Integration is Base Engineering
1. Energy Trac > Import > Select 01 Location ( attached comptran.csv is used )
*Issue:*
Invoice is created with 2 line items, tax for 2 line items is incorrect
*Acceptance:*
Tax for 2 line items should be computed correctly specially when line item 1 has contract and other line item does not have contract
Related to IET-232 and IET-247.
When we import, we are creating the two invoice lines, but the tax amount supplied in comptran.csv is the total invoice tax and this ends up as the tax for each line item resulting in the total tax being double what it should be.
To correct this we will need to split that tax proportionately between each line item, based on gallons. A re-calc using i21 methods may not be correct since base rounds differently than we do for tax.
An example:
Total delivery gallons: 555.6
Contract gallons: 450
Contract price $1.25
Standard gallons 105.6
standard price $1.79
Total invoice tax $30.06
450 / 555.6 = .8099352
.8099352 x $30.06 = $24.35 (rounded)
$30.06 - $24.35 = $5.71
Contract line would have $24.35 as the tax, and the standard line would have $5.71
|