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/26 23:58] joebordes [Financial Block and Fields] |
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 85: | Line 85: | ||
| ====Line Completed==== | ====Line Completed==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes | + | |Quotes|This field has no meaning| |
| - | This field has no meaning | + | |SalesOrder|This field signifies whether all units of the line have been delivered. When no units have been delivered or a part of the sold units (field: Quantity) has been delivered, this field should remain unchecked.\\ Only when all sold units have been delivered to the Organization this field should be set to 'yes'| |
| - | SalesOrder | + | |Invoice|This field has no meaning| |
| - | This field signifies whether all units of the line have been delivered. When no units have been delivered or a part of the sold units (field: Quantity) have been delivered, this field should remain unchecked. | + | |PurchaseOrder|This field signifies whether all units ordered at the vendor (Quantity field) have been received by us. As long as there are more units in the Quantity-field than in the 'Delivered/Received' field, this field should remain unchecked\\ When the no. in 'Units Delivered / Received' meets or exceeds the no. in 'Quantity', this field should be set to 'yes'.| |
| - | + | ||
| - | Only when all sold units have been delivered to the Organization this field should be set to 'yes' | + | |
| - | Invoice | + | |
| - | This field has no meaning | + | |
| - | PurchaseOrder | + | |
| - | This field signifies whether all units ordered at the vendor (Quantity field) have been received by us. As long as there are more units in the Quantity-field than in the 'Delivered/Received' field, this field should remain unchecked | + | |
| - | + | ||
| - | When the no. in 'Units Delivered / Received' meets or exceeds the no. in 'Quantity', this field should be set to 'yes'. | + | |
| ====Cost Price==== | ====Cost Price==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes, SalesOrder, Invoice | + | |Quotes, SalesOrder, Invoice|This field indicates the cost price of the product or service, per unit| |
| - | This field indicates the costprice of the product or service, per unit | + | |PurchaseOrder|This field should be zero. The cost price of a product should, in the context of a purchase order, be represented on the 'Unit Price' field.| |
| - | PurchaseOrder | + | |
| - | This field should be zero. The costprice of a product should, in the context of a purchaseorder, be represented on the 'Unit Price' field. | + | |
| ====Total Stock==== | ====Total Stock==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | All | + | |All|This field should carry the value of the stock level of the related product of the line **at the moment the line was created and the master-record was first saved.** After the initial save, this field should never be altered.\\ The stock we use to fill in this field will respect the units delivered/received field as such: when a master-record (like SalesOrders) ‘delivers’ units, the stock saved on this field will reflect the stock on the product, minus the units delivered on the first save. When a master-record receives products (like PurchaseOrders), the field will hold the product stock plus the units received at the first save.\\ Subsequent changes to the units delivered/received field will not update this field.| |
| - | This field should carry the value of the stocklevel of the related product of the line at the moment the line was created and the master-record was first saved. After the initial save, this field should never be altered. | + | |
| - | + | ||
| - | The stock we use to fill in this field will respect the units delivered/received field as such: when a master-record (like SalesOrders) ‘delivers’ units, the stock saved on this field will reflect the stock on the product, minus the units delivered on the first save. When a master-record receives products (like PurchaseOrders), the field will hold the product stock plus the units received at the first save. | + | |
| - | + | ||
| - | Subsequent changes to the units delivered/received field will not update this field. | + | |
| ====Remaining Units==== | ====Remaining Units==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes | + | |Quotes|No meaning| |
| - | No meaning | + | |SalesOrder|The number of units that remain to be delivered to the Organization. Should always be the 'Quantity' minus the 'Units Delivered/Received'.| |
| - | SalesOrder | + | |Invoice|No meaning| |
| - | The number of units that remain to be delivered to the Organization. Should always be the 'Quantity' minus the 'Units Delivered/Received'. | + | |PurchaseOrder|The number of units that remain to be received from the vendor. Should always be the 'Quantity' minus the 'Units Delivered/Received'.| |
| - | Invoice | + | |
| - | No meaning | + | |
| - | PurchaseOrder | + | |
| - | The number of units that remain to be received from the vendor. Should always be the 'Quantity' minus the 'Units Delivered/Received'. | + | |
| ====Products==== | ====Products==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes | + | |Quotes|Which product/service are we offering?| |
| - | Which product/service are we offering? | + | |SalesOrder|Which product/service are we selling?| |
| - | SalesOrder | + | |Invoice|Which product/service are we invoicing?| |
| - | Which product/service are we selling? | + | |PurchaseOrder|Which product/service are we buying?| |
| - | Invoice | + | |
| - | Which product/service are we invoicing? | + | |
| - | PurchaseOrder | + | |
| - | Which product/service are we buying? | + | |
| ====Organizations==== | ====Organizations==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes | + | |Quotes|B2C: Empty, or the company the contact works in\\ B2B: To who are we offering the product or service| |
| - | B2C: Empty, or the company the contact works in | + | |SalesOrder|B2C: Empty, or the company the contact works in\\ B2B: To who are we selling the product or service| |
| - | B2B: To whom are we offering the product or service | + | |Invoice|B2C: Empty, or the company the contact works in\\ B2B: To who are we invoicing the product or service| |
| - | SalesOrder | + | |PurchaseOrder|No meaning should be empty| |
| - | B2C: Empty, or the company the contact works in | + | |
| - | B2B: To whom are we selling the product or service | + | |
| - | Invoice | + | |
| - | B2C: Empty, or the company the contact works in | + | |
| - | B2B: To whom are we invoicing the product or service | + | |
| - | PurchaseOrder | + | |
| - | No meaning, should be empty | + | |
| ====Vendor==== | ====Vendor==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | All | + | |All|If the Product field contains a Product (not a service), the main vendor of that product| |
| - | If the Product field contains a Product (not a service), the main vendor of that product | + | |PurchaseOrder|**Concept: not in production:**\\ From whom are we buying the product or service?| |
| - | PurchaseOrder | + | |
| - | Concept: not in production: | + | |
| - | From whom are we buying the product or service? | + | |
| ====Line Item ID==== | ====Line Item ID==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | All | + | |All|A reference to the legacy 'productinventoryrel' table ID| |
| - | A reference to the legacy 'productinventoryrel' table ID | + | |
| ====Unit Price==== | ====Unit Price==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes, SalesOrder, Invoice | + | |Quotes, SalesOrder, Invoice|The unit price of the Product or Service on the Product-field| |
| - | The unitprice of the Product of Service on the Product-field | + | |PurchaseOrder|The cost price of the Product or Service on the Product-field| |
| - | PurchaseOrder | + | |
| - | The Costprice of the Product of Service on the Product-field | + | |
| ====Gross Price==== | ====Gross Price==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | All | + | |All|The total amount of money this line represents, before discounts or individual taxes. The formula would be\\ Quantity * Unit Price| |
| - | The total amount of money this line represents, before discounts or individual taxes. The formula would be | + | |
| - | + | ||
| - | Quantity * Unit Price | + | |
| ====Discount Amount==== | ====Discount Amount==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes, SalesOrder, Invoice | + | |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.| |
| - | The discount awarded to the Organization for this particular line, represented as an absolute amount of money. | + | |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.| |
| - | + | ||
| - | 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 Tax==== | ====Line Tax==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | All | + | |All|A quantified representation of the sum of all tax percentages. This follows the formula:\\ Net Total * (Tax Percent / 100).\\ The Net Total and the Line Tax together form the Line Total| |
| - | A quantified representation of the sum of all tax percentages. This follows the formula: | + | |
| - | + | ||
| - | Net Total * (Tax Percent / 100). | + | |
| - | + | ||
| - | The Net Total and the Line Tax together form the Line Total | + | |
| ====Units Delivered/Received==== | ====Units Delivered/Received==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes | + | |Quotes|No meaning| |
| - | No meaning | + | |SalesOrder|The number of units that have been delivered to the Organization.| |
| - | SalesOrder | + | |Invoice|No meaning| |
| - | The number of units that have been delivered to the Organization. | + | |PurchaseOrder|The number of units that have been received from the vendor.| |
| - | Invoice | + | |
| - | No meaning | + | |
| - | PurchaseOrder | + | |
| - | The number of units that have been received from the vendor. | + | |
| ====Cost Total==== | ====Cost Total==== | ||
| ^Context^Purpose^ | ^Context^Purpose^ | ||
| - | Quotes, SalesOrder, Invoice | + | |Quotes, SalesOrder, Invoice|The total cost price of this line, represented as an amount of money. This follows the formula:\\ Cost Price * Quantity| |
| - | The total costprice of this line, represented as an amount of money. This follows the formula: | + | |PurchaseOrder|This field should always be zero| |
| - | Cost Price * Quantity | + | ====Related Line Item ID==== |
| - | PurchaseOrder | + | |
| - | This field should always be zero | + | This field needs to be discussed. What I don't like is that it is uitype 1. Not only is this the wrong Uitype for an ID (should be 7 since it's always a number), it's also not a reference field. So if we decide to give some meaning to this field, we won't be able to use workflows on it. |
| - | ====Related Line Item ID==== | + | ^Context^Purpose^ |
| - | This field needs to be discussed. What I don't like is that it is Uitype 1. Not only is this the wrong Uitype for an ID (should be 7 since it's always a number), it's also not a reference field. So if we decide to give some meaning to this field, we won't be able to use workflows on it. | + | |Quotes|No meaning. Should be empty| |
| - | Context | + | |SalesOrder|References the InventoryDetails line on which this line was offered. So the context of the line referenced is a Quote| |
| - | Purpose | + | |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| |
| - | Quotes | + | |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.| |
| - | No meaning, should be empty | + | |
| - | SalesOrder | + | ===== Some Internals ===== |
| - | References the InventoryDetails line on which this line was offered. So the context of the line referenced is a Quote | + | |
| - | Invoice | + | ==== vtiger_productcurrencyrel ==== |
| - | 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 | + | This table holds the relation of the unit price of the product for each currency configured in the application. It contains two values: |
| - | 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. | + | |
| + | * 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 | ||
| - | 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. | ||
