Functional Description
Purpose
The purpose of this function is to void or nsf a draft at any status.
Setup Notes and Prerequisites
The following validation must be done before calling this business function:
Event Void/Delete
Special Logic
Technical Specification
Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
VREszVoidReasonCodeIYesVoid reason code
VDGJjdVoidDateForGLJulianIYesVoid date
PIDszProgramIdIYesProgram Id
ICUmnBatchNumberIYesBatch Number
ICUTszBatchTypeIYesBatch Type
DICJjdDateBatchJulianIYesBatch Date
ISTcBatchStatusIYesBatch Status
PYIDmnPaymentIDIYesPayment Id
EV01cFlagUpdatePayInstIYesFlag for the Pay instrument of
the invoice record to be updated
EV02cRenewalFlagIYesRenewal Flag
PYINcPayInstforInvoiceIYesPay instrument for new
invoice
RYINcPayInstforDraftIYesPay instrument for draft to be
updated to
AIDszAccountIdForNewDraftIYesAccount Id for new draft
EV04cPostedYNPartiallyIYesPosted partially flag
EV06cVoidNSFModeIYesV or N for Void or NSF
PYIDmnNewPaymentIdIYesNew Draft's payment ID
CKNUszDraftNumberIYesDraft Number
VLDTjdDraftDueDateIYesDraft Due Date
CTRYmnCenturyGLDateIYesCentury for GL Date
FYmnFiscalYear1GLIYesFiscal Year
PNmnPeriodNoGeneralLedgeIYesGeneral Ledger period number
DOCGmnInternalDraftNumberIYesInternal Draft Number
DMTJjdDraftDateNeIYesNew Draft Date
EV01cR1OpenAmountFlagIYesOpen amount flag
PSTcChargebackPayStatusIYesCharge back pay status code
EV04cChargebackDateOptionIYesCharge back date option
MATH01mnAutoWriteOffUndeIYesAutomatic Writeoff Under
Amount
ARDRszAdjReasonCodeDebitWriteOfIYesDebit Write off reason code
MATH02mnAutoWriteOffOverAmounIYesAutomatic Writeoff Over
amount
ARCRszAdjReasonCodeCreditWriteOfIYesCredit Write off reason code
MATH03mnManWriteOffUnderAmountdIYesManual Write off under amount
MATH04mnManWriteOffOverAmountdIYesManual Write off over amount
EV10cEditPayApproveInvoicesIYesPay approved invoices
EV11cOverpaymentOptionIYesOverpayment Option
MCUszCostCenterIYesCost Center
CRRmnRenewalCRRINoRenewal draft exchange rate
* Required if cRenewalFlag = 1
ERDJjdRenewalERDJINoRenewal draft exchange rate date
* Required if cRenewalFlag = 1
CRCMcRenewalCRCMINoRenewal draft coversion method
* Required if cRenewalFlag = 1
CRR2mnRenewalCRR2INoRenewal draft triang leg TWO
* Required if cRenewalFlag = 1
CRR1mnRenewalCRR1INoRenewal draft triang leg ONE
* Required if cRenewalFlag = 1
Related Tables
Table Table Description
F03B13Receipt Register File
F03B11Customer Ledger
F03B14A/R Check Detail File
F03B40A/R Deduction Management
Related Business Functions
Source NameFunction Name
B03B0012AR Apply Receipt To Invoice
B03B0069Create Maintain RU Detail
B03B0146F03B14 Create F03B14 Record GL Entry
B03B0156F03B11 Create R1 Record Draft
B0000004Batch Open On Initialize
B0000007Batch Revise On Transaction Commitment
B0000008Batch Revise On Exit
B03B0044F03B13Z1 Update Purge Flag To Y
B9800100Get Audit Information
B0000027Currency Conversion
Processing
A delete is performed when user selects to void an unposted record. The records are deleted from
F03B13, F03B14 and the F03B11 files are updated. When a user selects a void on the posted record the
void reason code, void date, the post code, batch number, void/nsf receipt, batch date void/nsf receipt
and NSF/Void code are updated. The records are updated in the F03B13 file, F03B14 file and F03B11
file.
The following files are updated:
Update F03B13 records:
Update Void/NSF reason code, Void/NSF date, post code, batch number, Void/NSF receipt, Batch Date
Void/NSF receipt and NSF/Void code. The NSF/Void code have the following values:
N NSF, V Void.
Update F03B14 records:
Update Void/NSF Reason Code, Void/NSF Date and Post Code.
Write a reversing entry for each F03B14 record.
Update F03B11 records:
Add gross amount, adjustment amount, chargeback amount and discount taken to open amount of the
invoice. If the invoice is closed it needs to be re-opened.
1.Open F03B13, F03B14, F03B11 and F03B40 tables. If an error occurs return error to application.
2.If this draft has pay items which have deductions associated with it verify that the deductions
have been void before trying to void this receipt.
3.If this draft has pay items which have chargebacks associated with them and the chargebacks are
partially paid set an error. If the chargeback has been fully paid and the receipt is unposted treat is
as posted.
4.Fetch the F03B13 draft record.
Update the batch.
Update the corresponding R1 record.
If draft renewal is on create new draft.
New draft is created using exchange rate from renewal parameters
If there is a deduction associated update deduction record.
If there is a chargeback associated update chargeback record.
Update original invoices.
If renewal flag is on pay original invoices with the new draft created.
Update the F03B14 records with batch information and mark it void
Insert reversing records.
Update the F03B13 record with void batch information.
If the record is unposted
Update the batch.
Delete the corresponding R1 record.
If draft renewal is on create new draft.
New draft is created using exchange rate from renewal parameters
If there is a deduction associated delete deduction record.
If there is a chargeback associated delete chargeback record.
Update original invoices.
If renewal flag is on pay original invoices with the new draft created.
Delete the F03B14 records
Delete the F03B13 record.
D03B0179 - Void NSF Draft At Any Status
Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
VREszVoidReasonCodeIYesVoid reason code
VDGJjdVoidDateForGLJulianIYesVoid date
PIDszProgramIdIYesProgram Id
ICUmnBatchNumberIYesBatch Number
ICUTszBatchTypeIYesBatch Type
DICJjdDateBatchJulianIYesBatch Date
ISTcBatchStatusIYesBatch Status
PYIDmnPaymentIDIYesPayment Id
EV01cFlagUpdatePayInstIYesFlag for the Pay instrument of
the invoice record to be updated
EV02cRenewalFlagIYesRenewal Flag
PYINcPayInstforInvoiceIYesPay instrument for new
invoice
RYINcPayInstforDraftIYesPay instrument for draft to be
updated to
AIDszAccountIdForNewDraftIYesAccount Id for new draft
EV04cPostedYNPartiallyIYesPosted partially flag
EV06cVoidNSFModeIYesV or N for Void or NSF
PYIDmnNewPaymentIdIYesNew Draft's payment ID
CKNUszDraftNumberIYesDraft Number
VLDTjdDraftDueDateIYesDraft Due Date
CTRYmnCenturyGLDateIYesCentury for GL Date
FYmnFiscalYear1GLIYesFiscal Year
PNmnPeriodNoGeneralLedgeIYesGeneral Ledger period number
DOCGmnInternalDraftNumberIYesInternal Draft Number
DMTJjdDraftDateNeIYesNew Draft Date
EV01cR1OpenAmountFlagIYesOpen amount flag
PSTcChargebackPayStatusIYesCharge back pay status code
EV04cChargebackDateOptionIYesCharge back date option
MATH01mnAutoWriteOffUndeIYesAutomatic Writeoff Under
Amount
ARDRszAdjReasonCodeDebitWriteOfIYesDebit Write off reason code
MATH02mnAutoWriteOffOverAmounIYesAutomatic Writeoff Over
amount
ARCRszAdjReasonCodeCreditWriteOfIYesCredit Write off reason code
MATH03mnManWriteOffUnderAmountdIYesManual Write off under amount
MATH04mnManWriteOffOverAmountdIYesManual Write off over amount
EV10cEditPayApproveInvoicesIYesPay approved invoices
EV11cOverpaymentOptionIYesOverpayment Option
MCUszCostCenterIYesCost Center
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szVoidReasonCode | VRE | char | OPT | NONE |
A code that explains why a receipt was voided. | ||||
jdVoidDateForGLJulian | VDGJ | JDEDATE | OPT | NONE |
The date that specifies the financial period to which the voided transaction is to be posted. Financial periods are set up in the Company
| ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cGLPostedCode | POST | char | OPT | NONE |
A code the system uses to determine whether a transaction is available for the post process. Valid codes
| ||||
cPayStatusCode | PST | char | OPT | 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
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | OPT | 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 | OPT | 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.
| ||||
jdDateBatchJulian | DICJ | JDEDATE | OPT | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
cBatchStatus | IST | char | OPT | NONE |
A user defined code (98/IC) that indicates the posting status of a batch. Valid values are:
Blank
Unposted batches that are pending
| ||||
mnPaymentID | PYID | MATH_NUMERIC | OPT | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
cFlagUpdatePayInst | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cRenewalFlag | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cPayInstforInvoice | PYIN | char | OPT | NONE |
A user defined code (00/PY) that determines the means by which a payment is issued to a supplier or received from the customer.
| ||||
cPayInstforDraft | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
szAccountIdForNewDraft | AID | char | OPT | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
cPostedYNPartially | EV04 | char | OPT | NONE |
PeopleSoft event point processing flag 04. | ||||
cVoidNSFMode | EV06 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnNewPaymentID | PYID | MATH_NUMERIC | OPT | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
szDraftNumber | CKNU | char | OPT | NONE |
For Auto Bank Statement, this code identifies the payment/receipt or reference number.
NOTE:
Bank Statement Detail section: The
| ||||
jdDraftDueDate | VLDT | JDEDATE | OPT | NONE |
The date that the payment amount was debited or credited to the bank account. The value date is not the date the bank reconciled the
| ||||
mnCenturyGLDate | CTRY | MATH_NUMERIC | OPT | 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
| ||||
mnFiscalYear1GL | FY | MATH_NUMERIC | OPT | 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
| ||||
mnPeriodNoGeneralLedge | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
mnInternalDraftNumber | DOCG | MATH_NUMERIC | OPT | NONE |
The document number of the corresponding journal entry that the system created when the receipt was posted. This field is used in
| ||||
jdDraftDateNew | DMTJ | JDEDATE | OPT | NONE |
The date on a payment or the date on which a receipt was entered.
In Accounts Payable, the manual payment date and the general ledger
| ||||
cR1OpenAmountFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cChargebackPayStatus | PST | char | OPT | 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
| ||||
cChargebackDateOption | EV04 | char | OPT | NONE |
PeopleSoft event point processing flag 04. | ||||
mnAutoWriteOffUnder | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
szAdjReasonCodeDebitWriteOff | ARDR | char | OPT | NONE |
A code that specifies the reason for a write off that results from an underpayment. | ||||
mnAutoWriteOffOverAmount | MATH02 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance High Value. | ||||
szAdjReasonCodeCreditWriteOff | ARCR | char | OPT | NONE |
A code that specifies the reason for a write-off that results from an overpayment. | ||||
mnManWriteOffUnderAmountd | MATH03 | MATH_NUMERIC | OPT | NONE |
- - - Bad Performance Low Value. | ||||
mnManWriteOffOverAmountd | MATH04 | MATH_NUMERIC | OPT | NONE |
Event point for Math Numeric. | ||||
cEditPayApproveInvoices | EV10 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cOverpaymentOption | EV11 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szCostCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnRenewalCRR | CRR | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
jdRenewalERDJ | ERDJ | JDEDATE | OPT | INPUT |
The date that the system uses to retrieve the exchange rate from the Currency Exchange Rates table (F0015). | ||||
cRenewalCRCM | CRCM | char | OPT | INPUT |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
mnRenewalCRR2 | CRR2 | MATH_NUMERIC | OPT | INPUT |
The exchange rate from the triangulation currency to the domestic currency (leg 2). This rate applies when you use triangulation to calculate
| ||||
mnRenewalCRR1 | CRR1 | MATH_NUMERIC | OPT | INPUT |
The exchange rate from the foreign currency of the invoice to the triangulation currency (leg 1). This rate applies when you use triangulation
|
B0000004 Batch - Open On Initialization | ||||
B0000007 Batch - Revise On Transaction Commitment | ||||
B0000008 Batch - Revise On Exit | ||||
B03B0012 F03B14 Apply Receipt to Invoice | ||||
B03B0044 F03B13Z1 Update Purge Flag To Y | ||||
B03B0069 F03B14 Maintain Unapplied Cash | ||||
B03B0146 F03B14 - Create F03B14 Record - GL Entry | ||||
B03B0154 Draft Change Delete Void NSF | ||||
B03B0156 F03B11 Create R1 Record Draft | ||||
B9800100 Get Audit Information |
F03B11 Customer Ledger | ||||
F03B13 Receipts Header | ||||
F03B14 Receipts Detail | ||||
F03B40 A/R Deduction Management |