Functional Description
Purpose
To calculate the five tax authority tax amounts and return the five authorities and the related
fields from the Tax Rate/Area table (F4008). This process takes into consideration the Colombian Tax Set Up
( Company Tax Payer, Supplier Tax Payer, etc ).
Setup Notes and Prerequisites
You must provide a tax amount and a taxable amount.
Special Logic
This function calculates a tax amount for each tax authority.
Parses tax explanation and determines what type of taxes. If tax type is non-tax exits program.
Checks for tax rate/area - if blank sets error and exits program.
Retreives tax rate area
Get Colombian Tax Set Up.
Calculates tax amount for each tax authority. Flags first non-zero amount for use in rounding. If
all are zero, authority one will be used for rounding.
Handles rounding. Five amounts must total tax amount. Adjusts first non-zero amount.
Calculates GST and PST rates and uses them to calculate GST non-recoverable amount.
Returns tax authority related fields from Tax Rate/Area table (F4008).
Technical Specifications
Parameters:
TXA1szTaxarea1RequiredTaxRate/Area
DSVJjdDateservicecurrencyRequiredService/Tax
Date
ITMmnIdentifiershortitemNo RequiredItem Number -
Used to
retreive tax
rate/area
TXR1mnTaxrate1Tax rate 1
TXR2mnTaxrate2OTax rate 2
TXR3mnTaxrate3OTax rate 3
TXR4mnTaxrate4OTax rate 4
TXR5mnTaxrate5OTax rate 5
TA1mnTaxauthority1OTax auth 1
TA2mnTaxauthority2OTax auth 2
TA3mnTaxauthority3OTax auth 3
TA4mnTaxauthority4OTax auth 4
TA5mnTaxauthority5OTax auth 5
GL01szGlclassbytaxarea1OG/L class
auth 1
GL02szGlclassbytaxarea2OG/L class
auth 2
GL03szGlclassbytaxarea3OG/L class
auth 3
GL04szGlclassbytaxarea4OG/L class
auth 4
GL05szGlclassbytaxarea5O G/L class
auth 5
STAMmnAmtAuth1OTax amt auth1
STAMmnAmtAuth2OTax amt auth2
STAMmnAmtAuth3OTax amt auth3
STAMmnAmtAuth4OTax amt auth4
STAMmnAmtAuth5OTax amt auth5
STAMmnNonRecoverGSTONon
recoverable
GST amount
STAMmnTaxAmtIRequired. Tax
amount
ATXAmnTaxableAmtIRequired.
Taxable
Amount
EXR2szTaxexemptreasonIRequired. Tax
explanation
code
TC2 (Ficm)cTaxcalcmethodOTax
calculation
method - tax
on tax flag
TT3 (evat)cVATRecoerableFlag3OVat
recoverable
flag 3
TT4 (evat)cVATRecoerableFlag4OVat
recoverable
flag 4
TT5 (evat)cVATRecoerableFlag5OVat
recoverable
flag 5
TAXAszDescriptiontaxareaOTax rate/area
description
FVTcFactorvaluetypeOFactor value
type
AN8mnAddressNumberIRequired.
Address
Number
CRRMcCurrencyModeIRequired.
Currency Mode
DOCmnDocVoucherInvoiceEINo
Required.
Document
Number
DCTszDocumentTypeINo
Required.
Document Type
KCOszCompanyKeyINo
Required.
Company Key
SFXszDocumentPayItemINo
Required.Pay
Item
LNIDmnLineNumberINo
Required.
Line Number
NLINmnNoOfLinesOnOrderINo
Required.
Number of
Lines
MCUszCostCenterIRequired.
Cost Center
CTIDszComputerIdINo
Required.
Computer Id
EV01cCallTaxCalcFlagINo
Required.
Flag
AC07szReportCodeAddBook007IRequired.
Category Code
007
MTAXmnMaximumTaxAmtOTax Amt
EV01cSystemCodeFlagIRequired.
'1' A/R ;
'2' A/P;
'3' G/L
COszCompanyIRequired.
Company
Related Tables
F4008Tax Rates
Related Business Functions
B76C0006GetColombianTaxSetUp
^
D76C0009 - Calculate Tax Authority tax Amounts - COL - 00 - 76C
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szTaxarea1 | TA | char | NONE | NONE |
Tax Area-Payroll. The code of a taxing authority. All time entries for this Cost Center default to the value entered in this field. | ||||
jdDateservicecurrency | DSVJ | JDEDATE | NONE | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
mnIdentifiershortitem | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
mnTaxrate1 | TXR1 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxrate2 | TXR2 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxrate3 | TXR3 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxrate4 | TXR4 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxrate5 | TXR5 | MATH_NUMERIC | NONE | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
| ||||
mnTaxauthority1a | TA1 | MATH_NUMERIC | NONE | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
| ||||
mnTaxauthority2 | TA2 | MATH_NUMERIC | NONE | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
| ||||
mnTaxauthority3 | TA3 | MATH_NUMERIC | NONE | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. This is the agency to whom you pay and report sales, use,
| ||||
mnTaxauthority4 | TA4 | MATH_NUMERIC | NONE | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
| ||||
mnTaxauthority5 | TA5 | MATH_NUMERIC | NONE | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
| ||||
szGlclassbytaxarea1 | GL01 | char | NONE | NONE |
A code that indicates how to locate the tax account for general ledger entries. This field points to automatic accounting instructions (AAIs)
| ||||
szGlclassbytaxarea2 | GL02 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szGlclassbytaxarea3 | GL03 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szGlclassbytaxarea4 | GL04 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
szGlclassbytaxarea5 | GL05 | char | NONE | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
| ||||
mnAmtAuth1 | STA1 | MATH_NUMERIC | NONE | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the first of five
| ||||
mnAmtAuth2 | STA2 | MATH_NUMERIC | NONE | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the second of five
| ||||
mnAmtAuth3 | STA3 | MATH_NUMERIC | NONE | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the third of five
| ||||
mnAmtAuth4 | STA4 | MATH_NUMERIC | NONE | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the fourth of five
| ||||
mnAmtAuth5 | STA5 | MATH_NUMERIC | NONE | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the fifth of five possible
| ||||
mnNonRecoverGST | RCLA | MATH_NUMERIC | NONE | NONE |
You can use this field to define the limit amount (or maximum amount) of a Recovery. The Recovery Limit amount is the maximum amount
| ||||
mnTaxAmt | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). | ||||
mnTaxableAmt | ATXA | MATH_NUMERIC | NONE | NONE |
The amount on which taxes are assessed. | ||||
szTaxexemptreason | EXR2 | char | NONE | NONE |
A value in user defined code table 00/EX that controls how a tax is assessed and distributed to the general ledger revenue and expense
| ||||
cTaxcalcmethod | FICM | char | NONE | NONE |
A code that specifies the tax method that the Vertex payroll-tax calculation system uses to calculate certain taxes. The codes are defined in
| ||||
cVATRecoverableFlag3 | EVAT | char | NONE | NONE |
The Vat Recovery Flag is used to identify transactions for which the VAT tax may be recovered by the company.
Valid Values:
0 NOT
| ||||
cVATRecoverableFlag4 | EVAT | char | NONE | NONE |
The Vat Recovery Flag is used to identify transactions for which the VAT tax may be recovered by the company.
Valid Values:
0 NOT
| ||||
cVATRecoverableFlag5 | EVAT | char | NONE | NONE |
The Vat Recovery Flag is used to identify transactions for which the VAT tax may be recovered by the company.
Valid Values:
0 NOT
| ||||
szDescriptiontaxarea | TAXA | char | NONE | NONE |
Text that names or describes the tax rate/area. You can use this 30-character field, for example, to identify a zip code for a tax area or to
| ||||
cFactorValueType | FVT | char | NONE | NONE |
A code that indicates whether the Factor Value is a multiplier (%) or an additional/deductable amount (A) when applied to an order's price. | ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnDocVoucherInvoiceE | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szCompanyKey | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
szDocumentPayItem | SFX | char | NONE | NONE |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
| ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnNoOfLinesOnOrder | NLIN | MATH_NUMERIC | NONE | NONE |
A number representing the number of lines on either a purchase or sales order.
or The number of receivers recorded during the receipts
| ||||
szCostCenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szComputerID | CTID | char | NONE | NONE |
szJobNumber | JOB | char | NONE | NONE |
Job Number | ||||
cCallTaxCalcFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szReportCode007 | AC07 | char | NONE | NONE |
One of 30 reporting codes that you can assign to an address in the Address Book system. Category Code 07 is used in the 1099 process to
| ||||
mnMaximumTaxAmt | MTAX | MATH_NUMERIC | NONE | NONE |
A number that identifies the maximum amount that an item can be taxed. If the unit cost of an item is more than the amount that you specify in
| ||||
cSystemCodeFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnCurrencyConverRateOv | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
|
None |
F4008 Tax Areas |