NettingBeginDoc

Account Netting Master Business Function

Master Business Function

Object Name: N03B0176

Parent DLL: CFIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This function is used to do header level initialization, defaulting, and editing for the Account
Netting Process. This includes data dictionary defaults, edits, and UDC editing. A record will be
written to the account netting header cache regardless of any errors that might occur. This function is part
of the Account Netting Master Business Function (N03B0176) which is used to net an account. The MBF
is capable of A/R to A/P netting or A/P to A/R netting. The function relies on both the Invoice Entry
and Voucher Entry Master Business Functions to create netted invoices and vouchers, respectively. In
addition, F03B13/14 and F0413/14 records are created to close the corresponding original documents.

Currently, only A/R to A/P netting is fully functional.

Setup Notes and Prerequisites
None.

Special Logic
None.

Technical Specification




Parameters


Item DescriptionI/OReq?Notes


JOBSmnJobNumberI/OYZero the first time NettingBeginDoc is called; 

mnJobNumber assigned by NettingBeginDoc, if previously called


ACTNcDocumentActionIY'A' or '1' for add, 'C' or '2' for change, and 'D' or 

'4' for delete


EV01cProcessEditsIN'0' for no edits, '1' (default) for full edits


EV01cErrorFlagON'0' if successful, '1' for warnings, '2' for errors


SYszSourceSystemCodeIY'03B' if netting from A/R to A/P, '04' if netting from 

A/P to A/R


VERSszInvoiceEntryVersionIYRequired if szSourceSystemCode is '04'


VERSszVoucherEntryVersionIYRequired if szSourceSystemCode is '03B'


VERSszJournalEntryVersionIY


VERSszReceiptEntryVersionIYRequired if szSourceSystemCode is '03B'


VERSszPaymentEntryVersionIYRequired if szSourceSystemCode is '04'


DOCmnDocumentNumberINIf zero, a next number will be assigned in 

NettingEndDoc


KCOszDocumentCompanyINIf blank, will default to company


COszCompanyIY


AN8mnAddressNumberIY


PYRmnPayorNumberIYRequired if szSourceSystemCode is '03B'


DGJjdGLDateIY


DIVJjdDocumentDateI/ONIf blank, will default to G/L date


DSVJjdTaxServiceDateI/ONIf blank, will default according to Invoice Entry or 

Voucher Entry processing option


BCRCszBaseCurrencyIY


CRRMcCurrencyModeIY


CRCDszTransactionCurrencyIY


CRRmnExchangeRateI/ONIf zero, will be retrieved from the exchange rate 

table


CRR1mnTriangulationRate1I/ONIf zero, will be retrieved from the exchange rate 

table


CRR2mnTriangulationRate2I/ONIf zero, will be retrieved from the exchange rate 

table


CRCMcConversionMethodI/ONIf blank, will be retrieved from the exchange rate 

table


EFTjdTransactionDateI/ONIf blank, will be retrieved from the exchange rate 

table


MCUszBusinessUnitI/ONIf blank, will default from address book


GLCszGLOffsetI/ONIf blank, will default from customer/supplier master


TXA1szTaxRateAreaI/ONIf blank, will default from customer/supplier master


EXR1szTaxExplanationCodeI/ONIf blank, will default from customer/supplier master


PTCszPaymentTermsI/ONIf blank, will default from customer/supplier master


RYINcPaymentInstrumentI/ONIf blank, will default from customer/supplier master


RMKszRemarkIN


ALPHszAlphaNameON





Related Tables


None.





Related Functions


B03B0177Maintain Account Netting Header Cache


B03B0178Maintain Account Netting Detail Cache


BDDVALData Dictionary Validation


X0903Retrieve Company Currency Code


B0000033GFiscal Date Edits +


B0000128et Exchange Rate


B0100002A/B - Get Parent Address


X0010Next Numbers





Processing


Perform Initializations,


 Initialize the header cache.


 Initialize the detail cache.


Process Required Edits,


 Edit Document Action Code.


 Edit Source System Code.


Process Optional Edits,


 Edit Company.


 Edit Address Number.


 Edit Payor Number.


 Edit G/L Date.


 Edit Currency Processing,


  If Currency Processing is ON,


   Zero out currency processing fields.


  Else,


   Edit Base Currency.


   Edit Transaction Currency.


   Edit Currency Mode.


  Endif.


Process Defaults,


 Default Processing Option Versions.


 Default Document Company.


 Default Document Date.


 Default Exchange Rate.


 Default Parent Number.


 Default G/L Offset.


 Default Tax/Rate Area.


 Default Tax Explanation Code.


 Default Payment Terms.


 Default Payment Instrument.


Maintain Header Cache,


 If Job Number = '0',


  Get Next Job Number.


  Add Header Cache Entry.


 Else,


  Update Cache Entry.


 Endif.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobNumber	JOBS	MATH_NUMERIC	REQ	BOTH
The job number (work station ID) which executed the particular job.
cDocumentAction	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
cProcessEdits	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
cErrorFlag	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szSourceSystemCode	SY	char	REQ	INPUT
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
szInvoiceEntryVersion	VERS	char	REQ	INPUT
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szVoucherEntryVersion	VERS	char	REQ	INPUT
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szJournalEntryVersion	VERS	char	REQ	INPUT
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szReceiptEntryVersion	VERS	char	REQ	INPUT
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szPaymentEntryVersion	VERS	char	REQ	INPUT
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
mnDocumentNumber	DOC	MATH_NUMERIC	OPT	INPUT
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.
szDocumentCompany	KCO	char	OPT	INPUT
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.
szCompany	CO	char	REQ	INPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnPayorNumber	PYR	MATH_NUMERIC	REQ	INPUT
The address book number of the person or company that sends the payment.
jdGLDate	DGJ	JDEDATE	REQ	INPUT
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 assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the company to retrieve the appropriate fiscal period number, as well as to perform date validations.
jdDocumentDate	DIVJ	JDEDATE	OPT	BOTH
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 date of your invoice to the customer.
jdTaxServiceDate	DSVJ	JDEDATE	OPT	BOTH
A date that indicates when you purchased goods or services, or when you incurred a tax liability.
szBaseCurrency	BCRC	char	REQ	INPUT
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the domestic side of the transaction.
cCurrencyMode	CRRM	char	REQ	INPUT
An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.
szTransactionCurrency	CRCD	char	REQ	INPUT
A code that identifies the currency of a transaction.
mnExchangeRate	CRR	MATH_NUMERIC	OPT	BOTH
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
mnTriangulationRate1	CRR1	MATH_NUMERIC	OPT	BOTH
The exchange rate from the foreign currency of the invoice to the triangulation currency (leg 1). This rate applies when you use triangulation to calculate the exchange rate for a receipt.
mnTriangulationRate2	CRR2	MATH_NUMERIC	OPT	BOTH
The exchange rate from the triangulation currency to the domestic currency (leg 2). This rate applies when you use triangulation to calculate the exchange rate for a receipt.
cConversionMethod	CRCM	char	OPT	BOTH
A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the foreign amount by the divisor exchange rate to calculate the domestic amount.
jdTransactionDate	EFT	JDEDATE	OPT	BOTH
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 effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
szBusinessUnit	MCU	char	OPT	BOTH
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szGLOffset	GLC	char	OPT	BOTH
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables). You can assign up to four alphanumeric characters to represent the G/L offset or you can assign the three-character currency code (if you enter transactions in a multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L offset and uses the account that is set up for PC or RC for the company specified. If you set up a default value in the G/L Offset field of the customer or supplier record, the system uses the value during transaction entry unless you override it. Note: Do not use code 9999. It is reserved for the post program and indicates that offsets should not be created.
szTaxRateArea	TXA1	char	OPT	BOTH
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax and G/L distribution amounts when you create an invoice or voucher.
szTaxExplanationCode	EXR1	char	OPT	BOTH
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 system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each transaction pay item can be defined with a different tax explanation code.
szPaymentTerms	PTC	char	OPT	BOTH
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include: Blank Net 15 001 1/10 net 30 002 2/10 net 30 003 Due on the 10th day of every month 006 Due upon receipt This code prints on customer invoices.
cPaymentInstrument	RYIN	char	OPT	BOTH
The user defined code (00/PY) that specifies how payments are made by the customer. For example: C Check D Draft T Electronic funds transfer
szRemark	RMK	char	OPT	INPUT
A generic field that you use for a remark, description, name, or address.
szAlphaName	ALPH	char	OPT	OUTPUT
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

Data Structure

D03B0176A - Account Netting Begin Document

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

mnJobNumber JOBS MATH_NUMERIC REQ BOTH

The job number (work station ID) which executed the particular job.

cDocumentAction ACTN char REQ INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

cProcessEdits EV01 char OPT INPUT

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

cErrorFlag EV01 char OPT OUTPUT

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

szSourceSystemCode SY char REQ INPUT

A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts
Payable 09 General Accounting 11 Multicurrency

szInvoiceEntryVersion VERS char REQ INPUT

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

szVoucherEntryVersion VERS char REQ INPUT

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

szJournalEntryVersion VERS char REQ INPUT

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

szReceiptEntryVersion VERS char REQ INPUT

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

szPaymentEntryVersion VERS char REQ INPUT

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

mnDocumentNumber DOC MATH_NUMERIC OPT INPUT

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.

szDocumentCompany KCO char OPT INPUT

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.

szCompany CO char REQ INPUT

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

mnAddressNumber AN8 MATH_NUMERIC REQ INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnPayorNumber PYR MATH_NUMERIC REQ INPUT

The address book number of the person or company that sends the payment.

jdGLDate DGJ JDEDATE REQ INPUT

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
assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the
company to retrieve the appropriate fiscal period number, as well as to perform date validations.

jdDocumentDate DIVJ JDEDATE OPT BOTH

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
date of your invoice to the customer.

jdTaxServiceDate DSVJ JDEDATE OPT BOTH

A date that indicates when you purchased goods or services, or when you incurred a tax liability.

szBaseCurrency BCRC char REQ INPUT

A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
domestic side of the transaction.

cCurrencyMode CRRM char REQ INPUT

An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the
foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.

szTransactionCurrency CRCD char REQ INPUT

A code that identifies the currency of a transaction.

mnExchangeRate CRR MATH_NUMERIC OPT BOTH

A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field
can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

mnTriangulationRate1 CRR1 MATH_NUMERIC OPT BOTH

The exchange rate from the foreign currency of the invoice to the triangulation currency (leg 1). This rate applies when you use triangulation
to calculate the exchange rate for a receipt.

mnTriangulationRate2 CRR2 MATH_NUMERIC OPT BOTH

The exchange rate from the triangulation currency to the domestic currency (leg 2). This rate applies when you use triangulation to calculate
the exchange rate for a receipt.

cConversionMethod CRCM char OPT BOTH

A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The
system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the
foreign amount by the divisor exchange rate to calculate the domestic amount.

jdTransactionDate EFT JDEDATE OPT BOTH

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
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

szBusinessUnit MCU char OPT BOTH

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szGLOffset GLC char OPT BOTH

A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For
example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables). You can assign up to four
alphanumeric characters to represent the G/L offset or you can assign the three-character currency code (if you enter transactions in a
multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L
offset and uses the account that is set up for PC or RC for the company specified. If you set up a default value in the G/L Offset field of the
customer or supplier record, the system uses the value during transaction entry unless you override it. Note: Do not use code 9999. It is reserved for
the post program and indicates that offsets should not be created.

szTaxRateArea TXA1 char OPT BOTH

A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher.

szTaxExplanationCode EXR1 char OPT BOTH

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
system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each
transaction pay item can be defined with a different tax explanation code.

szPaymentTerms PTC char OPT BOTH

A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions
form. Examples of payment terms include: Blank Net 15 001      1/10 net 30 002      2/10 net 30 003      Due on the 10th day of every month 006
Due upon receipt This code prints on customer invoices.

cPaymentInstrument RYIN char OPT BOTH

The user defined code (00/PY) that specifies how payments are made by the customer. For example: C Check   D Draft   T Electronic funds
transfer

szRemark RMK char OPT INPUT

A generic field that you use for a remark, description, name, or address.

szAlphaName ALPH char OPT OUTPUT

The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

Related Functions

None

Related Tables

None

NettingClearDoc
NettingClearDoc

Account Netting Master Business Function

Master Business Function

Object Name: N03B0176

Parent DLL: CFIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This function is used to clear the header and detail cache records for the Account Netting Process.
An error will be set if a valid job number is not provided to the function. This function is part of
the Account Netting Master Business Function (N03B0176) which is used to net an account. The MBF is
capable of A/R to A/P netting or A/P to A/R netting. The function relies on both the Invoice Entry and
Voucher Entry Master Business Functions to create netted invoices and vouchers, respectively. In
addition, F03B13/14 and F0413/14 records are created to close the corresponding original documents.

Currently, only A/R to A/P netting is fully functional.

Setup Notes and Prerequisites
None.

Special Logic
None.

Technical Specification

Parameters
Item DescriptionI/OReq?Notes
JOBSmnJobNumberIYJob number assigned by NettingBeginDoc.
EV01cClearHeaderIN'0' (default) to retain header cache, '1' to clear
header cache.
EV01cClearDetailIN'0' (default) to retain detail cache, '1' to clear
detail cache.
LNIDmnDetailLineFromINBeginning line number for the range of detail records
to be cleared.
LNIDMnDetailLineToINEnding line number for the range of detail records to
be cleared.

Related Tables
None.

Related Functions
B03B0177Maintain Account Netting Header Cache
B03B0178Maintain Account Netting Detail Cache

Processing
If Job Number = '0',
Set error.
Else,
Delete the header cache record.
Repeat,
Read detail cache record.
Delete the detail cache record.
Until detail cache records exist.
Endif.

Data Structure

D03B0176B - Account Netting Clear Document

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

mnJobNumber JOBS MATH_NUMERIC REQ INPUT

The job number (work station ID) which executed the particular job.

cClearHeader EV01 char OPT INPUT

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

cClearDetail EV01 char OPT INPUT

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

Related Functions

None

Related Tables

None

NettingEditDoc
NettingEditDoc

Account Netting Master Business Function

Master Business Function

Object Name: N03B0176

Parent DLL: CFIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This function is used to edit the header and detail cache records for the Account Netting Process.
This function is part of the Account Netting Master Business Function (N03B0176) which is used to net an
account. The MBF is capable of A/R to A/P netting or A/P to A/R netting. The function relies on both
the Invoice Entry and Voucher Entry Master Business Functions to create netted invoices and vouchers,
respectively. In addition, F03B13/14 and F0413/14 records are created to close the corresponding
original documents.

Currently, only A/R to A/P netting is fully functional.

Setup Notes and Prerequisites
None.

Special Logic
None.

Technical Specification

Parameters
Item DescriptionI/OReq?Notes
JOBSmnJobNumberIYJob number assigned by NettingBeginDoc.
EV01cErrorFlagON'0' if successful, '1' for warnings, '2' for errors.
AGmnTotalNettingAmountON
BCRCszBaseCurrencyON
CRRMszCurrencyModeON
CRCDszTransactionCurrencyON
ACRmnForeignTotalNettingAmON

Related Tables
None.

Related Functions
B03B0177Maintain Account Netting Header Cache
B03B0178Maintain Account Netting Detail Cache
B1100008DecimalsTriggerGetByCRDCCRCD
B0400047Voucher Entry Master Business Function
B03B0011Invoice Entry Master Business Function

Processing
Perform Initializations.
Perform Required Edits,
Verify that specified document does not already exist.
If record exists,
Set error.
Endif.
While detail records exist,
Read detail record.
Accumulate total netting amounts.
End While.
Validate that the total netting amount is negative.
Process Header Cache.
Load return values.

Data Structure

D03B0176C - Account Netting Edit Document

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

mnJobNumber JOBS MATH_NUMERIC REQ INPUT

The job number (work station ID) which executed the particular job.

cErrorFlag EV01 char OPT OUTPUT

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

mnTotalNettingAmount AG MATH_NUMERIC OPT OUTPUT

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.

szBaseCurrency BCRC char OPT OUTPUT

A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
domestic side of the transaction.

cCurrencyMode CRRM char OPT OUTPUT

An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the
foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.

szTransactionCurrency CRCD char OPT OUTPUT

A code that identifies the currency of a transaction.

mnForeignTotalNettingAmount ACR MATH_NUMERIC OPT OUTPUT

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.

Related Functions

None

Related Tables

None

NettingEditLine
NettingEditLine

Account Netting Master Business Function

Master Business Function

Object Name: N03B0176

Parent DLL: CFIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This function is used to edit the detail cache records for the Account Netting Process. This function
is part of the Account Netting Master Business Function (N03B0176) which is used to net an account.
The MBF is capable of A/R to A/P netting or A/P to A/R netting. The function relies on both the Invoice
Entry and Voucher Entry Master Business Functions to create netted invoices and vouchers,
respectively. In addition, F03B13/14 and F0413/14 records are created to close the corresponding original
documents.

Currently, only A/R to A/P netting is fully functional.

Setup Notes and Prerequisites
None.

Special Logic
None.

Technical Specification

Parameters
Item DescriptionI/OReq?Notes
JOBSmnJobNumberIYJob number assigned by NettingBeginDoc.
ACTNcLineActionIY'A' or '1' for add, 'C' or '2' for change, and 'D' or
'4' for delete.
EV01cErrorFlagON'0' if successful, '1' for warnings, '2' for errors.
DOCmnSourceDocumentNumberIY
DCTszSourceDocumentTypeIY
KCOszSourceDocumentCompanyIY
SFXszSourceDocumentPayItemIY
DGJszSourceGLDateIY
DIVJszSourceDocumentDateIY
DSVJszSourceTaxServiceDateIY
AGmnGrossAmountIY
AAPmnOpenAmountIY
ADSCmnDiscountAvailableIY
ADSAmnDiscountTakenIY
PAAPmnAppliedAmountIY
BCRCszBaseCurrencyIY
CRRMcCurrencyModeIY
CRCDszTransactionCurrencyIY
CRRmnExchangeRateIY
ACRmnForeignGrossAmountIY
FAPmnForeignOpenAmountIY
CDSmnForeignDiscountAvailabIY
CDSAmnForeignDiscountTakenIY
PFAPmnForeignAppliedAmountIY
VR01szReferenceNumberIN

Related Tables
None.

Related Functions
B03B0178Maintain Account Netting Detail Cache

Processing
Perform Initializations,
Process Required Edits,
Edit Line Action Code.
If line action code is invalid,
Set error.
Endif.
Process Netting Detail Cache.

Data Structure

D03B0176D - Account Netting Edit Line

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

mnJobNumber JOBS MATH_NUMERIC REQ INPUT

The job number (work station ID) which executed the particular job.

cLineAction ACTN char REQ INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

cErrorFlag EV01 char OPT OUTPUT

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

mnSourceDocumentNumber DOC MATH_NUMERIC REQ INPUT

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.

szSourceDocumentType DCT char REQ INPUT

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

szSourceDocumentCompany KCO char REQ INPUT

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.

szSourceDocumentPayItem SFX char REQ INPUT

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.

jdSourceGLDate DGJ JDEDATE REQ INPUT

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
assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the
company to retrieve the appropriate fiscal period number, as well as to perform date validations.

jdSourceDocumentDate DIVJ JDEDATE REQ INPUT

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
date of your invoice to the customer.

jdSourceTaxServiceDate DSVJ JDEDATE REQ INPUT

A date that indicates when you purchased goods or services, or when you incurred a tax liability.

mnGrossAmount AG MATH_NUMERIC REQ INPUT

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.

mnOpenAmount AAP MATH_NUMERIC REQ INPUT

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

mnDiscountAvailable ADSC MATH_NUMERIC REQ INPUT

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.

mnDiscountTaken ADSA MATH_NUMERIC REQ INPUT

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
discount available.

mnAppliedAmount PAAP MATH_NUMERIC REQ INPUT

In the Accounts Payable system, the amount of the payment. In the Accounts Receivable system, the amount of the receipt. This amount
must balance to the total amount applied to the invoice pay items.

szSourceBaseCurrency BCRC char REQ INPUT

A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
domestic side of the transaction.

cSourceCurrencyMode CRRM char REQ INPUT

An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the
foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.

szSourceTransactionCurrency CRCD char REQ INPUT

A code that identifies the currency of a transaction.

mnSourceExchangeRate CRR MATH_NUMERIC REQ INPUT

A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field
can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

mnForeignGrossAmount ACR MATH_NUMERIC REQ INPUT

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.

mnForeignOpenAmount FAP MATH_NUMERIC REQ INPUT

The unpaid foreign amount of a transaction.

mnForeignDiscountAvailable CDS MATH_NUMERIC REQ INPUT

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

mnForeignDiscountTaken CDSA MATH_NUMERIC REQ INPUT

The amount of the discount, expressed in the foreign currency of the transaction, that was taken or granted during the application of a
payment to an open invoice or voucher.

mnForeignAppliedAmount PFAP MATH_NUMERIC REQ INPUT

The foreign amount to be paid on an A/P Payment run.

szSourceReferenceNumber VR01 char OPT INPUT

An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
number, or job number.

mnSourceAddressNumber AN8 MATH_NUMERIC REQ INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

szSourceBusinessUnit MCU char REQ INPUT

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szSourceRemark RMK char OPT INPUT

A generic field that you use for a remark, description, name, or address.

jdSourceExchangeRateDate ERDJ JDEDATE REQ INPUT

The date that the system uses to retrieve the exchange rate from the Currency Exchange Rates table (F0015).

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.
Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions
form. Examples of payment terms include: Blank Net 15 001      1/10 net 30 002      2/10 net 30 003      Due on the 10th day of every month 006
Due upon receipt This code prints on customer invoices.

Related Functions

None

Related Tables

None

NettingEndDoc
NettingEndDoc

Account Netting Master Business Function

Master Business Function

Object Name: N03B0176

Parent DLL: CFIN

Location: Client/Server

Language: NER

Data Structure

D03B0176E - Account Netting End Document

tests

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

mnJobNumber JOBS MATH_NUMERIC REQ INPUT

testp

cErrorFlag EV01 char OPT OUTPUT

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

szSourceBatchType ICUT char REQ INPUT

A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
Valid values are set up in user defined code table 98/IT. You cannot assign new values. All batch types are hard coded.

mnSourceBatchNumber ICU MATH_NUMERIC REQ INPUT

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
assign a batch number or let the system assign it using the Next Numbers program.

jdSourceBatchDate DICJ JDEDATE REQ INPUT

The date of the batch. If you leave this field blank, the system date is used.

szTargetBatchType ICUT char REQ INPUT

A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
Valid values are set up in user defined code table 98/IT. You cannot assign new values. All batch types are hard coded.

mnTargetBatchNumber ICU MATH_NUMERIC REQ INPUT

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
assign a batch number or let the system assign it using the Next Numbers program.

jdTargetBatchDate DICJ JDEDATE REQ INPUT

The date of the batch. If you leave this field blank, the system date is used.

szProgramID PID char REQ INPUT

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cSummaryDetailMode EV01 char OPT INPUT

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

Related Functions

None

Related Tables

None

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.
szCompanyCOcharREQINPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
mnAddressNumberAN8MATH_NUMERICREQINPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
mnPayorNumberPYRMATH_NUMERICREQINPUT
The address book number of the person or company that sends the payment.
jdGLDateDGJJDEDATEREQINPUT