Common data > BP tables > Invoicing terms 

Invoicing terms are used on standard sales orders relating to non deliverable service or generic products.
Invoicing terms determine the invoicing schedule for the given products.
Depending on the setup, the schedule can be defined as follows, based on:

  • A fixed invoicing percentage that you enter on each schedule line and a minimum scheduled invoice amount, if needed. If this minimum amount is not reached, the scheduled invoice will be added for the next item.
  • Or an invoicing frequency (week, half-month, month, etc.).
    The invoicing percentage is thus defined based on the invoicing frequency
    (100% divided by the invoicing frequency) and with a spread to the last scheduled invoice line (in percentage and amount).

Use the Simulation action to view the schedule corresponding to the setup used, based on a scheduled invoice start date and amount.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

The display and content of the screen can vary according to the selected scheduled invoice.

  • When the scheduled invoice type is Frequency, information related to frequency must be entered: number of scheduled invoices, frequency type (month, quarter, etc.), invoicing method (pre-invoicing or post-invoicing) and the day of invoicing.
  • When the scheduled invoice type is Fixed percentage, information related to frequency are not available. However, on each scheduled invoice line, you must enter:
      • the invoiced percentage,
      • the information required for determining the due date based on the start date: months/days to be added, set days to consider.

In both cases, you can specify invoicing days to be excluded and mention if any unavailability period (e.g. bank holidays) should also be excluded.

Close

 

Fields

The following fields are present on this tab :

Block number 1

Enter a code identifying the invoicing term.

In creation mode, the legislation code can be initialized via the user parameter LEGFIL - Legislation (selection filter)(SUP chapter, INT group). You can also use this parameter to filter the selection panel and only display the codes defined for this legislation and those defined at the All legislations level.
You can enter a specific legislation so as to limit the use of the invoicing term only to documents linked to companies of the same legislation.

SEEREFERTTO For further information, refer to the documentation on the general principles linked to the multi-legislation setup.

  • Description (field DESAXX)

This long description is used as a title in screens and reports.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFOThe connection language must be defined as a default language for thefolder.

  • Short description (field SHOAXX)

Short title used in the screens and reports. This title is recorded in your connection language.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFOThe connection language must be defined as a default language for thefolder.

If a group is entered, the invoicing term can only be used on orders linked to the companies of this group.
A consistency check is applied between the legislation/group specified for the invoicing term and the legislation/group of the order.
SEEREFERTTO For further information, refer to the documentation on the General principles linked to the multi-legislation setup.

Scheduled invoice type

  • Scheduled invoice type (field INVCNDTYP)

 Select the scheduled invoice type: Fixed percentage or Frequency.
Once the invoicing element is used on a sales order, the scheduled invoice type can no longer be modified.

  • When the schedule is of the Frequency type, the scheduled invoice amount is calculated by dividing the overall amount by the number of scheduled invoices.
    In this case, you must enter the information related to periodicity.
  • When the schedule is of the Fixed percentage type, the amount of each scheduled invoice is calculated by applying the specified percentage to the overall amount.
    In this case, the schedule information are to be entered in the management grid.

Periodicity

  • Number of due dates (field FREQINV)

This field can only be accessed if the schedule type is Frequency.
In this case, the schedule is determined based on the number of scheduled invoices linked to the periodicity.

  • Periodicity (field PERINV)

This field can only be accessed if the schedule type is Frequency.
You can only enter an invoicing day in the month, if the frequency is at least equal to a month.

  • Invoicing method (field INVMETH)

This field can only be accessed if the schedule type is Frequency.
Select the method used to determine invoicing dates:

  • Pre-invoicing (term to mature): the invoicing date of each periodic scheduled invoice is determined based on the period start date and selected invoicing day. It is set, at the earliest, before the scheduled invoice start date and, at the latest, at the beginning of the period. Post-invoicing also includes excluded days and unavailability periods.
  • Post-invoicing (over due term): the invoicing date of each periodic scheduled invoice is determined based on the period end date and selected invoicing day. This process is performed when the period ends at the earliest. Post-invoicing also includes excluded days and unavailability periods.

Examples of determination of the next invoice dates on the first period, based on the invoicing method:

Due date basis

Period start

Period end

Invoicing day

First invoice

Pre-invoicing

Post-invoicing

05/02/2016

05/02/2016

04/03/2016

X

05/02/2016

04/03/2016

03

05/02/2016

03/04/2016

10

05/02/2016

10/03/2016

  • Day (field INVDAY)

This field can only be accessed when the schedule is of the Frequency type and when the frequency is of at least one month.
You can enter your preferred day of invoicing in the month.
The value 31 corresponds to the last day of the month.

Excluded days

  • Monday (field FBDDAYFLGM)

 Select the day(s) that cannot be the day(s) of invoicing.

  • Tuesday (field FBDDAYFLGT)

 

  • Wednesday (field FBDDAYFLGW)

 

  • Thursday (field FBDDAYFLGT)

 

  • Friday (field FBDDAYFLGF)

 

  • Saturday (field FBDDAYFLGS)

 

  • Sunday (field FBDDAYFLGS)

 

  • Unavailable days of site (field INVFBDHLYF)

Select this check box to exclude the Unavailable periods set up for the site from the suggested invoicing days.
If the calculated invoicing date corresponds to an unavailable period, then it is automatically postponed to the next authorized day. This control is combined with the one applied to excluded days.

Grid Management

  • Percentage (field INVPERCENT)

This field can only be accessed when the schedule is of the Fixed percentage type.
Enter the invoicing percentage assigned to each schedule line.

  • Minimum amount (field MINAMTNOT)

This field can only be accessed when the schedule is of the Fixed percentage type.
You can enter a minimum scheduled invoice amount. If the calculated scheduled invoice is lower than this minimum amount, it will be automatically grouped with the next scheduled invoice and their amounts added.
SEEINFO You cannot enter a minimum amount on all scheduled invoices. This field must be blank on at least one line.

For example :
Scheduled invoice start date: 05/02/2016

Percentage 

Minimum amount

Number of months

Number of days

End of month

 50

 

 0

 0

 No

 40

 50.00

 1

 0

 No

 10

 

 2

 0

 No

  • Scheduled invoices determination with an amount of 1,000.00.
     

    Scheduled invoices 

    Amount

    Period start

    Period end

    Next invoice

     1

     500.00

     05/02/2016

     05/02/2016

     05/02/2016

     2

     400.00

     06/02/2016

     05/03/2016

     05/03/2016

     3

     100.00

     06/03/2016

     05/04/2016

     05/04/2016


     
  • Open items determination with an amount of 100.00.
     

    Scheduled invoices 

    Amount

    Period start

    Period end

    Next invoice

     1

     50.00

     05/02/2016

     05/02/2016

     05/02/2016

     2

     50.00

     06/02/2016

     05/04/2016

     05/04/2016

This field cannot be entered. This is the default folder currency.
It is only entered when the schedule is of the Fixed percentage type and when a minimum amount is specified.

  • Number of months (field INVNBMONTH)

This field can only be accessed when the schedule is of the Fixed percentage type.
Enter the number of months to be added to the scheduled invoice start date in order to determine the period end date and the next invoice date.

Example

  • Amount: 1,000
  • Scheduled invoice start date: 05/02/2016

 Percentage

Amount

Number of months

Period start

Period end

Next invoice

 50

 500

 1

 05/02/2016

 05/03/2016

 05/03/2016

 30

 300

 3

 06/03/2016

 05/05/2016

 05/05/2016

 20

 200

 5

 06/05/2016

 05/07/2016

 05/07/2016

  • Number of days (field INVNBDAYS)

This field can only be accessed when the schedule is of the Fixed percentage type.
Enter the number of days to be added to the scheduled invoice start date and otherwise to the given number of months, in order to determine the period end date and the next invoice date.

Example

  • Amount: 1,000 
  • Scheduled invoice start date: 05/02/2016

Percentage 

Amount

Number of months

Number of days

Period start

Period end

Next invoice

 50

 500

 1

 0

 05/02/2016

05/03/2016

05/03/2016

 30

 300

 3

 2

 06/03/2016

 07/05/2016

 07/05/2016

 20

 200

 5

 5

 08/05/2016

 10/07/2016

 10/07/2016

  • Month end (field INVMONTHEN)

This field can only be accessed when the schedule is of the Fixed percentage type.
You can specify whether or not you want to consider the end of the month in the invoicing date calculation.

  • End of next month:
    The invoice date is set back to the end of the month, after the number of months and days has been applied.
  • End of current month:
    The schedule start date is set back to the end of the month, before application of the number of months and days determining the date of the next invoice.

Examples:

  • Amount: 1000
  • Scheduled invoice start date: 05/02/2016

1/ End of month: No on all lines.

Percentage 

Amount

Number of months

Number of days

Period start

Period end

Next invoice

 50

 500

 1

 0

 05/02/2016

 05/03/2016

 05/03/2016

 30

 300

 3

 2

 06/03/2016

 07/05/2016

 07/05/2016

 20

 200

 5

 5

 08/05/2016

 10/07/2016

 10/07/2016

2/ End ofnext monthon all lines

Percentage 

Amount

Number of months

Number of days

Period start

Period end

Next invoice

 50

 500

 1

 0

 05/02/2016

 31/03/2016

 31/03/2016

 30

 300

 3

 2

 01/04/2016

 31/05/2016

 31/05/2016

 20

 200

 5

 5

 01/06/2016

 31/07/2016

 31/07/2016

3/ End ofcurrent monthon all lines

Percentage 

Amount

Number of months

Number of days

Period start

Period end

Next invoice

 50

 500

 1

 0

 05/02/2016

 29/03/2016

 29/03/2016

 30

 300

 3

 2

 30/03/2016

 31/05/2016

 31/05/2016

 20

 200

 5

 5

 01/06/2016

 03/08/2016

 03/08/2016

 SEEINFOIf some days are excluded and unavailability periods or set days are specified, the determined invoice date will be automatically set back to the next authorized day.

  • Day of the month (field INVDAYMON1)

The value entered must be a date in the month (between 1 and 30) or 99 which corresponds to the last day of the month.
The use of this date is used to automatically postpone the due date calculated up to the nearest day of the month.
There can be up to 6 days on a same scheduled invoice line.

  • Day of the month (field INVDAYMON2)

 

  • Day of the month (field INVDAYMON3)

 

  • Day of the month (field INVDAYMON4)

 

  • Day of the month (field INVDAYMON5)

 

  • Day of the month (field INVDAYMON6)

 

Close

 

Specific actions

You can run a scheduled invoices determination simulation, entering a set of criteria such as:

  • The site
  • the amount, 
  • a currency, which can differ from the folder currency,
  • the scheduled invoice start date.

The schedule displays as a grid with one line per scheduled invoice. For each scheduled invoice, the following is mentioned:

  • the scheduled invoice percentage,
  • the scheduled invoice amount. The calculation of this amount includes the minimum amount, if specified. When a currency different from the folder currency is entered, the conversion is based on the day rate.
  • the start and end dates of the period, 
  • the invoicing dates of the scheduled invoices. Their automatic determination includes:
      • parameters specific to each scheduled invoice type: Frequency or Fixed percentage,
      • excluded days, 
      • the unavailability periods defined for the site, if they are to be excluded.

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

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

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

  • All folders (field TOUDOS)

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

  • To folder (field DOSDES)

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

Close

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

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation