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

  1. Zero stock via Adjustment

  2. Go to Item Inventory Card > Settings > Set fractional

  3. Close and Save the change

  4. 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)

  1. Make sure all Purchase orders and WorkOrders have been received and closed.

  2. Make sure all Transfers and Sales has been Shipped and Closed.

  3. Before starting step 1, please Backup WMS database File

  4. Remove stock from the system via Stock/Item Adjustment

  5. Add stock back after changing the setting (as per below) (make sure no OnHand/OnOrder/OnHold or Committed before ticking)

  6. 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.

  1. Make sure all Purchase orders and WorkOrders have been received and closed.

  2. Make sure all Transfers and Sales has been Shipped and Closed.

  3. Before starting step 1, please Backup WMS database File

  4. Remove stock from the system via Stock/Item Adjustment

  5. Add stock back after changing the setting (as per below) (make sure no OnHand/OnOrder/OnHold or Committed before unticking)

  6. Log in as superuser and  Go to item details > Settings and untick below

  7. 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  to activate fractional qty entry in Orders. Only Superusers can make these changes.