Navigation:  Creditor Functions > Invoice Order Inquiry > Invoice Order Inquiry >

Invoices

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

When this option is selected, you can inquire on and view invoices for either the selected creditor or debtor.

 

When debtors was selected, two options can be entered, either the External Organisation or the Invoice Number for the External Organisation.

 

On this tab the following fields can be viewed:

 

hmtoggle_plus1Creditor

When this option is selected, the Invoice Number combo is populated with all creditor invoices for the External Organisation selected (the default).

hmtoggle_plus1Debtor

When this option is selected, the External Organisation or the Invoice Number can be used as search criteria for the specific invoice. On selecting the External Organisation all the invoices linked to that External Organisation will populate in the Invoice Number combo.

 

On selecting the Invoice Number in the combo, the External Organisation linked to that Invoice will populate in the External Organisation combo box.

hmtoggle_plus1External Organisation

It is populated with the organisation name, organisation code and the trading status creditors and trading status debtors from the External Organisation table where:

 

The trading status creditors and debtors is Active "A",
The Creditors option is selected, the Creditors account is not equal to spaces, and
The Debtors option is selected, the Debtors account is not equal to spaces.

 

The number of characters to be entered before the list is shown is governed by the value of populate length (mandatory).

hmtoggle_plus1Invoice Number

It is populated with invoice numbers of the selected organisation from the Invoice table.

 

If Creditors is selected, it is populated with all creditor invoices, for the selected organisation from the Invoice table.

 

If Debtors is selected, it is populated with all debtor invoices, for the selected organisation from the Invoice table.

 

The number of characters to be entered before the list is shown is governed by the value of populate length (mandatory).

hmtoggle_plus1Invoices

Once the selection criteria has been entered the Inquire button is enabled.  When the Inquire button is clicked, the Invoice list box is populated according to the selection criteria.

 

If Orders is selected and Purchase Orders = True or Invoices was chosen and Creditors = True:

 

1.Invoices are populated from the Account Codes, Accounts, Invoice Line Link and External Organisation tables.

 

2.If Creditors is selected, invoices are populated from the above tables where:

 

The organisation code from the Invoice Line Link table is equal to the selected organisation,
The selected invoice is not equal to spaces and the invoice number from the Invoice Line Link table is equal to the selected number,
The line number is not equal to spaces and the line number from the Invoice Line Link table is equal to the selected line.

 

3.If Purchase Orders is selected, invoices are populated from the above tables where:

 

The order number from the Invoice Line Link table is equal to the selected order number, and
The completion date is equal to the completion date of the selected line number.

 

4.Furthermore, it populates with the organisation code from the Invoice Line Link table where the organisation code is equal to the organisation code on the External Organisation table.

 

 

If Orders is chosen and Customer Orders = True or Invoices was chosen and Debtors = True:

 

1.Invoices are populated from the Debtor Line Link, External Organisation, Debtor Invoice, Account Codes and Accounts tables.

 

2.If Debtors is selected, invoices are populated from the above tables where:

 

The organisation code from the Debtor Line Link table is equal to the selected organisation,
The selected invoice is not equal to spaces and the invoice number from the Debtor Line Link table is equal to the selected invoice,
A line number was selected and the line number from the Debtor Line Link table the selected line.

 

3.If Customer Orders is selected, invoices are populated from the above tables where:

 

The order number from the Debtor Line Link table is equal to the selected order,
The order type is equal to "CUST",
A line number was selected, the order line in the Debtor Line Link table is equal to the selected line number,
The completion date from the Debtor Line Link table is equal to the completion date of the selected line.

 

4.Furthermore, it populates with the organisation code from the External Organisation table where it is equal to the organisation code on the Debtor Invoice, External Organsation and Debtor Line Link tables.  It also populates with the invoice number from the Debtor Line Link table where it is equal to the invoice number on the Debtor Invoice table.

 

 

If Service Requisitions was chosen:

 

1.Invoices are populated from the Accounts, Account Codes, Invoice Line Link, Column Values and External Organisation tables where:

 

The column name from the Column Values table is equal to "type of link",
The column value from the Column Values table is equal to the type of link on the Invoice Line Link table,
The requisition number from the Invoice Line Link table is equal to the selected invoice,
The organisation code from the Invoice Line Link table is equal to the organisation code on the External Organisation table,
The organisation name from the Invoice Line Link table is equal to the organisation name on the External Organisation table.
hmtoggle_plus1Line Number

It is populated with the line numbers for the selected invoice number.

 

If Creditors is selected, it is populated with the line number, for the selected organisation and invoice number from the Invoice table.

 

If Debtors is selected, it is populated with the line number, for the selected organisation and invoice number, from the Invoice table.

 

The number of characters to be entered before the list is shown is governed by the value of populate length (optional).