Booking in stock from purchase orders will not accept fractional quantities

I have a number it stock item that sell as fractional quantities but can only be booked into stock from a purchase order in whole numbers.  If I raise a PO for 20 tonnes of sand, my supplier delivers say 18.76 tonnes which I need to book in as exactly that.  The system will only allow me to receive the stock in whole numbers. I note with interest this was waiting on a fix back in 2020. Anyone know of a fix or workaround??

 

177 Views
Message 1 of 2
Report
1 Solution
Square Community Moderator

Solution

Hi, @AtlasSupplies ! Welcome to the Square Community! 

 

Square still does not support receiving fractional quantities through purchase orders (e.g., 18.76 tonnes), even though items can be sold in fractional amounts.

 

Workarounds I've seen other sellers use: 

1. Manually Adjust Inventory

After receiving the full PO in whole units, you can:

  • Go to Inventory > Stock Adjustment

  • Subtract the difference to reflect the actual amount received (e.g., if PO says 20, and you received 18.76, subtract 1.24 manually)

2. Break Into Smaller Units

If it suits your operation:

  • Create a separate unit of measure (e.g., 1 tonne = 1000 kg)

  • Receive and sell in kilograms instead of tonnes, allowing fractional stock control (e.g., 18,760 kg instead of 18.76 t)

3. Split the PO

This is messy but can help track variances:

  • Close out the original PO at 20 t

  • Manually adjust inventory to reflect actual delivery

  • Add a note or second PO for partial receipt tracking

I know this may not have been the answer you were looking for, but I wanted to provide some workarounds I know have worked for others. I hope this helps!

View Solution >

174 Views
Message 2 of 2
Report
1 REPLY 1
Square Community Moderator

Solution

Hi, @AtlasSupplies ! Welcome to the Square Community! 

 

Square still does not support receiving fractional quantities through purchase orders (e.g., 18.76 tonnes), even though items can be sold in fractional amounts.

 

Workarounds I've seen other sellers use: 

1. Manually Adjust Inventory

After receiving the full PO in whole units, you can:

  • Go to Inventory > Stock Adjustment

  • Subtract the difference to reflect the actual amount received (e.g., if PO says 20, and you received 18.76, subtract 1.24 manually)

2. Break Into Smaller Units

If it suits your operation:

  • Create a separate unit of measure (e.g., 1 tonne = 1000 kg)

  • Receive and sell in kilograms instead of tonnes, allowing fractional stock control (e.g., 18,760 kg instead of 18.76 t)

3. Split the PO

This is messy but can help track variances:

  • Close out the original PO at 20 t

  • Manually adjust inventory to reflect actual delivery

  • Add a note or second PO for partial receipt tracking

I know this may not have been the answer you were looking for, but I wanted to provide some workarounds I know have worked for others. I hope this helps!

175 Views
Message 2 of 2
Report