RelieveCommitments

F0902 Relieve Commitments

Major Business Rule

Object Name: B4300420

Parent DLL: CDIST

Location: Client/Server

Language: C

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'

/* Process only unrelieved transactions
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'

Check for existance of the value in OrderType in the UDC table 40/CT using business
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

set CommitmentReliefFlag to 'P' and End Processing

if DS4311.PDAID is equal to AccountNumber

If DS4311.PDFUF2 is equal to 'N' then

Assign 'N' to INT_PostQuantitiesFlag

Else

Assign NULL to INT_PostQuantitiesFlag

CommitmentUpdate (X00COM)
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

Set the flag CommitmentReliefFlag to 'P'
EndProcessing

Data Structure

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, or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company. If two or more original documents have the same document number and document type, you can use the document company to locate the desired document.
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 number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are: Accounts Payable o Original document - voucher o Matching document - payment Accounts Receivable o Original document - invoice o Matching document - receipt Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents: deductions, unapplied receipts, chargebacks, and drafts.
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 types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
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 reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
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 sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to assign a next number. In this case, you probably would not use the order company to locate the document.
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 multiple transactions for an original order. For purchase orders, the code is always 000. For sales orders with multiple partial receipts against an order, the first receiver used to record receipt has a suffix of 000, the next has a suffix of 001, the next 002, and so on.
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 this number,but in some cases you can override it.
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 ledger posting, tax ledger posting, alternate currency ledger posting, etc. This code is used to designate job cost projections and/or commitment relief updates have been completed.
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. Possible values are: blank The commitment should be relieved. N The commitment relief has already been performed and should not be performed for this journal entry. X The commitment should be relieved; however if the receipt/payment is for a different exchange rate than the purchase order or contract, omit any exchange rate conversion.
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 can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
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 address book number. If you enter a subledger, you must also specify the subledger type.
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 editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
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 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.
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 year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
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 General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.
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 financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.
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 minus sign (-) either before or after the amount.
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, hours, and so on.
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 can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
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 reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
mnDistributionLineNumber	DLNID	MATH_NUMERIC	OPT	NONE

Related Functions

B4300110 Get Purchase Order Detail
X0005 Get User Defined Codes
X00COM Update Commitment Ledger

Related Tables

F0026 Job Cost Constants
F4311 Purchase Order Detail File