Setup > Sales > Entry transactions > Invoices 

Use this function to manage the settings for the customization of the sales invoice entry screens.

A standard sales invoice entry transaction is initialized upon installation of the software. It can be modified or deleted using this option, which can also be used to create new ones.

You can set up several transactions for sales invoices. Each transaction, identified by a code and a description, appears in a selection window when calling the Invoices option.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

The transaction header allows the user to create new transaction codes or to look for existing transactions to be modified or deleted.

Close

 

Fields

The following fields are present on this tab :

Invoice/Credit memo trans.

  • Transaction (field STRNUM)

Code used to identify the transaction set up.

The setup of the entry transactions enables the user to fully set up the entry screens associated with a document (quote, invoice order, request for quotes etc.) or with a stock transaction type (receipt, issue etc.).

For each document or stock transaction type, it is possible to define as many entry transactions as necessary, each one being identified by a code.

Each transaction is used to define, both for fields located on the document header and fields entered in the lines, whether they must be:

  • Entered
  • Only displayed
  • Or hidden

Upon validation of this setup, dedicated entry screens are created, and then can be used by any user having been granted rights on the access code defined on this setup header.

  • If a given user has the right to use several transactions of a given type, the choice is presented to the user when entering the function.
  • If the user is only authorized one transaction, this transaction is automatically taken into account when entering the function.
  • Description (field DESAXX)

Transaction description.

  • Active (field ENAFLG)

Use this field to activate or deactivate a transaction.
Inactive transactions are not displayed in the transaction selection window.

This access code is used to restrict access to data by user or group of users.
If this field is entered, only users with this access code in their profile can use this transaction.
If several transactions are available, you can choose the transaction you want to use to open the function. If only one transaction is available, there is no selection to be made: the default entry screen opens directly.

The group of companies or sites entered here is used to filter the records.
These records will be accessible during the transaction.

Close

 

Tab Parameter Definitions

Fields

The following fields are present on this tab :

Invoice

This is the code of the invoice document automatically printed at end of entry.

  • Auto print (field DOCFLG)

Select this check box to automatically launch the printing of the document on entry completion.

The automatic printing only takes place in creation mode.

Miscellaneous

  • Document type (field INVTYPFAC)

This is the invoice category. This field is used to identify the invoice (Invoice, Proforma).

This parameter is used to define, for this transaction, a default transaction group code.

  • Warehouse (field WRHCOD)

 

  • Single warehouse (field WRHOBY)

 

Invoicing elements

  • Elements (field INVDTACOD)

This table contains the document invoicing elements (quote, order, shipment, invoice).

Stock

This setup is used to define for this entry transaction a movement code used to specify rules for a specific type of movements.
These codes must be created in the miscellaneous table number 14.

This field is used for this transaction to specify the code of the accounting automatic journal used to generate, via the stock accounting interface, the accounting entries with respect to the stock movements created with this transaction.
This field can only be accessed if the SCOIFA - WIP accounting interface parameter is set to No.

Stock to issue

  • Automatic determination (field STKFLG)

Select this check box to specify that the stock to issue for this transaction should be automatically determined. The automatically determined stock information is the product, the unit, and the quantity.

If this check box is not selected, the stock must be manually chosen.

Automatic determination is based on:

  • the filters entered at product category level, especially the issue flow management rules for the relevant movement type/code.
  • the allocation rule dedicated to the relevant movement,
  • the stock information entered on the line.

The automatic determination rules applied to stock to issue are the following:

  • If the product is managed by Receipt/Issue serial number, the serial numbers are necessary and sufficient. Other entered information is not used.
  • If the product is managed by lot or lot/sublot, the lot number or lot/sublot numbers are necessary. The following information is used if it has been entered:
        • The license plate number (in priority) or the location
        • The status, the identifiers 1 and 2
  • For the other products, at least one of these three pieces of information is needed.
        • The license plate number (in priority) or the location
        • Identifier 1
        • Identifier 2
The following information is used if it has been entered:
  • The license plate number (in priority) or the location
  • The status, the identifiers 1 and 2
If the product is not managed by location on the site, and identifiers 1 and 2 are not specified, then only one stock line corresponds to the information entered.

When the entry transaction only concerns 'Pick location’ replenishments, this check box cannot be accessed.

Close

 

Tab Display

Presentation

In this section, select the columns that will be present on the invoice.

 

Fields

The following fields are present on this tab :

Header

  • Invoice origin (field SIHORICOD)

This field is used to determine the origin of the invoice/proforma.
The origin is comprised of a code of origin and the number of the original document.
For a pro-forma invoice, it can be a quote, an order or a delivery.
For an invoice, it can be a quote, an order or a service contract.
SEEWARNINGThe number of the original document is only entered if the original document is unique.

  • Purchase invoice no. (field PIHNUMCOD)

This is the purchase invoice number generated from the sales invoice when in inter-company.

  • Invoice status (field STACOD)

This field specifies the various statuses of the document.

  • Intercompany (field BETCPYCOD)

Use this parameter to define if the inter-company nature of the document must be displayed or not.
Inter-company documents are used for exchanges between sites belonging to different legal companies.
Reminder:

A inter-company document is considered as such if it meets the following criteria:

  • The recipient business partner is defined as a site: this BP is set to inter-site at the level of the BP record and linked to a site.
  • This site linked to the recipient BP belongs to a different legal company than the original site of the document.
  • Invoice amount (field AMTCOD)

Different totals in the document.

  • ISR/QR reference number (field BVRREFNUMC)

Select this check box to display the ISR reference number in the sales invoice entry transaction.

This check box needs to be selected to print the QR Inpayment slip for QR-bills.


This field is related to the SWICUSBVR - Swiss ISR usage Sales (LOC chapter, SWI group) parameter.

The ISR payment bank of the invoice is specified in the Payment bank ISR field in one of the following functions. The system pulls the information from the first entry found.

  1. From the BP/Company section of the Business partner record (GESBPR)
  2. From the Financial section of the Customer record (GESBPR)
  3. From the Details section of the Sites function (GESFCY)

Line

  • Margin (field PFMCOD)

This parameter is used to define, for this entry transaction, whether the margin must be displayed or not.

This concerns the display of the margin on the line, and of the document total margin.

  • field PFMSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Stock unit (field STUCOD)

Product storage unit.

  • field STUSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Net price (field NETPRICOD)

Net price.
It is the net price for the line. It is calculated from the gross price and the various charges/discounts.
This field cannot be modidfed.

  • field NETPRISCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Line type (field LINTYPCOD)

Field that cannot be entered and that defines the line.
The line can have the following values:

  • Normal,
  • Kit parent product,
  • Kit component,
  • Kit option,
  • Kit variant,
  • BOM parent product,
  • BOM component,
  • BOM option,
  • BOM variant,
  • Subcontracted,
  • Service,
  • Supplied material.
  • field LINTYPSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Free (field FOCFLGCOD)

Non-enterable field defining the free item characteristics.
The values can be:
- No: This line mentions a price and has not delivered any free items
- Origin: Line mentioning a price and giving rise to free items
- Free item: Free line.


  • field FOCFLGSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.

 

Tab Header

Presentation

In this section, specify the management mode of specific sections in the entry screen of the invoice header.

Close

 

Fields

The following fields are present on this tab :

Entry

  • Sold-to (field BPCORDCOD)

Code of the customer requesting the order, the direct delivery or the direct invoice. This code:

  • must be managed in the customer table,
  • must be of normal, miscellaneous or inter-company type,
  • can be modified as long as no line has been entered on the document.
  • Pay-by (field BPCPYRCOD)

The Pay-by BP is initialized by default by the pay-by BP associated with the sold-to customer in the latter's record in the case of a direct delivery. Otherwise, the pay-by BP of the original order is used.

It is possible to:   

  • modify the pay-by BP if necessary,
  • select a BP or access BP management by tunnel if user authorizations allow it.

SEEINFO Special features linked to the inter-company: in the case of an inter-company order automatically generated from a purchase order, the pay-by BP corresponds to the customer associated with the invoicing site entered in the purchase order. It cannot be modified in this context.

  • Group customer (field BPCGRUCOD)

The group customer is initialized by the group customer code associated to the sold-to customer in the latter's record. This information is used for the generation of statistics. It is also involved in the grouping of invoices during the automatic generation of invoices. There is the possibility to modify the group customer if necessary.
From this field, it is possible to select a customer or access customer management by tunnel if the user's authorizations allow it.

It is possible to search a customer or several customer grouped under the same criteria by selecting "Quick customer search". A list of matching items is generated on tabulating to the next field.
For a more advanced search, all fields present in the block can be entered. The list of matches is narrowed down with each tabulation.

  • Delivery address (field BPAADDCOD)

This field indicates the code of the address to ship to.
You can view the detailed address information by clicking Address from the Actions icon.

  • On creation, this field is no longer accessible when a delivery line is created.
  • Once the delivery has been created, you can no longer modify this field but you can still display the detailed address information.
    You can modify the address after clicking Address/Delivery from the Actions panel.
  • Project (field PJTCOD)

This parameter is used to define, for this entry transaction, whether the project field must be:

  • Hidden:
    The field is not displayed on the entry screen.
  • Displayed:
    The field is displayed and cannot be modified.
  • Entered:
    The field is displayed but can be modified. The value entered is not controlled (free entry).
  • Sales reps (field REPCOD)

The sales reps are initialized by the customer sales reps, then by those of the ship-to customer, if no sales rep exists in the customer record. In the case of a prospect, the representatives of the prospect are not considered. These sales rep codes are copied to the document lines. If a representative is modified in the document header upon creation or when lines exist in the document, the system suggests to copy the modification to all the lines that already exist.

  • Memo reason (field CNORENCOD)

This field can be entered in the case of credit memos: enter the reason for the credit memo in this field.

  • VCS number (field BELVCSCOD)

 

  • Tax rule (field VACBPRCOD)

This information is used to indicate the tax rule for the document. This code is controlled in the tax rule table and is initialized by the corresponding code in the BP record. It can be modified.
This information is mandatory and remains accessible provided the delivery has not been confirmed.
Only a tax rule with a legislation and group that are consistent with those of the document can be entered.
SEEREFERTTOThe general principles linked to the multi-legislation setup are detailed here.

  • Price - / +tax (field PRITYPCOD)

The value of this field (Ex-tax or Tax-incl.) is defined by the general parameter SALPRITYP - Price/Amount type (TC chapter, INV group).

When the general parameter NOTATI - Ex-tax and tax-incl. amount/price (TC chapter, INV group) is set to No you cannot modify this information.

  • Stock transaction (field STOMVTCOD)

Stock movement flag that indicates if the invoice is managed with stock update.

  • Shipment site (field STOFCYCOD)

Shipment site By default it is initialized with the shipment site of the ship-to customer. The site must be defined with the Warehouse flag set to the value "YES".

  • Transaction group (field TRSFAMCOD)

Movement group, initialized by the movement group of the transaction being used.
This statistical information is recorded in the stock journal when saving the receipt/disposal movements. This movement group comes from the miscellaneous table number 9. The value given in the transaction setup corresponds to a default value that can/cannot be visualized and/or modified according to the transaction setup (entered, displayed, hidden field).

Statistical information used in the stock transactions associated with the shipment. This value is fixed if the original document does not reference a movement group. Otherwise, the movement group of the document at the origin of the quality control is suggested in priority.

  • Incoterm (field EECICTCOD)

This setup is used to define, for this entry transaction, whether the Incoterm code field must be:

  • hidden: the field does not appear in the entry screen but a default value is assigned to it.
  • displayed: The default value is assigned to the field and displayed but the value cannot be modified.
  • entered: the default value can be modified and when it is the case, it will be checked in the currency table no. 5.

The access to the freight terms code and city/town is also carried out via the menu Options / Customs information.

SEEINFO The assigned default value is the Incoterm code associated with the ship-to customer in its record.

  • Entity/Use (field SSTENTCOD)

 

  • VAT declaration no. (field DCLEECNUMC)

 

  • Method of correction (field METCORCOD)

Use this parameter to define, for this entry transaction, whether the method of correction must be 'Hidden' or 'Entered'.

This method is hidden by default. This method can only be accessed if the following conditions are met:

  • The EDIX3 - Paperless document exchange and KSP - Spanish localization activity codes are activated
  • The value of the FACTURAE - Facturae format (LOC chapter, SPA group) parameter is set to 'Yes'.

Entry

  • Currency (field CURCOD)

This is corresponds to the currency of the order, delivery or invoice.
It is initialized by default with the bill-to customer currency and can be modified. In this case, it can only be modified in creation and duplication modes and is controlled in the currency table.

It is possible to choose the currency for the delivery transaction as well as to define (depending on the value of the 'Excl. tax and Incl. tax Prices' parameter - TC Chapter / INV/NOTATI group) if the prices are expressed excluding tax or including tax. When the delivery comes from an order, this information is automatically loaded and cannot be modified. When it is a direct delivery, this information is no longer modifiable once at least one delivery line is entered. It is inherited in this case from the invoiced customer information.

  • Currency rate (field RATCURCOD)

Enter here the exchange rate for the currency with respect to the company currency.

If it is not assigned, the rate used will be that initialized as a function of the "Currency exchange rate" file (displayed after the editable field).

  • Comments (field DESCOD)

This field is used to enter comments where the first line can be taken as a label for the posting according to the parameters of the automatic journal (PIHI for the purchase invoice or SIHI for the sales invoice).
SEEINFOThe presence of this field depends on the entry transaction used.

  • Factor (field BPRFCTCOD)

Code of the factor proposed as a default value on the invoices for this customer.
The presence a Factor code in an invoice indicates that this invoice is transferred to a factoring organization and that the payment must be made in favour of the Factor.

  • Control (field BPRSACCOD)

Enter the code for the BP (customer or supplier) control account initialized by default with the accounting code for the BP invoice.

The initialization of the code for the Control field depends on whether or not the BP/Company tab is present in the BP record (GESBPR).

  • Due date basis (field DUDDATCOD)

Open item payment due date.

If the MAXPD - Maximum period (companies) activity code is activated, a blocking message is displayed if the last due date is greater than the period specified, depending on the case, at the level of the following parameters or of the Contractual period possibly specified at the BP level.

  • Payment term (field PTECOD)

Payment condition code. This code defines the payment code and the distribution rules of the various pre-payments and open items.
It is initialized by the bill-to BP and is controlled in the payment condition table.
Only a discount code consistent with the legislation and company group of the document site can be entered.
SEEREFERTTOThe general principles linked to the multi-legislation setup are detailed here.

It is possible to simulate a distribution thanks to the "Simulation" button. In order management, creation mode, the pre-payments corresponding to the payment condition are automatically created. The 'payment terms' code can be modified as long as no pre-payment has been made and the order has not been invoiced. Such a modification would then trigger the deletion of the already existing pre-payments followed by the creation of the pre-payments related to the new payment condition.

  • Mandate reference (field UMRNUMCOD)

This field is used to define, for this entry transaction, whether the reference of the ship-to customer must be:

  • Hidden:
    The field is not displayed in the entry screen and thus it remains empty.
  • Displayed:
    The field is displayed empty and cannot be modified.
  • Entered:
    The field is displayed empty but can be modified.

SEEINFO The management of this field is also subject to the SDD - SDD management activity code and to parameter SDDMGT - SDD management (chapter TC, group SDD).

  • Settlement discount (field DEPCOD)

Parameter used to define, for this entry transaction, if the discount must be:

  • Hidden:
    The field does not appear on the entry screen but it is assigned a default value.
  • Displayed:
    The default value is assigned to the field and displayed but the value cannot be modified.
  • Entered:
    The default value is assigned to the field and displayed. It can be modified.
  • Benefit period (field SVCDATCOD)

Start and end period for the service provision.

  • VAT adjustment - 40 (field FLD40RENCO)

Field subject to activity code: KPO - Portuguese localization
This parameter used to define, for this entry transaction, whether the VAT adjustment reason for the field 40 must be:

  • Hidden:
    The field is not displayed in the entry screen and thus it remains empty.
  • Displayed
    The field is displayed empty and cannot be modified.
  • Entered:
    The field is displayed empty but can be modified. The value entered is controlled in the miscellaneous table 8300.
  • VAT adjustment - 41 (field FLD41RENCO)

Field subject to activity code: KPO - Portuguese localization
This parameter used to define, for this entry transaction, whether the VAT adjustment reason for the field 41 must be:

  • Hidden:
    The field is not displayed in the entry screen and thus it remains empty.
  • Displayed
    The field is displayed empty and cannot be modified.
  • Entered:
    The field is displayed empty but can be modified. The value entered is controlled in the miscellaneous table 8301.
  • Registration (field LICPLATCOD)

 

  • Trailer license plate (field TRAPLTCOD)

 

  • Departure date (field DPEDATCOD)

 

  • Arrival date (field ARVDATCOD)

 

  • Departure time (field ETDCOD)

 

  • Arrival time (field ETACOD)

 

  • Payment bank ISR/QR (field PAYBANCOD)

Use this field to select how the ISR payment bank field displays in the sales invoice entry transaction.

For printing the QR Inpayment slip for QR-bills, this field must be Displayed.

  • Entered: The determined payment bank is assigned to the field and displayed. It can be modified.
  • Displayed: The determined payment bank is assigned to the field and displayed but the value cannot be modified.
  • Hidden: The field does not appear on the entry screen but it is assigned the determined payment bank.

This field is related to the SWICUSBVR - Swiss ISR usage Sales (LOC chapter, SWI group) parameter.

The payment bank information is used to print the necessary sender’s bank account information on ISR payment forms. Use this bank account as the destination account when paying the invoice.

The ISR payment bank for the invoice is specified in the Payment bank ISR field in one of the following functions. The system pulls the information from the first record found.

  1. From the BP/Company section of the Business partner record (GESBPR)
  2. From the Financial section of the Customer record (GESBPR)
  3. From the Details section of the Sites function (GESFCY)

Important: The ISR payment bank is only considered in the ISR process.

  • Period date (field PERCOD)

 

Close

 

Tab Line 1

Presentation

In this section, specify the management mode for particular fields in the entry screen at the level of each invoice line by deciding for each of the submitted fields whether they should be Hidden, Displayed or Entered according to the same principles as for the fields set up at invoice header level.

Close

 

Fields

The following fields are present on this tab :

Product lines grid

  • No. of fixed columns (field NBRCOL)

The first N columns specified in this field remain visible on the screen when scrolling.

Entry

  • Translated description (field ITMDESCOD)

This is the product description translated into the customer language. This description is the one that will be printed on the document. If the translation does not exist in the customer language, the un-translated product description is used. This description is also transferred to the next document.

SEEINFOThe product record can be accessed from this field using a tunnel.

  • field ITMDESSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Standard description (field ITMDES1COD)

This is the description entered on the product record. This description is transferred from the sales invoice to the purchase invoice in case of inter-company invoicing. When the invoice stems from another document, the standard description is inherited from the source line.

  • field ITMDES1SCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Major version (field ECCCOD)

Use this field to control entry or modification of the Major version number for a product. You can set this field to one of the following values:

  • Hidden:
    The Major version field is not displayed on the entry screen
  • Displayed
    The version number is loaded automatically if a product is version managed. It cannot be modified.
  • Entered
    The version number can be entered. The version number is loaded automatically if a product is version managed but can be modified.

  • field ECCSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Minor version (field ECCCODMIN)

Use this field to control entry or modification of the Minor version number for a product. You can set this field to one of the following values:

  • Hidden
    The Minor version field is not displayed on the entry screen.
    The minor version is always hidden if the major version is hidden.
  • Displayed
    The version number is loaded automatically if a product is version managed. It cannot be modified.
  • Entered
    The version number can be entered. The version number is loaded automatically when a product is version managed but it can be modified.
    You can only select this value if the Major version is set to 'Entered'.

  • field ECCSCRMIN

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Percentage (field INVPRCCOD)

This field only applies to the invoicing open items of orders. For this entry transaction, you use it to define if the invoiced percentage must be:
Hidden

The field is not displayed.

Displayed

The field is loaded with the percentage defined for the invoicing term and cannot be modified.

Entry

The field is displayed and can be modified.

  • field INVPRCSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Sales unit (field SAUCOD)

The sales unit is initialized by the sales unit defined in the Product-customer record, if it exists, if not, it will be initialized by the sales unit of the product. Entry of another unit is possible in a selection window. The suggested units, other than those mentioned previously, are the packing units for the product and the packing units defined in the Product-customer record. When necessary, and if you have been granted the appropriate authorizations, you can access the units table.

Once the line is entered, you can no longer modify the sales unit. You must delete the line and recreate it to be able to modify the unit.

  • field SAUSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • SAL-STK conversion (field SAUCOECOD)

This is the conversion factor between the sales unit and the stock unit. This coefficient can be modified in certain cases. It can be edited if the sales unit of the product has been specified as 'editable', or if the chosen packing unit has also been specified as 'Editable' (See Product record). It cannot be edited if the unit used is a unit defined for the customer. If units are used where the factor is modifiable, it is necessary to define for the product concerned, only prices expressed in stock unit. In addition, if a basic price list has been defined for the sales unit, the modification of the conversion factor for the sales unit does not trigger a recalculation of the unit gross price.

SEEINFO Once the line entered, it is no longer possible to modify the conversion factor. The line must be deleted and recreated so as to modify the factor.

  • field SAUCOESCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Gross price (field GROPRICOD)

Help common to the Order and Buyer plan functions.

Use this field to determine the gross and excluding tax unit price of the product. This price is expressed in order unit if the Unit field is declared as accessible at the time of entry in the transaction, if not, it is expressed in purchase unit.

When the main information for the line has been given, a price list search process is automatically carried out. The objective of this search is to recover:

  • The gross price and the associated reason.
    If the order (or purchase) unit is different from that of the price list line:
    - The price list amount is converted if the value of the Unit conversion is set to 'Yes' at the Pricing parameters level. This conversion is based on the unit conversion coefficient table. If no conversion is set up between these units, the price list amounts are those that are considered by applying a 1 conversion rate.
    - The price list is not used if the value of the Unit conversion is set to 'No' at the Pricing parameters level The value of the gross price is set to '0'.
  • The charges and discounts in percentages or in amounts to be applied to the line level as well as the associated reasons.

When the entered price is null, a message appears to request confirmation from the user.

In the Price field, you can use the Actions icon to:

  • View and modify the Discount and Cost fields defined using the structure code associated with the supplier. The values contained in these fields come from the price list search and can be modified if the associated reason allows it.
  • View the reasons associated with the price as well as the different discounts and charges fields
  • View the price lists
  • Re-initialize the price, as well as the discounts and costs, by requesting a new price list search.

The entry of other data on the line depends on the selected transaction. This is the case for example for the Site information, Quality control code, etc.

Inter-company specificities: Within the framework of an inter-site or inter-company order, if the inter-company price lists have been set up, they will be used in the same way as normal price lists. When the sales order is generated, the prices and the discounts calculated for the reciprocal sales order will be determined from the inter-company price lists or the normal price lists. In no case will the prices and discounts entered in the purchase order be transferred to the sales order. The prices between the sales and purchasing documents can change independently. The reconciliation is made at the time of invoicing.

  • field GROPRISCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Cost price (field CPRPRICOD)

The 'cost price' is populated by default with the valuation of the product chosen for the margin calculation (see the valuation methods defined for the Product-Site record) at the time of the creation of the document line and is expressed in sales unit. The various possible choices for the cost price valuation are: Standard price, Revised standard price, Last price, Weighed average price, FIFO price, Lot average price and LIFO price. If the valuation method happened to return a zero value, a default value is used by specifying another valuation method contained in the list previously described. This value is stored in the "document" line.

It is possible to preload this information according to the document transaction used. Still, during the following events, the entered value is systematically replaced by the value originating from the setup of the valuation method for the product, except if this setup determines a null value (in which case the change is saved):

  • Turning a quote into an order
  • Delivering an order 
  • Validating a delivery
  • Invoicing an order The cost price is fixed when invoicing a delivery

In quote management, the 'lot average price' always returns a null value. A default value is used. During the delivery validation, the 'Lot average price' is used to recalculate the margin and obtain a real margin depending on the shipped lot(s).

  • field CPRPRISCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Line amount (field AMTLINCOD)

 

  • field AMTLINSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Tax level (field VACITMCOD)

This field indicates the tax level applied to the selected product.
The tax level, when crossed with the document tax rule, is used to determine the tax rate to be applied on the document line.

There are several tax levels for a document line:

  • The first level is mandatory. It corresponds to the VAT,
  • The two other levels correspond to additional or special taxes which may:
    • be liable to VAT,
    • be applied on ex-tax basis or other valuated formula.

The tax levels for the document line will be loaded by default with the values associated with the product record ("Accounting" tab).
These values can be modified depending on the transaction.
Provided the user has the corresponding authorizations, he can access the tax level management.

  • field VACITMSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Rep commission rate (field REPCODD)

The sales reps on the document line are initialized by the sales reps entered in the document header. If the latter are not entered, the sales reps in the line are initialized by the sales reps for the customer, by those for the ship-to customer if there are no sales reps in the customer record.

If the parameter LINREP - Sales rep on detail allows it (chapter VEN, group MIS), the sales reps can be modified on the document line. It is possible, based on the user's authorizations, to access the sales representative record.

  • field REPSCRD

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Benefit period (field SVCDATCODD)

Service start and end date, numver of periods and frequency exploited in Finance to distribute the Accruals.

  • field SVCDATSCRD

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Physical flow (field FLOPHYCODD)

This field is used to specify whether the line identifies a physical flow playing a role in the Customs document file statement. An invoice line not linked to a physical flow can be declared for regulation if an EEC rule and/or an EEC transaction nature is entered on the invoice (Customs information option).
The initialization of this field is carried out differently whether it concerns a product managed in stock or not:

1/ Product managed in stock

  • If it concerns direct invoices/direct credit memos without stock movements the physical flow is initialized to No and remains modifiable.
  • If it concerns direct invoices/direct credit memos with stock movements the physical flow is initialized to Yes and remains modifiable.
  • If it concerns invoices stemming from a delivery or an order the physical flow is initialized to Yes and cannot be modified.
  • If it concerns invoices stemming from a delivery or an order to which additional lines have been added the physical flow is initialized to Yes and cannot be modified.

2/ Product not managed in stock

  • If it concerns direct invoices without stock movements the physical flow is initialized to No and remains modifiable.
  • If it concerns direct invoices with stock movements the physical flow is initialized to No and remains modifiable.
  • If it concerns invoices stemming from a delivery or an order the physical flow is initialized to Yes and remains modifiable.
  • If it concerns invoices stemming from a delivery or an order to which additional lines have been added the physical flow is initialized to Yes and cannot be modified.

  • field FLOPHYSCRD

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Project (field PJTCODD)

This parameter is used to define, for this particular entry transaction, if the Project field must be:

  • Hidden:
    The field is not displayed on the entry screen.
  • Displayed:
    The field is displayed and cannot be modified.
  • Entered:
    The field is displayed but can be modified.
    The control applied to the entered value is based on the CTLOPPCOD - Mandatory project control parameter (TC chapter, MIS group).

SEEINFOEven if the project code can be entered using this setup, its entry is still prohibited if the document management is single-project (thePJTSNGDOC - Single-project documentparameter is set to Yes): in that case, the project code of the line automatically uses the value of the project code in the header.

  • field PJTSCRD

 

  • Reinvoicing (field INVCNDUPDC)

 

  • field INVCNDUPDS

 

  • Reinvoicing date (field NEXINVDATC)

 

  • field NEXINVDATS

 

Close

 

Tab Line 2

Fields

The following fields are present on this tab :

Entry

  • Discount/Charge 1 (field DISCRGCOD1)

Help common to the Sales and Purchase modules.

The displayed discount and cost columns are linked to the setup of the price lists structure code associated with the supplier in said supplier's record.
These columns can be initialized by means of the price lists (see the Sales pricing setup and Price list entry documentations).

Access to these columns can depend on the setup of the reasons associated with the price lists as well as the value of the reason given to the

These discounts or costs are defined in amount or in percentage and they are applied with a totaling or cascading method to the gross price to determine the net price of the document line.

From the Actions icon, you can:

  • View the reasons associated with the price as well as the different discounts and costs fields
  • Modify, if necessary, the reasons allocated to each column.
  • field DISCRGSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Discount/Charge 2 (field DISCRGCOD2)

 

  • field DISCRGSCR2

 

  • Discount/Charge 3 (field DISCRGCOD3)

 

  • field DISCRGSCR3

 

  • Discount/Charge 4 (field DISCRGCOD4)

 

  • field DISCRGSCR4

 

  • Discount/Charge 5 (field DISCRGCOD5)

 

  • field DISCRGSCR5

 

  • Discount/Charge 6 (field DISCRGCOD6)

 

  • field DISCRGSCR6

 

  • Discount/Charge 7 (field DISCRGCOD7)

 

  • field DISCRGSCR7

 

  • Discount/Charge 8 (field DISCRGCOD8)

 

  • field DISCRGSCR8

 

  • Discount/Charge 9 (field DISCRGCOD9)

 

  • field DISCRGSCR9

 

Close

 

Tab Line 3

Fields

The following fields are present on this tab :

Entry

  • Lot (field LOTCOD)

If the product is managed by lot then, on manual creation of the delivery line or when the stock to be issued has not been determined, it possible to enter a lot existing in the 'shipment site'.
A selection window accessed by right click on the field is used to select a lot number. 
It is also possible to enter a lot number which does not exist in stocks.
A message then informs the user that no lot exists. This alternative is provided so it is possible to record a lot number that has never been entered even though the goods are physically available. This method can only be applied when negative stock is authorized for the product and when the delivery transaction is set up with no stock determination. In the case of a delivery transaction with stock determination, this lot is only considered if the product if in complete shortage (the detailed allocation algorithm will attempt to allocate stock first).

  • field LOTSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Sublot (field SLOCOD)

Indicates the sub-lot to be issued.

It is not necessary to enter it in the following cases:

  • the issue is a multi-lot one
  • all characteristics of the stock to be issued are not entered (lot, sub-lot, serial no., location)

If the product is managed with serial numbers, only this number is necessary to determine the stock to issue.
If this is not the case, the lot, sub-lot and location (depending on the management method for the product) are necessary.
There is no selection window for this field. The selection window is available on the lot field and makes it possible to choose the requested lot and sub-lot. When the lot is selected, the sub-lot it instantly initialized. Otherwise, it is also possible to enter a sub-lot number which does not exist. An information message will report it. Same remarks as for the lot number in this context.

  • field SLOSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Status (field AQRCOD)

Irrespective of the product used, there is the possibility, during manual creation of the delivery line or when the stock to be issued has not been determined, to enter a status for the stock to be issued.
A selection window accessed by right click on the field is used to select any status that has been defined.

  • field AQRSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Location (field LOCCOD)

If the product is managed by location at the 'shipment site' then, on manual creation of the delivery line or when the stock to be issued has not been determined, it possible to enter a location existing in the 'shipment site'. A selection window accessed by right click on the field is used to select a location.

  • field LOCSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Starting serial number (field SERCOD)

This field is used to enter the first serial number (Start) to issue. The last serial number (End) will be automatically calculated.

  • It is not necessary to enter the start serial number when the serial numbers to issue are not in a row.
  • If the product is managed with serial numbers, only this number is necessary to determine the stock to issue.
  • If this is not the case, the lot, sub-lot and location (depending on the management method for the product) are necessary.

  • field SERSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Ending serial number (field SERECOD)

This is the end serial number automatically calculated using the start serial number.
This field is never enterable.

  • field SERESCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Identifier 1 (field IDECOD01)

 

  • field IDESCR01

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Identifier 2 (field IDECOD02)

 

  • field IDESCR02

 

  • Movement description (field MVTDESCOD)

Enter a free description that will be registered in all the stock transactions associated with the delivery line.
This description is also accessible from the stock issue detail window. If it has been modified by this function, it will be automatically recovered and registered on the shipment line in this field.

  • field MVTDESSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Warehouse (field WRHCOD1)

The presence or absence of this option is subject to the activity code WRH.
It is used to define, for this entry transaction, whether the warehouse on the document line must be:

  • Hidden: The field is not displayed. This will be single-warehouse managed.
  • Displayed: The field is loaded with the warehouse entered in the header, and cannot be modified. This will be single-warehouse managed.
  • Entered: The field is displayed and it can be modified. This setup allows a multi-warehouse management.
    This value cannot be selected if single-warehouse management has been activated in the transaction header.
  • field WRHSCR1

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.
  • Container (field LPNCOD)

This field is subject to the LPN - License plate no. management activity code.

For this entry transaction, specify if the container and license plate number on the document line must be:

  • Hidden
  • Displayed
    The values are displayed and cannot be modified.
  • Entered
    The license plate number can be entered or modified if determined automatically.
  • field LPNSCR

Specify, for this entry transaction, if the field must be present in:

  • Form and table mode
  • Form mode
  • Table mode.

Close

 

Tab Analytical

Presentation

In this function, the Distribution line field is hidden.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Header dimensions (field HEACCECOD)

Parameter used to define if, for this transaction, the analytical dimensions fields of the document header must be:

  • Hidden: The options/analytical dimensions menu of the main window will be hidden.
  • Displayed: It will be possible to access the options/analytical dimensions menu of the main window, the fields will appear but it will not be possible to access them.
  • Entered: It will be possible to access the options/analytical dimensions menu of the main window, the fields will appear and it will be possible to access them.
  • Distribution line (field DSPCOD)

This setup is used to define, for this entry transaction, if the analytical distribution key at line and invoicing element level must be:

  • Hidden: the field does not appear on the entry screen but the default value is attributed to it,
  • Displayed: The default value is assigned to the field and displayed but it cannot be modified.
  • Entered: The default value is assigned to the field and displayed. It can be modified.
  • field DSPSCR

Parameter used to define, for this entry transaction, if the field must be present in:

  • Record +Table modes,
  • Form mode,
  • Table mode.
  • Stock movement dimensions (field STOCCECOD)

Specify for this transaction if the analytical dimension fields related to stock movements must be:

  • Hidden
  • Displayed: The menu Analytical sections, accessible from the menu in the movement detail window, will be available. The fields are displayed but cannot be accessed.
  • Entered: The menu Analytical sections, accessible from the menu in the movement detail window, will be available. The fields are displayed and can be accessed.
This screen is common to the entry transactions for the orders and open orders. In the open orders entry transaction, this field is not available.

Entry

  • field CCESCR

 

Grid Dimension line

You can enter an analytical dimension type code on each table line.
You can access a function from the Actionsicon to pre-load all the dimension types defined on the sites of a given group of sites.

  • Method (field CCECOD)

Parameter used to define, for this entry transaction, if the analytical dimension must be:

  • Hidden: The field is not displayed on the entry screen. However, it is possible to initialize this field with a default section code.
  • Displayed: The default value is allocated to the field and displayed but the value cannot be modified.
  • Entered: The default value is assigned to the field and displayed. It can be modified, and, in that case, the entered value is checked in the analytical dimension table.
    The default value assigned to the analytical dimension is dependent on the dimension setup performed.

Close

 

Action icon

Pre-loading the dimension types

Click the Preload dimensions action to load the default dimensions defined for a selected group of sites or companies.

 

Close

 

Specific Buttons

It is used to validate the screen by generating the corresponding code. This validation is automatic on creation or modification; the button is thus only really useful when deleting a screen file on the application server, or in the case of a copy from one folder to another (the validation is not in this case carried out automatically in the target folder).

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

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

  • All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).

  • To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

Close

This button is used to copy the record definition from or to another folder.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

You do not have access to this code.

This message appears when the access code entered does not exist in your user profile. To solve this problem, choose an access code from the list displayed or (provided you have the authorization) add the requested access code to your user profile.

Tables used

SEEREFERTTO Refer to documentation Implementation