Exact Online Add-On

V.2.1

Exact Online add-on

Procedure
  • Preparation within Exact.
  • Preparation of the source file (*).
  • Import specifications.
  • Fields.
  • Bookings: Journal, Fiscal Year and Period.
  • Import.
  • Validation.
  • Definition.
(*)
The preparation also includes a formula setup that will facilitate an additional independent validation later on. Among others, the formulas at stake look like:
=INT((E2-DATE(YEAR(E2-
WEEKDAY(E2-1)+4);1;3)
+WEEKDAY(DATE(YEAR(E2-
WEEKDAY(E2-1)+4);1;3))+5)/7)
 Example-1
Click on the image to enlarge it. Example-2
Click on the image to enlarge it.
Procedure
  • Preparation within Exact.
  • Preparation of the source file (*).
  • Import specifications.
  • Fields.
  • Bookings: Journal, Fiscal Year and Period.
  • Import.
  • Validation.
  • Definition.
(*)
The preparation also includes a formula setup that will facilitate an additional independent validation later on. Among others, the formulas at stake look like:
=INT((E2-DATE(YEAR(E2-
WEEKDAY(E2-1)+4);1;3)
+WEEKDAY(DATE(YEAR(E2-
WEEKDAY(E2-1)+4);1;3))+5)/7)
 Example-1
If the device width exceeds 1050, you can click on the image to take a look at an exact enlargement. Example-2
If the device width exceeds 1050, you can click on the image to take a look at an exact enlargement.