Logistical services > Calculation 

This function is used to start the calculation of an invoice for a given invoicing folder and concerning a given period.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

The calculation of a logistics invoice is organized in 2 phases:

  • Phase 1: The calculation parameters are entered.
  • Phase 2: The calculation itself is done and an invoice generated.

Phase 1 - The calculation parameters are entered

To start the calculation, the operator must necessarily enter the invoicing folder and the logistic services calculation period. It should be noted that the number of the latest validated invoice as well as the period concerned are displayed.

It should be noted that:

  • by default, the lower range of the calculation period is initialized with the higher range of the period + 1 day.
  • the higher range of the calculation period cannot be later than the current date.

Phase 2 - The calculation of the logistics invoice

The logistics invoice calculation breaks down as follow:

  • The values of each section over the calculation period are calculated (current and archive folders taken into account) and the calculation data saved.
  • The ex-tax amounts of each section are calculated according to the price list corresponding to the calculation period.
  • The ex-tax amounts of each service (Sum of ex-tax amounts of the sections linked) are calculated.
  • The ex-tax amount of the logistics invoice is calculated for the invoicing folder (Sum of ex-tax amounts of the services linked).
  • The logistics invoice is generated with the status "7-Pending validation"

Note about the invoicing folder currency and the X3 folder currency: All price lists are in the currency of the X3 folder. However the invoice can be generated in an other currency that can be parametrated in the invoicing folder; In this case all prices are automatically converted in the currency of the invoicing folder according to the table of currency exchange rates.

Entry screen

Presentation

 

Close

 

Fields

The following fields are present on this tab :

Block number 1

Invoicing folder code defined in GEODE invoicing folder table. It is the entity for which the logistics invoicing will be calculated. This folder is linked to a Site/Depositor.

This field indicates the invoicing currency used for the preinvoicing of an invoicing folder.

Last invoice

This field indicates the number of the latest preinvoice validated in this invoicing folder.

  • Posting date (field LASVALDAT)

This field indicates the validation date of the latest preinvoice.

  • Period (field LASSTRDAT)

This field indicates the start date of the latest preinvoice calculation period.

  • field LASENDDAT

This field indicates the end date of the latest preinvoice calculation period.

Calculation period

  • Start date (field WSTRDAT)

This field indicates the start date of the preinvoice calculation period.

  • End date (field WENDDAT)

This field indicates the end date of the preinvoice calculation period.

Block number 4

  • Detailed log file (field TRA)

Used to display the log (progress) of the program at the end of the processing.

  • Preinvoice print (field WIMP)

When ticked, the preinvoice will be printed at the end of the calculation.

Close

 

Batch task

This function can be run in batch mode. The standard task INVCAL is provided for that purpose.

Error messages

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

Error zone "Calculation period": Period overlapping not authorized

No validated invoice should exist for the calculation period.

 

Tables used

SEEREFERTTO Refer to documentation Implementation