User Tools
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:inventorymodules [2020/08/27 00:11] joebordes [Total Stock] |
en:inventorymodules [2020/10/27 10:13] (current) joebordes [vtiger_productcurrencyrel] |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| * **Total discount**: the sum of line and global discount | * **Total discount**: the sum of line and global discount | ||
| * **Net before global discount**: gross total minus individual line discounts | * **Net before global discount**: gross total minus individual line discounts | ||
| - | * **Net total (after global discount)**: gross total minus total discounts | + | * **Net total (after global discount)**: gross total minus ALL (total sum of all) discounts |
| * **Tax retention**: the sum of all taxes marked as type retention | * **Tax retention**: the sum of all taxes marked as type retention | ||
| * **Total tax**: the sum of all taxes applied | * **Total tax**: the sum of all taxes applied | ||
| Line 140: | Line 140: | ||
| ====Discount Amount==== | ====Discount Amount==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | |Quotes, SalesOrder, Invoice|The discount awarded to the Organization for this particular line, represented as an absolute amount of money.\\ When there is a direct discount awarded to this line, that amount will be placed here directly.\\ When there is a discount percentage awarded to this line, the amount represented by that percentage will be calculated and automatically filled in here. | + | |Quotes, SalesOrder, Invoice|The discount awarded to the Organization for this particular line, represented as an absolute amount of money.\\ When there is a direct discount awarded to this line, that amount will be placed here directly.\\ When there is a discount percentage awarded to this line, the amount represented by that percentage will be calculated and automatically filled in here.| |
| |PurchaseOrder|The discount awarded by the Vendor to us for this particular line, represented as an absolute amount of money. An administration department should later verify that this discount was actually deducted when we receive the Invoice.\\ When there is a direct discount awarded to this line, that amount will be placed here directly.\\ When there is a discount percentage awarded to this line, the amount represented by that percentage will be calculated and automatically filled in here.| | |PurchaseOrder|The discount awarded by the Vendor to us for this particular line, represented as an absolute amount of money. An administration department should later verify that this discount was actually deducted when we receive the Invoice.\\ When there is a direct discount awarded to this line, that amount will be placed here directly.\\ When there is a discount percentage awarded to this line, the amount represented by that percentage will be calculated and automatically filled in here.| | ||
| Line 157: | Line 157: | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| |Quotes, SalesOrder, Invoice|The total cost price of this line, represented as an amount of money. This follows the formula:\\ Cost Price * Quantity| | |Quotes, SalesOrder, Invoice|The total cost price of this line, represented as an amount of money. This follows the formula:\\ Cost Price * Quantity| | ||
| - | PurchaseOrder|This field should always be zero| | + | |PurchaseOrder|This field should always be zero| |
| ====Related Line Item ID==== | ====Related Line Item ID==== | ||
| Line 168: | Line 168: | ||
| |Invoice|References the InventoryDetails line on which this line was sold. So the context of the referenced line is a SalesOrder. There could be multiple Invoicelines referencing a single SalesOrderline since a SalesOrder could be Invoiced in multiple tranches| | |Invoice|References the InventoryDetails line on which this line was sold. So the context of the referenced line is a SalesOrder. There could be multiple Invoicelines referencing a single SalesOrderline since a SalesOrder could be Invoiced in multiple tranches| | ||
| |PurchaseOrder|References a possible InventoryDetails line on which this product was sold. Only applicable when there is a direct and true relationship between these lines. Meaning: a product sold to an Organization on a SalesOrder is ordered at a Vendor in the same Quantity.\\ Note: there could be 'collector' lines for PurchaseOrders, e.g.: PurchaseOrder lines that order Products in one line that are meant to fulfill multiple SalesOrderlines. This can, in this configuration only be done by relating those records on a M:M basis.| | |PurchaseOrder|References a possible InventoryDetails line on which this product was sold. Only applicable when there is a direct and true relationship between these lines. Meaning: a product sold to an Organization on a SalesOrder is ordered at a Vendor in the same Quantity.\\ Note: there could be 'collector' lines for PurchaseOrders, e.g.: PurchaseOrder lines that order Products in one line that are meant to fulfill multiple SalesOrderlines. This can, in this configuration only be done by relating those records on a M:M basis.| | ||
| + | |||
| + | ===== Some Internals ===== | ||
| + | |||
| + | ==== vtiger_productcurrencyrel ==== | ||
| + | |||
| + | This table holds the relation of the unit price of the product for each currency configured in the application. It contains two values: | ||
| + | |||
| + | * the **actual unit price** of the product in each currency. This is the price introduced by the user in the application | ||
| + | * the **converted price** of the product in each currency. This represents the mathematical calculation of the price in that currency based on the conversion rate. This value is not used anywhere in the application, it is only a reference value | ||
| + | |||
