1.1Purpose
This NER will calculate the domestic amounts for Estimated Billable Unit, Estimated Billable Amount, Actual Billable Unit and Actual Billable
Amount, Estimated Payable Unit, Estimated Payable Amount, Actual Payable Unit and Actual Payable Amount for a part in the Parts List or a routing (labor) in
the Routing Instructions.
1.2Setup Notes and Prerequisites
1.3Special Logic
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
DTBILDateBilledIN
DTPAYDatePaidIN
BILLBillableFlagIN
PAYABPayableFlagIN
PYPRTPayForPartsIN
PCOVRPercentageCoveredIN
CTIDComputerIDIN
JOBSJobNumberIN
DCTOOrderTypeIN
DOCOOrderNumberIN
KCOOOrderCompanyIN
LNIDLineNumberIN
ASN2BillAdjScheduleIN
ASN4PayAdjScheduleIN
CRCDDomesticCurrencyCodeIN
SUPPSSuppressErrorMsgIN
DTAIErrorMessageIDIN
CGPCBillSoldToCustGrpIN
CPGPPaySoldToCustGrpIN
CGPCBillShipToCustGrpIN
CPGPPayShipToCustGrpIN
AREVAdjustmentRevLevelIN
EV02AdvanceRevLevelIN
EV03SuppressWriteToWFIN
AN8BillSoldToIN
AN8PaySoldToIN
ITMShortItemNumberIN
MMCUBranch/PlantIN
LNTYLineTypeIN
COCompanyIN
MCUBusinessUnitIN
PTCBillPaymentTermsCodeIN
TRAPPayPaymentTermsCodeIN
RYINBillPaymentInstrumentIN
PYINPayPaymentInstrumentIN
CTRCountryIN
PRODFProductFamilyIN
PRODMProductModelIN
PEFJPriceEffectiveDateIN
TYPSTypeOfServiceIN
WR01CatCode01IN
WR02CatCode02IN
WR03CatCode03IN
WR04CatCode04IN
COSTCostTypeIN
UORGEstimatedQuantityIN
UORGActualQuantityIN
URATUserReservedAmountIN
APUMUnitOfMeasureIN
LOCNLocationIN
LOTNLotIN
SHANBillShipToIN
SHANPayShipToIN
MTHPRBillMethodOfPricingIN
PMTHPPayMethodOfPricingIN
ESUNBEstBillUnitDomI/ON
EBILLEstBillAmtDomI/ON
ACUNBActBillUnitDomI/ON
TOTBActBillAmtDomI/ON
ESUNPEstPayUnitDomI/ON
EPAAPEstPayAmtDomI/ON
ACUNPActPayUnitDomI/ON
PAAPActPayAmtDomI/ON
2.2Related Tables
Table Table Description
2.3Related Business Functions
Source NameFunction Name
2.4Processing
//
// Calculate Estimated Billable Unit
//
If BF mnEstBillableUnit is equal to
BF mnEstBillableAmount = "0"
//
// Calculate Estimated Billable Amount
//
If BF mnEstBillableAmount is equal to
//
// Calculate Actual Billable Unit
//
If BF mnActualBillableUnit is equal to
BF mnActualBilledAmount = "0"
//
// Calculate Actual Billable Amount
//
If BF mnActualBilledAmount is equal to
//
// Calculate Estimated Payable Unit
//
If BF mnEstPayableUnit is equal to
BF mnEstPayableAmount = "0"
//
// Calculate Estimated Payable Amount
//
If BF mnEstPayableAmount is equal to
//
// Calculate Actual Payable Unit
//
If BF mnActualPayableUnit is equal to
BF mnActualPayableAmount = "0"
//
// Calculate Actual Payable Amount
//
If BF mnActualPayableAmount is equal to
is equal to
D1701130 - Calculate Parts Labor Pricing
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
jdDateBilled | DTBIL | JDEDATE | OPT | NONE |
In service billing, the date a customer was billed for a service. | ||||
jdDatePaid | DTPAY | JDEDATE | OPT | NONE |
The date a service provider was paid for a service. | ||||
cBillableYN | BILL | char | OPT | NONE |
Specifies whether a general ledger account should be billed. Valid codes are:
Y Yes, the account should be billed.
N No, it should not be
| ||||
cPayableYN | PAYAB | char | OPT | NONE |
This field specifies whether a general ledger account should be paid. Valid values are:
Y The account should be paid.
N The account
| ||||
cPayServProviderForParts | PYPRT | char | OPT | NONE |
A code to indicate if the service provider should be paid for parts used during a repair.
Valid values are:
Y or 1 - Pay the service provider
| ||||
mnPercentCovered | PCOVR | MATH_NUMERIC | OPT | NONE |
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
| ||||
szComputerID | CTID | char | REQ | INPUT |
mnJobnumberA | JOBS | MATH_NUMERIC | REQ | INPUT |
The job number (work station ID) which executed the particular job. | ||||
szOrderType | DCTO | char | OPT | NONE |
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
| ||||
mnOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderCompany | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szBillAdjSchedule | ASN2 | char | OPT | NONE |
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szPayAdjSchedule | ASN4 | char | OPT | NONE |
A user defined code (40/AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szDomesticCurrency | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
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 | char | OPT | NONE |
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
| ||||
szBillSoldToCustGrp | CGPC | char | OPT | NONE |
szPaySoldToCustGrp | CPGP | char | OPT | NONE |
A user defined code (40/PC) that identifies a customer group. You can group customers with similar characteristics, such as comparable
| ||||
szBillShipToCustGrp | CGPC | char | OPT | NONE |
szPayShipToCustGrp | CPGP | char | OPT | NONE |
A user defined code (40/PC) that identifies a customer group. You can group customers with similar characteristics, such as comparable
| ||||
cSuppressWriteToWF | EV03 | char | OPT | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
mnBillSoldTo | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnPaySoldTo | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szBranchPlant | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
szLineType | LNTY | char | OPT | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szBillPaymentTermsCode | PTC | char | OPT | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
szPayPaymentTermsCode | TRAP | char | OPT | NONE |
A code that indicates the default payment terms for a supplier. Payment terms determine the due date, discount amount, and discount due
| ||||
cBillPaymentInstrument | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
cPayPaymentInstrument | PYIN | char | OPT | NONE |
A user defined code (00/PY) that determines the means by which a payment is issued to a supplier or received from the customer.
| ||||
szCountry | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
szProductFamily | PRODF | char | OPT | NONE |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. | ||||
szProductModel | PRODM | char | OPT | NONE |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
jdPriceEffectiveDate | PEFJ | JDEDATE | OPT | NONE |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
cTypeOfService | TYPS | char | OPT | NONE |
A user defined code (00/TY) that indicates the classification of a work order or engineering change order.
You can use work order type as a
| ||||
szCategoriesWorkOrder001 | WR01 | char | OPT | NONE |
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only
| ||||
szCategoriesWorkOrder002 | WR02 | char | OPT | NONE |
A user defined code (00/W2) that indicates the type or category of a work order.
Note: A processing option for some forms lets you enter a
| ||||
szCategoriesWorkOrder003 | WR03 | char | OPT | NONE |
A user defined code (00/W3) that indicates the type or category of the work order.
Note: A processing option for some forms allows you to
| ||||
szCategoriesWorkOrder004 | WR04 | char | OPT | NONE |
A user defined code (00/W4) that indicates the type or category of the work order. | ||||
szCostType | COST | char | OPT | NONE |
A code that designates each element of cost for an item. Examples of the cost object types are:
o A1 Purchased raw material
o B1
| ||||
mnEstimatedQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnActualQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnUserReservedAmount | URAT | MATH_NUMERIC | OPT | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUnitOfMeasure | APUM | char | OPT | NONE |
The basic measurement abbreviation used to designate the quantity of an inventory item.
Examples are:
BA bale
LB - pound
BG bag
| ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnBillShipTo | SHAN | MATH_NUMERIC | OPT | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
mnPayShipTo | SHAN | MATH_NUMERIC | OPT | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
cBillMethodOfPricing | MTHPR | char | OPT | NONE |
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
| ||||
cPayMethodOfPricing | PMTHP | char | OPT | NONE |
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
| ||||
mnEstBillableUnit | ESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit cost for billing. | ||||
mnEstBillableAmount | EBILL | MATH_NUMERIC | OPT | NONE |
mnActualBillableUnit | ACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit billable amount. | ||||
mnActualBilledAmount | TOTB | MATH_NUMERIC | OPT | NONE |
The total amount billed through this application number. | ||||
mnEstPayableUnit | ESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit cost of the payable. | ||||
mnEstPayableAmount | EPAAP | MATH_NUMERIC | OPT | NONE |
This is the estimated payment amount used in service billing. | ||||
mnActualPayableUnit | ACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit payable amount. | ||||
mnActualPayableAmount | PAAP | MATH_NUMERIC | OPT | NONE |
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount
| ||||
cPartOrRouting_EV01 | EV01 | char | OPT | NONE |
0 = Part
| ||||
mnAdvPricingProcessID_PEID | PEID | MATH_NUMERIC | REQ | BOTH |
A code that identifies the Inter-Process Communication ID. | ||||
mnAdvPricingTransID_TCID | TCID | MATH_NUMERIC | REQ | BOTH |
szBillableCurrency | BCRCD | char | OPT | NONE |
The currency for the billable amounts of a service order. | ||||
mnBillableExchangeRate | BCRR | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for
| ||||
cBillableCurrencyMode | BCRRM | char | OPT | NONE |
A code that specifies whether the system uses the foreign currency (currency of the customer) or the domestic currency for billable
| ||||
mnForeignEstBillUnit | FESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is billable in the currency of the customer. | ||||
mnForeignEstBIllAmount | FEBILL | MATH_NUMERIC | OPT | NONE |
The estimated billable amount in the currency of the customer. | ||||
mnForeignActBillUnit | FACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is billable in the currency of the customer. | ||||
mnForeignActBillAmount | FTOTB | MATH_NUMERIC | OPT | NONE |
The actual amount that is billable in the currency of the customer. | ||||
mnForeignEstPayUnit | FESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is payable in the currency of the service provider. | ||||
mnForeignEstPayAmount | FEPAAP | MATH_NUMERIC | OPT | NONE |
The estimated payable amount in the currency of the service provider. | ||||
mnForeignActPayUnit | FACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is payable in the currency of the service provider. | ||||
mnForeignActPayAmount | FPAAP | MATH_NUMERIC | OPT | NONE |
The actual payable amount that is recorded in the foreign currency of the service provider. | ||||
mnPayableExchangeRate | PCRR | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for
| ||||
szPayableCurrency | PCRCD | char | OPT | NONE |
A code that indicates the currency of the payable amounts on a work order or claim. | ||||
cPayableCurrencyMode | PCRRM | char | OPT | NONE |
A code that specifies whether payable amounts are in the foreign currency (currency of the service provider) or in the domestic currency.
| ||||
mnUniqueKeyPricing | UKIDP | MATH_NUMERIC | OPT | NONE |
If no value is passed in this parameter, the NER will get one from next numbers system 17 index 5.
| ||||
mnEstPayAdjRevisionLevel_AREV | AREV | MATH_NUMERIC | OPT | NONE |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
mnActPayAdjRevisionLevel_AREV | AREV | MATH_NUMERIC | OPT | NONE |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
mnEstBillAdjRevisionLevel_AREV | AREV | MATH_NUMERIC | OPT | NONE |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
mnActBillAdjRevisionLevel_AREV | AREV | MATH_NUMERIC | OPT | NONE |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
cAdvanceRevisionLevel_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cUseBasePriceConstant_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cPayCurrConversionMeth_CRCM | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
cBillCurrConversionMeth_CRCM | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
|
None |
None |