Différences

Ci-dessous, les différences entre deux révisions de la page.

--- en:addons:drm [2025/11/17 10:22] – [Calculation of duties and taxes payable] ics02
+++ en:addons:drm [2026/10/17 14:28] (Version actuelle) – Automatic push translation eneuville
@@ Ligne 1: / Ligne 1: @@
-====== DRM: Monthly Summary Declaration * ======
+====== DRM: Monthly Summary Declaration ======
-FIXME MIGRATION IN PROGRESS
 ===== Overview =====
-All winegrowers, as well as brewers, are required to submit a DRM: each month, this involves taking inventory of the cellar, which must be consistent with the movements recorded during the month.
+All winegrowers, as well as beer producers, are required to submit a DRM: each month, this involves carrying out a stock take of the cellar, which must match the stock movements recorded during the month.
-This extension uses the stock movements recorded in Gestan and automatically calculates the theoretical results based on the recorded movements and previous stocks: all that remains is to compare them with the inventory.
+This extension uses the stock movements recorded in Gestan and automatically calculates the theoretical results based on the recorded movements and previous stock levels: all that remains is to compare these with the physical stock count.
-It also calculates the taxes to be paid in the case of a brewery.
+It also enables the calculation of taxes payable in the case of a brewery.
 ===== Configuration =====
-Via //Tools -> Administration -> Configurable labels//, configure the types of movements. For example:
+=== Configuration of stock movement types ===
+Via //Tools -> Administration -> Customisable Labels//, configure the transaction types. For example:
-{{:en:addons:drm_01_en.png?nolink|}}
+{{fr:addons:drm_01.png?nolink|}}
-Then configure the table of correspondences between units, via //Tools -> Administration -> Repository -> Coefficient between units//, to record the ratio between your reference unit for calculating DRMs (usually the bottle or the neck) and other possible units: for example, a magnum = 2 bottles, a jeroboam = 8 bottles, 1 fillette = 0.5 or 0.75 bottles (depending on the region), 12 bottles = 1 cuite, 24 bottles = 1 coma, etc.
+=== Configuring unit conversions ===
-{{:en:addons:drm_02_en.png?nolink|}}
+Then configure the unit conversion table via //Tools -> Administration -> Repository -> Unit Conversion Factors//, to record the ratio between your reference unit for calculating DRMs (usually the bottle or the neck) and other possible units: for example, a magnum = 2 bottles, a jeroboam = 8 bottles, 1 ‘fillette’ = 0.5 or 0.75 bottle (depending on the region), 12 bottles = 1 ‘cuite’, 24 bottles = 1 ‘coma’, etc.
-Continue configuring via //Tools -> Application settings -> Extension settings -> DRM//.
+{{fr:addons:drm_02.png?nolink|}}
-{{:en:addons:drm_03_en.png?nolink|}}
+=== Configuring the extension itself ===
-The **Synth in reference unit** box allows you to total by appellation rather than by appellation/centilisation on the Summary tab, converting everything into the reference unit.
+Continue with the configuration via //Tools -> Application Settings -> Extension Settings -> DRM//.
-It is possible to specify a **number of decimal**, which is useful, for example, when you have a lot of bottles, but your reference unit for wine is the hectolitre.
+==General tab ==
-Specify the product family or families that correspond to the **wines** (or **beers**) sold, then the reference unit for calculations, in this case the bottle (but it could be hectolitres).
+{{fr:addons:drm_03.png?nolink|}}
-Indicate which types of stock movements should be taken into account for the totals calculations: **sales in France, sales in the EU, sales outside the EU**. The small magnifying glasses allow you to select one or more types of movements.
+Specify the product family or families that correspond to the **wines** (or beers) sold, then the**reference unit for wine** for the calculations.
-In the other **<configurable>** fields, you can specify three additional categories for your own needs, for example ‘Personal consumption’ or ‘Cellar tasting’. Everything else will be classified as ‘Other’.
+The **‘Synth in reference unit’** allows you, on the Summary tab, to total not by Appellation/Centilisation, but by Appellation, by converting everything into the reference unit.
-You can also specify, if necessary, the types of movements that should not be taken into account in the calculations (for example, transactions corresponding to a withdrawal for bottling).
+It is possible to specify a **number of decimal places**, which is useful, for example, when you have a large number of bottles but your reference unit for wine is the hectolitre.
-The **First inventory** date will be filled in automatically when you first access the application, or when you delete the stock history by appellation. This is the start date for stock calculations, normally the last day of the month.
+You can specify, where applicable, the types of movements not to be included in the calculations (for example, movements corresponding to a draw-off for bottling), via **Excluded Movements**.
-Calculations based on product names
+If you need to manage appellations, store them in a configurable drop-down list in the product master record, and specify them in the **Appellation drop-down**. Also store the alcohol content in an additional numeric field, and specify this field in the drop-down menu **Alcohol Content**.
-If you need to perform calculations based on your product names:
+Specify the product family for the **Capsules**, and specify **the CRD reference unit** for CRDs. Store the capsule type in a configurable combo box in the product master record, and specify this combo box via **Capsule drop-down**.
-Using the additional product fields (Tools > Application settings > Additional fields), select one of the available combos as the one managing product names, and enter the possible names on the same screen.
+Finally, specify in **tax drop-down** which drop-down list in the product master record you use to store the tax regime for the wine in question.
-{{:en:addons:drm_04_en.png?nolink|}}
+The date **First Inventory** field will be filled in automatically the first time the application is opened, or when the stock history by appellation is deleted. This is the start date for stock calculations, normally the last day of the month.
-For each product, you can now declare which name it is on the product sheet.
+== Groupings tab ==
-{{:en:addons:drm_05_en.png?nolink|}}
+{{fr:addons:drm_17.png?nolink|}}
-In the extension settings, indicate the combo box number you used to encode the names.
+You can use up to 12 groupings of stock movement types.
-{{:en:addons:drm_06_en.png?nolink|}}
+For example, you can group the transaction type “Cellar sales” and the transaction type “Showroom sales” into a group called “Sales in France”, or “Sales in Germany”, “Sales in Spain” and “Sales in Italy” into a group called “Sales in the EU”.
-The same applies to capsules if you manage a CRD stock: you can designate the **Capsules** product family and, in the **capsule combo box**, specify the combo box from the product sheet that will be used to differentiate them (CRD 0.5L, 0.75L, 1.5L, etc.).
+First, enter a label using the small buttons <badge>1</badge>.
+==== Additional fields in the product master record ====
+Via //Tools->Settings->Additional fields//.
+Here are the settings for the additional fields for the configuration described above.
+{{fr:addons:drm_04.png?nolink|}}
+  * Drop-down menu 1 stores the description (tax category)
+  * Text field 1 stores the alcohol content.
+  * Capsules are managed in drop-down menu 2
+  * The tax regime is selected in drop-down menu 5.
+In the product record, it will be possible to enter this information, as shown below, for example.
+{{fr:addons:drm_05.png?nolink|}}
 ==== Calculation of duties and taxes payable ====
 If you wish to calculate duties and taxes payable based on the volume of alcohol sold:
-Using the additional product fields, enter a number for managing the alcohol content by volume (ABV, or alcohol content, or alcohol percentage) and a combo box for managing taxes, as shown below:
+Using the additional product fields, enter a numeric field for managing the alcohol content by volume (ACV, or alcohol by volume, or alcohol content) and a drop-down menu for managing taxes, as shown below:
-{{:en:addons:drm_07_en.png?nolink|}}
+{{fr:addons:drm_07.png?nolink|}}
-Here, we have declared that the first additional numerical field available for the product sheet is used to declare the alcohol content, and that the third additional combo box available for the product sheet is used to declare the possible tax regime (e.g. reduced rate, full rate, custom brewing rate). These two fields are used as the basis for calculating the taxes levied on beer production.
+Here, we have specified that the first additional numeric field available for the product record is used to specify the alcohol content, and that the third additional drop-down menu available for the product record is used to specify the applicable tax regime (e.g. reduced rate, standard rate, contract brewing rate). These two fields form the basis for calculating the taxes levied on beer production.
-The <badge>1</badge> button allows you to set the correspondence between the tax regime and the tax rate (this avoids having to update all product sheets in the event of a change in the tax rate), which must be recorded as follows:
+The button <badge>1</badge> button allows you to set up the mapping between the tax regime and the tax rate (this avoids having to update all product records in the event of a change in the tax rate), which must be saved as follows:
 <code>
-[name of regime] | [tax rate]
+[libellé du régime] | [taux de taxe]
 </code>
-for example ‘Custom brewing|7.40’
+for example “Contract brewing|7.40”
+{{fr:addons:drm_08.png?nolink|}}
+You will also need to specify the correspondence between the reference unit (the bottle) and the litre, as shown below.
+{{fr:addons:drm_09.png?nolink|}}
+===== Usage =====
+:TIP: You can use a shortcut button with the command “Table_DRM” to display it as a button on the desktop at Gestan.
+==== Transactions for the month ====
+{{fr:addons:drm_10.png?nolink|}}
+This tab displays all transactions for the month. You can exclude transfer transactions if you manage several different locations, for example two separate warehouses.
+The //Market// column shows the market derived from the transaction type (transaction types can be grouped into markets).
+The table’s context menu includes a **sum** the selected rows. There is also an option to **Remove**option, which allows you to exclude certain transactions if required.
+The context menu for the transaction list also allows you to request the printing of the **DRM1** report: it is a good idea to file this alongside your Monthly Summary Declaration, so that you have a hard copy of the basis for the calculation. You can also print the **STK2** report on stock movements.
+The **Stk/App** button displays stock levels by item name for the current month.
+:TIP: Movements where the units could not be converted to the reference unit are highlighted in red on the first tab (and are not taken into account on the subsequent tabs). Otherwise, a successful conversion is indicated by a straw-yellow colour.
+:TIP: The context menu for the year/month selection field allows you to choose a custom date range.
+==== Totals by product ====
+This table shows the totals by product.
+If a product name management drop-down list has been defined, the results are presented by product name, as shown below:
+{{fr:addons:drm_11.png?nolink|}}
+==== Totals by transaction type ====
+This table shows the totals by transaction type.
+{{fr:addons:drm_12.png?nolink|}}
+==== Totals by tax regime ====
+This tab is only displayed if you have configured an alcohol content drop-down list and a tax regime drop-down list.
+The table shows the transactions for the period, grouped by tax regime. For each row, the alcohol equivalent is calculated and the tax rate applied. The total is the amount you will need to pay. :-(
+{{fr:addons:drm_13.png?nolink|}}
+==== The summary ====
+These are the figures you will need to enter on your DRM.
+You can enter the previous month’s stock values directly into the table (which you will find on your DRM for the previous month, of course). These will be saved for the following month, unless the current month precedes the month of the last stock-take (which would not be a normal situation).
+The last row is a total row calculated in the reference unit.
+In addition, a table shows the breakdown by group, according to the group settings.
+If you have specified a product name management drop-down menu, the totals are calculated by product name, as shown below.
+{{fr:addons:drm_14.png?nolink|}}
+The table’s context menu (below)
+{{fr:addons:drm_15.png?nolink|}}
+allows you to delete the stock history for the previous month (it will be recalculated automatically), or to delete all stock histories from the start. The last day of the month preceding the current month will be considered the date of the last stock-take.
+===== ===== versions
+^Version ^Date ^Comments^
+| 3.A1.10.02 | 17/10/26 | Correction to totalling in the summary table |
+| 3.A1.10.01 | 17/10/26 | Modification to the calculation of totals by market (now shown explicitly) |
+| 3.A1.09.00 | 26/08/11 | Adaptation for Gestan A1.09 |
+| 3.A1.01.03 | 17/11/25 | Migration to A1 format |
+| 3.15.38.05 | 11/07/22 | WD27 + addition of the option to reset stock history by item name. |
+| 3.15.21.04 | 07/02/21 | Various improvements and fixes |
+| 3.15.00.1F | 17/02/18| Various improvements – Storage of historical figures with decimal places - Addition of a summary table by transaction type |
+| 3.15.00 | 06/01/18 | Addition of tax calculation for breweries|
+| 3.13.2A | 16/05/17 | Addition of additional configuration options. Fixed an issue causing confusion between wine and capsules|
+| 3.13.00 | 00/00/00 | Initial version|
-{{:en:addons:drm_08_en.png?nolink|}}
+\\ \\
+-----------------
+ℹ️ **Other “Extensions” articles**
-You will also need to indicate the correspondence between the reference unit (the bottle in our example) and the litre, as shown below.
+[[en:wiki:admin:extensions|How to install an extension]]
-{{:en:addons:drm_09_en.png?nolink|}}
+<nspages fr:addons -nbCol=2 -textPages="" -h1 -r -simpleLineBreak >