Query Creditors Transactions {FPMO5-30}

This option allows the user to display all year-to-date transactions for a particular creditor.

Note that the user should not "Enter Query" in the screen as the program is already in query mode, but should just enter the creditor's code. The <List of Values> will display all valid creditors. Enter or tab from the creditor field defaults the current PM year and cycle into the screen. The account type is not mandatory. The <List of Values> will display all valid account types of the creditors.

The option consists of five Blocks on four screens, as follows:

Block 1 - Creditor to Query
Block 2 - Creditor Document Detail
Block 3 - Creditor Outstanding Orders
Block 4 - Creditor GRV/Supplier Return Not Paid
Block 5 - Received Invoices and Credit Notes.

When the creditor code is entered, the name, currency, retain and active indicators of the creditor are displayed. This is followed by the complete detail of the transactions and their net total.

The Outstanding Orders Tab Page displays all orders for the creditor not yet received.

Once on the Outstanding Order Tab pages the Outstanding Order Item Definition Tab Page becomes available. The Outstanding Order Item Definition displays all items on the outstanding order document.

On the Outstanding Order Item Definition Tab Page the Outstanding Order Item Detail Tab Page becomes available, this screen displays the item detail of the items on then order.

The Outstanding GRV/Supplier Return not yet Paid Tab Page displays all GRV's / Supplier Returns received but not yet invoiced for the creditor.

Once on the Outstanding GRV / Supplier Return Tab Pages the Outstanding Outstanding GRV / Supplier Return Item Definition tab page becomes available. The GRV/Supplier Return Item Definition displays all items on the document.

On the Outstanding GRV/Supplier Return Item Definition Tab Page the GRV / Supplier Return Item Detail Tab Page becomes available, this screen displays the item detail of the items on the GRV/ Supplier Return.

Should the Received Invoices / Credit Notes option {FPMO5-2} be used to capture and track Invoices / Credit Notes received, documents received not yet entered in the Maintance option {FPMO5-1} will display in this screen.

Block 1: Creditor to Query

It is mandatory to complete the Document Detail before the users can access Item Detail.

Field	Type & Length	Description
Creditor and Name	N9	Enter the Creditor to be queried. The creditor must be defined on option {FPMM-2}, TAB - Crediotor Detail. The <List Of Value> will display all valid Creditor Codes including the name, Currency Code, Retain and Active indicator.
Currency Code	A3	The currency code linked to the creditor in {FPMM-2}.
Retain Status	A1	Valid values are (P)artial, (Y)es or (N)o. This field indicates the retain status of the creditor (N)o - the creditor is not flagged as retained in {FPMM-2} (Y)es - the creditor is not flagged as retained in {FPMM-2}.
Active	A1	Indicates if the creditor is marked as (A)ctive or (N)on-active in system.
Account Type	A4	Account Types as defined in option {FCSC-21} for the subsystem PM. A List of Values of creditor and account types are available. If this field is completed, only creditor's transactions for the account type is displayed in block 2, elese transactions for all account types are displayed.
Cycle	MM	Displays the the current PM subsystem cycle. The cycle may be changed. Changing the cycle will result in displaying transaction up to the indicate cycle.
Year	YYYY	Displays the year from the current PM subsystem year. The year cannot be changed
Previous Years Y/N	A1	This field will determine if transactions for previous years or only the current year will display..

Example:

Block 2: Creditor Document Detail

Field	Type & Length	Description
Document Type	A2	Document types with the sequence between 21 and 60 and linked to subsystem 'PM' will be displayed for the selected creditor.
Document Number	A15	The document number for the above type of documents will be displayed for the selected creditor Pop up Menu - available on field Document Number. Query Document - Selecting the option drills down to the Query Creditor Transactons screen. Related Documents - Selecting the option drills down to the Search for a Document screen.
Retained	Display	Displays the Document Indicator
Paid	A1	Indicates if the document is linked to a payment or not, if no payment is linked the indicator is "Not Paid" else the indicator is "Fully Paid " or "Partially Paid".
Year / Cycle	YYYY MM	Displays the year and cycle of the document. When a document is created the year and cycle defaults from the current PM subsystem year and cycle.
Process Date	DD-MON-YYYY	The processed date of the document.
Document Date	DD-MON-YYYY	The document date of the document.
Local Currency Amount	N15.2	Displays the document total, VAT inclusive, for this record, in local currency.
Creditor Balance Foreign		Displays the creditor's, VAT inclusive, for this creditor, in foreign currency.
Creditor Balance Local		Displays the creditor's, VAT inclusive, for this creditor, in local currency.
Cash Flow Total	Display	Displays the Cash Flow Amount.

Example:

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
04-Dec--2007	v01.0.0.0	Kobus Kleinhans	t144148	New manual format.
12-Mar-2009	v01.0.0.1	Marchand Hildebrand	t152121	Proof Read System Owner
22-Oct-2012	v02.0.0.0	Marchand Hildebrand	t182859	Paid Indicator
03-Jun-2015	v03.0.0.1	Charlene van der Schyff	t203538	Added new image and Retained column adn Cash flow amount.