Fractional Quantities
Description
This article describes how to manage fractional quantities in WMS.
WMS has the option to have the items as forced fractional for invoices/purchases/workorders out in decimal places.
You should set a fractional item right after create it (or at go-live).
Detail Steps
Turning ON Fractional Qty for New Items with no transaction history
Zero stock via Adjustment
Go to Item Inventory Card > Settings > Set fractional
Close and Save the change
Set stock countback via Adjustment.
Turning ON Fractional Qty option on any existing item/s
Modifying this option is ONLY recommended during the initial setup.
This creates a problem with the current and historical transactions and reports for these items.
Basically, historical sales, purchases, workorders will be incorrect. However, dollars still should be correct on reports, only qty incorrect.
There are some ramifications if you make items fractional after they have been used.
For example:- When you change the UoM to 1000 (turn on forced fractional), it affects historical orders and current item quantity (e.g. current item qty 5 after fractional qty becomes .005)
Make sure all Purchase orders and WorkOrders have been received and closed.
Make sure all Transfers and Sales has been Shipped and Closed.
Before starting step 1, please Backup WMS database File
Remove stock from the system via Stock/Item Adjustment
Add stock back after changing the setting (as per below) (make sure no OnHand/OnOrder/OnHold or Committed before ticking)
Log in as superuser and Go to item details > Settings and tick below
OR
7. Create new item/s and set the old items to be inactive with a Z prefix. This means that the reports will show a discontinuity at the point this is done.
NOTE: This can also be done in bulk by the superuser under Preferences > Security Tab >

Turning OFF Fractional Qty option
Modifying this option is ONLY recommended during the initial setup.
This creates a problem with the current and historical transactions and reports for these items.
Basically, historical sales, purchases, workorders will be incorrect. However, dollars still should be correct on reports, only qty incorrect.
Items with transaction history will require manual correction.
Make sure all Purchase orders and WorkOrders have been received and closed.
Make sure all Transfers and Sales has been Shipped and Closed.
Before starting step 1, please Backup WMS database File
Remove stock from the system via Stock/Item Adjustment
Add stock back after changing the setting (as per below) (make sure no OnHand/OnOrder/OnHold or Committed before unticking)
Log in as superuser and Go to item details > Settings and untick below
Select OK to Approve the change
OR Create new item/s and set the old items to be inactive with a Z prefix. This means that the reports will show a discontinuity at the point this is done.
Related Information
When an item is fractional, the UoM becomes 1000.
Go to Preferences > Inventory Tab > Make sure quantity format set to at least #0.00