AccumulateReceiptsForInquiry

Accumulate Receipts For Inquiry

Major Business Rule

Object Name: B430301

Parent DLL: CDIST

Location: Client/Server

Language: C

Functional Description

Purpose

This business function will retrieve information from the Purchase Order Receipts File (f43121) on
Amount paid to date and quantity and amount not vouchered. It also accumulates the amounts that are in a
receipts routing phase for purchase order Inquiry Purposes. It also returns the Return date value
from the F43121 file. If ErrorCodeF43121 will return a value of 1 if a record is not fetched in the
F43121 and ErrorCodeF43092 will contain a a value of 1 if fetch on F43092 fails

Edits:

Retrievals:
a. Using the fetch key
MATC = '1'
DOCO
DCTO
KCOO
LNID
Fetch all matching records from the Purchase Receipts file (F43121).

If the PRLAND is not equal to '2' and is not equal to '3' then

If the field PRRTGC is equal to 'Y' then move '1' into the RoutingActiveFlag.

Add the fileds
PRQTYR
PRQTYW
PRQTYC
PRQYTJ
PRQTYA
together and cumulate into the QuantityDispositioned field.

Add PRUOPN into QuantityNotVouchered

Add PRFAP into ForeignAmountNotVouchered

Add PRAOPN into DomesticAmountNotVouchered.

NOTE : there may be multiple records fetched from the F43121 table. Each record fetched needs
to be cumulated into the Data Structure amounts.

b. using the fetch key
MATC = '2'
DOCO
DCTO
KCOO
LNID
Fetch all matching records from the Purchase Receipts file (F43121).

If the PRLAND is not equal to '2' and is not equal to '3' then

Add PRUPTD into QuantityPaidToDate
Add PRFAPT inot ForeignAmountPaidToDate
Add PRAPTD into DomesticAmountPaidToDate

Returns:
Values as calculated above.

Data Structure

D430301 - Accumulate Receipts For Inquiry

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnOrderNumber DOCO MATH_NUMERIC NONE NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

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.

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
this number,but in some cases you can override it.

mnQuantityDispositioned QTYR MATH_NUMERIC NONE NONE

The number of units that you returned to the supplier through receipt routing. You can return goods for credit or for replacement. The system
writes these transactions as new lines on the original purchase order.

mnQuantityNotVouchered UOPN MATH_NUMERIC NONE NONE

The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
vouchered to date.

mnForeignAmountNotVouchered FAP MATH_NUMERIC NONE NONE

The unpaid foreign amount of a transaction.

mnDomesticAmountNotVouchered AOPN MATH_NUMERIC NONE NONE

The amount of the order, invoice, or voucher that is still unpaid or open. When you enter a document (for example, an order, invoice, or
voucher), the open amount is the original amount of that document. If you change the original amount, the open amount is reduced by the net
change. For example,payments, shipments, or receipts against a document result in a reduction of the open balance.

mnQuantityPaidToDate UPTD MATH_NUMERIC NONE NONE

The units paid to date on an invoice or voucher.

mnForeignAmountPaidToDate FAPT MATH_NUMERIC NONE NONE

Amount - Foreign Amount Paid to Date The amount, expressed in foreign currency, that is paid to date on an invoice or voucher.

mnDomesticAmountPaidToDate APTD MATH_NUMERIC NONE NONE

The amount paid to date on an invoice or voucher.

cRoutingActiveFlag RTGC char NONE NONE

Inidcates if the receipt transaction is in or through the purchase order routing process. Valid values are:    Y Transaction is in or has been
through the purchase order routing process.    N Transaction is not in or has not been through the purchase order routing process.

jdDateReceived RCDJ JDEDATE NONE NONE

The date you received this purchase order line.

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.

mnQuantityInRouting QTYO MATH_NUMERIC NONE NONE

The number of units currently at this operation.

cErrorCodeF43121 ERR char NONE NONE

The Data Field Error Code field is simply a generic data field to pass an error condition flag.  This field is one of the fields that make up the
external parameter data structure of the Data Dictionary Server.

cErrorCodeF43092 ERR char NONE NONE

The Data Field Error Code field is simply a generic data field to pass an error condition flag.  This field is one of the fields that make up the
external parameter data structure of the Data Dictionary Server.

szErrorCodeValue DTAI char NONE 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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cSuppressErrorMessage EV01 char NONE NONE

An option that specifies the type of processing for an event.

mnNumberOfLines 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
process.  This field will be used in Voucher Matching.

Related Functions

None

Related Tables

F43092 Purchase Order Receipt Routing File

F43121 Purchase Order Receiver File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
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.
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 this number,but in some cases you can override it.
mnQuantityDispositioned	QTYR	MATH_NUMERIC	NONE	NONE
The number of units that you returned to the supplier through receipt routing. You can return goods for credit or for replacement. The system writes these transactions as new lines on the original purchase order.
mnQuantityNotVouchered	UOPN	MATH_NUMERIC	NONE	NONE
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and vouchered to date.
mnForeignAmountNotVouchered	FAP	MATH_NUMERIC	NONE	NONE
The unpaid foreign amount of a transaction.
mnDomesticAmountNotVouchered	AOPN	MATH_NUMERIC	NONE	NONE
The amount of the order, invoice, or voucher that is still unpaid or open. When you enter a document (for example, an order, invoice, or voucher), the open amount is the original amount of that document. If you change the original amount, the open amount is reduced by the net change. For example,payments, shipments, or receipts against a document result in a reduction of the open balance.
mnQuantityPaidToDate	UPTD	MATH_NUMERIC	NONE	NONE
The units paid to date on an invoice or voucher.
mnForeignAmountPaidToDate	FAPT	MATH_NUMERIC	NONE	NONE
Amount - Foreign Amount Paid to Date The amount, expressed in foreign currency, that is paid to date on an invoice or voucher.
mnDomesticAmountPaidToDate	APTD	MATH_NUMERIC	NONE	NONE
The amount paid to date on an invoice or voucher.
cRoutingActiveFlag	RTGC	char	NONE	NONE
Inidcates if the receipt transaction is in or through the purchase order routing process. Valid values are: Y Transaction is in or has been through the purchase order routing process. N Transaction is not in or has not been through the purchase order routing process.
jdDateReceived	RCDJ	JDEDATE	NONE	NONE
The date you received this purchase order line.
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.
mnQuantityInRouting	QTYO	MATH_NUMERIC	NONE	NONE
The number of units currently at this operation.
cErrorCodeF43121	ERR	char	NONE	NONE
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the external parameter data structure of the Data Dictionary Server.
cErrorCodeF43092	ERR	char	NONE	NONE
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the external parameter data structure of the Data Dictionary Server.
szErrorCodeValue	DTAI	char	NONE	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnNumberOfLines	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 process. This field will be used in Voucher Matching.

F43092 Purchase Order Receipt Routing File
F43121 Purchase Order Receiver File