Use this function to display customer and subcontractor returns lines to one or all sites on one, or between a range of dates.

You can inquire by company and site, product and customer, project and type of return. You can filter the results by the category and type of return, and the status of the credit note. 

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 for code 'CSR' determines the way in which you enter information, and how information is displayed and printed.

The Return lines inquiry function contains a section for you to enter your selection criteria and a table (grid) in which the results of the search are displayed.

Header

Selection

Use this section to filter or select returns:

  • Start date. The default Start date is the first date of the month two months before the current month but can be amended.
  • End date. The default End date is the last date of the current month but can be amended.

The search, therefore, covers a 3 month period, by default.

Category and return type, Credit memo

You can filter the results by the category and type of return, and the status of the credit note using the Category and return type and Credit memo sections.

You can use the Criteria action to enhance the selection criteria applied.

Selection

Company (field CPY)

This field is used to specify the company code.
The company is automatically loaded with the company of the user's default storage site. It remains modifiable.
SEEINFO It is possible to display the returns of all the companies by leaving this field blank. In this case, the site field is automatically left blank.
Receiving site (field STOFCY)

This field is used to indicate the storage site.
SEEINFO This site is automatically loaded with the user's default storage site. It can be left blank. In that case, the inquiry will concern all the company's returns.
Customer code (field BPCNUM)

This field is used to enter the code identifying the customer.
SEEINFO When no customer is specified, the inquiry will concern all the customeers of the folder.
Product (field ITMREF)

This field contains the reference identifying the product.
From project (field PJTDEB)

Use these fields to 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 content 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 cost structure or the project operational 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).

 
To project (field PJTFIN)
Whole project (field PJTDSPALL)

Select this check box to view all records linked to the selected projects. To only view records linked to the selected structure of the projects, leave this check box clear.

If the value of the From/To project field includes a character such as an exclamation mark "!" the search includes the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational 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".
Start date (field RTNDATDEB)

These two fields are used to define the date ranges.
These ranges are used to filter the returns with a return date included within this time interval.
They are initialized by default in the following manner:

  • the end date is initialized with the current date postponed to the last day of the month,
  • the start date is initialized with the first day of the month coming from the current date minus two months.
End date (field RTNDATFIN)

Currency

Company (field CURS)

This field displays the company currency and cannot be modified.

Folder (field CURD)

This field displays the folder currency and cannot be modified.

Category and return type

Normal (field RTNTYPNOR)

This field is used to select the returns of "Normal" category. A "Return type" can also be entered to apply an additional filter.
Return type (field SRHTYPNOR)

This field can only be entered if the category is specified. It is used to filter the returns of a same category according to the return type.
Loan (field RTNTYPLND)

This field is used to select the returns of "Loan" category. A "Return type" can also be entered to apply an additional filter.
Return type (field SRHTYPLND)

This field can only be entered if the category is specified. It is used to filter the returns of a same category according to the return type.
Subcontract (field RTNTYPSCO)

This field is used to select the returns of "Subcontract" category. A "Return type" can also be entered to apply an additional filter.
Return type (field SRHTYPSCO)

This field can only be entered if the category is specified. It is used to filter the returns of a same category according to the return type.

Credit memo

Pending (field RTNTYPNCN)

Check the box Gen. credit memo to view the returns awaiting a credit memo.
Check the box Completed to display the completed credit memos.

If you check both boxes, all returns will be displayed.

If you only check the box Gen. credit memo, the list suggests the returns for the Credit memo field is set to 'Yes' in the Customer returns record and for which the column Credit memo no. is blank.

If you only check the box Completed, the list will suggest:

  • returns for which the field Credit memo is set to 'Yes' in the Customer returns record and for which the column Credit memo no. is filled,
  • returns for which the Credit memo field is set to 'No' in the Customer returns record.
Completed (field RTNTYPCNO)

Tab Search results

This section displays all customer and subcontractor returns lines that meet the defined selection criteria. Actual and expected return dates and quantities for each line are included.

The columns displayed in the grid or table and the order in which they are displayed is determined by the Inquiry screens function for code 'CSR'.

Grid

Return no. (field SRHNUM)
Ship-to (field BPCORD)
Delivery address (field BPADES)
Bill-to customer (field BPCINV)
Project (field PJT)

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 content 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 cost structure or the project operational 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).
Tax rule (field VACBPR)
Payment term (field PTE)
Settlement discount (field DEP)
Pay-by (field BPCPYR)
Group customer (field BPCGRU)
Sales rep 1 (field REP1)
Sales rep 2 (field REP2)
Return date (field RTNDAT)
Expected return date (field EXTRTNDAT)
Product (field ITMREF)
Description (field ITMDES)
Return quantity (field QTY)
SAL-STK conv. (field SAUSTUCOE)
Return quantity STK (field QTYSTU)
Actual delivered qty. (field WDLVQTY)
Expected return qty. (field EXTQTY)
Sales unit (field SAU)
Return reason (field RTNREN)
Net price - tax (field NETPRINOT)
Net price + tax (field NETPRIATI)
Currency (field CUR)
Net price, tax excl. (company) (field NETPRINOTL)
Net price incl tax incl (company) (field NETPRIATIL)
Order price (company) (field PRIORDL)
Net price, tax excl. folder (field NETPRINOTD)
Net price incl tax (folder) (field NETPRIATID)
Order price folder (field PRIORDD)
Amount - tax (field RETNOT)
Amount + tax (field RETATI)
Amount - tax (co) (field RETNOTLOC)
Invoice amt. + tax (co) (field RETATILOC)
Amount - tax (folder) (field RETNOTDOS)
Invoice amt. + tax (folder) (field RETATIDOS)
Receiving site (field STOFCY)
Delivery no. (field SDHNUM)
Credit memo no. (field SIHNUM)
Order no. (field SOHNUM)
Supplier return no. (field PNHNUM)
Loan return (field LNDRTN)
Subcon. mat. rtrns. (field SCORTN)
Order update (field ORDUPD)
Return is subject of a credit memo (field RTNCNOFLG)
Return deducted from the invoice (field RTNINVUPD)
Return type (field SRHTYP)
Return

Click Return from the Actions icon to view the return 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.
Credit memo on return

Click Credit memo on return from the Actions icon to view the credit note details. The credit 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.
Delivery

Click Delivery from the Actions icon to view the delivery 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.
Customer order

Click Customer order from the Actions icon to view the 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.
Sales journal traceability

Click Sales journal traceability from the Actions icon to open the Journal traceability inquiry where you can view or browse through the hierarchy of documents created from this returns line.

Specific actions

Click the Search action to load the table (grid) with returns lines that meet the entered selection criteria.

The maximum number of lines displayed is defined in the Inquiry screens function for code 'CSR'.

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

You can optionally select the returns lines by applying a calculation formula.

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.

Selection

Memo code (field MEMO)

When the criteria definition function is used, it is possible to store the modified criteria thanks to button [Memo].
A window is used to enter a code that identifies the saved criteria.
Button [Call] is used to call criteria saved under a given code (the code has then to be entered).
When the account inquiry function is open, the parameters stored with the STD code are called by default.
If the criteria are not saved in an STD memo, the proposed default values are:

  • the default accounting site for the user (and the corresponding company),
  • the date range corresponding to the last open financial year,
  • the default company currency.
Company (field CPY)

This is the code of the assignment company of the entity.
This optional zone makes it possible to specify entities common to several companies.
Receiving site (field STOFCY)

Enter or select the storage site where the selected product is active.

The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table.
Customer (field BPCNUM)

Enter the supplier at the origin of the receipt. The selection lists specific to the intersite and intercompany orders and deliveries available for receipt are filered to those related to the entered supplier.

From the Selection icon, you can:

  • select a supplier from the list of active suppliers.
  • access, based on your authorizations, the supplier record, and create a new supplier if necessary.
Product (field ITMREF)

This field indicates the product reference code. It is generated by a sequence number counter (set up in function Sequence number counters) in the case when the product category has a sequence number counter code.

The reference cannot be modified. It is automaticaly assigned and displayed at product creation end.
From return no. (field RTNNUMDEB)
To return no. (field RTNNUMFIN)
From project (field PJTDEB)

Use these fields to 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 content 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 cost structure or the project operational 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).

 
To project (field PJTFIN)
Whole project (field PJTDSPALL)

Select this check box to view all records linked to the selected projects. To only view records linked to the selected structure of the projects, leave this check box clear.

If the value of the From/To project field includes a character such as an exclamation mark "!" the search includes the structure of the project. The character is the separator between a project code and the structure, either the project cost structure or the project operational 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".
Start date (field RTNDATDEB)

These two fields are used to define the date ranges.
These ranges are used to filter the returns with a return date included within this time interval.
They are initialized by default in the following manner:

  • the end date is initialized with the current date postponed to the last day of the month,
  • the start date is initialized with the first day of the month coming from the current date minus two months.
End date (field RTNDATFIN)
Formula (field SELFOR)

Enter, select or build an Enterprise Management filter calculation expression using the formula editor.

 
field TSICOD
field TSCCOD

Category and return type

Normal (field RTNTYPNOR)
Return type (field SRHTYPNOR)
Loan (field RTNTYPLND)
Return type (field SRHTYPLND)
Subcontract (field RTNTYPSCO)
Return type (field SRHTYPSCO)

Credit memo

Pending (field RTNTYPNCN)
Completed (field RTNTYPCNO)

Display

Screen code (field ECRAN)

This field is used to enter the code of the screen used to display the postings.
SEEINFO If the field is not entered, the STD screen code is used by default.
Sort order (field TRI)

The available sorting criteria for Production Cost Prices are
Date (by default)
WO number
Actual quantity
Ratio

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation