Invoices

Use this function to manage:

  • All invoices: invoices on orders, packing slips, service contracts, service requests and order scheduled invoices, including direct invoices and pro forma invoices
  • Direct credit memos and credit memos on invoices or customer returns
  • Cancellation invoices if the INVCAN - Cancellation invoice parameter is set to Yes and if the transaction setup authorizes it.

You can:

  • Modify, delete or cancel automatically generated invoices using:
  • Create invoices linked to direct invoicing orders or non-deliverable standard orders which have been invoiced using an invoicing schedule. In this case, the orders can also be subject to the following features in a Project management context:
    • Progress billing: This feature is aimed at companies who manage projects. It is used to determine the amount to be invoiced to customers based on the scheduled invoices and estimated percentage of progress or quantity tracked against a given project, budget or task.
    • Milestone billing: This feature is used to define milestones (budgets or tasks) that have to be reached before the invoicing can be done.
    • Billing with no milestone: The scheduled invoices are billed if the next invoice date has been reached.

    For more information, refer to the Project management (PJM) how to guide. Click the link that applies to your Sage X3 solution:

French electronic signatures for sales invoices and journal entries

In compliance with French and Portuguese antifraud legal requirements and to ensure data security, electronic signatures are automatically generated when a customer invoice or journal entry is posted or set to Final, respectively. After the electronic signature is generated, further modifications to any of the fields identified below can be easily detected.

You can use the Electronic signature control function (FRADSICTL) to review the current electronic signature and highlight any inconsistencies.

See the “French electronic signature how to guide” or the "SVAT certification for Portuguese legislation guide" on the How to tab for details on implementing this feature. This document is intended for administrators and consultants who maintain and update Sage X3.

Exceptions

Data from invoices or journal entries posted before activating the electronic signature feature is not added to the DKSDATAFRA table and therefore no electronic signature is created.

Legislations other than French or Portuguese do not need to generate electronic signatures.

The electronic signature is a record in the Electronic signatures table (DKSDATAFRA) that includes data from the following fields in the Sales invoice (SINVOICE) and Account entries (GACCENTRY) tables:

Field code

Description

Data source: SINVOICE

Data source: GACCENTRY

ORIDOC

Origin of the document

1

2

DOCTYP

Journal

SINVOICE.SIVTYP

GACCENTRY.TYP

DOCNUM

Journal description

SINVOICE.NUM

GACCENTRY.NUM

TOTTAX(9)

Total by tax rate

SIH.AMTTAX(i) + SIH.BASTAX(i)

AMTATI

Invoice amount with VAT

SIH.AMTATI

DATTIM

Date and time of the signature

Datetime$

INVSNS

Document type

Evaluate SIH.SNS

CPYNAM

Company name

CPY.CPYNAM

POSCOD

Company postal code

BPA.POSCOD

CPYEECNUM

Company VAT number

CPY.EECNUM

BPRNAM

Customer name

SIH.BPRNAM(0)

BPARTNER.BPRNAM

BPREECNUM

Customer postal code

SIH.POSCOD

JOU

Journal code

GACCENTRY.JOU

DESTRA

Journal description

GACCENTRY.DESTRA

FNLPSTNUM

Final number

GACCENTRY.FNLPSTNUM

ACCDAT

accounting date

SINVOICE.ACCDAT

GACCENTRY.ACCDAT

ACC

Account code

GACCENTRYD.ACC

BPR

BP

SINVOICE.BPR

GACCENTRYD.BPR

LIN

Journal entry line

GACCENTRYD.LIN

LINDES

Line description

string$([F:DAE]DES<>"",

[F:DAE]DES)+string$([F:DAE]DES="","NA")

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The presentation of the entry screen depends on the setup of the selected transaction. You must define at least two transactions in this function because their setup is not the same:

  • One transaction for pro forma invoices
  • One transaction for credit memos. This transaction can also be used to include or exclude cancellation invoices included in a sub-category of credit memos.

When entering the function, a window displays the list of the defined transactions. Based on your management needs, select the transaction you want to use.

  • When using a transaction with the Invoice or Pro forma type, the selection panel contains the pick lists relating to deliveries, orders, service contracts, service requests and order scheduled invoices. From this list, you are free to select:
    • The whole order: All scheduled invoices with a date before or equal to the invoice creation date are selected.
    • The order line
    • The next invoice: The next scheduled invoice(s) of the order line are selected, grouped by date.
      • For progress billing: Only the scheduled invoices that meet the following criteria are displayed and available for selection:
        • The project status is set to: Launched.
        • The scheduled invoice has a validated progress status on the billing plan.
      • For milestone billing: The scheduled invoices are displayed and available for selection if both the next invoice date and the milestone have been reached (budget closed/delivered or task closed).
      • For billing with no milestone: All scheduled invoices can be selected once the next invoice date has been reached.

For more information on how to manage progress billing, refer to the Project management (PJM) how to guide.

Reminder: If the approval circuit is managed (parameter APPSOH - Order signature management), the sales orders complying with the established signature rules are not taken into account unless they are Totally signed or automatically signed.

For Pro forma invoices, the selection lists are always blank. You cannot create Pro forma invoicing by picking. The creation of Pro forma invoices is always performed from the source document, by clicking Pro forma.

  • If you select a Credit memo transaction type, the selection panel is restricted to the customer return and invoice picking lists. The invoice types available are those concerning the credit memos. For cancellation invoices, the selection panel only includes the picking list of invoices to be canceled.

Header

From the header, enter general information related to the invoice such as the invoice type, sales site, customer code, date, etc.

Tab Controls

In this section, enter the commercial information found on the invoice header such as the sold-to customer code, paying customer code and group customer code, etc.

Most of this information is initialized by default and is displayed on this screen depending on the chosen transaction.

Tab Invoicing

In this section, enter the invoicing terms. Most fields in this section depend on your selected transaction.

Tab Lines

Use this section to enter the invoiced product(s). The presence of the fields depends on the chosen transaction but the minimum information to be entered are the product, the quantity and the unit.

These lines can be initialized in the case of an invoice by selecting:

  • one or several picking notes,
  • one or several order lines,
  • one or several order scheduled invoices,
  • several orders or one or several service contracts,
  • one service request in the dedicated lists of the selection panel.

In the case of a credit memo, the lines can be initialized by selecting one or more invoice lines or one or more return lines.

For cancellation invoices, lines are initialized by selecting one or several invoices in the list of invoices to be canceled. The cancellation applies to each invoice as a whole and you cannot select lines one by one or modify them.

Discounts and charges for the line

Discounts and charges columns are displayed. They depend on the setup of the Price list structure code (see the Price list structure documentation). They can be initialized by the use of the price lists (see the help on Price list parameters and Price list entry). 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 UPDPRISAL - Default price reason - base parameter (VEN chapter, PRI group).

Click the Actions icon to view the reasons associated with the price as well as the different discounts and charges fields.

Stock information where the invoice has a stock transaction.

The following information (which can be set up by transaction) is used to enter, on line creation or for lines coming from an order with direct invoicing, the characteristics of the goods to be issued when they are known and unique (a single lot number for example). Once the invoice has been created or the invoice has been determined for the invoice line, the stock information for the invoice line is no longer directly accessible. To modify stock lines to be issued, use the Stock issues action available on the invoice line.

When various pieces of information relate to one single characteristic (e.g.: several lots or serial numbers), the entry is not performed in invoice line entry, but from the Stock issues detail window. This window automatically opens once the invoice line entry is complete. You can also open it from the Actions icon on the line.

Depending on the invoice transaction used, different operating modes are possible.

  • a transaction code can be associated with the invoice transactions on the condition that a specific transaction code has been defined for the transactions of type Delivery at the level of the stock issues for the stock with the product category.
  • a specific transaction code is used to define the different issue rules for certain transactions (the authorized statuses and sub-statuses, the management of the expired lots and picking locations).

1/ When the information entered is sufficient to determine the stock line to be issued, the issue occurs on that basis. The automatic determination rules applied to stock to issue are the following:

  • If the product is managed by serial number (Receipt/Issue or Global receipt & issue), 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, 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, 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.

Example for a product managed by lot:

  • If the lot is not entered, but the status and location are entered, this information will not be used and the detailed allocation rule is run.
  • If the lot is entered, the container, or location, and status used to select the stock lines are considered. The stock quantity identified may be insufficient. In that case, the balance is completed with other stock lines based on the detailed allocation rule only (restricted by the issue rule).
  • If no stock line is available, the Stock issues detail window is automatically displayed.

2/ If the stock information entered on the note line does not allow to clearly determine the stock line to be issued, two different situations can arise:

The invoice transaction is set up for the automatic determination of the stock to be issued:

In this case, the system attempts to select, at the end of the invoice line, stock lines to be issued based on:

  • the stock information entered on the invoice line,
  • the detailed allocation rule associated to the product category. This rule can be restricted by:
  • the product category issue rule.

In this functioning mode, the stock information entered on the invoice line are considered if the principal characteristics for the product have been entered.

For instance, for a product managed by lot, if the lot is not entered but the status and location are, this information is not used and the system executes the detailed allocation rule. If the lot is entered, the system takes into account the location and the status used during the stock lines selection. The stock quantity identified may be insufficient. In this case, the system completes the balance with other stock lines by executing only the detailed allocation rule (restricted by the issue rule). If no stock line is available, the Stock issues detail window is automatically displayed.

The invoice transaction does not automatically determine the stock to be issued:
In this case, the system attempts to select, at the end of the invoice line, the stock lines to be issued based on the stock information entered on the invoice line. If at least one item of information characterizing the stock is missing, or if the stock identified does not correspond to any available stock line, the Stock issue detail screen that is used to select the stock lines is automatically displayed at the end of the line. The detailed allocation rules and the category of the product are not used in this configuration: you must explicitly define the stock to be issued.
The functioning is the same when the product to be issued possesses no specific stock characteristic if it is not the unit or status. In this case, the allocation algorithm is triggered at the end of the line to determine the stock to be issued according to the unit and status. If the status is entered on the invoice line, it is used as an exclusive filter. If no stock line is found in this status, the detail window automatically opens to let the user determine the stock to be issued.

On completing the entry of an invoice line, several cases are possible: They are materialized by default using the following color codes, determined in the Presentation styles function.

  • The product on the invoice line is displayed in red.
    The stock lines to be issued have not been determined. It is possible to access the stock information of the invoice line or the detail of the lines to be issued via the Stock issue function, accessed from the Actions menu on the invoice line. As long as a line is displayed in red, it is impossible to create or save the invoice.
  • The product on the invoice line is displayed in blue.
    The lines for the stock to be issued have not been determined, but the balance has been saved as a shortage. (This is only possible for products with authorized negative stock or for kit parent products, even if these do not authorize negative stock (this is to ensure the management of the BOM links). This control is performed upon invoice validation.) You cannot directly access the stock information of the invoice line. The detail window must be used to modify the stock to be issued.
  • The product on the invoice line is displayed in black.
    The stock to issue has been determined. You cannot directly access the stock information of the invoice line. The detail window must be used to modify the stock to be issued.

If, for an invoice line, a stock sub-detail exists (several stock lines selected). The presence of this sub-detail is identified by the $ sign in the column(s) characterizing the stock having a sub-detail (for example, a $ in the lot column signifies that several lot numbers are associated with the invoice line).
When the invoice is created or saved, the selected stock lines are allocated in detail to the invoice. The identified shortages lead to the generation of allocations with shortages with any stock information if they have been entered in the stock detail screen (Lot number, etc.).

Stock information where the credit memo has a stock transaction

Depending on the product setup, you need to enter the stock characteristics:

    The internal lot.
  • The number of Sub-lots and the Sub-lot number. The Final sub-lot is calculated if several sub-lots are specified and consecutive (this information cannot be modified).
  • The Supplier lot.
  • The Serial number if the product is subject to a serial number. The Final serial number is calculated if several serial numbers are returned and consecutive (this information cannot be modified).
  • The Container and the License plate number, if the product is managed by container.
  • The Status. This is the quality status of the product.
  • The Location type and the Location if the product is managed by locations.
  • The order Price. This is the stock value assigned to the credit memo transaction.
  • The transaction Description. It is a description entered in the stock journal.

At the end of the credit memo line, a window for the entry of the stock detail may be automatically displayed if all the stock information has not been entered or initialized. This information must be entered in this detail screen.

For direct credit memos with stock movement:

  • If the credit memo line is direct: the location and the status can be accessed. They may be loaded by the stock receipt rules.
  • If the original invoice triggered a stock movement: the stock information come from the original invoice, except for the status and location which can be accessed from and initialized by the stock receipt rules.
  • Once created, the stock movement is carried out. The only way to modify the stock information is to use the Receipt modification action from the Actions icon on the credit memo line.

In addition to the product stock characteristics, some rules also affect stock receipts. For a customer credit memo, these rules can be described in a general manner, see Stock management rules, in the Delivery return section (the same rules are used for customer returns and credit memos). These rules are refined by Product categories and by product categories defined by sites.

A stock receipt rule for the return can be defined by Product categories for a movement type (see the movement code definition in the setup of the customer credit memo transactions).

The lot

If the product is managed by lot, different cases are possible based on the lot management rule associated with the transaction type Shipment return and based on the product lot management rule.

  • If a product is not managed by lot, the Lot and Supplier Lot columns cannot be accessed.
  • If a product is managed with mandatory or optional lots, the access to the lot field depends on the setup of the customer credit memo transaction used, and on the management rule Shipment return defined in the category of the product or in the stock management rules.

At this level, it is possible to specify the type of lot entry and to assign a default value to the lot.

Never initialize the lot with a document number. (If the return number is automatically allocated in creation, the initialization process with the document number is not visible when assigning an empty value. If the lot number is not entered in the lot field, the document will be loaded in this field when validating the credit memo). The option for initializing the internal lot with the supplier lot is not available with a customer credit memo.

When the entry is completed, if no lot number has been entered, several cases can arise:

  • The movement management rule allocates the document number.
  • The lot sequence number of the product is used to assign the new lot number. If no sequence number for the lot has been specified for the product and the lot is mandatory, a blocking message is displayed.

Specific case of the products managed as optional lot

This product type allows the entry of a blank lot field. In this case, this must be indicated by entering the Lot field by clicking Blank lot , available from the Actions menu. On saving the document, neither the sequence number nor the document number are used. This management method is incompatible with a management rule that does not allow the entry of an internal lot number.
The grid given below summarizes the impact of the management rule setup on the delivery return type transaction with mandatory lot management upon entry of a direct credit memo. In the case of optional lots, you can access an additional function from the Actions menu on the Lot field in order to indicate that you want to record a blank lot.

Lot entry

No

Free

New lot

Default lot

None

No entry on the line or in the stock detail window.

Automatic assignment according to the sequence number

Selection for all the lots

Lot info function

No initialization

Free entry

'Next lot number in the counter' function

If lot not assigned, automatic assignment according to the sequence number

No selection

Lot info function

No initialization

Free entry. But lot existence is checked.

'Next lot number in the counter' function

If lot not assigned, automatic assignment according to the sequence number

Journal number

No entry on the line or in the detail

Automatic assignment according to the document no.

Selection for all the lots

Lot info function

No initialization if the credit memo sequence number is automatic

Free entry

'Next lot number in the counter' function

If lot not entered document no. allocation.

No selection

Lot info function.

No initialization if the credit memo sequence number is automatic

Free entry. But lot existence is checked.

'Next lot number in the counter' function

If lot not entered document no. allocation.

From the Actions menu, you can:

  • select a lot number from amongst the list of lots declared for the site. If the product is managed by lot and sub-lot, the sub-lots appear in the selection window. The choice of a lot and sub-lot is used to load the lot and sub-lot fields.
  • identify the manner in which the lot is calculated, when this is not assigned, by the Lot info function (Blank lot, sequence number for the lot or the document number),
  • consult the stock by lot.

The sub-lot

If the product is managed by lot and sub-lot, it is mandatory to specify the sub-lot number associated with the internal lot for a direct credit memo. This entry is not mandatory at the level of the credit note line because it can be necessary to break down the stock detail lines or to have several sub-lots to enter. By default, sublot number 00001 is displayed if no sublot number has been assigned to the selected lot. If this is not the case, the next sub-lot number is suggested as an increment of the last sub-lot.
In some cases, the next sublot is not displayed because the last sublot corresponds to a character chain that cannot be incremented (e.g. 'AAAAA'). It is possible to enter a sub-lot number that does not correspond to the sub-lot suggested and a sub-lot already assigned to the lot.
It is possible at the level of the credit memo line to enter a number of sub-lots corresponding to the number of sales units. If a number larger than one is entered, the sublots to be assigned are calculated automatically based on the entered sublot number. The To sub-lot number is displayed.
If a $ symbol is to be found in the two Sub-lot columns, it means that the stock detail for the Sub-lots entered is not consecutive. At the level of the detail line, it is possible to define as many sub-lots as there are stock units.
If a single sub-lot is required, the To sub-lot number is identical to the From sub-lot number.

The supplier lot

If the product is managed by lot and this is a new lot number that is manually entered, it is possible for a credit memo to assign the original supplier lot if it is known (no specific control is carried out on this information). If this is not the case, this information is not be accessible and it is initialized by the supplier lot associated with the internal lot if it exists (only a supplier lot can correspond to an internal lot).
A selection window is used to choose a supplier lot among known ones (that have the object of a receipt).
If several supplier lots must be specified, they are entered in the stock detail window.

The serial number

If the product is managed by serial numbers at the receipt/issue or only at issue, it is mandatory to have assigned, before registering the credit memo, one or more serial numbers as a function of the quantity returned (this entry is made in the stock detail window). A control is carried out to verify that the number entered is not already in stock (a serial number being considered as unitary and not divisible).
For a direct credit memo, you can enter a serial number that has never been recorded in the application (i.e. old number not referenced in Sage X3). This is signaled by an information message. On saving the credit memo, the serial number is automatically created.
If several serial numbers are returned, the end number contains the last serial number, provided the numbers are consecutive. If not, a $ symbol is displayed in the two fields to specify that the numbers returned are not consecutive. The stock detail window must be used to view all the serial numbers.

The status

It is initialized with the default status defined by the management rule assigned to the Shipment return transaction type. If no status is specified in the rule no value is suggested. The status is not mandatory in the credit memo line, but if it is not entered, the stock detail window will automatically be displayed at the end of the line so that a status can be specified.
In certain cases, the user may choose not to enter the status in the document line, because the goods returned are of varying quality and a split is required. This split is specified in the stock detail window. If a “$” symbol is displayed in this field after entry on the document line, it means that different statuses have been assigned and that a stock line has subdetails.
According to the management rule used for the Delivery return transaction type, it is possible to generate an analysis request during the receipt to stock of goods if the goods have the to-be-controlled status (Q*).

The location type and the location

If the product is managed by location, a default location can be initialized depending on the management rule assigned to the Delivery return movement type and depending on the locations set up on the Product-site record. The semantic identifying a location category is used to associate in the Product/site record a location type and a potential location. The location type and the location defined in the Product-site record can refer to a group of location types and/or locations if the wild cards (?,*) are used in their definition (see the Location types and Product-site documentations). In the case of some location types, the assignment depends on their availability or their capacity (replenishment management). These pieces of information can be modified.

If the customer credit memo transaction allows it, a dock type location can be entered in the credit memo header. If this is the case, this location is suggested by default. The dock-type locations are not suggested in the selection if the customer credit memo transaction does not specify receipts to dock.
In some cases, the user may choose not to enter the location type and/or location, because the goods to return will be distributed across different storage locations. This distribution is specified in the stock detail window. If a “$” symbol is displayed in these fields after entry, it means that different location types and/or locations have been assigned and that a stock line has subdetails.

From the Location type field, use the Actions icon to:

  • select a location type,
  • Go to the location type table if user authorizations allow it.

From the Location type field, use the Actions icon to:

  • select a location,
  • access by tunnel the location table if the user's authorizations allow it,
  • Access by tunnel the Location occupation inquiry if the user's authorizations allow it.
  • jump to the inquiry of dedicated Locations for the product being entered if the user's authorizations allow it.

Credit memo coming from an invoice with stock transaction

In the case where a credit memo comes from an invoice with stock transaction, most of the information is automatically initialized from the stock information for the line in the original document, other information must be manually entered or is initialized as a function of the setup associated with the receipt transaction of customer return type.

The internal lot

This information is not accessible in this context on the credit memo line. If the credit memo concerns a direct invoice with stock transaction that references a single lot number, the latter is displayed on the line. If the original document references several lot numbers, this is indicated by the presence of the $ symbol in the lot field. If the originating invoice is multi-lot and the credit memo concerns only a part of the invoice the choice of lot is made via the stock detail screen (by deleting the lines that are not required). Same remarks as those concerning the management of sub-lot numbers.

The serial number

This information is not accessible in this context on the credit memo line. If the serial numbers in the original invoice line are consecutive, they are displayed on the credit memo line. If this is not the case, the $ symbol is displayed in the two fields to indicate that the numbers are not consecutive. If the document of origin contains several serial numbers and the credit memo only concerns some of these numbers, it is necessary to access the stock detail window to choose the required numbers. Only the serial numbers in the original invoice can be chosen. The serial number selection window only suggests the serial numbers from the original document line.

The location type and the location

The operation is identical to that of the direct credit memos.

Note on the credit memo entry cycle

When a credit memo line is created by selecting an invoice line with a stock movement and several stock lines are generate the stock information can only be modified from the Stock detail window. The same note applies to the modification of a direct credit memo line (provided the credit memo has not been created). Only the following information remains accessible: Quantity, Order price (Only for direct credit memos) and the Transaction description.

When a single stock detail line exists, the information remains modifiable on the credit memo line for a direct credit memo. For a credit memo having as its origin an invoice with stock transaction, only the information concerning the Status, the Location type, the Location and the Transaction description can be modified.

If the quantity on the credit memo line is modified and several lines exist in the stock detail, the detail window is automatically displayed so that the user can choose the line(s) affected by this modification.

If the quantity on the credit memo line is increased and only one stock detail line exists, the detail window is automatically displayed so that the user may specify that the additional quantity concerns the same detail line or another detail line.

If the quantity is decreased in the credit memo line and only one detail line exists, the stock window is not displayed.

Note on the management of factors and credit memo units

When the credit memo has an invoice with stock transactions as its origin, the units used to carry out the stock transaction are by default those of the invoice.

In the case of a credit memo with stock transaction, it is no longer be possible to manually modify the credit memo unit or the conversion factor between the sales unit and the stock unit when a line has been entered or when the line has as its origin an invoice with stock transaction.

The conversion factor between the sales unit and the stock unit can be recalculated when this is modified in the stock detail window and it involves a direct credit memo with stock transaction. If it involves a credit memo originating from an invoice with transaction, it is the invoiced quantity modified and not the conversion factor.

If, in the stock detail window, different units are entered and the total quantity entered does not correspond to the quantity expressed in the unit entered on the credit memo line, the credit memo line unit is replaced by the stock unit to ensure a conversion with the units used to carry out the receipt to stock.

Note on the credit memos for invoices with stock transaction and missing products

It is necessary to enter the stock information in the original invoice to create a credit memo for an invoice line with a stock transaction that only contains missing products. A message is displayed to highlight the problem.

If the credit memo concerns an invoice line with stock transaction containing shortages and identified stock lines, only the quantities corresponding to the identified stock lines are suggested on the credit memo line. It is impossible to modify the quantity being the subject of the credit memo above the quantities identified during the original issue.

If the credit memo concerns an invoice with stock transaction with a packaging that cannot be decimalized, the suggested unit is the stock unit in order to be able to process the identified quantities.

Axes

The presence of this information depends on the transaction setup.

When entering a direct invoice line, the analytical dimension types are initialized based on the SID Default dimension code. If the invoice line comes from a document, the analytical dimension types are loaded with the analytical dimensions present in the document line and potentially completed by this default dimension code.

It is possible, based on the user's authorizations, to access the dimension code management.

When modifying an analytical dimension, some controls must be carried out to check the validity of the dimension:

  • existence of the analytical dimension,
  • mandatory dimension on a dimension type (see the SAIANAx accounting parameters),
  • prohibited dimension on a dimension type (see the SAIANAx accounting parameters),
  • the dimension cannot be posted,
  • the dimension is prohibited with the dimension (see dimension/dimension prohibitions),
  • the dimension is reserved for a site, a company or a group of sites,
  • the invoice date is outside the limits of the dimension validity dates,
  • the user does not have the access rights for this dimension.

Free item

This information specifies whether the line concerns a free item or if the line is at the origin of the generation of one or more free items.
On exiting the line grid, all the totals are carried out as well as any calculations of the tax calculation bases.
In the lower part of the section, non-editable excluding tax and including tax totals are displayed, as well as the invoice total margin.

Tab Valuation

Use this section to display the different tax calculations carried out on the tax basis in the invoice and the integration of the different invoicing elements into the calculation of the excluding-tax and including-tax amount of the invoice.

Reports

By default, the following reports are associated with this function :

  SBONFAC : Customer invoice

  SBONFAC9 : Reprint customer invoice

  SBONFACFRA : Customer invoice

  SBONFACP : Customer invoice portrait

  SBONFACP2 : Fixd footer portrait cust inv

  SBONFACP2PI : Cust invoice portrait preprint

  TRTCLIENT : Customer notes P/R

  SINVOICEE : List of sales invoices

  SINVOICEL : List of detail sales invoices

This can be changed using a different setup.

This setup is performed at the Customization level of the current object, by associating a report code or a print code to it.
It is possible to further specify this setup:

  • By specifying a given report at transaction entry level. If this report matches a print code, the list of reports associated with this print code is also submitted.
    The report entered at transaction entry level and the reports associated with the print code are automatically submitted in creation mode only.
  • At a more detailed level, by associating a print template with the BP. This template mentions the report to be used in priority for the printing of each document, as well as the expected number of copies.
    SEEINFOIf the number of copies is not specified, or if there is no print template associated with the BP, the number of copies defined for the Destination printer is chosen. If the number of copies is not specified for the destination printer, then a single copy is printed by default.

Sage Sales Tax

Click this action to display the detailed fiscal statistics, based on the Sage Sales Tax (SST) tax code. This option is available if the document is imposed using the SST tax code.

SEEINFO The calculation detail is stored in the LTAVCR table associated with the document, to fiscal administrations and to the rates imposed by the SST tax code.

Specific Buttons

Error messages

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

No sequence number is assigned to this document

This message is displayed no sequence number has been assigned for the Sales module. To correct this problem, check if the required sequence numbers exist (if this is not the case, they should be created), then assign them to the different documents using the appropriate function. (See the Prerequisites section of this documentation).

This document does not exist!

This message is displayed when the entered invoice number does not exist in the table. To correct this problem, it is possible to use a selection window to search more easily for the correct code.

Prospect customer

This message is displayed when entering the customer code for the invoice but this customer is declared as a Prospect in the customer record.

Inactive customer

This message is displayed when entering the bill-to customer code but this customer is declared Inactive in the customer record.

Blocked customer

This warning message is displayed when entering the bill-to customer but this customer is declared as Blocked in the customer record.

Incorrect date

This message is displayed when entering the invoice date but this invoice does not fall within any period or fiscal year.

Fiscal year not open

This message is displayed when entering the invoice date and this date belongs to a fiscal year that is not yet open.

Period not open

This message is displayed when entering the invoice date and this date belongs to a period that is not yet open.

Closed period

This message is displayed when entering the invoice date and this date belongs to a closed period.

The site is not in the same legal company

This message is displayed when the entered shipment site does not belong to the same legal company as the sales site. To correct this problem, you need to select a site from the suggested list.

Business partner incompatible with the control account

This message is displayed when entering the collective account code and the collective account associated with this code is not authorized for this bill-to customer.

Problem on substitution product

This message is displayed when entering a reference product subject to substitution but this substitution cannot be carried out because the substitute product is not declared as sold (missing from the product-sales record).

Product does not exist for this site

This message is displayed when the entered product is managed in stock but has not been declared for the shipping site (missing from the product-site record) and you are not authorized to create the product-site link on entry or, if you answered ‘No’ when asked to confirm the creation.

Prohibited product

This message is displayed when the entered product is declared as Prohibited for this customer in the price list management.

Sale unit unknown for this product

This message is displayed if the entered sales unit does not correspond to any of the sales or packing units defined in the product record. To correct this problem, it is necessary to select a unit from those proposed.

Quantity < Minimum Quantity of 999 Units

This message is displayed when the entered quantity is less than the minimum quantity defined on the product record. The minimum quantity is expressed in the sales unit defined in the product record. This message can be a simple warning message or a blocking message depending on the value given to the previously-defined user parameter SDACLOK - Non-blocking control, price, margin, qty (VEN chapter, AUZ group).

Quantity < Maximum Quantity of 999 Units

This message is displayed when the entered quantity is greater than the maximum quantity defined on the product record. The maximum quantity is expressed in the sales unit defined in the product record. This message can be a simple warning message or a blocking message depending on the value given to the previously-defined user parameter SDACLOK - Non-blocking control, price, margin, qty (VEN chapter, AUZ group).

999.99 Net price < minimum price 999.99

This message is displayed when the calculated net price is less than the threshold price defined on the product record. The threshold price is displayed in the order currency to facilitate the comparison. This message can be a simple warning message or a blocking message depending on the value given to the previously-defined user parameter SDACLOK - Non-blocking control, price, margin, qty (VEN chapter, AUZ group). It can appear during the entry or the modification of several fields (site, price, discounts, charges, etc.) and during the saving of the invoice.

99.99 Margin Less than Minimum Margin of 99.99%

This message is displayed when the calculated margin is less than the minimum margin defined on the product record. This message can be a simple warning message or a blocking message depending on the value given to the previously-defined user parameter SDACLOK - Non-blocking control, price, margin, qty (VEN chapter, AUZ group). It can appear during the entry or the modification of several fields (price, discounts, charges, etc.) and during the saving of the invoice.

Authorized credit level reached XXX,XX currency

This is a message indicating that the authorized credit level for the bill-to customer has been reached.

This message is informational or blocking depending on the value given to the user parameter SCDTUNL - Authorization to unblock order (chapter VEN, group AUZ).

The control on the authorized credit level is performed only for the invoices created from orders or deliveries, as well as the direct invoices with stock transactions. Direct invoices with no stock update are not controlled (this is the case of purely financial invoices, for instance).

Note: When the parameter SCDTUNL - Authorization to unlock order has a value of Yes, the creation of invoices from an order or a delivery, as well as a direct invoice with stock transactions, are authorized even if the invoiced customer has an open item overrun, but on the condition that this customer is not blocked. If the customer is blocked, only the creation of direct invoices with no stock update is authorized.

The value of this parameter, the authorized credit level, and the current credit level are displayed by clicking Calculation details from the Actions icon on the Bill-to customer field.

Kit not generated for product XXX

This message is displayed after invoice line entry for a kit parent product or BOM parent product and a problem prevents the generation of invoice lines for the components of this parent product.

Possible reasons are:

  • There is no code for this parent product.

  • There is no valid code for this parent product.

  • None of the suggested codes has been selected.

  • The invoice line could not be generated because the component is not a sold product (it does not belong to the product-sales table) or because it is prohibited. In such cases, the following warning messages can be displayed:

  • Continue: the invoice line is not generated for this component and the BOM keeps being processed.

  • Cancel: The invoice lines are not generated for the different components and the parent product is considered as a normal product for this invoice.

Insertion not possible

This message is displayed after invoice line entry when the maximum number of lines for an invoice has been reached in the following contexts:

  • When generating the invoice lines for the components of a BOM or kit parent product.

  • In automatic generation of a free item line.

  • on selecting a document.

Some mandatory Analytical Dimensions were not indicated

This message is displayed on saving the invoice when analytical dimensions in the invoice header have not been entered. The invoice can neither be created nor modified.

No line entered. Update impossible.

This message is displayed when saving the invoice and no line has been entered: the invoice is not created.

Problem when the sequence number counter is recovered

This message is displayed when saving the invoice and the sequence number reading fails and no sequence number could be recovered.

Processing not possible: This invoice is validated

This message is displayed when you try to modify or delete a posted invoice.

Processing not possible: This line originates from a delivery.

This message is displayed when you try to delete or modify an invoice line coming from a delivery.

Processing not possible: Component of a kit

This message is displayed when you try to delete, modify or close a kit component.

After clicking the ‘Open items’ action in open item modification, the following messages can be displayed:

Incorrect due date total

This message is displayed when modifying the open item value or the creation of new open items, when the sum of the open items no longer corresponds to the tax incl. total of the invoice. To correct this problem, it is necessary to modify the open item amount.

Regulated due date, cancellation not possible

This message only is displayed when you try to delete an open item that has been paid, in part or in full.

Due date on statement, cancellation not possible

This message is displayed when you try to delete an open item that is already grouped on a statement.

Amount less than payment

This message is displayed when modifying the open item amount and the entered value is less than the sum of payments and prepayments for this open item.

After activation of the Post button, during the stock update phase, different messages can appear and prevent the posting of the invoice:

Indefinite period or processing prohibited at this date

This message is displayed when the product is managed in stock and the period in which the invoice date falls is not defined.

Product blocked for count

This message is displayed when the product is managed in stock but blocked for stock count.

X sales invoicing element without correspondence in purchasing Purchase invoice not created.

This message is displayed when posting the intercompany sales invoice or sales credit memo and an invoicing element used on the sales invoice has no match in the Sales intercompany setup. The sales invoice is posted, but the purchase invoice control has not been generated. It will then be necessary to modify the inter-company setup and select the sales invoice in a purchase invoice control.

When updating the accounting, different messages can appear and prevent the posting of the invoice. These messages are mostly the result of setup errors at the level of the automatic journals. On the appearance of one of these messages, it is necessary to verify the setup carried out for the automatic journals. For a precise description of these messages, the user should refer to the documentation concerning the accounting.

The tax incl amount is negative!

When an invoice is created or modified, a warning message is returned if the tax incl. total of the invoice is negative.

For instance, if a footer discount is entered and as a consequence of the discount amount, the invoice becomes negative, this message is returned to the user.

Lines originating from documents have been added or deleted. The invoicing elements are not recalculated.

This message is displayed when lines from a document with invoicing elements are added or deleted. In this case, the share of invoicing elements related to these documents is not added/subtracted from the invoice.

One invoice per credit memo (Parameter BELVCS)

In the case of a credit memo linked to several invoices, a control prevents the credit memo from being attached to the various invoices. The user must create as many credit memos as there are invoices.

Line NNN, product XXX: The quantity of the credit memo line is greater than the authorized quantity X Unit (Original invoice Y Unit - already completed credit memos Z Unit)

This message is displayed when a control on the amount entered in the credit memo line, in document currency, is applied and when the total of credit memo lines related to this invoice line exceed the invoiced amount. This message can be for information only or blocking depending on the value of the CTLCRENOT - Credit memo invoice control parameter (VEN chapter, INV group).

Line NNN, product XXX: The tax incl. amount of the credit memo line X Currency (Original invoice Y Currency - already completed credit memos Z Currency)

This message is displayed when a control on the amount entered in the credit memo line, in document currency, is applied and when the total of credit memo lines related to this invoice line exceed the invoiced amount. This message can be for information only or blocking depending on the value of the CTLCRENOT - Credit memo invoice control parameter (VEN chapter, INV group).

Tax incl. amount of the credit memo is greater than the authorized amount. X Currency (Original invoice Y Currency - already completed credit memos Z Currency)

This message is displayed in the following cases:

  • With an invoice vs. a credit memo with no direct lines on the credit memo: the tax incl. amount of the invoice is compared to the tax incl. amount of the credit memo.

  • With an invoice vs. one to N credit memos linked to the same invoice with no direct lines on the credit memos: the tax incl. amount of the invoice is compared to the total tax incl. amount of the credit memos.

  • With an invoice vs. 1 to N credit memos linked to different invoice lines or with direct lines: the tax incl. amount of the invoice is compared to the total tax incl. amounts of credit memo lines originating from the invoice, plus, the pro rata of invoicing elements on the credit memo footer. This pro rata is calculated based on the tax incl. total of credit memo lines linked to the invoice and on tax incl. total of all credit memo lines.

This message can be for information only or blocking depending on the value of the CTLCRENOT - Credit memo invoice control parameter (VEN chapter, INV group).

Tax incl. amount of the credit memo is greater than the theoretical amount of the selected invoice lines. including the breakdown of the invoicing elementsTheoretical authorized amount : X Currency (Original invoice Y Currency - already completed credit memos Z Currency)

This message is displayed for an invoice vs. one to N credit memos linked to different invoice lines or with direct lines:

  • The considered tax incl. invoice amount contains the tax incl. total of line amounts, except for lines not linked to the credit memo being controlled, plus, the pro rata of footer invoicing elements. This pro rata is calculated based on the tax incl. total of lines linked to the credit memos and on tax incl. total of all invoice lines.

  • The considered tax incl. credit memo amount contains the tax incl. total of credit memo line amounts originating from the invoice, plus, the pro rata of footer invoicing elements. This pro rata is calculated based on the tax incl. total of credit memo lines linked to the invoice and on tax incl. total of all credit memo lines.

If, for the resulting amounts, the tax incl. amount of credit memos is greater than the tax incl. amount of the invoice, this message is displayed. This control is never blocking as it is based on a theoretical distribution of invoicing elements. It is displayed if the CTLCRENOT - Credit memo invoice control parameter (VEN chapter, INV group) is set to ‘Non-blocking control’ or ‘Blocking control’.

Taxes have not been correctly defined

This warning or blocking message is displayed when inconsistencies are reported on:

  • the tax codes of the document lines,

  • The tax codes of the document invoicing elements.

The consistency check on tax codes is performed based on the value of parameter CTLTAX - Tax codes control (VEN chapter, VAT group - no control, non-blocking control, blocking control).

After the message is displayed, a log file details the errors that occurred during the consistency check.

'Field error' 'Invoice Type' 'IN1 [LEG 1] : Document type IN2 : Record does not exist for the current legislation [LEG 1]'

This message is displayed when the legislation of the entry type linked to the invoice type does not match the invoice legislation.

Tables used

SEEREFERTTO Refer to the implementation documentation.