Setup >  Sales >  Entry transactions >  Open orders  

Display all Hide all

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

A standard open orders 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 open orders. Each transaction, identified by a code and a text description, appears in a selection window when calling the Open orders function.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

The transaction header enables the user to create new transaction codes or to search existing transactions to modify or delete.

Close

 

Fields

The following fields are present on this tab :

Open orders

  • 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 in 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 in 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)

This flag is used to activate or deactivate a transaction.
The inactive transactions are not presented in the transaction selection window.

Access code that is used to restrict access to data by user or group of users.
If this field is assigned, only users with this access code in their profile can use this transaction.
If several transactions are set up for a function, and the user only has access to one of them because of the access codes, the selection window is no longer suggested: the access is by direct entry. 

The company or site group entered here is used to filter the entries.
These entries can be accessed during the transaction.

Close

 

Tab Parameter Definitions

Presentation

In this tab, define several elements such as the automatic printing of the sales open orders and the display of some specific fields.

Close

 

Fields

The following fields are present on this tab :

Order acknowledgement

Code of the standard document printed during an automatic printing at the 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.

Display

  • Intersite (field BETFCYCOD)

Help common to all transactions related to sales documents.

Use this parameter to define if the inter-site nature of the document must be displayed or not.
Inter-site documents are used for exchanges between different sites. These sites can belong to different legal companies, but only if the documents are also defined as ‘inter-company’.
Reminders:

  • A document is considered as an inter-site document when 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.
  • An inter-company document is always an inter-site document as well.
  • An inter-site order is an order that is delivered but not invoiced.

  • 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.
  • Delivery type (field SDHTYPCOD)

This check box is used to specify whether, for this entry transaction, the delivery type must be displayed or not.

  • Document status (field STACOD)

Various statuses of the document linked to the order (acknowledgement printed and Status of balance, allocation, delivery, order, invoice and credit).

  • Stock unit (field STUCOD)

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.

  • Margin (field PFMCOD)

Parameter used to define, for this entry transaction, if the margin must be displayed or not.

In both cases, a value is assigned to the field. This value is calculated from the product net price and cost price.

  • field PFMSCR

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

  • Form + Table mode,
  • Form mode,
  • Table mode.

Close

 

Tab Header

Presentation

In this tab, specify the management mode of particular fields in the entry screen of the open order header.

Close

 

Fields

The following fields are present on this tab :

Entry

  • 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.

  • 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.

  • 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.
  • Project (field PJTCOD)

 

  • 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.

  • Currency type (field CHGCOD)

This field is controlled by local menu and can take the following values: current exchange rate/monthly exchange rate/average exchange rate.

The exchange rate type proposed by default is the exchange rate type associated with the supplier entered in the order header. As long as the order has not been created, it can be modified except when a line with a cost structure has already been entered.

An exchange rate type is used to determine the currency exchange rate in the exchange rate table taking into account the order date. This information is used to determine the prices and discounts on the basis of the price lists authorizing the conversion between currencies.

If order lines have been entered, or during the copy of an order, a question will be posed to the user about whether to re-calculate the prices and discounts depending on the price lists. If the user decides not to apply the price lists, the prices and discounts will be simply converted into the new currency at the rate determined by the exchange rate type and the order date.

If the currency is equal to the company currency, the exchange rate type will not be accessible since it will have no influence in this context.

  • 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.

  • Allocation type (field ALLTYPCOD)

The allocation type (global/detailed) is initialized to the value of general parameter ALLTYP - Allocation type (VEN chapter, SAL group). It can be modified depending on the entry transaction used. The allocation type specified in this tab serves as the default value for the order lines created later.

This information can no longer be modified once the order has allocations.

The global allocation reserves the goods without distinction by applying a global total, whilst the detailed allocation reserves specific stock objects (lot, serial number...). An order can be allocated from the order (entry of the quantity to be allocated or using the Actions icon of the line to select stock lines in detailed allocation or using the allocation button) or from the Automatic allocation or Allocation by product functions.

Close

 

Tab Line 1

Presentation

In this tab, define the management method of fields in their return entry screen on each open order line.

Close

 

Fields

The following fields are present on this tab :

Entry

  • Major version (field ECCCOD)

Use this parameter to define, for this entry transaction, whether the Major version number is displayed. 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 the product is version managed. It cannot be modified.
  • Entered
    The version number can be entered. The version number is loaded automatically if the product is version managed but can be modified.
  • Minor version (field ECCCODMIN)

Use this parameter to define, for this entry transaction, whether the Minor version number is displayed. 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 the product is version managed. It cannot be modified.
  • Entered
    The version number can be entered. The version number is loaded automatically when the product is version managed but it can be modified.
    The Minor version parameter can only have the 'Entered' value when the Major version also has the 'Entered' value.
  • Location reference (field USEPLCCOD)

Use this field to specify the consumption place for the carrier or to define an address complement.

Examples: Dock xx or Hall yy.

The place of consumption is written on the order document.

Inter-company specificities: for inter-company or inter-site orders, the consumption location is transferred to the generated sales order line.

  • Project (field PJTCODD)

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 control on the entered value is based on the CTLOPPCOD - Mandatory project code parameter (TC chapter, MIS group).

SEEINFO Even if this setup makes this project code available for entry, entering the field is prohibited when a single-project management of documents is used (parameter PJTSNGDOC - One project per document set to Yes): in this case, the project code of the line automatically takes the value of the header code.

  • Price list code (field PLICOD)

Parameter used to define, for this entry transaction, if the price list code must be:

  • Hidden:
    The field is not displayed in the entry screen and thus remains empty.
  • displayed:
    The field is displayed empty and cannot be modified.
  • entered:
    The field is displayed empty and can be modified. The entered value is controlled in the price list structure table. If the Price list code parameter takes on the Hidden or Dsiplayed value, it is mandatory to enter the price directly into the contract.
    If the Price list code parameter takes on the Entered value, it is forbidden to enter the price directly into the contract.
  • Sales unit (field SAUCOD)

The sales unit is initialized by the sales unit defined in the Product-customer record, if it exists, otherwise it will be initialized by the sales unit of the product. It is possible to enter another unit using a selection window. The units proposed 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 the user has the appropriate authorizations, it is possible to access the units table.

Once the line is entered, it is no longer possible to modify the sales unit. It is necessary to delete the line and to recreate it to modify the unit.

  • 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.

  • 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.

  • Tax rule (field VACBPRCODD)

 

  • Expected quantity (field EXTQTYCOD)

This field indicates the planned quantity, expressed in sales unit, for this contract product.
For information purposes, this quantity is used upon price list search.

  • Expected amount (field EXTAMTCOD)

Amount planned for this product of the contract. It is expressed in the contract currency.
This amount, which is for information purposes only, can be modified at any time.


  • Actual amount (field CPLAMTCOD)

Amount achieved for this product of the contract. It is expressed in the contract currency.
This amount is updated upon delivery and can be modified to allow for adjustments.



  • 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

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

  • Form + Table mode,
  • Form mode,
  • Table mode.
  • 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.

Close

 

Tab Line 2

Presentation

In this tab, define the management mode for the 'Discounts/Charges' fields in the entry screen at the level of each contract 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 order header level.

Close

 

Fields

The following fields are present on this tab :

Entry

  • Discount/Charge 1 (field DISCRGCOD1)

Discounts and charges columns are displayed.
They depend on the setup of the Price list structure code associated with the supplier in the supplier record (see documentation Price list structure).

They can be initialized by the use of the price lists (see the Price list setups and Price list entry documentations). Access to these columns can depend on the setups of the reasons associated with the price lists as well as the value of the reason given to the UPDPRISAL setup for Sales and to the UPDPRIPUR setup for Purchase.

These discounts or charges 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.

The contextual button is used to:

  • view the reasons associated with the price as well as the different discounts and charges fields,
  • modify, if necessary, the reasons allocated to each column.
  • field DISCRGSCR1

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

  • Form + 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 Analytical

Presentation

In this function, the following fields are not available:

  • Stock movement section
  • Line distribution

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 the value cannot be modified.
  • Entry: 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,
  • Record 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 Analytical dimensions menu, 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

  • Input (field CCESCR)

 

Grid Dimension line

You can enter an analytical dimension type code on each table line.
Use the function available from the Actions icon to preload all the dimension types defined for 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 in the entry screen. However, it is possible to initialize this field with a default section code.
  • Displayed: The default value is assigned to the field and displayed but the value is non-modifiable.
  • 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 based 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 the 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