Related topics
Supply quantity rounding types, which deal with the possibility to define rounding rules in percentage for pack size and/or pallets, are applied when Purchase suggestions and Internal replenishment suggestions are created automatically by the system via the Create purchase suggestions and Create internal replenishment suggestions menu items. The rounding rules in percentage determine if the automatically calculated suggested quantity should be rounded up or down to the closest number of packages and/or pallets, or if the packages and/or pallets are allowed to be incomplete. You also, optionally, have the possibility to enter a number of multiples that will always induce a round up (consider them complete when you reach a certain number of packages and/or pallets).
Note: If no defined rounding rules, via a Supply qty rounding type, are linked to the applicable item/warehouse combination in the Item file, then the system will not consider pallet quantity at all to determine the rounding, and will work as follows:
For automatically created Purchase suggestions:
The system will always round up to the next multiple of pack size (if Pack size is defined for the item and supplier combination on the Item file maintenance, Purchase prices, details panel). If Pack size is not defined, then the automatically calculated supply (suggested) quantity will not be rounded.
For automatically created Internal replenishment suggestions:
- The system will look for any Internal pack size entry for the item and warehouse combination (on the Item file maintenance, Inventory management panel, and round up to the next multiple of Internal pack size.
- If the Internal pack size is not defined, the system will look for any Pack size entry for the item and supplier combination (on the Item file maintenance, Purchase prices, details panel), and round up to the next multiple of pack size. If the Pack size is not defined, then the automatically calculated supply (suggested) quantity will not be rounded.
Options
| Add | Select this option to add a record. |
| Change | Select this option to change a record. |
| Copy | Select this option to copy a record. |
| Delete | Select this option to delete a record. Note: Deletion is not allowed when warehouses exist. |
| Display | Select this option to view a record. |
| Translate/Display translations | Select this option to either update or view information from the Table translation file. Displayed fields can be translated to any of the languages registered in Work with languages. |
Selection fields
- Rounding type
- This column lists the rounding type code.
- Description
- This column lists the description for the rounding type code.
- Pallet rounding
- This column, which is only available to display via the Edit column functionality if Warehouse Management is activated, denotes if rules are defined over how to round the suggested supply quantity in regards to full pallets.
- Pallet round up %
- This column is only available to display via the Edit column functionality if Warehouse Management is activated. This column denotes the percentage of a pallet quantity that will induce a rounding up to the next multiple of pallets.
Example:
Pallet quantity (defined in the Quantity in pallets field on the Item file maintenance, Warehouse management panel for the item) is 1000 stock units. Round up % is 15%.- Calculated Supply (Suggested) quantities >= 850 and <1000 will be rounded up to 1000
- Calculated Supply (Suggested) quantities >= 1850 and <2000 will be rounded up to 2000
- Calculated Supply (Suggested) quantities >= 2850 and <3000 will be rounded up to 3000
- Calculated Supply (Suggested) quantities >= 3850 and <4000 will be rounded up to 4000
- etc
- Pallet round down %
- This column is only available to display via the Edit column functionality if Warehouse Management is activated. This column denotes the percentage of a pallet quantity that will induce a rounding down to the previous multiple of pallets.
Example:
Pallet quantity (defined in the Quantity in pallets field on the Item file maintenance, Warehouse management panel for the item) is 1000 stock units. Round down % is 10%.- Calculated Supply (Suggested) quantities > 1000 and <=1100 will be rounded down to 1000
- Calculated Supply (Suggested) quantities > 2000 and <=2100 will be rounded down to 2000
- Calculated Supply (Suggested) quantities > 3000 and <=3100 will be rounded down to 3000
- Calculated Supply (Suggested) quantities > 4000 and <=4100 will be rounded down to 4000
- etc
- Pallet round up multiples
- This column is only available to display via the Edit column functionality if Warehouse Management is activated. This column lists the number of multiples of pallet quantities that always will induce a rounding up to the next multiple of pallets.
Example:
Pallet quantity (defined in the Quantity in pallets field on the Item file maintenance, Warehouse management panel for the item) is 1000 stock units. Round up multiples is 10.- Now suggested quantity >1000×10=10,000 will always round up to the next multiple of full pallets, no matter how the Round up % and Round down % are defined.
- 9999 will not be affected because it is less than the suggested quantity.
- 11050 will always round up to 12000.
- 14560 will always round up to 15000.
- etc
- Pack size rounding
- This column denotes if rules are defined over how to round the suggested supply quantity in regards to pack size.
- Pack size round up %
- This column denotes the percentage of a pack size quantity that will induce a rounding up to the next multiple of purchase unit pack size. (Note: On Item file maintenance, Purchase prices, details panel where the pack size is defined, please be aware that it is defined in purchase units. So if Purchase unit is BOX5 and Pack size is defined as 100, then the pack size in stock units that is used in all further calculations is 5×100=500 in stock units.)
Example:
Pack size (defined in the Pack size field on the Item file maintenance, Purchase prices, details panel) is 100. Round up % is 15%.- Calculated Supply (Suggested) quantities >= 85 and <100 will be rounded up to 100
- Calculated Supply (Suggested) quantities >= 185 and <200 will be rounded up to 200
- Calculated Supply (Suggested) quantities >= 285 and <300 will be rounded up to 300
- Calculated Supply (Suggested) quantities >= 385 and <400 will be rounded up to 400
- etc
- Pack size round down %
- This column denotes the percentage of a pack size quantity that will induce a rounding down to the previous multiple of purchase unit pack size. (Note: On Item file maintenance, Purchase prices, details panel where the pack size is defined, please be aware that it is defined in purchase units. So if Purchase unit is BOX5 and Pack size is defined as 20, then the pack size in stock units that is used in all further calculations is 5×20=100 stock units.)
Example:
Pack size (defined in the Pack size field on the Item file maintenance, Purchase prices, details panel) is 100 stock units. Round down % is 10%.- Calculated Supply (Suggested) quantities > 100 and <=110 will be rounded down to 100
- Calculated Supply (Suggested) quantities > 200 and <=210 will be rounded down to 200
- Calculated Supply (Suggested) quantities > 300 and <=310 will be rounded down to 300
- Calculated Supply (Suggested) quantities > 400 and <=410 will be rounded down to 400
- etc
- Pack size round up multiples
- This column lists the number of multiples of pack size quantities that always will induce a rounding up to the next multiple of pack sizes.
Example:
Pack size (defined for the item and supplier combination (on the Item file maintenance, Purchase prices, details panel) for the item) is 100 purchase units. Round up multiple is defined as 10.- Now suggested quantity >100×10=1000 purchase units will always round up to the next multiple of full packages, no matter how the Round up % and Round down % are defined.
- 999 will not be affected because it is less than the suggested quantity.
- 1105 will always round up to 1200.
- 1456 will always round up to 1500.
- etc
Work with supply quantity rounding types (INVD03704)
Note: This panel can be accessed in either Maintenance or Enquiry mode. In Enquiry mode, you are only able to view the information. The panel heading differs accordingly.
If you accessed this panel via the Display option, then you will only be able to view the information. To create or update a record, return to the previous panel and select either the Add or Change option (if available).
On this panel you create a new supply quantity rounding type or maintain an existing one.
Note: It is possible to define both a Round up % and Round down %. In such a case, and basing it on the examples where Round up % = 15% and Round down % = 10% for 1000 stock units, it means that sometimes the calculated suggested quantity will not be rounded according to pallet quantity, i.e., pallets will be incomplete.
Example:
- Calculated Supply (Suggested) quantity >0 and <850 will not round the quantity, i.e., pallet will be incomplete.
- Calculated Supply (Suggested) quantity >1100 and <1850 will not round the quantity, i.e., pallet will be incomplete. The result will be one complete pallet of 1000 stock units and one incomplete pallet (i.e., the remainder of the suggested quantity)
- Calculated Supply (Suggested) quantity >2100 and <2850 will not round the quantity, i.e., pallet will be incomplete. The result will be two complete pallets of 1000 stock units each and one incomplete pallet (i.e., the remainder of the suggested quantity).
- Calculated Supply (Suggested) quantity >3100 and <3850 will not round the quantity, i.e., pallet will be incomplete. The result will be three complete pallets of 1000 stock units and one incomplete pallet (i.e., the remainder of the suggested quantity).
- Supply quantity >4100 and <4850 will not round the quantity, i.e., pallet will be incomplete. The result will be four complete pallets of 1000 stock units each and one incomplete pallet (i.e., the remainder of the suggested quantity).
Note: Based on 1000 stock units for the Round up % and Round down % examples, if you enter Round up % = 50% (i.e. 1500) and Round down % = 50% (500), then the calculated supply (suggested) quantity will be half adjusted to the closest multiple of pallets.
Function keys
- Rounding type
- Enter a code to identify the supply quantity rounding type.
- Description
- Enter a description of the supply quantity rounding type.
- Pallet rounding
- This field is only displayed if Warehouse Management is activated, and is an optional entry. Indicate if you want to define rules over how to round the suggested supply quantity in regards to full pallets.
- Round up %
- This field is only displayed if Warehouse Management is activated, and is an optional entry. When the Pallet rounding field above is set to YES, at least this field or the Round down % field must be defined. Enter the percentage of a pallet quantity that will induce a rounding up to the next multiple of pallets.
Example:
Pallet quantity (defined in the Quantity in pallets field on the Item file maintenance, Warehouse management panel for the item) is 1000 stock units. Round up % is 15%.- Calculated Supply (Suggested) quantities >= 850 and <1000 will be rounded up to 1000
- Calculated Supply (Suggested) quantities >= 1850 and <2000 will be rounded up to 2000
- Calculated Supply (Suggested) quantities >= 2850 and <3000 will be rounded up to 3000
- Calculated Supply (Suggested) quantities >= 3850 and <4000 will be rounded up to 4000
- etc
- Round down %
- This field is only displayed if Warehouse Management is activated, and is an optional entry. When the Pallet rounding field above is set to YES, at least this field or the Round up % field must be defined. Enter the percentage of a pallet quantity that will induce a rounding down to the previous multiple of pallets.
Example:
Pallet quantity (defined in the Quantity in pallets field on the Item file maintenance, Warehouse management panel for the item) is 1000 stock units. Round down % is 10%.- Calculated Supply (Suggested) quantities > 1000 and <=1100 will be rounded down to 1000
- Calculated Supply (Suggested) quantities > 2000 and <=2100 will be rounded down to 2000
- Calculated Supply (Suggested) quantities > 3000 and <=3100 will be rounded down to 3000
- Calculated Supply (Suggested) quantities > 4000 and <=4100 will be rounded down to 4000
- etc
- Round up multiples
- The idea with this parameter is to avoid incomplete pallets when the suggested quantity is a large number of pallets. This field is only displayed if Warehouse Management is activated, and is an optional entry. Enter the number of multiples of pallet quantities that always will induce a rounding up to the next multiple of pallets.
Example:
Pallet quantity (defined in the Quantity in pallets field on the Item file maintenance, Warehouse management panel for the item) is 1000 stock units. Round up multiples is 10.- Now suggested quantity >1000×10=10,000 will always round up to the next multiple of full pallets, no matter how the Round up % and Round down % are defined.
- 9999 will not be affected because it is less than the suggested quantity.
- 11050 will always round up to 12000.
- 14560 will always round up to 15000.
- etc
- Pack size rounding
- Optional entry. Indicate if you want to define rules over how to round the suggested supply quantity in regards to pack size.
- Round up %
- Optional entry. When the Pack size rounding field above is set to YES, at least this field or the Round down % field must be defined. Enter the percentage of a pack size quantity that will induce a rounding up to the next multiple of pack sizes. (Note: On Item file maintenance, Purchase prices, details panel where the pack size is defined, please be aware that it is defined in purchase units. So if Purchase unit is BOX5 and Pack size is defined as 100, then the pack size in stock units that is used in all further calculations is 5×100=500 in stock units.)
Example:
Pack size (defined in the Pack size field on the Item file maintenance, Purchase prices, details panel) is 100. Round up % is 15%.- Calculated Supply (Suggested) quantities >= 85 and <100 will be rounded up to 100
- Calculated Supply (Suggested) quantities >= 185 and <200 will be rounded up to 200
- Calculated Supply (Suggested) quantities >= 285 and <300 will be rounded up to 300
- Calculated Supply (Suggested) quantities >= 385 and <400 will be rounded up to 400
- etc
- Round down %
- Optional entry. When the Pack size rounding field above is set to YES, at least this field or the Round down % field must be defined. Enter the percentage of a pack size quantity that will induce a rounding down to the previous multiple of pack sizes. (Note: On Item file maintenance, Purchase prices, details panel where the pack size is defined, please be aware that it is defined in purchase units. So if Purchase unit is BOX5 and Pack size is defined as 20, then the pack size in stock units that is used in all further calculations is 5×20=100 stock units.)
Example:
Pack size (defined in the Pack size field on the Item file maintenance, Purchase prices, details panel) is 100 stock units. Round down % is 10%.- Calculated Supply (Suggested) quantities > 100 and <=110 will be rounded down to 100
- Calculated Supply (Suggested) quantities > 200 and <=210 will be rounded down to 200
- Calculated Supply (Suggested) quantities > 300 and <=310 will be rounded down to 300
- Calculated Supply (Suggested) quantities > 400 and <=410 will be rounded down to 400
- etc
Note: It is possible to define both a Round up % and Round down %. In such a case, and basing it on the examples where Round up % = 15% and Round down % = 10%, it means that sometimes the calculated suggested quantity will not be rounded according to pack size, i.e., package will be incomplete.
Example:
- Calculated Supply (Suggested) quantity >0 and <85 will not round the quantity, i.e., package will be incomplete.
- Calculated Supply (Suggested) quantity >110 and <185 will not round the quantity, i.e., package will be incomplete. The result will be one complete package of 100 stock units and one incomplete package (i.e., the remainder of the suggested quantity).
- Calculated Supply (Suggested) quantity >210 and <285 will not round the quantity, i.e., package will be incomplete. The result will be two complete packages of 100 stock units each and one incomplete package (i.e., the remainder of the suggested quantity).
- Calculated Supply (Suggested) quantity >310 and <385 will not round the quantity, i.e., package will be incomplete. The result will be three complete packages of 100 stock units and one incomplete package (i.e., the remainder of the suggested quantity).
- Calculated Supply (Suggested) quantity >410 and <485 will not round the quantity, i.e., package will be incomplete. The result will be four complete packages of 100 stock units each and one incomplete packages (i.e., the remainder of the suggested quantity).
Note: If you enter Round up % = 50% and Round down % = 50%, then the supply quantity will be half adjusted to the closest multiple of pack sizes.
- Round up multiples
- The idea with this parameter is to avoid incomplete packages when the suggested quantity is a large number of packages. This field is optional. Enter the number of multiples of pack size quantities that always will induce a rounding up to the next multiple of pack sizes.
Example:
Pack size (defined for the item and supplier combination on the Item file maintenance, Purchase prices, details panel for the item) is 100 purchase units. Round up multiple is defined as 10.- Now suggested quantity >100×10=1000 purchase units will always round up to the next multiple of full packages, no matter how the Round up % and Round down % are defined.
- 999 will not be affected because it is less than the suggested quantity.
- 1105 will always round up to 1200.
- 1456 will always round up to 1500.
- etc
Work with supply quantity rounding types, Copy (INVD03705)
- Rounding type
- Displays the supply quantity rounding type(s) you selected to copy.
- New rounding type
- Enter the code(s) for the new supply quantity rounding type(s) that you are creating.