Purchasing >  Inquiries >  Invoices >  Invoice lines  

Display all Hide all

Use this function to display the purchase invoice and credit note lines for one site or all sites on a given date or for a date range.

You can perform an inquiry by site and article, for a supplier or a supplier range, an invoice number or a number range, a project or a project range. You can filter the search results by invoice category (invoice, credit memo) and invoice status.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

This function is customized to the needs of your organization and your processes. The Inquiry screens function, ‘CPJ’ code, determines the entry, display and printing conditions of the information.

The invoice line inquiry function includes a block where you may enter selection criteria and a table which displays the search results.

Header

Presentation

Enter the main selection criteria for the inquiry in the header.

To access additional selection criteria, click Criteria from the Actions panel.

Close

 

Fields

The following fields are present on this tab :

Selection

This field is used to specify the company code.
The company is automatically loaded with the user default purchase site. It can still be modified.

SEEINFO To view the invoice lines of all the companies, leave this field blank.
In this case, the site field is automatically left blank.

This field is used to indicate the Invoicing site.
SEEINFOThis site is automatically loaded with the user's default purchase site. It can be left blank. In that case, the inquiry will displey all the company's invoices.

These fields are optional. They are used to enter or select the range of suppliers whose invoices are to be displayed.

 
  • From invoice no. (field NUMDEB)

These fields are optional. They are used to enter or select the range of invoices to be displayed.
  • To invoice no. (field NUMFIN)

 

Filter for results within a range of project codes. For a single project, enter the same project code in the from/start Project and to/end Project fields. The content can be one of the following:

  • A project code
  • A project code and a project budget code
  • A project code and a project task code, that is a material task code, a labor task code (sales only), or a combined (mixed) labor and material task code.

If the value of this field includes a character such as an exclamation mark '!' this field links to the structure of the project. The character is the separator between a project code and the structure, either the project budget structure or the project operational (task) structure. For example, if a material task code is 'USA-P3' and a project code is 'USA12345678', this field displays a link to the project operational structure as 'USA12345678!USA-P3'.

To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (link to the project budget structure).

 This field is populated by default with the project code if you accessed this function directly from the project. If you accessed this function from the project structure the project code and project budget/task code is displayed accordingly.

 
  • Start date (field BPRDATDEB)

You can use these fields to filter the invoices whose supplier invoice date is included in the entered date range.
By default, these dates are initialized as follows:

  • The start date is initialized with the first day of the month coming from the current date minus two months.
  • The end date is initialized with the current date postponed to the last day of the month.

Enter the product reference if you wish to perform a selection based on this information.

Invoice type

  • Invoice (field PIHTYP1)

Check this box to select invoices, which includes invoices and additional invoices.
To select invoices or additional invoices only, click the Criteria action to access additional selection criteria.

  • Credit memo (field PIHTYP3)

Select this check box to select credit memos, which include credit memos and credit memos on return.
To select credit memos or credit memos on return only, click the Criteria action to access additional selection criteria.

Status

  • Posted (field STAO)

Check this box to select validated invoices.
  • Not validated (field STAN)

Check this box to select non-validated invoices.

Close

 

Tab Search results

Presentation

This block displays all the purchase invoice and credit memo lines which meet the defined selection criteria. The quantities and prices of credit notes and invoices are specified for each line.

The columns displayed in the table and the order in which they are displayed depend on the setup in the Inquiry screens function, ‘CPJ’ code.

Close

 

Fields

The following fields are present on this tab :

Grid

  • Document no. (field NUM)

 

 

 

This field displays the associated project code. The content can be one of the following:

  • A project code
  • A project code and a project budget code
  • A project code and a project task code, that is a material task code, a labor task code (sales only), or a combined (mixed) labor and material task code.

If the value of this field includes a character such as an exclamation mark '!' this field links to the structure of the project. The character is the separator between a project code and the structure, either the project budget structure or the project operational (task) structure. For example, if a material task code is 'USA-P3' and a project code is 'USA12345678', this field displays a link to the project operational structure as 'USA12345678!USA-P3'.

To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (link to the project budget structure).
  • Accounting date (field ACCDAT)

 
  • Type (field INVTYP)

 

 
  • UOM qty. (field QTYUOM)

 
  • STK-PUR conversion (field UOMPUUCOE)

 
  • PUR qty. (field QTYPUU)

 

 

 
  • Net price (field NETPRI)

 
  • Order no. (field POHNUM)

 
  • Receipt no. (field PTHNUM)

 
  • Match status (field TWMSTA)

 

 

 

 

Code used by default for the current BP to identify a series of early discount and late charge rates (up to 12) to be applied to a payment according to a number of days early or days late with respect to the open item date.
  • Description (field ITMDES)

 

 
  • Line amount - tax (doc) (field AMTNOTLIN)

 
  • Line amount - tax (co) (field AMTNOTLINS)

 
  • Line amount + tax (doc) (field AMTATILIN)

 
  • Line amount + tax (co) (field AMTATILINS)

 
  • Landed cost coef. (field CPRCOE)

 
  • Return no. (field PNHNUM)

 
  • Fixed cost per unit (co) (field CPRAMT)

 
  • Line origin (field TYPORI)

 
  • Purchase cost per unit (co) (field CSTPUR)

 
  • Purchase cost per unit (doc) (field CSTPURDOC)

 

 
  • Purchase cost (co) (field LINCSTPUR)

 
  • Purchase cost (doc) (field LINCSTPURD)

 

Close

 

Action icon

Document

Click Document from the Actions icon to view the Purchase invoice details. The transaction you select determines the way in which you enter information, and information is displayed and printed. If only one transaction has been set up you are not offered a choice, the default entry screen is displayed.

Supplier order

Click Supplier order from the Actions icon to view the purchase order details. The transaction you select determines the way in which you enter information, and how information is displayed and printed. If only one transaction has been set up you are not offered a choice, the default entry screen is displayed.

Receipt

Click Receipt from the Actions icon to view the purchase receipt details. The transaction you select determines the way in which you enter information, and how information is displayed and printed. If only one transaction has been set up you are not offered a choice, the default entry screen is displayed.

Purchase journal traceability

Click Purchase journal traceability from the Actions icon to open the Journal traceability inquiry and view or search journals in the hierarchy of documents created from this purchase invoice.

 

Close

 

Specific actions

Click the Search action to load the purchase invoice lines that meet the entered selection criteria.

The maximum number of displayed lines is defined in the Inquiry screens function for the ‘CPJ’ code.

The following fields are included on the window opened through this button :

Selection

  • Active memo (field MEMO)

 

Use this check box to select the invoices which have a 'warning' Three-way match status.

SEEINFO The Three-way match status is defined in the Product function.

 

 

 
  • From invoice no. (field NUMDEB)

Use this check box to select the invoices which have a 'warning' Three-way match status.

SEEINFO The Three-way match status is defined in the Product function.
  • To invoice no. (field NUMFIN)

 

Filter for results within a range of project codes. For a single project, enter the same project code in the from/start Project and to/end Project fields. The content can be one of the following:

  • A project code
  • A project code and a project budget code
  • A project code and a project task code, that is a material task code, a labor task code (sales only), or a combined (mixed) labor and material task code.

If the value of this field includes a character such as an exclamation mark '!' this field links to the structure of the project. The character is the separator between a project code and the structure, either the project budget structure or the project operational (task) structure. For example, if a material task code is 'USA-P3' and a project code is 'USA12345678', this field displays a link to the project operational structure as 'USA12345678!USA-P3'.

To provide a quick and easy visual reference the link to the project or project structure is distinguishable by the number of separator characters used. If there is no separator, the link is made to the project. A single separator character such as an exclamation mark after the project code (the first code) indicates the link type is a task (the link is to the project operational structure). Two separators placed after the project code mean that the link corresponds to a budget code (link to the project budget structure).

 This field is populated by default with the project code if you accessed this function directly from the project. If you accessed this function from the project structure the project code and project budget/task code is displayed accordingly.

 
  • Start date (field BPRDATDEB)

Use this check box to select the invoices which have a 'warning' Three-way match status.

SEEINFO The Three-way match status is defined in the Product function.
  • End date (field BPRDATFIN)

 

 

 

Status

  • Invoice (field PIHTYP1)

Use this check box to select the invoices which have a 'warning' Three-way match status.

SEEINFO The Three-way match status is defined in the Product function.
  • Credit memo (field PIHTYP3)

 
  • Posted (field STAO)

 
  • Payment approval level (field BAPO)

 
  • Additional invoice (field PIHTYP2)

 
  • Credit memo/return (field PIHTYP4)

 
  • Not validated (field STAN)

 
  • Not at payment approval level (field BAPN)

 

Match status

  • Warning (field TWMSTAW)

 
  • Blocked status (field TWMSTAB)

 
  • Unblocked (field TWMSTAU)

 
  • Successful (field TWMSTAS)

 
  • Not applicable (field TWMSTAN)

 

Display

 
  • Sort order (field TRI)

 

Close

Click the Criteria action to access additional selection and display criteria. You can filter the invoice lines to be processed by analysis group and modify the sort order.

Status. Use this block to add filters on the invoice status: for example, only display additional invoices and filter according to payment validation status.

Match status. Use this block to filter results according to match status: you may filter by warning, blocked invoice lines, matched invoiced lines, etc.

Screen code. You can select the required customized inquiry screen, if you are using personalized inquiries.

Please see the Inquiry screens documentation.

You can save one or several sets of criteria using the Memo action. You can recall these using the Recall action or delete them using the Delete memo action.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation