AsOfServer

F0414 As Of Server

Minor Business Rule

Object Name: B0400530

Parent DLL: CFIN

Location: Client/Server

Language: C

B0400530
F0414 As Of Server

Functional Description

Purpose
The purpose of this business function is to accumulate payment amounts prior to the As of Date.

Setup Notes and Prerequisites
If cPaymentFlag is returned as a 0, then no as of processing was done.
If cPaymentFlag is returned as a 1, then as of processing was done.

Special Logic
Special Logic For Drafts (P1 Documents)

Technical Specifications

Parameters
ItemDescriptionI/OReq?Notes
DGJ   jdGLDateI
DAG   jdDateAgeAsOfI
DOC   mnDocVoucherInvoiceEI
DCT   szDocumentTypeI
KCO   szCompanyKeyI
SFX   szDocumentPayItemI
AG    mnAmountGrossI
AAP   mnAmountOpenO
ACR   mnAmountCurrencyI
FAP   mnAmountForeignOpenO
ADSC  nAmtDiscountAvailableO
CDS   nForeignDiscountAvailO
SFXE   mnPayItemExtensionNumberI
EV01  cVoidFlagO
EV02  cPaymentFlagO

Related Tables
F0411 - Account Payable Ledger
F0413 - Account Payable Matching Document
F0414 - Account Payable Matching Document Detail
F0911 - Account Ledger

Related Business Functions

Processing
• Process Regular Vouchers
•

Process for Drafts

•
Set Selection Parameters - F0911
• JDB_SetSelection - F0911
• JDB_SelectKeyed - F0911
• While Loop

•
JDB_Fetch - F0911
• Accumulate payment amounts prior to As of Date G/L Date is greather that the As Of Date
and Batch Type = 'G'
• Assign amount open with the difference of original amount and total payments made before
As Of Date.

•
Process for Payments

•
Set Selection Parameters - F0414
• JDB_SetSelection - F0414
• JDB_SelectKeyed - F0414
• While Loop

•
JDB_Fetch - F03B14
• Get the G/L Date from F0413 by the Payment ID on F0414
• Accumulate payment amounts prior to As of Date
• Assign amount open with the difference of original amount and total payments made before
As Of Date

• Process Void Vouchers
•
Set Selection Parameters - F0411
• JDB_SetSelection - F0411
• JDB_SelectKeyed - F0411
• While Loop

•
JDB_Fetch - F0411
• Accumulate payment amounts prior to As of Date G/L Date is greather that the As Of Date
• Change the sign of the amounts
• Assign amount open with the difference of original amount and total payments made before
As Of Date.

• Return ER_S

Data Structure

D0400530 - F0414 As Of Server

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

jdGLDate DGL JDEDATE OPT 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.

jdDateAsOf DAG JDEDATE OPT NONE

A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the
invoice date, statement date, due date, or G/L date, which is defined by the value in the Date Aging Based On field (AGE), and then uses the
value in the Aging Method field (AGEM) to determine which aging category to update. If you use method 1, the aging categories are defined in
the Aging Days fields (CRDY, AGR1, AGR2, AGR3, AGR4, AGR5, AGR6, and AGR7) in the Accounts Receivable constants. If you leave this
field blank, the system uses the current date. Note: The Sales Order Management system also uses this date for credit checks. Leave this
field blank to ensure that the credit checks are always current.

mnDocVoucherInvoiceE DOC MATH_NUMERIC OPT 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.

szDocumentType DCT char OPT 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

szCompanyKey KCO char OPT 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.

szDocumentPayItem SFX char OPT NONE

A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
multiple pay items, the numbers are sequential.

mnAmountGross AG MATH_NUMERIC OPT NONE

A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
the tax explanation code. The system does not decrease the gross amount when payments are applied. When you void a transaction, the
system clears the gross amount field.

mnAmountOpen AAP MATH_NUMERIC OPT NONE

The amount of an invoice or voucher pay item that is unpaid.

mnAmountCurrency ACR MATH_NUMERIC OPT NONE

The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
to Y, the foreign amount is multiplied by the exchange rate to arrive at the domestic amount. If the Multi-Currency Conversion option is set to Z,
the foreign amount is divided by the exchange rate.

mnAmountForeignOpen FAP MATH_NUMERIC OPT NONE

The unpaid foreign amount of a transaction.

mnAmtDiscountAvailable ADSC MATH_NUMERIC OPT NONE

The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The
system calculates discount amounts based on the payment term entered on the transaction. Note: If the system calculates the discount, verify
that it applies to the pay item specified. Usually, freight, sales tax, and labor charges that are included in the gross amount do not qualify for
discounts.

mnForeignDiscountAvail CDS MATH_NUMERIC OPT NONE

The foreign amount of the discount available as opposed to the amount of the discount actually taken.

mnPayItemExtensionNumber SFXE MATH_NUMERIC OPT NONE

A code to designate an adjusting entry to a pay item on a voucher or invoice. This field is required so that each record is unique.

cVoidFlag VOD char OPT NONE

This code is used to determine whether an entry has been voided. A value of V will be entered into this field if the record has been
voided. Note:   A/P processing may also fill this field with a value of U to mark prepayment records entered through the Manual Payment without
Voucher Match program (P04106).

cPaymentFlag EV01 char OPT NONE

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

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
jdGLDate	DGL	JDEDATE	OPT	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.
jdDateAsOf	DAG	JDEDATE	OPT	NONE
A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the invoice date, statement date, due date, or G/L date, which is defined by the value in the Date Aging Based On field (AGE), and then uses the value in the Aging Method field (AGEM) to determine which aging category to update. If you use method 1, the aging categories are defined in the Aging Days fields (CRDY, AGR1, AGR2, AGR3, AGR4, AGR5, AGR6, and AGR7) in the Accounts Receivable constants. If you leave this field blank, the system uses the current date. Note: The Sales Order Management system also uses this date for credit checks. Leave this field blank to ensure that the credit checks are always current.
mnDocVoucherInvoiceE	DOC	MATH_NUMERIC	OPT	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.
szDocumentType	DCT	char	OPT	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
szCompanyKey	KCO	char	OPT	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.
szDocumentPayItem	SFX	char	OPT	NONE
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has multiple pay items, the numbers are sequential.
mnAmountGross	AG	MATH_NUMERIC	OPT	NONE
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on the tax explanation code. The system does not decrease the gross amount when payments are applied. When you void a transaction, the system clears the gross amount field.
mnAmountOpen	AAP	MATH_NUMERIC	OPT	NONE
The amount of an invoice or voucher pay item that is unpaid.
mnAmountCurrency	ACR	MATH_NUMERIC	OPT	NONE
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set to Y, the foreign amount is multiplied by the exchange rate to arrive at the domestic amount. If the Multi-Currency Conversion option is set to Z, the foreign amount is divided by the exchange rate.
mnAmountForeignOpen	FAP	MATH_NUMERIC	OPT	NONE
The unpaid foreign amount of a transaction.
mnAmtDiscountAvailable	ADSC	MATH_NUMERIC	OPT	NONE
The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The system calculates discount amounts based on the payment term entered on the transaction. Note: If the system calculates the discount, verify that it applies to the pay item specified. Usually, freight, sales tax, and labor charges that are included in the gross amount do not qualify for discounts.
mnForeignDiscountAvail	CDS	MATH_NUMERIC	OPT	NONE
The foreign amount of the discount available as opposed to the amount of the discount actually taken.
mnPayItemExtensionNumber	SFXE	MATH_NUMERIC	OPT	NONE
A code to designate an adjusting entry to a pay item on a voucher or invoice. This field is required so that each record is unique.
cVoidFlag	VOD	char	OPT	NONE
This code is used to determine whether an entry has been voided. A value of V will be entered into this field if the record has been voided. Note: A/P processing may also fill this field with a value of U to mark prepayment records entered through the Manual Payment without Voucher Match program (P04106).
cPaymentFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.