Functional Description
Purpose
This function is used to update Customer Ledger (F03B11) records through applications other than
Invoice Entry applications, primarily through Speed Status Change (P03B114). The application will blindly
update the fields specified by the user therefore the user should ensure that the values of the fields
being updated are correct.
Setup Notes and Prerequisites
None.
Special Logic
In cases where discount available amounts are updated, if one of the two discount available amounts
(foreign or domestic) is zero and the other one is not, and an exchange rate or the triangulation rates
are passed, then the function will calculate the missing discount available amount.
Technical Specification
Parameters
Item DescriptionI/OReq?Notes
KCOszCompanykeyIYDocument Company.
DOCmnDocvoucherinvoiceeIYDocument Number.
DCTszDocumenttypeIYDocument Type.
SFXszDocumentpayitemIYDocument Pay Item.
PSTcPaystatuscodeI/ONDocument Pay Status.
DDNJjdDatediscountduejulianI/ONDiscount due date.
ADSCmnAmtdiscountavailableI/ONDomestic discount available.
COszCompanyI/ON
CRCDszCurrencycodefromI/ONTransaction currency.
CRRmnCurrencyconverrateovI/ONExchange rate.
CDSmnForeigndiscountavailI/ONForeign discount available.
RMKszNameremarkI/ONCustomer remark.
AN8JmnAddnoalternatepayeeI/ONAlternate payee.
DDJjdDateduejulianI/ONDue date.
PYINcPaymentinstrumentI/ONPayment Instrument.
CTLszApcheckscontrolfieldI/ONCheck/Draft number.
PIDszProgramidI/ONProgram updating record.
CCT1szBaseCurrencycodeI/ONBase Currency.
ATXAmnAmountTaxableI/ONTaxable amount.
ATXNmnAmountTaxExemptI/ONTax exempt amount.
STAMmnAmtTaxI/ONTax amount.
CTXAmnForeignTaxableAmountI/ONForeign taxable amount.
CTXNmnForeignTaxExemptI/ONForeign tax exempt amount.
CTAMmnForeignTaxAmountI/ONForeign tax amount.
TXA1szTaxRateAreaI/ONTax rate area.
EXR1szTaxExplanationCodeI/ONTax explanation code.
DSVJjdDateServiceTaxI/ONService tax date.
PYRmnPayorAddressNumberI/ONPayor address number.
DNLTcDelinquencyLetterI/ONYes or No.
AFCcApplyFinChargesI/ONYes or No.
CRRmnTriangulationRate1I/ON
CRRmnTriangulationRate2I/ON
CRCMcCurrencyCoversionMethodI/ON
EFTjdTransactionDateI/ONTransaction date.
Related Tables
F03B11Customer Ledger File
Related Functions
B0000027CurrencyConvForAndDom
B9800100Get Audit Information
Processing
Perform Initializations.
Open F03B11.
If Open Table failed,
Return error.
Endif.
If (Currency = 'ON') AND (Exchange Rates exist) AND
(One of discount available amounts is zero while the other is not),
Calculate the missing discount available amount.
If function call failed,
Return error.
Endif.
Endif.
Get Audit Information.
Load update values.
Perform the update to F03B11.
If Update failed,
Close F03B11.
Return error.
Enfif.
Close F03B11.
Return success.
^
D03B0018 - AR Speed Status Update
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
| ||||
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
| ||||
jdDatediscountduejulian | 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
| ||||
mnAmtdiscountavailable | 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
| ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szCurrencycodefrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnCurrencyconverrateov | 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
| ||||
mnForeigndiscountavail | CDS | MATH_NUMERIC | NONE | NONE |
The foreign amount of the discount available as opposed to the amount of the discount actually taken. | ||||
szNameremark | RMK | char | NONE | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
mnAddnoalternatepayee | AN8J | MATH_NUMERIC | NONE | NONE |
An alternate address to which accounts payable can send payments due. | ||||
jdDateduejulian | 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
| ||||
cPaymentinstrument | PYIN | char | NONE | 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.
| ||||
szApcheckscontrolfield | 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
| ||||
szProgramid | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szBaseCurrencycode | CCT1 | char | NONE | NONE |
Enter the currency code of the common currency used to calculate the cross rate. The program copies the currency code you enter to the
| ||||
mnAmountTaxable | ATXA | MATH_NUMERIC | NONE | NONE |
The amount on which taxes are assessed. | ||||
mnAmountTaxExempt | ATXN | MATH_NUMERIC | NONE | NONE |
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the
| ||||
mnAmtTax | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). | ||||
mnForeignTaxableAmount | CTXA | MATH_NUMERIC | NONE | NONE |
That portion of the sale that is subject to tax in foreign currency. | ||||
mnForeignTaxExempt | CTXN | MATH_NUMERIC | NONE | NONE |
The foreign amount associated with this document which is not subject to sales, use or value-added tax due to the nature of the transaction
| ||||
mnForeignTaxAmount | CTAM | MATH_NUMERIC | NONE | NONE |
The tax amount in foreign currency. This can be the sales, use, or VAT tax. | ||||
szTaxRateArea | TXA1 | char | NONE | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode | EXR1 | char | NONE | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
jdDateServiceTax | DSVJ | JDEDATE | NONE | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
mnPayorAddressNumber | PYR | MATH_NUMERIC | NONE | NONE |
The address book number of the person or company that sends the payment. | ||||
cDelinquencyLetter | DNLT | char | NONE | NONE |
An option that specifies whether to print delinquency notices for the customer or company based on the notification instructions that are set
| ||||
cApplyFinCharges | AFC | char | NONE | NONE |
An option to specify whether to process delinquency fees for the customer.
On
Process delinquency fees
Off
Do not process delinquency
| ||||
mnTriangulationRate1 | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnTriangulationRate2 | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
jdTransactionDate | EFT | JDEDATE | OPT | NONE |
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
| ||||
szPaymentTermsCode | PTC | char | OPT | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
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
| ||||
mnTotalSentReminders | RMDS | MATH_NUMERIC | OPT | NONE |
This field specifies the number of delinquency notices that have been generated for an invoice pay item. | ||||
cNetStatusCode | NETST | char | OPT | NONE |
A user defined code (00/NS) that indicates the current netting status for a voucher or an invoice. Valid values are:
0
Ineligible for
|
B0000027 CurrencyConvForAndDom | ||||
B0000033 Get Exchange Rate | ||||
B9800100 Get Audit Information |
F03B11 Customer Ledger |