Functional Description
Purpose
This function inserts a new recurring document in the F03B11 file as part of the process of recycling
an existing document. If the function fails to write the new invoice to the F03B11 file it will set
an error without passing any error flags back to the calling application.
Setup Notes and Prerequisites
A valid existing document, that has recurring information set up (recurring frequency and number of
remaining payments) must be used with this function.
The Calculate Recurring Date (B0000050) function must be called first to calculate all the dates
associated with the new invoice (based on the recurring frequency and the processing options specified).
The F0011 Write Batch Header (B0000004) must also be called for every batch of recurring documents
being created to obtain batch information. The F0008 Get Fiscal Year Period Number (X0903) function must
be called to obtain fiscal date information for the company that recycles the document in question.
Finally, the X0010 Get Next Number (X0010) function must be called to obtain the document number for the
new invoice being created.
The value of the cPayStatusCode field should be set equal to the existing document's pay status code
unless that code is equal to "P". In that case the pay status code is left blank (i.e. if existing
document's pay status code is equal to "P" then set cPayStatusCode equal to blank).
The jdDateStatementJulian field can be used for specifying a statement date; however it is
recommended that this field be passed a blank value.
The mnRecurFrequencyOfPaym field should be set equal to the number of remaining payments of the
recycled document decremented by 1.
Special Logic
None.
Technical Specification
Parameters
Item DescriptionI/OReq?Notes
KCOszCompanyKeyIYCompany number of recycled document.
DOCmnDocVoucherInvoiceeIYDocument number of recycled document.
DCTszDocumentTypeIYDocument type of recycled document.
SFXszDocumentPayItemIYDocument pay item of recycled document.
DRFmnRecurFrequencyOfPaymIYRemaining payments of recycled document 1 (see note
above).
PSTcPayStatusCodeIYRecycled document's pay code if not "P" otherwise
DGJjdDateForGLAndVoucherIYAs determined by B0000050.
PNmnPeriodNumberIYAs determined by X0903.
ICUmnBatchNumberIYAs determined by B0000004.
ICUTszBatchTypeIYRecycled document's batch type.
DIVJjdInvoiceDateIYAs determined by B0000050.
DDJjdDueDateIYAs determined by B0000050.
DSVJjdServiceTaxDateIYAs determined by B0000050.
DOCmnDocumentNumberIYAs determined by X0010; new document's doc number.
RFszRecurringFrequencyIYRecycled document's recurring frequency.
ADSCmnDiscountAvailableIYRecycled document's discount available.
FAPmnForeignAmountIYForeign currency amount from recycled document.
POSTcPostStatusIYAlways
FYmnFiscalYearIYAs determined by X0903.
CTRYmnCenturyIYAs determined by X0903.
AAPmnOpenAmountIYDomestic open amount of recycled document.
AGmnAmountGrossIYDomestic gross amount of recycled document.
DDNJjdDateDiscountDueIYAs determined by B0000050.
ADSAmnAmountDiscountTakenIYAlways
CTLszStatementNumberIY
SMTJjdDateStatementJulianIY
Related Tables
F03B11Customer Ledger File
Related Functions
B9800100Get Audit Info
Processing
Open F03B11 file.
Determine if record exists in F03B11.
Move new information to F03B11 data structure fields.
Get Audit Info.
Write new ledger record (F03B11).
Close F03B11 file.
^
D03B0020 - Insert Recurring Invoice Record
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCompanyKey | 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,
| ||||
mnDocVoucherInvoicee | 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
| ||||
szDocumentType | 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
| ||||
szDocumentPayItem | SFX | char | NONE | 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
| ||||
mnRecurFrequencyOfPaym | DRF | MATH_NUMERIC | NONE | NONE |
The number of recurring invoices or vouchers that you want the system to process. This number includes the original transaction that you
| ||||
cPayStatusCode | PST | char | NONE | NONE |
A user defined code (00/PS) that indicates the current payment status for a voucher or an invoice. Examples of codes include:
A
Approved
| ||||
jdDateForGLAndVoucher | DGJ | JDEDATE | NONE | NONE |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
| ||||
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
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
szBatchType | ICUT | char | NONE | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
jdInvoiceDate | DIVJ | JDEDATE | NONE | NONE |
The date that either you or the system assigns to an invoice or voucher. This can be either the date of the supplier's invoice to you or the
| ||||
jdDueDate | DDJ | JDEDATE | NONE | NONE |
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount
| ||||
jdServiceTaxDate | DSVJ | JDEDATE | NONE | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
mnDocumentNumber | 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
| ||||
szRecurringFrequency | RF | char | NONE | NONE |
A code to specify the time interval between transactions that the system creates. Valid recurring frequency values
| ||||
mnDiscountAvailable | ADSC | MATH_NUMERIC | NONE | 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
| ||||
mnForeignAmount | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
cPostStatus | POST | char | NONE | NONE |
A code the system uses to determine whether a transaction is available for the post process. Valid codes
| ||||
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
| ||||
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
| ||||
mnOpenAmount | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
mnAmountGross | AG | MATH_NUMERIC | NONE | 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
| ||||
jdDateDiscountDue | DDNJ | JDEDATE | NONE | NONE |
In the Accounts Receivable system, the date that the invoice must be paid to receive the discount. The system calculates the discount due
| ||||
mnAmountDiscountTaken | ADSA | MATH_NUMERIC | NONE | NONE |
The amount by which an invoice or voucher is reduced if paid by a specific date. The discount taken does not have to be the same as the
| ||||
szStatementNumber | CTL | char | NONE | NONE |
Accounts Payable - A code the system uses to determine the order in which A/P payments are printed. The value of the field differs
| ||||
jdDateStatementJulian | SMTJ | JDEDATE | NONE | NONE |
The most recent date on which the system generated a statement for the invoice pay item. | ||||
cErrorFlag | FLAG | char | REQ | NONE |
Contains an indicator for the operation. |
B9800100 Get Audit Information | ||||
N7000690 B03B0020 - Plug & Play - 03B | ||||
X0903 Fiscal Date Edits + |
F03B11 Customer Ledger |