1.Functional Description
1.1Purpose
The purpose of this business function is to calculate the Foreign and Domestic Minimum Amount (if needed), Foreign and Domestic Billable Amount,
Foreign and Domestic Taxable Amount, Foreign and Domestic Tax Amount and Foreign and Domestic Total Billable Amount. If Vertex is being used to
calculate taxes, the Taxable Flag will be ignored and Vertex will be used to decide if the amount is taxable or not.
from Call Entry (P17501) when adding a new call. If the pricing method is flat rate, billing for calls is being done, and the call has not yet been billed, then it
will be called from the Call MBF (N1700720) when updating a record. If the pricing method is time and materials and billing for calls is being done
then it will be called from Call Time Entry (P17505).
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
2.4Processing
//
// If Currency is Off OR Domestic Currency = Foreign Currency
// all Foreign fields should be set to blank and no currency processing
// is done.
//
If SL CurrencyProcessing is equal to "N" Or BF szCompanyCurrencyCode_CRDC is equal to BF szCustomerCurrencyCode_CRCD
// Initialize Foreign fields to '0'
//
BF mnForeignJournaledTaxAmt_JTXF = "0"
BF mnVertexForeignUnitPrice_ACUNB = "0"
BF mnTotalForeignBillableAmt_ACR = "0"
BF mnForeignTaxAmount_CITX = "0"
BF mnForeignTotalTaxableAmt_ACR = "0"
BF mnForeignDiscountAmount_CIDS = "0"
BF mnForeignBillableAmount_ACR = "0"
BF mnMinimumForeignAmount_MINAF = "0"
BF mnForeignFlatRateAmount_AMTFF = "0"
BF mnForeignBillingRate_ARTBF = "0"
//
// Check the Pricing Method
//
If BF cMethodofPricing_MTHPR is equal to "F"
// Take the greater of the Minimum Amount and the Flat
// Rate Amount and multiply by the Percentage Covered to get the
// Billable Amount
//
If BF mnMinimumAmount_MINAD is greater than or equal to BF mnFlatRateAmount_AMTFD
// Pricing Method is Time & Material
// Calculate the Minimum Amount if there is none
//
If BF mnMinimumAmount_MINAD is equal to
//
// Take the greater of the Minimum Amount and the Billable
// Rate and multiply by the Percentage Covered to get the
// Billable Amount
//
VA evt_mnBillHrXBillRate_AG = [BF mnBillableHours_HRBL]*[BF mnBillingRate_ARTBD]
If BF mnMinimumAmount_MINAD is greater than or equal to VA evt_mnBillHrXBillRate_AG
If BF cDiscountMethod_DSFT is equal to "P"
BF mnTotalTaxableAmount_AG = [BF mnBillableAmount_AG]-[BF mnDiscountAmount_IDSC]
CSMS Calculate Taxes
// Currency is On and the Foreign and Domestic
// Currencies are different.
//
If BF cMethodofPricing_MTHPR is equal to "F"
// Convert Foreign Minimum Amount to Minimum Amount
// OR
// Convert Minimum Amount to Foreign Minimum Amount
//
If BF cCurrencyMode_CRRM is equal to "F"
Decimals Trigger Get by CRDC CRCD
Currency Conversion, Calculate
//
// Take the greater of the Foreign Minimum Amount and the Foreign Flat
// Rate Amount and multiply by the Percentage Covered to get the
// Foreign Billable Amount
//
If BF mnMinimumForeignAmount_MINAF is greater than or equal to BF mnForeignFlatRateAmount_AMTFF
// Take the greater of the Minimum Amount and the Flat
// Rate Amount and multiply by the Percentage Covered to get the
// Billable Amount
//
If BF mnMinimumAmount_MINAD is greater than or equal to BF mnFlatRateAmount_AMTFD
// Pricing Method is Time & Material
// Calculate the Minimum Amount & Foreign Minimum Amount if there is none
//
If BF cCurrencyMode_CRRM is equal to "F"
BF mnMinimumAmount_MINAD = [BF mnMinimumBillableHours_MINHR]*[BF mnBillingRate_ARTBD]
// Convert Foreign Minimum Amount to Minimum Amount
//
Decimals Trigger Get by CRDC CRCD
Currency Conversion, Calculate
// Currency Mode = D
//
If BF mnMinimumAmount_MINAD is equal to
BF mnMinimumForeignAmount_MINAF = [BF mnMinimumBillableHours_MINHR]*[BF mnForeignBillingRate_ARTBF]
// Convert Minimum Amount to Foreign Minimum Amount
//
Decimals Trigger Get by CRDC CRCD
Currency Conversion, Calculate
//
// Take the greater of the Foreign Minimum Amount and the
// (Billable Hours * Foreign Billing Rate) and multiply by the Percentage
// Covered to get the Foreign Billable Amount
//
VA evt_mnBillHrXForBillRate_AG = [BF mnBillableHours_HRBL]*[BF mnForeignBillingRate_ARTBF]
If BF mnMinimumForeignAmount_MINAF is greater than or equal to VA evt_mnBillHrXForBillRate_AG
//
// Take the greater of the Minimum Amount and the
// (Billable Hours * Billing Rate) and multiply by the Percentage
// Covered to get the Billable Amount
//
VA evt_mnBillHrXBillRate_AG = [BF mnBillableHours_HRBL]*[BF mnBillingRate_ARTBD]
If BF mnMinimumAmount_MINAD is greater than or equal to VA evt_mnBillHrXBillRate_AG
If BF cDiscountMethod_DSFT is equal to "P"
// Calculate the Discount Amount on the Call - Foreign & Domestic
//
BF mnDiscountAmount_IDSC = [BF mnBillableAmount_AG]*([BF mnDiscountPercent_DSPC]/100)
BF mnForeignDiscountAmount_CIDS = [BF mnForeignBillableAmount_ACR]*([BF mnDiscountPercent_DSPC]/100)
//
// Calculate the Total Taxable Amount after the discount
// on the Call - Foreign & Domestic
//
BF mnTotalTaxableAmount_AG = [BF mnBillableAmount_AG]-[BF mnDiscountAmount_IDSC]
BF mnForeignTotalTaxableAmt_ACR = [BF mnForeignBillableAmount_ACR]-[BF mnForeignDiscountAmount_CIDS]
CSMS Calculate Taxes
D1701720 - Calculate Case Billing Amounts
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cFutureUse_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
cCurrencyMode_CRRM | CRRM | char | OPT | INPUT |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
szCompanyCurrencyCode_CRDC | CRDC | char | REQ | INPUT |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
szCustomerCurrencyCode_CRCD | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
mnExchangeRate_CRR | CRR | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
jdTaxEffectiveDate_EFTB | EFTB | JDEDATE | OPT | INPUT |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
mnCustomerNumber_ANC | ANC | MATH_NUMERIC | REQ | INPUT |
Client number in SAR records which corresponds to Address Book record. | ||||
mnPercentageCovered_PCOVR | PCOVR | MATH_NUMERIC | REQ | INPUT |
The percentage covered under warranty or contract. This is used to calculate the amount to bill or the amount to cost for the line item being
| ||||
cMethodofPricing_MTHPR | MTHPR | char | REQ | INPUT |
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values
| ||||
mnMinimumBillableHours_MINHR | MINHR | MATH_NUMERIC | OPT | INPUT |
The minimum number of hours to charge the customer. If the billable number of hours is less than the minimum number of hours, then the
| ||||
mnBillableHours_HRBL | HRBL | MATH_NUMERIC | OPT | INPUT |
The number of hours billed. | ||||
mnBillingRate_ARTBD | ARTBD | MATH_NUMERIC | OPT | INPUT |
The billing rate that the system uses when calculating the billable amount.
The billing rate is expressed in the currency that is set up for the
| ||||
mnForeignBillingRate_ARTBF | ARTBF | MATH_NUMERIC | OPT | INPUT |
The billing rate that the system uses when calculating the billable amount.
The billing rate is expressed in the currency that is set up for the
| ||||
mnFlatRateAmount_AMTFD | AMTFD | MATH_NUMERIC | OPT | INPUT |
The monetary amount charged to the customer regardless of how many hours were spent or how many parts were used in performing the
| ||||
mnForeignFlatRateAmount_AMTFF | AMTFF | MATH_NUMERIC | OPT | INPUT |
The monetary amount charged to the customer regardless of how many hours were spent or how many parts were used in performing the
| ||||
mnMinimumAmount_MINAD | MINAD | MATH_NUMERIC | OPT | BOTH |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
mnMinimumForeignAmount_MINAF | MINAF | MATH_NUMERIC | OPT | BOTH |
The minimum monetary amount to charge the customer. If the billable amount is less than the minimum amount, the system charges the
| ||||
mnBillableAmount_AG | AG | MATH_NUMERIC | OPT | BOTH |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnForeignBillableAmount_ACR | ACR | MATH_NUMERIC | OPT | BOTH |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
cDiscountMethod_DSFT | DSFT | char | OPT | INPUT |
On the Item Price Category Revisions, a $ indicates that the numeric type is an added amount, a % indicates the factor is a multiplier. | ||||
mnDiscountPercent_DSPC | DSPC | MATH_NUMERIC | OPT | INPUT |
Takeoff Pricing file discount percentage | ||||
mnDiscountAmount_IDSC | IDSC | MATH_NUMERIC | OPT | BOTH |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
mnForeignDiscountAmount_CIDS | CIDS | MATH_NUMERIC | OPT | BOTH |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
mnTotalTaxableAmount_AG | AG | MATH_NUMERIC | OPT | OUTPUT |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnForeignTotalTaxableAmt_ACR | ACR | MATH_NUMERIC | OPT | OUTPUT |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
mnTaxAmount_ITAM | ITAM | MATH_NUMERIC | OPT | OUTPUT |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
mnForeignTaxAmount_CITX | CITX | MATH_NUMERIC | OPT | OUTPUT |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
mnJournaledTaxAmount_JTAX | JTAX | MATH_NUMERIC | OPT | OUTPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
mnTotalBillableAmount_AG | AG | MATH_NUMERIC | OPT | OUTPUT |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnTotalForeignBillableAmt_ACR | ACR | MATH_NUMERIC | OPT | OUTPUT |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
cTaxableYN_TAX1 | TAX1 | char | REQ | INPUT |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
szTaxExplanationCode_EXR1 | EXR1 | char | REQ | INPUT |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
szTaxRateArea_TXA1 | TXA1 | char | REQ | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
mnSiteNumber_LANO | LANO | MATH_NUMERIC | REQ | INPUT |
The address book number for the lessor, renter, or lending institution. | ||||
szResponsibleBusinessUnit_MCUZ | MCUZ | char | REQ | INPUT |
Identifies a separate entity within a business for which you wish to track costs, for example, a warehouse location, job, project, work center,
| ||||
cSuppressErrorMessage_SUPPS | SUPPS | char | OPT | INPUT |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
szErrorMessageID_DTAI | DTAI | char | OPT | OUTPUT |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cVertexGeoCodesAreValid_EV01 | EV01 | char | REQ | INPUT |
An option that specifies the type of processing for an event. | ||||
szVertexFlatRateTransType_VVTY | VVTY | char | OPT | INPUT |
Vertex Sales and Use Tax transaction type. | ||||
szVertexTMTransactionType_VVTY | VVTY | char | OPT | INPUT |
Vertex Sales and Use Tax transaction type. | ||||
mnVertexCacheJobNumber_JOBS | JOBS | MATH_NUMERIC | OPT | BOTH |
The job number (work station ID) which executed the particular job. | ||||
szVertexShipFromGeoCode_VGCST | VGCST | char | OPT | INPUT |
The location to which a product is delivered. This location is used by the Quantum calculation system for determining the appropriate taxing
| ||||
szVertexShipToGeoCode_VGCST | VGCST | char | OPT | INPUT |
The location to which a product is delivered. This location is used by the Quantum calculation system for determining the appropriate taxing
| ||||
szVertexOrderAccGeoCode_VGCST | VGCST | char | OPT | INPUT |
The location to which a product is delivered. This location is used by the Quantum calculation system for determining the appropriate taxing
| ||||
cVertexActiveCache_EV01 | EV01 | char | OPT | BOTH |
An option that specifies the type of processing for an event. | ||||
szVertexCompany_CO | CO | char | REQ | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnVertexItemNumber_ITM | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
mnVertexCustomerNumber_AN8 | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szVertexLineType_LNTY | LNTY | char | OPT | INPUT |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szVertexCostType_COST | COST | char | OPT | INPUT |
| ||||
mnVertexCallNumber_DOCO | DOCO | MATH_NUMERIC | OPT | INPUT |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szVertexCallDocumentType_DCTO | DCTO | char | OPT | INPUT |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szVertexOrderSuffix_SFXO | SFXO | char | OPT | INPUT |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
mnVertexLineNumber_LNID | LNID | MATH_NUMERIC | OPT | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnVertexUnits_U | U | MATH_NUMERIC | OPT | INPUT |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
| ||||
mnVertexUnitPrice_ACUNB | ACUNB | MATH_NUMERIC | OPT | INPUT |
The actual unit billable amount. | ||||
mnVertexForeignUnitPrice_ACUNB | ACUNB | MATH_NUMERIC | OPT | INPUT |
The actual unit billable amount. | ||||
mnTriangulationRate1_CRRD | CRRD | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
| ||||
mnTriangulationRate2_CRRD | CRRD | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
| ||||
cCurrencyConversionMethod_CRCM | CRCM | char | OPT | INPUT |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
mnForeignJournaledTaxAmt_JTXF | JTXF | MATH_NUMERIC | OPT | OUTPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
szPaymentTermsCode_PTC | PTC | char | OPT | INPUT |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
mnPayTermDiscountPercent_DSPC | DSPC | MATH_NUMERIC | OPT | NONE |
Takeoff Pricing file discount percentage | ||||
mnPayTermsDiscountAvail_IDSC | IDSC | MATH_NUMERIC | OPT | NONE |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
mnPayTermsForDiscAvail_CIDS | CIDS | MATH_NUMERIC | OPT | NONE |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
szVertexProductCategory_VVTC | VVTC | char | OPT | INPUT |
User defined code used in the Vertex Tax Decision Maker for products or services that are non-taxable or are at a non-stanard rate. |
None |
None |