CreateRERecGross

Create 'RE' Record - Change In Gross Amount

Major Business Rule

Object Name: B0300002

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This will create an 'RE' record in the F0311 if a change has been made to the gross amount of a
posted record.

Setup Notes and Prerequisites
Document Number, Document Type, Key Company, Pay Item and Matching Document Number combination should
exist in the F0311.

Special Logic
Write RE record to the database only if the new calculated Gross Amount, Tax Amount or Taxable Amount
is not equal to 0.

Technical Specification

Parameters

ItemDescriptionI/OReq?Notes

DOCmnDocumentNumberIYesDocument Number-part of the primary key.

DCTszDocumentTypeIYesDocument Type - part of the primary key.

KCOszDocumentCompanyI YesDocument Company-part of the primary key.

SFXszPayItemIYesPay Item - part of the primary key.

AGmnGrossAmountIYesGross amount - changed gross amount.

STAMmnTaxAmountIYesTax amount - changed tax amount.

ATXAmnTaxableAmountIYesTaxable amount - changed taxable amount.

ACRmnForeignAmountIYesForeign gross amount-changed gross amount.

CTAMmnForeignTaxAmountIYesForeign tax amount - changed tax amount.

CTXAmnForeignTaxableAmtIYesForeign taxable amount - changed taxable

amount

DOCMmnMatchingDocNoIYesMatching Document Number - part of the

primary key.

DCTMszMatchingDocTypeIYesMatching Document Type - part of the primary

key.

Related Tables

F0010Company Master

Related Functions

B9800100Get Audit Info

Processing

Retrieve F0311 Record based upon the key values passed.

Retrieve company information for Company 00000 to determine currency method used.

Matching Document Type set to "RE"

Pay Status Code set to "P"

If currency is off, invoice is domestic or invoice is Mode 3

calculate new domestic amounts

Else

calculate new foreign amounts

End if

If any of the new amount fields are not 0

write new F0311 record

End if

Data Structure

D0300002 - Create 'RE' Record - Change in Gross Amount

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 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.
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 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
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, 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.
szPayItem	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 multiple pay items, the numbers are sequential.
mnGrossAmount	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 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.
mnTaxAmount	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).
mnTaxableAmount	ATXA	MATH_NUMERIC	NONE	NONE
The amount on which taxes are assessed.
mnForeignAmount	ACR	MATH_NUMERIC	NONE	NONE
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.
mnForeignTaxAmount	CTAM	MATH_NUMERIC	NONE	NONE
The tax amount in foreign currency. This can be the sales, use, or VAT tax.
mnForeignTaxableAmt	CTXA	MATH_NUMERIC	NONE	NONE
That portion of the sale that is subject to tax in foreign currency.
mnMatchingDocNo	DOCM	MATH_NUMERIC	NONE	NONE
The number of the matching document, such as a receipt, payment, adjustment,or credit. You apply a matching document (DOCM) against an original document (DOC), such as an invoice or voucher.
szMatchingDocType	DCTM	char	NONE	NONE
Within Auto Bank Statement process, a document type is needed for the following: 1) Document Type is needed for creating Variance Journal Entries for payments, receipts, and journal entries when running the Auto Bank Statement Process (R09616). If Document Type on the Payment Clear tab is left blank, it will default to PN. If Document Type on the Receipt Clear tab is left blank, it will default to RC. If Document Type on the Journal Entry Reconcile tab is left blank, it will default to JE. 2) Document Type is needed for creating Journal Entries on the Journal Entry Create tab, and the Draft Paid tab. For both of these, it will default to JE if left blank.

Related Functions

B9800100 Get Audit Information

Related Tables

F0010 Company Constants
F0311 Accounts Receivable Ledger