Functional Description
Purpose
The Invoice Entry Master Business Function is used to create and maintain a document for Invoice
Entry Processing. F03B11 Begin Document performs defaulting and validation at the invoice header level. If
no errors are found, the information is cached in memory.
Setup Notes and Prerequisites
If calling F03B11 Begin Document for the first time, pass a Job Number of zero. The function will
retrieve a new Job Number from Next Numbers and return it to the calling application. To update the
header cache, call the function again and pass it the Job Number.
The function also requires that an invoice batch (type 'IB') be opened for update.
Special Logic
None.
Technical Specification
Parameters
Item DescriptionI/OReq?Notes
JOBSmnJobNumberI/OYPass zero on initial call. Pass Job Number on subsequent
calls.
CTIDszComputerIDIY
ACTNcActionCodeIY'A' or '1' for add,
'C' or '2' for change,
'D' or '4' for delete.
EV01cEditInstructionFlagINFuture use.
EV01cErrorFlagON' ' if successful,
'1' if warnings,
'2' if errors.
DOCmnDocumentNumberINIf zero, document number will be assigned by F03B11 End
Document.
DCTszDocumentTypeINIf blank, will default from processing option on F03B11
Edit Document.
KCOszDocumentCompanyINIf blank, will default from Company.
COszCompanyIY
AN8mnAddressNumberIY
ALPHszAlphaNameON
MCUszBusinessUnitI/ONIf blank, will default from Address Book.
POSTcPostCodeIY
DGJjdGLDateIY
DIVJjdInvoiceDateI/ONIf blank, will default from G/L Date.
RYINcPaymentInstrumentI/ONIf blank, will default from Customer Master.
PTCszPaymentTermsI/ONIf blank, will default from Customer Master.
ICUmnBatchNumberIY
ICUTszBatchTypeIYPass 'IB'.
DICJjdBatchDateIY
CRRmnExchangeRateI/ONIf zero, will be retrieved from Exchange Rate table.
CRCDszCurrencyCodeI/ONIf blank, will default from Customer Master.
CRDCszBaseCurrencyI/ONIf blank, will be retrieved from Company table.
CRRMcCurrencyModeI/ONIf blank, will default based on currency codes.
CMszCreditMessageI/ONIf blank, will default from Address Book.
PA8mnParentAddressI/ONIf zero, will be retrieved from Address Book.
DSVJjdServiceTaxDateI/ONIf blank, will default based on processing option setting.
SFXEmnLastPayItemINUsed to track the last pay item that was added.
EV01cHeaderChgFlagINPass a '1' if any header field was changed since the last
time Begin Document ran.
TSTAszTempCreditMsgI/ONIf blank, default from Customer Master.
ALKYszLongAddressNumberINIf not blank, this field will be used instead of Address
Number to validate.
VDGJjdVoidDateIYRequired if Action Code is 'D' and invoice has been posted.
EV01cBypassDefaultsINPass a '1' if defaulting should be suppressed.
CRRMcPrevCurrModeIYRequired after first call to Begin Document.
EV02cNoSplitINPass a '1' if split payment terms are not allowed.
ANIszRevenueAccountONDefault revenue account from Customer Master in long
account format.
DL01szAccountDescriptionONDefault revenue account description.
EXR1szTaxExplanationCodeI/ONIf blank, will default from Customer Master.
TXA1szTaxRateAreaI/ONIf blank, will default from Customer Master.
AREszAdjustmentReasonCodeIYRequired if Action Code is 'D'.
EV03cExchangeRateDateONValue of Exchange Rate Date processing option.
EV04cFutureFlag Future use.
JDEVERSszInvoicePOVersionI/ONIf blank, will default to version 'ZJDE0001'.
DTARszDocTyArDefaultJeONModel Journal Entry document type from Customer Master.
DCARmnDocNoArDefaultJeONModel Journal Entry document number from Customer Master.
KCORszCompanyKeyARModelONModel Journal Entry document company from Customer Master.
Related Tables
F0014Payment Terms
Related Functions
B0000026Edit Exchange Rate Tolerance
B0000033Get Exchange Rate
B0000036Edit Effective Date
B0000128Retrieve Company Currency Code
B0100002Get Parent Address
B0300005Delete Invoice from F0311
B03B0013Delete Invoice from F03B11
B0400001Default Currency Fields
N0100041Address Book Master Business Function
N0100042Customer Master Business Function
N7000570Invoice Entry Plug & Play
X0010Next Numbers
X0903Edit Date
XX0901Validate Account Number
Processing
D03B0011A - F03B11 Begin Document
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
szComputerID | CTID | char | NONE | NONE |
cActionCode | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
cEditInstructionFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
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
| ||||
szDocumentCompany | 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,
| ||||
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
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szAlphaName | ALPH | char | NONE | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
szBusinessUnit | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
cPostCode | POST | char | NONE | NONE |
A code the system uses to determine whether a transaction is available for the post process. Valid codes
| ||||
jdGLDate | 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
| ||||
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
| ||||
cPaymentInstrument | RYIN | char | NONE | 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
| ||||
szPaymentTerms | PTC | char | NONE | 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.
| ||||
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.
| ||||
jdBatchDate | DICJ | JDEDATE | NONE | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
mnExchangeRate | 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
| ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szBaseCurrency | CRDC | char | NONE | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
szCreditMessage | CM | char | NONE | NONE |
A value in the user defined code table 00/CM that indicates the credit status of a customer or supplier. Examples are:
1
Over credit
| ||||
mnParentAddress | PA8 | MATH_NUMERIC | NONE | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
jdServiceTaxDate | DSVJ | JDEDATE | NONE | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
mnLastPayItem | SFXE | MATH_NUMERIC | NONE | 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. | ||||
cHeaderChgFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szTempCreditMsg | TSTA | char | NONE | NONE |
A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The
| ||||
szLongAddressNumber | ALKY | char | NONE | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
jdVoidDate | VDGJ | JDEDATE | NONE | 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
| ||||
cBypassDefaults | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cPrevCurrMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
cNoSplit | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szRevenueAccount | ANI | char | NONE | NONE |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
szAccountDescription | DL01 | char | NONE | NONE |
A user defined name or remark. | ||||
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
| ||||
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
| ||||
szAdjustmentReasonCode | ARE | char | NONE | NONE |
A code that identifies the reason that an invoice pay item was voided. | ||||
cExchangeRateDate | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cFutureFlag | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
szInvoicePOVersion | JDEVERS | char | NONE | NONE |
The name given to identify a version of the software. | ||||
szDocTyArDefaultJe | DTAR | char | NONE | NONE |
A code that identifies the type of model journal entry to use for a particular customer. | ||||
mnDocNoArDefaultJe | DCAR | MATH_NUMERIC | NONE | NONE |
A code that identifies the document number of the model journal entry to use for a particular customer. | ||||
szCompanyKeyARModel | KCOR | char | NONE | NONE |
A number that, along with A/R Model Document Type (DTAR) and A/R Model Document Number (DCAR), uniquely identifies the model
| ||||
cOriginatingSystem | OMOD | char | OPT | NONE |
A user defined code (03B/OS) that identifies the system that generated the invoice or credit memo. Valid values are:
Blank
Not Applicable.
| ||||
szCollectionManager | CLMG | char | OPT | NONE |
The name of the collection manager responsible for managing this customer's account. You must set up the collection manager in the
| ||||
szCreditManager | CMGR | char | OPT | NONE |
The name of the credit manager responsible for approving changes to the credit limit. You must set up the credit manager in the address
| ||||
jdExchangeRateDate | ERDJ | JDEDATE | OPT | NONE |
The date that the system uses to retrieve the exchange rate from the Currency Exchange Rates table (F0015). | ||||
mnJobLevelCacheNumber | JOBS | MATH_NUMERIC | OPT | BOTH |
The job number (work station ID) which executed the particular job. | ||||
cSummarizeRecords | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. |
B0000007 Batch - Revise On Transaction Commitment | ||||
B0000026 Edit Exchange Rate Tolerance | ||||
B0000028 CurrencyConvSftRound | ||||
B0000033 Get Exchange Rate | ||||
B0000036 Eff Date for Curr Rate LT Curr Period | ||||
B0000037 Retrieve Account Currency | ||||
B0000055 ValidateAAICompletely | ||||
B0000098 Validate Post Edit Code | ||||
B0000128 Retrieve Company Currency Code | ||||
B0000163 Calculate Advanced Payment Terms Due Date | ||||
B0000170 BalanceConvertedPayItems | ||||
B0000283 Calculate Discount Amount No Tax | ||||
B0100002 A/B - Get Parent Address | ||||
B0300001 Validate F0311 Records To Be Deleted | ||||
B0300002 Create 'RE' Record - Change In Gross Amount | ||||
B0300004 Create 'RE' Record - Voids | ||||
B0300005 Delete Invoice from F0311 | ||||
B03B0013 Delete Invoice from F03B11 | ||||
B03B0014 Validate Invoice Records to Delete | ||||
B03B0015 Void Invoice | ||||
B03B0021 F03B112 Create Invoice Revision | ||||
B0400001 Default Currency Fields | ||||
B0400002 Default Tax Rate Area | ||||
B0400037 Default Due Dates | ||||
B0400244 Default Factor/Special Payee | ||||
B0400285 Edit Voucher Gross Amount | ||||
B1100007 Decimals Trigger Get by CO CRCD | ||||
B9800100 Get Audit Information | ||||
N7000570 B03B0011 - Plug & Play - 03B | ||||
X0005 Get User Defined Codes | ||||
X00TAX Calculate and Edit Tax Amounts | ||||
X0903 Fiscal Date Edits + | ||||
X0909 Validate Subledger | ||||
XX0901 Validate Account Number |
F0101 Address Book Master | ||||
F03012 Customer Master by Line of Business | ||||
F0311 Accounts Receivable Ledger | ||||
F03B11 Customer Ledger |