Training: January 2012
Training: January 2012
Training: January 2012
TRAINING
OPE201 – Sales fundamentals,
Students’ book
TRAINING OPE201 – Sales fundamentals, Students’ book– 2/54
COURSE MAP
CB 101
CB 101 Sage ERP X3 Fundamentals
Introduction
Introduction
(1
(1 day)
day)
CB 102
Functional Overview
(3 days)
FIN 201
Finance
(4 days)
To take this training, you must have already completed the following training courses:
SAGE ERP X3 Introduction (CB101 – 1 day)
SAGE ERP X3 Introduction (CB102 – 3 days)
SAGE ERP X3 Stocks (OPE202 – 3 days)
Contents
COURSE OBJECTIVES...............................................................................................5
REQUIREMENTS........................................................................................................ 6
3. QUOTE MANAGEMENT..............................................................................10
3.1. Process for managing a prospect.................................................................11
3.1.1. Identify prospect.........................................................................................................11
3.1.2. Managing prospects...................................................................................................12
3.2. Process for creating a quote........................................................................14
3.3. Process for managing a sales price.............................................................18
4. ORDER MANAGEMENT..............................................................................19
4.1. Strategic “Product” attributes for sales.........................................................20
4.1.1. Mandatory attribute values for sales..........................................................................20
4.1.2. Optional sales attributes.............................................................................................21
4.1.3. Optional attributes if product is managed in stock......................................................21
4.1.4. Attributes linked to checks..........................................................................................22
4.2. Strategic “Customer” attributes for the order................................................23
4.2.1. Attributes linked to addresses....................................................................................23
4.2.2. Attributes linked to the delivery address.....................................................................23
4.2.3. Structural attributes....................................................................................................24
4.2.4. Behavioral attributes...................................................................................................24
4.2.5. Attributes linked with checks and rights.....................................................................24
4.3. Order creation process.................................................................................25
4.3.1. Order management....................................................................................................25
4.3.2. Entry transaction.........................................................................................................25
4.3.3. Order types.................................................................................................................26
4.3.4. Reminder of other important parameters...................................................................27
4.3.5. Manual order creation................................................................................................27
4.3.6. Other possible actions................................................................................................30
5. DELIVERY MANAGEMENT.........................................................................32
5.1. Allocation...................................................................................................... 32
5.1.1. Allocation type............................................................................................................32
5.1.2. Allocation functions.....................................................................................................33
5.1.3. Allocation parameters.................................................................................................34
5.2. Delivery creation process.............................................................................36
5.2.1. Delivery origins...........................................................................................................37
5.2.2. Delivery types.............................................................................................................37
5.2.3. Functions used for creating delivery...........................................................................37
5.2.4. Delivery transaction....................................................................................................38
5.2.5. Delivery steps.............................................................................................................39
6. INVOICING MANAGEMENT........................................................................44
6.1. Invoice creation process..............................................................................44
6.1.1. Invoice types & categories.........................................................................................44
6.1.2. Invoice origins.............................................................................................................45
6.1.3. Functions used for creating invoices..........................................................................46
6.1.4. Invoice transaction......................................................................................................46
6.1.5. Invoice status..............................................................................................................46
6.1.6. Other parameters/reminders......................................................................................47
6.1.7. Invoice/credit memos..................................................................................................48
7. REVERSE LOGISTIC..................................................................................51
7.1. Return management....................................................................................51
7.1.1. Return types...............................................................................................................51
7.1.2. Possibilities & Impacts................................................................................................52
7.1.3. Return parameters......................................................................................................52
7.1.4. Return transaction......................................................................................................52
7.1.5. Return creation...........................................................................................................53
7.2. Credit memos management.........................................................................54
8. INQUIRIES................................................................................................... 55
8.1. Utilities......................................................................................................... 55
8.2. Inquiries....................................................................................................... 55
COURSE OBJECTIVES
The first objective is to get to know the sales concepts managed in Sage ERP X3 and to run various
flows from creating a prospect to printing customer invoices
You will note the high integration of sales in SAGE ERP X3 as well as its interactions with the
“purchasing”, “accounting”, and “stock” modules.
REQUIREMENTS
In this section we are going to look at how to enter a requirement into Sage ERP X3 and to discover the
basic data which flows into accounting in order to process these requirements
Overview
All sales transactions are carried out for the sites. These sites must all be “sales” sites so that a flow is
possible.
The Sage ERP X3 sales process includes quotes, orders, picking tickets, delivery notes, returns,
invoices and credit memos.
The Sage ERP X3 sales concerns customers or prospects (quotes).
Each sales document has at least one product which is (or isn’t) managed in stock.
Complete sales flow
It is possible to initiate a sales flow from a quote, an order, a delivery note or an invoice.
In SAGE ERP X3 the sub-division into companies corresponds to the structure of legal companies
managed in the folder.
Each company is sub-divided into various sites. A site corresponds to a geographic and/or management
entity. Each managing event in SAGE ERP X3 Standard Edition refers to a site. Each site has a role:
finance, sales, purchasing, production and/or warehouse.
Prerequisites are necessary to be able to initiate a sales flow in Sage ERP X3:
Sales sites: Sites must be “sales” sites so that a document associated with this site can be created.
Warehouse site: Sites where goods are stored must be labeled as “warehouse” sites so that stock
movement is possible on these sites.
Financial site: The site present on the sales invoices must be labeled as a “financial” site as these
invoices will generate entries in the Sage ERP X3 accounting.
A site may be a “warehouse”, “sales” and “financial” site at the same time.
A site which is not labeled as a “financial” site must be associated with a financial site of the same
company.
Exercise
3. QUOTE MANAGEMENT
Process for creating a quote
Process for creating a quote
Sales > Quotes > Quotes
Misc.
Site Quantity lines
selection Misc. data & unit data
Pre-requisite
16
Quote management is used to manage the offers or price proposals that we wish to send to customers or
prospects. To this end, this option is used to create, modify, delete, copy, view and print quotes. It is
possible at any time to value a quote and generate a pro forma invoice.
In this chapter we are going to learn how to create a prospect then we will create a quote for this new
prospect.
This function is used to search for a BP or a contact present in the Sage ERP X3 database using criteria
such as:
Company name
Post code
Town
Surname or first name of contact
Contact telephone number
This function is also available by right clicking from the “Customer” field within a quote via the “ Search”
function.
BPs
Prospect
The prospect function is used to create a new prospect or update data related to the prospect.
A prospect is a BP which can only be used in the CRM module’s sales action functions and in the quote.
The prospect is identified by a code with a maximum of 15 characters. This code is entered by the user
who created the prospect. Four tabs are then used to define the information related to:
Its identity ( Identity tab): Language, Country.
its addresses ( Address tab): It is possible to define several addresses, one of it will be defined as
the “default address”
Its contacts ( Contact tab): it is possible to create new contacts or associate this prospect with
contacts common with other BPs.
Its characteristics ( Control tab): The statistical families and the commission category etc. are
entered here. This tab is also used to enter observation lines which will be displayed when any future
quotes are entered.
Creating a prospect leads to the creation of an associated BP. This operation is transparent for the user.
All data in the Identity , Address + Contact , tabs is then transferred into the generated BP.
The BP has the same code as the prospect.
Once the prospect has been created, the following data is specific to the prospect and is not transferred
to the BP:
Currency
Address/default
Contact/by default
The prospect can also be created by the business partner screen using the button “Prospect”, where all
the common data is also pre-loaded
Associated parameters
Activity code PPT set at YES is used to activate prospect management in Sage ERPX3
3.2.Process
Processfor
for creating
creating a quote
a quote Sales > Quotes > Quotes
Pre-requisite
The Quote function is used to create, modify, print and copy sales offers intended for a customer or a
prospect. It is possible at any time to value a quote and to generate a pro forma invoice.
The function called “Default Office Document” is used to associate a Microsoft Office® document with
a quote which can then be edited in Word® or Excel® with preset page formatting (Advanced training).
The quotes created using this function can be transformed into orders. This transformation is made
under certain conditions using the order management option.
The Sage ERP X3 function is broken down into a header information section and 3 tabs to manage the
general conditions, the invoicing information and the various lines.
“Controls” tab
Sales site: This field indicates the sales site on which the quote is passed. This site may be filled by
default according to the Function profile parameters associated with the user.
Quote no: This field corresponds to the quote code number. According to the parameters of the
associated counter, this field may or may not be entered (Counter parameters).
Parameters > General parameters > Sequence number definition > Structures
Parameters > General parameters > Sequence number definition > Assignment
Customer: This field is used to enter a customer or prospect code. Search functions are available by
right click in this field.
Delivery address code: This field is initialized with the customer or prospect’s default delivery
address. It is possible to choose another address from those defined in the customer/prospect. Finally
it is then possible to modify the content of this address for the quote in progress. The reference
address defined in the customer/prospect record remains unchanged. According to the value of the
parameter below, the address code will/will not be re-entered on the quote line.
LINBPD parameter (VEN Module - DIV Group):
Customer delivered on the line - Values: Yes or No
Shipping site: This field is initialized by the shipping site defined in the delivered customer’s address.
This field is mandatory which means, if there is no initialization it must be entered manually. It
specifies the warehouse the goods will be shipped to. This site will be re-entered on the quote lines.
The warehouse must belong to the same company as the sales site.
Delivery lead-time: This field is initialized by the shipping site defined on the delivered customer’s
address. This field indicates the number of days we will allow to deliver the goods starting from the
order date. This lead time will be re-entered in the quote lines.
Representative: This field is initialized by the customer/prospect. It may be modified when required
for the quote. According to the value of the parameter below, the representative will/will not be reused
in the quote line.
LINREP parameter (VEN Module - DIV Group): Representative on line - Values: Yes or No
Tax rule: This field is initialized by the customer. It is mandatory. This field paired with the product’s
fiscal level will make it possible to define the quote line’s fiscal rate. The rule may be modified when
required for the quote.
WARNING:
THIS RULE MUST BE ASSOCIATED WITH THE SAME LEGISLATION AS THE SALES SITE
Currency: This field is initialized by the customer/prospect. It indicates the currency in which the quote
amounts will be entered and displayed. According to the rights defined via the parameter below, the
operator will be able to modify this currency for the quote as and when required.
UPDCUR parameter (VEN Module - AUZ Group): Modify currency - Values: Yes or No
Price type: This field is initialized according to the value of the two following sales parameters
NOTATI parameter (VEN Module - PRI Group): Management of prices inc. tax and excl. tax
PRITYP parameter (VEN Module - PRI Group): Inc.tax or excl.tax
It indicates whether the prices entered via the “Gross price” field present on the sales document lines
(quote, order, Delivery note, and invoice) includes or does not include tax.
Validity date: This field entered by the operator indicates a validity limit date for the quote. Beyond
this date the quote cannot be transformed into an order.
Quote status: This field is inaccessible. It indicates whether the quote has been fully ordered, partially
ordered or not ordered at all. It is updated dynamically.
“Invoicing” tab
Payment condition: This field is initialized by the customer. It indicates the payment conditions
(check, bank transfer) as well as the due dates. This field is mandatory.
Analytical sections: These sections are initialized according to rules defined through the default
sections.
Dynamic information: No of last order with its date, and pro forma invoice no.
Invoicing element: This date is retrieved from the customer. It is used to define the expenses and
discounts expressed as an amount or as a percentage which is applied on all the document’s lines.
Advanced training dedicated to this function is provided (Advanced training)
“Lines” tab
Product: This field indicates the code of the sold product. This code is defined by 20 alphanumeric
characters. The operator may, by right click in this field:
Choose the product from among those referenced to the customer.
The last products ordered by the customer
View the sales prices of a product
Quantity: This field is entered by the operator. It is mandatory and cannot be nil. The quantity entered
is relative to the unit.
Gross price & discounts & charges: After entering the quantity, Sage ERP X3 will automatically
search the sales price. The result of this search enters the gross price and various expenses and
discounts, which make up a net unit price. According to the user rights defined by the parameter
below, the operator has/has not the right to modify the various amounts.
SPRIMOD parameter (VEN Module - AUZ Group): Modification of prices and discounts Values: Yes or No
If the operator has the right to modify an amount, it is possible to make the “reason” for this modification
mandatory using the parameters below:
SALREN parameter (VEN Module - PRI Group): Mandatory price reasons – Values: Yes or No
DACMANSAL parameter (VEN Module - PRI Group): Manual reason entry by default – Values: list of reasons
Company
Price reason Validity date
(GESSPR) Price type
Criteria
Parameters > Sales > Price > Reasons Priority
Parameters > Sales > Price > Sales > Price > Price entry Sales > Price > Search
Parameters
Price structure
(GESPRSS)
This function is used to define the price rules which will be applied when creating or updating a sales
document (quote, order, delivery note, invoice). The sales prices are used to enter the gross price and the
charges/discounts defined in the sales documents line.
4. ORDER MANAGEMENT
Description of the possible flows
Order management is used to enter the need expressed by a customer in terms of the product,
quantity, and delivery it is looking for. With this function it is also possible to modify, copy, close, delete
and print orders.
Through this function, it is possible to manage goods reservation via the allocation mechanism.
It is also possible at any time to value an order and generate a pro forma invoice.
Finally, the user is able to create an order from a quote.
In this chapter we are going to look at the conditions which the customer and the product must fill in
order to be integrated into an order.
We are also going to look at the elements which may block a flow and those which allow a flow to
continue.
Some product attributes must be filled in with a correct value so that the product can be used in a sales
document:
Category: The category is a notion used to define management rules common to a product group.
Therefore the category to which the product is associated must authorize the sales flow.
Status: The status of the product is a flag placed manually in the product record. There are 5 statuses
which are blocking or non-blocking:
Active...................No block, the product is available in all the processes.
In development.....No block, but it will not be displayed in the selections function.
Not stocked..........No block, but it will not be displayed in the selections function
Not renewed.........No block, but it will not be displayed in the selections function
Obsolete...............No block, but it will not be displayed in the selections function
Not usable............Displays a blocking message in line entry.
Life start: If filled in, this attribute prohibits the product from being sold before this date.
Sales unit (SAL): This unit is mandatory if it is initialized by stock unit (STK). The unit present in the
sales document lines is initialized by this field.
Tax level: This field is mandatory. Associated with the customer’s tax rule, these fields will define the
VAT rate. (Advanced training)
Accounting code: This field is mandatory. It is used to define the account used in the accounting
module. (Advanced training)
Substitution product: This field associated with a substitution date is used to automatically substitute
an old product code with the new product code. This mechanism is practical during the transitory
period when the product code is not yet known by all the operators.
Replacement product: With this field the operator is able to manually replace the current product
being entered with this replacement product (if there is a stock shortage for example). This
replacement is performed by right click in the quantity field of the document’s line.
Weight & volume: These fields are used to automatically calculate a weight and a volume in the
delivery notes. Associated with transport expenses calculation parameters, SAGE ERP X3 will
calculate the carriage amounts in the delivery note’s footer (Advanced training).
Only a site with the warehouse option set at YES can be a storage site
Once the product-site record has been created, it is then possible to activate stock management
elements. The principle for managing these elements will be described in the stock training. Nevertheless,
here are the impacts when setting up these elements in the sales flow:
Lot management:
It will be possible to allocate an order line on a single lot number
In order picking the system will suggest the lots to be issued
Activate upstream or downstream traceability
Expiration management
It is possible to prohibit stock from being issued if a product has expired
Location management
It will be possible to define picking locations for order picking
It will be possible to loan goods to customers
In order picking, the system will suggest to the warehouseman where to pick the goods to be issued
In customer return the warehouseman will be able to specify the return location
Min quantity - max quantity: With these two attributes it is possible to display or not to display a
blocking message if the quantity (in stock units) entered on the line is below or above these values.
SDACLOK parameter (VEN Module - AUZ Group): Non-blocking check of price, margin, etc. – Values: Yes/No
Exercise
Price inc/excl tax: This attribute defines whether the entered prices in the order line include or
exclude tax. (See currency section for the parameters associated).
Tax rule: This field is mandatory. Associated with the product’s tax level, these fields will define the
VAT rate (Advanced training)
Accounting code: This field is mandatory. It is used to define the account in the accounting module.
(Advanced training)
Payment condition: This field is mandatory. It is used to define the payment method(s) and the
associated due dates. (Advanced training)
Credit control check: This flag indicates whether the customer credit control is being tracked. The
possible values are as follows:
Free: In this case the credit control is never exceeded; however the customer credit control amount
remains up to date.
Check: In this case credit control is exceeded if the authorized credit control amount is exceeded.
Blocked: The customer is blocked. It is impossible to create a new order for this customer.
Quote
(GESSQH)
Inter-site PO
(GESPOH)
Orders Allocation
(GESSOH)
Import if stock issue is applicable
(GIMPOBJ)
Direct
(GESSOH)
The order transaction is used to customize order screens. Each transaction includes:
The parameters and the links such as company group, the access code, the document associated, the
net price display, etc.
The customizing of the header, which is used to manage or not to manage certain information related
to the order in general.
Customizing the lines, which determines the choice to enter, display or hide a field.
It is possible to configure several different transactions for the orders. The active transactions appear in a
selection window when calling the function.
Order categories:
This indication is part of the fields to be ticked when setting the entry transaction. Four categories are
possible: Normal, loan orders, orders with direct invoicing and open orders (contracts).
The normal order is to be delivered and invoiced. This type concerns orders of products managed in
stock for which a logistical step (order picking, delivery) is necessary. A normal order may be applied
on an open quote and validates the above.
Note, for a standard invoice, products that are not managed in stock also go through a delivery step.
The loan order will be delivered but it is not intended for invoicing until a specific non-return lead-time
defined in the order. If this lead-time has been exceeded, the delivered line becomes inviolable. The
loan delivery generates two types of movements. One is the issue of original stock and the other is
stock entry into a BP location, declared at delivered customer level.
The order with direct invoicing, the direct invoicing orders are those to be invoiced without going via
a delivery step. This type concerns orders for products not managed in stock, or orders for products
managed in stock for which a logistical step is not necessary.
The open order is created by the contract function, which will then be followed by delivery requests,
delivery and invoicing.
Order type (parameters/sales): An order type must be associated with an order category; this makes it
possible to classify and if necessary diversify the counters by type.
Order origins
A sales order may have several origins:
Quote: via a manual creation, by using the information entered in a quote by the picking; it remains
modifiable and confirms the customer requirement and defines the delivery conditions.
Direct: via manual creation, an order can be entered directly.
Inter-site: an inter-site purchase order automatically generates the sales order on the inter-site
supplier side.
Import: a sales order may be imported
The delivery requests from a contract, also lead to the creation of recordings in the order tables.
Parameters > General parameters > Sequence number definition > Allocation
General parameters:
SPRIMOD parameter (VEN Module - AUZ Group)...........Modification of prices / discounts (yes/ no)
UPDCUR parameter (VEN Module - AUZ Group)............Modification of currency (yes/no)
LINBPD parameter (VEN Module - MIS Group)...............Customer delivered on the line (yes/no)
DIRORDCTL parameter (VEN Module - ORD Group).......Purchase order if WIP is exceeded (yes/no)
LOKORD parameter (VEN Module - ORD Group)...........order blocked if pre-payment has not been
received (yes/no)
PRITYP parameter (VEN Module - PRI Group)...............price type (Excl / incl tax)
GRPPRI parameter (VEN Module - PRI Group)...............Management of grouped price (yes/no)
The list is not exhaustive. It only contains fields that are mandatory and important in most situations.
Control
Step 3:In the first tab, , entry of order management elements
The elements in this tab are reused by default from the quote or the customer record.
Check/Modify this data, especially the delivery address
It is possible to associate a project corresponding to the customer to the order if it has not already been
recorded from the quote.
In the case of a loan order, entering the return date is mandatory.
In the case of an inter-site order, the customer is essential so that the inter-site flag and possibly the
inter-company flag are automatically ticked.
Delivery
Step 4:In the second tab , entry of delivery management elements
The elements in this tab are reused by default from the quote or the customer.
Modify or enter the shipping site if it has not already been entered:
From the quote
From the ship-to customer
From the default site in the “Stock” module (User function profile)
Enter the requested delivery date that determines the shipping date by deducting the delivery lead-time
and taking it into account. The default delivery lead-time is to be entered in the quote or the customer
record.
The date and site entered in this tab will be proposed by default on the lines when entering them and
may be modified by the user.
Invoicin
Step 5:In the third tab , entry of order invoicing elements
The elements in this tab are reused by default from the quote or the customer record.
Enter the invoicing elements
Check the payment conditions (modification possible)
lines
Step 6:In the fourth tab , direct entry of the order lines
Enter the code of the ordered product: each order line must be filled with an existing product from the
database. If a customer reference base exists, it is possible to select the product related to the customer
by right click in the field. It is possible to view the product record, its price list and its situation in stock
before you start entering
The description comes from the product record, it is possible to modify it, mainly for products with a
generic category
Enter the ordered quantity
Enter the price insofar as it is not managed by any price list. The price modification right is configurable
Modify if necessary the requested delivery date
The absence of values and/or the blocking entry on some fields such as the tax code or the analytical
dimension, is due to the configuration
Sales journal traceability – It opens a window where all the events linked to this order line are
displayed.
Assignment(s) – It allows to inquire the project stock for the product line as well as to verify the pending
assignments (orders)
The creation of a firm sales order results in a firm requirement that impacts the available stock and
the requirement calculation for the products concerned. However, no stock line is moved and the
stock is only reserved after an assignment step.
A planned or suggested sales order (indication on the order line) can be used as forecast; it can be
taken into account in the requirement calculations (see calculation parameters)
Delivery methods
Depending on the product parameters, a sales order line can have one of the following four delivery
methods:
Stock: The order line will be loaded with the available stock.
Direct purchase order: A purchase order will be generated for the product and the quantity of the
sales order line for the supplier defined in the product record. The purchase order is used when the
supplier directly delivers the customer. It will be possible to deliver the order once the purchase order
has been generated. The delivery will not result in a stock movement.
Receipt purchase order: A purchase order will be generated for the product and the quantity of the
sales order line for the supplier defined in the product record. The receipt purchase order is used when
the delivery is preceded by an order of a receipt. It will be possible to deliver the order once the receipt
has been completed. The received quantity will be assigned on the order.
Work order: A work order will be generated for the product and the quantity of the sales order line.
The work order method is used when the ordered product is manufactured before delivery. It will be
possible to deliver the order once the work order is generated and the production declaration is
completed. The declared quantity will be assigned on the order.
Purchase orders may be launched order by order via a button in the menu bar Option/Purchase order or
be launched en masse via the purchase order function in the purchasing module.
Work orders may be launched order by order via a button in the menu bar Option/Work order or be
launched in mass via the purchase order function in the production module.
Balance: Close is used to close all order lines. The remaining lines of a closed order
cannot be modified, assigned or invoiced. A closure by order line is possible by right click in
the concerned line.
Status
From the menu bar: The order progress tracking can be performed from the
tab. This tab shows the status of the order, assignment, delivery, invoice and customer credit. A
detailed tracking by order line is available via the menu bar Option/Status.
Exercise
5. DELIVERY MANAGEMENT
Delivery management is used to trace the full or partial completion of the customer order:
either by shipping or stock issue of stored products
or as a validation step concerning the non-stored products.
It can also be used for inter-site movements (Advanced training) or the delivery of components to the sub-
contractor (Advanced training).
A delivery would be direct or proceeded by an order.
A direct delivery must be manual. A delivery preceded by an order or delivery request would be created
manually or be processed by automatic delivery.
A delivery always includes one or several existing and active products.
In this training you will learn the steps of a standard delivery and a full procedure preceded by an order
relative to the stored order.
5.1. Allocation
In terms of Sage ERP X3, allocation is synonymous to reservation.
The stock allocation is one step before delivery for stored products.
Allocation takes into account the remainders of unclosed orders in firm status.
Customer reservations
Sales > Allocations > Customer reservations
This function concerns the reservation of a product on a site, for a customer, up to the defined reservation
end date. This reservation is independent from customer orders. In this case, the allocation cannot be
global. However, it has an impact on stock availability. It may be consumed according to the choice of
parameters, by the orders that follow it.
USERERBOC parameter (VEN Module - SAL Group): Customer reservation consumption
Customer order
Sales > Orders > Orders
The default type of order allocation is initialized according to the parameters (see parameters at the end
of the chapter). The corresponding flag may be modified on the header and on the line.
In the customer order header, there are two possibilities for the direct allocation of products:
On the order line by indicating the quantity to be allocated or by right clicking/ manual allocation on the
line created.
By using the Allocation button in the main bar or at the bottom of the screen.
ALLTYP parameter (VEN Module - SAL Group): Allocation type
INIALLORD parameter (VEN Module - SAL Group): Init.quantity to be allocated in order
Automatic allocations
Sales > Allocations > Automatic Allocations
This function is used to automatically reserve, order by order, products managed in stock for which firm
orders have previously been entered. Each order will be allocated according to its own allocation (global
or detailed).
With this function it is also possible to make the selection on customer code and/or order number and/or
delivery priority. It is also used to filter the orders according to the formula in the header and/or on the
order line.
Choosing yes/no on each of the following fields is also possible:
Partial allocation: used to partially allocate in the event of insufficient available stock.
Consumption of customer reservations: see explanations of the function concerned in the same chapter.
Generation of shortages: do you have to generate shortages if there is not enough stock? The shortages
if generated enable priority allocation during a future processing.
Priority for shortage quantities: see generation of shortages.
Consideration of manufacturing/reorder lead-time: This flag is used to take into consideration the reorder
lead time or production lead time, in terms of priority, in allocation processing.
Consideration of picking lead-time: This flag is used to take into consideration the picking lead time or
production lead time, in terms of priority, in allocation processing.
Allocation by product
Sales > Allocations > Allocations by product
This function is used to revise and reserve, by product, the firm and unclosed order lines.
The function starts with a selection which enables filters on delivered customers and/or product codes
and/or order numbers.
It is specially used to take into account the products which have already been allocated (flag to be
entered).
This function processes the remainders of firm orders (whether allocated or not). By right click on the
line, it is possible to de-allocate and re-allocate, manually or automatically, the products that have
already been allocated. It is also used to change the allocation type from global to detail.
Allocation is carried out product by product. If the user does not wish to process the proposed product,
he can move to the next product or go back to the previous one by using the key provided in the main
bar or at the bottom of the screen.
For each product, all the firm order lines are proposed in this screen, displayed in a table, and
corresponding to the selection made and sorted by shipping date.
The processing grants access to stock inquiry as well as to the detailed allocation screen, with the
adaptable picking criteria.
Allocation rules
Parameters > Inventory > Allocn and Issue rules
In this function, several allocation rules may be created, with a 6 character code, for attribution purposes
according to Sage ERP X3 modules and according to product categories.
If there are several lines on the table, it means that we wish to manage the priorities.
For example: Line 1 for location 1 and line 2 for location 2. The processing firstly processes line 1 and
if there is enough stock, it processes line 2 and so on.
The allocation rules are created so that product categories can be allocated (see following chapter)
Product category
Common data > Products > Product Categories
The allocation parameters are specified for Product Category. See the Issue flow tab. We can work on
the detailed allocation rules. In this screen, we can also configure the global allocations.
Global allocation: The “Authorized statuses” flags are used to choose between the statuses
authorized for the global allocation.
For example, ticking A and Q produces an “accepted” and an “under quality control” stock allocation.
The allocation remains valid when changing status.
Detailed allocation: On the parameters screen, there are several fields for assigning allocation rules
according to module and use. Regarding the sales module, the following fields are crucial:
Order: This field contains the orders’ detailed allocation rule.
Shipment: This field contains the detailed allocation rule for the picking and the deliveries. This is
because the system performs detailed allocation automatically, as soon as delivery is created.
Storage rule table: Each table line represents the parameters specific to each movement type. E.g.:
sales deliveries
In this table and for the concerned movements, the configuration of locations 1, 2 and 3 is important when
they are used by the selected allocation rules. The possible values for each of these fields (locations 1, 2,
3) are those used by product-site. The locations filled in for product-site then become the allocation
locations for this product category.
It is possible to fill in a default location for each storage category (picking, shipping, receipt,
storage, etc.) for a product-site.
Manual
Automatic
Automatic
Picking delivery(Advanced training): This function is used to create deliveries automatically and from
the picking which is carried out.
Automatic Manual
Delivery
Order: This function is used to create deliveries using . The delivery will be
created automatically.
Automatic Manual
Delivery
Picking ticket(Advanced training): This function is used to create deliveries using
.The delivery will be created automatically.
The delivery transaction is used to customize delivery screens. Each transaction includes:
The parameters and the links such as company group, the access code, the associated document, the
net price display, the automatic stock movements document, etc.
The customizing of the header, which is used to manage or not to manage certain information related
to the delivery in general.
Customizing the lines, which determines the choice of entry or display or invisibility of each field and
each stock and/or analytical addition, in table and/or record mode.
It is possible to configure several transactions for the deliveries. The active transactions appear in a
selection window when calling the function.
A delivery awaiting validation remains modifiable. In terms of stock, it manages no issue movement.
A detailed allocation will be made by default after this step, it takes into account the detailed order
allocation. Otherwise the product’s allocation rules will be applied. These allocations remain modifiable
while the delivery is invalid.
A validated delivery can no longer be modified. The stock movements are generated after this step. A
delivery can only be invoiced if validated.
SDHENDNBR parameter (VEN Module - SSD Group): Definitive supplier counter. This counter, if configured, gives
rise to a new document numbering system when the delivery is validated.
Product record
Article category (see control and issue flow tabs)
Product-site record
Counter allocation: Possibility of allocating a counter which can be configured via
Parameters > General parameters > Sequence number definition > Assignment
General parameters
SHINBRDAY parameter (VEN Module - SSD Group): Number of days in relation to remaining shipping time for
order picking/delivery requests.
An order may be delivered manually without prior allocation. A detailed default allocation is then
made upon creation of the delivery.
Note: Right clicking on the product field lets you access the selection and/or the usual issues concerning
the product.
Note: Once the line entry is completed, it is possible to access via a right click additional possibilities
linked to each line (picking and/or delivery texts, price explanation, miscellaneous inquiries)
Validati
Step 9: Validation of the delivery journal by clicking on the button
Step 10: once the entered or loaded information has been checked, click on the Validati button as
soon as the physical stock has been issued. The delivery validation in Sage ERP X3 deducts the
stock. Note that once the delivery has been validated, it can neither be modified nor deleted.
Invoice
Note: the delivery validation activates the button used to create by tunnel the sales invoice
corresponding to the delivery.
Exercise
6. INVOICING MANAGEMENT
Sales invoicing management is used to create invoices and/or credit memos for customers.
The sales invoice function is used to generate customer open items and sales accounting journals.
Pro forma: With this category it is possible to “simulate” an invoice creation but it does not enable
validation in accounting terms.
The invoice type is a free notion to be codified for the following purposes:
To have at least one type per category (mandatory)
To classify the invoices, from the transaction and/or by entering the invoice/credit memo header
To have different counters for the numbering
To use various translation rules in accounting, using automatic documents
SIVTYP parameter (VEN Module - INV Group): This parameter defines the invoice type that will be submitted by
default in the automatic invoice generation process or when creating an invoice automatically (from an order or a
delivery).
Direct credit memo: a credit memo may be created without prior phase. In this case, all the
information is entered in this function
It is also possible to create a direct invoice using the invoicing function for BP accounting customers.
It is possible to configure several transactions for the invoices. The active and accessible transactions
appear in a selection window when calling a function.
TRSFAC parameter (VEN Module - TRS Group): Automatic invoice transaction
Validated: the invoice has been posted and can no longer be modified. For direct invoicing with stock
movement, the stock is not updated before this step.
Open items are generated after validating the invoice. A validated invoice can no longer be modified or
deleted.
SIVCFM Parameter (VEN Module - INV Group): Invoice printing mandatory. If yes, it is not possible to validate
before printing.
This comment does not concern invoices on delivery, as in this case, any allocation and all movements
are generated by delivery.
Parameters > General parameters > Sequence number definition > Assignment
6.1.7.Invoice/credit memos
Invoice/credit memos Sales > Invoices> Invoices
Invoice transaction
Invoice transaction
•Currency •Payment terms •Tax rule
•Dimensions •Discounts •Sales rep
•Accounting •Footer elements •Dimensions
•Physical flow
Site
(sales & Invoice Quant & Other
shipping) Customer tab Unit info.
Defaulted by
the price list
•Invoice •Defaulted by the
•Credit memo customer (sold-to,
•Debit note paying BP, group
•Credit note customer, ship-to
address, sales rep, tax External report Customer invoice (SBONFAC*)
•Pro forma
External report Customer draft (TRTCLIENT)
rule) Report List of sales invoices (SINVOICEE*)
•Project Request Branch invoices / customer (VEN042)
•Stock transaction Request Financial invoices / customer (VEN043)
Request credit memos/product/date(VEN045)
Request Credit memos / reasons(VEN046)
Request credit memos/product/date(VEN047)
Request Financ. Credit memos/cust./date(VEN048)
Request Invoices / rep / date (VEN049)
All these fields are line data and they are defaulted if the line is not direct Request credit memos/rep (VEN050)
Request Inv. & credit memo to declare (VEN051)
Request Invoice not paid(VEN054)
Step 2: In the first tab , entry of certain header elements such as codes and
Controls
addresses of the invoiced and paying customers, as well as other information from the original
document or from the invoiced customer in the case of direct creation.
Define if the direct invoice or the credit memo on the invoice is subject to a stock movement
Invoicing
Step 3: In the second tab , entry of invoicing elements
These elements are taken from the source document or from the invoiced customer in the case of direct
creation.
Enter the invoicing elements in the case of a direct invoice.
Lines
Step 4:In the third tab , entry of invoice lines
Enter the invoice lines (product, quantity, unit, price, line,) in the case of direct invoicing or modification of
lines from the original document (see 4a).
Step 4b: The order, delivery, return or invoice information is used again
In the screen’s left list six sections (four for invoices and two for credit memos) can be accessed in order
to reuse source documents. These sections are different if an invoice or a credit memo is concerned
Order selection, to reuse orders with direct invoicing
Delivery selection, to reuse deliveries
Service contract selection, to reuse lines of a service contract to be invoiced (Advanced training)
Service request selection, to reuse service requests to be invoiced (Advanced training)
Return selection, to reuse returns waiting for a credit memo
Invoice selection, to reuse invoices (this is the case for a credit memo)
Note: the “payment” button is activated when the invoice or the credit memo has been validated.
Exercise
7. REVERSE LOGISTIC
7.1. Return management
The return function is used to register returns of deliveries that were intended for customers or sub-
contractors.
Shipments Manual
Direct Manual
(GESSRH)
Loan return: The loan return function is used to register returns following a validated loan delivery.
A loan is to be returned, otherwise it is to be invoiced at the due date defined on the loan order.
Sub-contractor material return: This concerns returns of non-consumed materials which were delivered
to sub-contractors (Advanced training).
In inter-company or inter-site flows, the origin of the sub-contractor return is not a delivery. You
must therefore search among the inter-site service provider returns ( Advanced training).
Parameters > General parameters > Sequence number definition > Assignment
General parameters:
SAUZRET parameter (VEN Module - AUZ Group): Modification of returns (yes/no)
It is possible to configure several transactions for the returns. The active transactions appear in a
selection window when calling the function.
Note: Once a line entry is completed, it is possible to access via a right click additional possibilities linked
to each line (text entry, display of corresponding delivery, etc.)
Step 4:On each line, enter or modify the management elements of each line, if authorized by
transaction and/or by delivery status
Returned quantity
Return reason
Return date for each line (reused by default from the header)
Stock update (yes/no)
Stock status given for the quantity returned
Location type
Location
Awaiting credit memo (yes/no)
Exercise
8. INQUIRIES
8.1. Utilities
Customer balances resynchronization
Used to perform the mass resynchronization of the financial WIP of the various transactions of the sales
module that can be viewed using the “Site transactions” and “Folder transactions” buttons in the customer
record
Paid commissions
This function enables to store in a table the invoiced amounts versus paid amounts if the activity code KIT
is active.
8.2. Inquiries
Quotes
Quote list Invoices
Quote lines List of invoices
Quote by period Invoice lines
Quote by sales rep Invoices by period
Estimate hitlist Invoices by sales rep
Invoice hitlist
Orders
List of orders Returns
Order lines List of returns
Order per period Return lines
Order hitlist Return reason hitlist
Shipments Preparations
Delivery list Packaging
Delivery lines
Sales journal traceability
Shipments by period