Functional Description
Purpose
The purpose of this business function is to relieve commitments from the Purchasing Commitments
Ledgers (PA and PU) for a General Ledger Transaction.
Setup Notes and Prerequisites
NOTE : The calling UBE / GL Update should take the value assigned to the flag ALT4 and update the
corresponding column in the F0911 table (GL transactions).
Technical Specification
2.4Processing
Use the company KCO to fetch the columns CLJCP (Job Cost Projections) and CLCMTR (Commitment Relief
Flag) from the F0026 table. If fetch fails (no record exists) then use the key '00000' to retry fetch
against the F0026 table.
If no record is found then set CommitmentReliefFlag to 'P' and end processing.
/* Check to see if relief of commitments if allowed for this company.
If F0026.CMTR = 'Y'
OR if F0026.CMTR = 'N' AND F0026.JCP = 'Y'
If CommitmentReliefFlag is NOT equal to 'P' and 'C'
AND CommitmebtProcessedFlag is NOT equal to 'N"
AND OrderNumber is not equal to 0 or BLANK or NULL
AND OrderNumber does NOT contain ALPHA characters
AND LedgerType is NOT equal to 'CA'
function GetUDC
If Value does not exits in the UDC table 40/CT then set CommitmentReliefFlag to 'P' and
End Processing.
Use the business function GetPurchaseOrder to retrieve the PO Details using the key
valuse from the data structure : OrderNumber (probably converted to Math-Numeric), OrderType,
OrderCompany, OrderSuffix and OrderLine.
If Purchase Order detail does NOT exist
DocumentAction<- 'R'
PO_ContractNumber<- OrderNumber (converted
MN).
PODocumentType<- OrderType
PODocumentCompany<- OrderCompany
PODocumentSuffix<- OrderSuffix
PODocumentLine<- OrderLineNumber
ShortAccountID<- AccountID
BusinessUnitN/A
ObjectAccountN/A
SubsidiaryN/A
CompanyN/A
Century<- Century
FiscalYear<- FiscalYear
PeriodNumber<- PeriodNumber
GeneralLedgerDate<- GLDate
Subledger<- Subledger
SubledgerType<- SubledgerType
Callingapplication<- CallingApplicationName
QuantityRelatedToAction<- GLUnits
AmountRelatedToAction<- GLAmount
TaxAmountRelatedToAction<- 0
PO_ContractQuantityN/A
PO_ContractUnitCostN/A
PO_ContractOpenQuantityN/A
PO_ContractOpenAmountN/A
PO_ContractReceivedQuantityN/A
PO_COntractReceivedAmountN/A
PO_ContractTaxAmountN/A
RecalculateProjectedFinalFlag<- '1'
WriteAuditRecordToPOLedger<- '1'
CurrencyProcessingFlagN/A
ProjectionsMultiplePeriodsN/A
ProjectionsThruPeriodNumberN/A
ProjectionsThruFiscalYearN/A
JournalEntryDocumentCompanyGLKeyCompany
JournalEntryDocumentNumberGLDocumentNumber
JournalEntryDocumentTypeGLDocumentType
JournalEntryLineNumberGLLineNumber
PostQuantitiesFlagINT_PostQuantitiesFlag
CurrencyExchangeRateExchangeRate
CommitmentReliefFlagCommitmentProcessFlag
ErrorOnUpdateN/A
PointerToF4311DS<- DS4311
EndProcessing
D4300420 - Relieve Commitments
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szGLKeyCompany | 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,
| ||||
mnGLDocumentNumber | 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
| ||||
szGLDocumentType | 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
| ||||
mnGLLineNumber | JELN | MATH_NUMERIC | NONE | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes. | ||||
szOrderNumber | PO | char | NONE | NONE |
A document that authorizes the delivery of specified merchandise or the rendering of certain services. | ||||
szOrderType | DCTO | char | NONE | 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
| ||||
szOrderCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szOrderSuffix | SFXO | char | NONE | NONE |
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
| ||||
mnOrderLineNumber | 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
| ||||
cCommitmentReliefFlag | ALT4 | char | NONE | NONE |
The alternate G/L posting codes are used for transactional posting other than the normal G/L posting. Examples include service date
| ||||
cCommitmentProcessFlag | ALT7 | char | NONE | NONE |
This field determines how the journal entry should impact a commitment made in the Purchasing and/or Contract Management systems.
| ||||
szLedgerType | LT | char | NONE | NONE |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
szAccountID | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
szSubledger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | NONE | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | NONE | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
jdGLDate | DGL | JDEDATE | NONE | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
mnGLAmount | AA | MATH_NUMERIC | NONE | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
mnGLUnits | U | MATH_NUMERIC | NONE | NONE |
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,
| ||||
mnGLExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
szTransactionCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szCallingApplicationName | PGM | char | NONE | NONE |
The name of an executable program. | ||||
szGLOrderType | 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
| ||||
mnDistributionLineNumber | DLNID | MATH_NUMERIC | OPT | NONE |
B4300110 Get Purchase Order Detail | ||||
X0005 Get User Defined Codes | ||||
X00COM Update Commitment Ledger |
F0026 Job Cost Constants | ||||
F4311 Purchase Order Detail File |