Symptom
More flexibility is needed in the calculation of units of measure (UoM) groups.
UDF (user-defined field) and weight factors are needed in the set up of Units of Measure (UoM) for base quantities, in addition to alternative quantities, to increase flexibility in UoM conversion rule calculations.
Solution
SAP intends to provide a feature package or patch to solve the symptom that is described in this SAP Note. The section References below lists the related feature package or patch once they become available. Be aware that References can only be confirmed at feature package or patch release date. SAP delivers feature packages or patches only for selected releases at its own discretion, based on the business impact and the complexity of implementation.
To allow for this requirement, the following changes are planned in SAP Business One, and SAP Business One, version for SAP HANA:
Unit of Measure Groups - Setup
The following changes are planned for the formula used in Group Definition - <Group Name> Setup for Unit of Measure Groups - Setup (follow path Administration → Setup → Inventory → Unit of Measure Groups → Group Definition for a group):
- The existing field UDF Factor is to be renamed Alt. UDF Factor.
- The existing field Weight Factor is to be renamed Alt. Weight Factor.
- A new field Base UDF Factor is planned between the existing fields Base Qty and Base UoM. Base UDF Factor is to have the same properties as Alt. UDF Factor and is not visible by default.
- A new field Base Weight Factor is planned between the existing fields Base UoM and Active. Base Weight Factor is to have the same properties as Alt. Weight Factor and is not visible by default.
The selection options and field value calculations for the two new fields Base UDF Factor and Base Weight Factor are respectively identical to Alt. UDF Factor and Alt. Weight Factor.
However, Base UDF Factor and Base Weight Factor differ in the way that they contribute to conversion calculations. An updated conversion formula is planned as follows:
- Alt. Qty x Alt. UDF Factor x Alt. Weight Factor = Base Qty x Base UDF Factor x Base Weight Factor
Therefore, the new conversion value for any document row where an Alternative Qty has been specified in Inventory Quantity = (Base Qty x Base UDF Factor x Base Weight Factor) / (Alt. Qty x Alt. UDF Factor x Alt. Weight Factor). The conversion value is then multiplied by the document line quantity to determine what the posted inventory quantity is for the document row (for document rows that cause an inventory posting).
As with Alt. UDF Factor and Alt. Weight Factor, Base UDF Factor and Base Weight Factor are ignored in the calculation formula if empty.
Previous to this change, the UoM conversion lines in the Group Definition - <Group Name> Setup worked according to the following formula:
- Alt. Qty x UDF Factor x Weight Factor = Base Qty
Previously, the conversion value for any document row where an Alternative Qty was specified in Inventory Quantity = Base Qty / (UDF Factor x Weight Factor x Alt. Qty). The conversion value was then multiplied by the document row quantity to determine what the posted inventory quantity was for the document row (for document rows that cause an inventory posting).
