1.Functional Description
1.1Purpose
This function calculates a total quantity with shrink for a parent item by taking the passed
transaction quantity in the item's primary unit of measure, and increasing (or decreasing) that quantity based
on the shrink factor (IBSRNK) and Shrink Factor Method (IBSRKF), percentage yield (%) or yield
quantity (F), in the Item Branch table (F4102) for that item.
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
2.4Processing
Retrievals:
Retrieve Item Branch Table (F4102) using index: Branch, Item where Item Number and Branch/Plant are
equal to the values passed in the data structure. Get the Shrink Factor (IBSRNK) and Shrink Factor
Method
(IBSRKF) from the table.
Returns:
Calculated Quantity with shrink:
If the Shrink Factor (IBSRNK) is zero, assign the Requested Quantity (TRQT) to the Requested Quantity
with
Shrink (RQTE1), do no other calculations, end the function.
If the Shrink Factor (IBSRNK) is not zero:
Calculate a new Requested Quantity with Shrink (RQTE1):
Request Quantity multiplied by a value that
equal to
(Note: if the Shrink Factor Method (IBSRKF) is a percent sign, the Shrink Factor
(IBSRNK) is expressed as a whole percentage after math numeric adjustments. Dividing by100 is
required to adjust this percentage to a factor or rate.)
Quantity plus the Shrink Factor.
Factor (IBSRNK) is recognized as a quantity to be added to the originally requested quantity. Except
for math numeric activity, no adjustment is needed for the Shrink Factor as a quantity)
Return the new Requested Quantity with Shrink (RQTE1)
^
D3000230 - Calculate Qty With Shrink
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szBranchPlant | MMCU | char | NONE | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
mnRequestedQuantity | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnRequestedQuantityWithShrink | RQTE1 | MATH_NUMERIC | NONE | NONE |
The number of parent items that you want to process. The system calculates lower level values in quantity per the number of parent items
| ||||
cShrinkFactorMethod | SRKF | char | NONE | NONE |
A value that determines whether the shrink factor you enter for this item is a percentage or a fixed quantity. Valid values are:
%
| ||||
mnShrinkFactor | SRNK | MATH_NUMERIC | NONE | NONE |
A fixed quantity or percentage that the system uses to determine inventory shrinkage for an item. The system increases the planned order
|
None |
F4101 Item Master | ||||
F4102 Item Branch File |