The ability to bill Sales Tax on a percentage of an Agreement Bill Amount originally existed in Coins ERP+ Ti; it has now been added to Coins ERP+.
No changes needed to be made to the L-Lump Sum Agreement Billing Type. You can currently create two separate Detail Lines, each representing the applicable amount and tax code, as shown in Sample of Two Separate Detail Lines.
Sample of Two Separate Detail Lines
Configuration
The SE parameter, ABTAXPCT, found in Coins ERP+ allows an Agreement Billing Sales Taxable % Method. When this is set to Y, the % Taxable field is visible in the Agreement, regardless of whether the Revenue Tax Code is referenced.
Parameter | Description |
ABTAXPCT | Allow Agreement Billing Sales Taxable % Method Note: The % Taxable field will be seen in the Agreement when the parameter is set to Y, regardless of the Revenue Tax Code referenced. |
Agreements
A Scheduled Billing Taxable % field is available under Scheduled Billing in Agreements > Locations tab > Agreement Allowable Work Details > Billing & Sales Tax tab, as shown in Scheduled Billing Taxable % Field. It is only visible and enabled when Scheduled Billing is selected as Revenue Taxable and parameter SE/ABTAXPCT is set to Y.
The value in this field allows for two decimal positions; it enforces the value to be positive and to not exceed 100. (In Coins ERP+ Ti, this value is a whole number that cannot exceed 100.) The value of 0 in this field is recognised as 100 percent.
Scheduled Billing Taxable % Field
Agreement Billings
Coins ERP+ Ti supports separate Taxable Amount values on a transaction through the use of a separate Taxable Amount field. However, in Coins ERP+, every transaction is taxable, and the value of the tax is based on the Tax Code referenced. The Generate Agreement Scheduled Billings and Generate Time of Service functions allow you to create two separate Service Order Scheduled Billing Detail Lines: (1) one line holds the taxable portion; and (2) the other line holds the non-taxable portion.
The taxable portion references the Agreement’s Revenue Taxable Tax Code and is the first line created.
The non-taxable portion references the Agreement’s Revenue Exempt Tax Code. Any rounding result is applied to the Taxable Detail Line. The sum of the two lines must equal the value of the Scheduled Amount.
Revenue Tax Defaults
The Generate Agreement Scheduled Billings function uses the Taxable % entered in the Agreement, since both the Service Order and the detail lines are created as one transaction. The Generate Time of Service (TOS) function (see Generate Time of Service) uses the Taxable % visible on the Service Order’s Allowable Work.
The Taxable % has no effect when a Scheduled Billing Detail Line (Scheduled Billing Detail Line) is manually entered. You must enter the applicable Amount and Revenue Tax Code on each Scheduled Billing Detail Line added.
Generate Time of Service
Scheduled Billing Detail Line
Print Invoices
If you wish to use the Taxable % process, you must have your Invoice Documents modified. This is due to the Print Invoices function only printing one line for all Scheduled Billings Detail Lines on a Service Order if the Service Order’s Allowable Work Taxable % is not 100 (or 0).
RO fields on the Invoice header contain the Invoice Taxable Amount (RO_sei_TaxableAmt) and Invoice Nontaxable Amount (RO_sei_NontaxableAmt). You may want to have your Invoice Documents adjusted to print the breakout of Taxable and Nontaxable amounts.
If the Invoice Line’s Tax value is <> 0, the Line’s Taxable Amount is calculated. Note: Retention is not considered as Taxable.
The difference between the Line’s Amount and the Taxable Amount is reported as the Nontaxable Amount.