F03B11GetInvoiceInfoRiba

F03B11 Get Invoice Info RIBA

Minor Business Rule

Object Name: B03B0167

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose

This function will provide the information about invoices paid by a particular draft.

Setup Notes and Prerequisites

This function is used in R03B672IP and R03B672IT.

Special Logic

Technical Specification






Parameters:


Data Item Data Structure DescriptionI/OReqNotes


PYIDmnPaymentID IY


DOCmnDocVoucherInvoice1O 


DIVJjdDateInvoiceJ1O 


AGmnInvoiceGross1O


DOCmnDocVoucherInvoice2O


DIVJjdDateInvoiceJ2O


AGmnInvoiceGross2O


DOCmnDocVoucherInvoice3O


DIVJjdDateInvoiceJ3O


AGmnInvoiceGross3O


DOCmnDocVoucherInvoice4O


DIVJjdDateInvoiceJ4O


AGmnAmountGross4O


DOCmnDocVoucherInvoice5O


DIVJjdDateInvoiceJ5O


AGmnAmountGross5O


DOCmnDocVoucherInvoice6O


DIVJjdDateInvoiceJ6O


AGmnInvoiceGross6O


DOCmnDocVoucherInvoice7O


DIVJjdDateInvoiceJ7O


AGmnInvoiceGross7O


DOCmnDocVoucherInvoice8O


DIVJjdDateInvoiceJ8O


AGmnInvoiceGross8O





Related Tables 


 


F03B11Customer Ledger File


F03B14A/R Check detail file


F03B672Draft Remittance Work File  One World 





Processing 





Initialize variables


Open table F03B11


Open table F03B14


Set error if error opening a table


Select records from F03B14 table where payment id is equal to data structure passed payment id 


and type input is equal to 'A'


For every F03B14 record determine whether the invoice number is the same as the previous one read.


If it is the same read the next F03B14 record.


If it is not the same add 1 to number of invoice, 


accumulate the gross amount and 


fetch the invoice record from the F03B11 record and retrieve the invoice date.


Copy the information back to the return variables.


Do the same process until there are no more invoices for the draft or the number of invoices 

processed is 8.


Close tables F03B14 and F03B11.

Data Structure

D03B0167 - F03B11 Get Invoice Info Riba

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnPaymentID	PYID	MATH_NUMERIC	NONE	NONE
A number that the system assigns from Next Numbers to identify and track payment records.
mnDocVoucherInvoice1	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.
jdDateInvoiceJ1	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 date of your invoice to the customer.
mnInvoiceGross1	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.
mnDocVoucherInvoice2	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.
jdDateInvoiceJ2	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 date of your invoice to the customer.
mnInvoiceGross2	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.
mnDocVoucherInvoice3	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.
jdDateInvoiceJ3	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 date of your invoice to the customer.
mnInvoiceGross3	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.
mnDocVoucherInvoice4	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.
jdDateInvoiceJ4	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 date of your invoice to the customer.
mnAmountGross4	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.
mnDocVoucherInvoice5	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.
jdDateInvoiceJ5	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 date of your invoice to the customer.
mnInvoiceGross5	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.
mnDocVoucherInvoice6	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.
jdDateInvoiceJ6	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 date of your invoice to the customer.
mnInvoiceGross6	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.
mnDocVoucherInvoice7	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.
jdDateInvoiceJ7	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 date of your invoice to the customer.
mnInvoiceGross7	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.
mnDocVoucherInvoice8	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.
jdDateInvoiceJ8	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 date of your invoice to the customer.
mnInvoiceGross8	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.
mnDocVoucherInvoice9	DOC	MATH_NUMERIC	OPT	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.
jdDateInvoiceJ9	DIVJ	JDEDATE	OPT	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 date of your invoice to the customer.
mnInvoiceGross9	AG	MATH_NUMERIC	OPT	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.

Related Functions

None

Related Tables

F03B11 Customer Ledger
F03B14 Receipts Detail
F03B672 Draft Remittance