Overflow 6 Runtime error during Calculate of Physical Inventory

Everytime I try to calculate my physical inventory, i get an error " overflow

6 ...." I have tried creating a new physical inventory and only doing a count for a specific department so my item list wouldnt be so long in the physical inventory, but I am still getting the Overflow error. Any ideas to what is causing this to error? I am also allowing it to create its own Physical Inventory number. I still get the overflow error.
Reply to
Andy Miller - T
Loading thread data ...

Everytime I try to calculate my physical inventory, i get an error " overflow 6 ...." I have tried creating a new physical inventory and only doing a count for a specific department so my item list wouldnt be so long in the physical inventory, but I am still getting the Overflow error. Any ideas to what is causing this to error? I am also allowing it to create its own Physical Inventory number. I still get the overflow error.

Reply to
CptSoft

Overflow means that a value is being generated that is too big for the variable that is supposed to hold it. In this context, I would guess that you have an extremely large quantity entered in one of your counts (Like a SKU was scanned into the quantity field by mistake). When the calculate process generates the value of that item, it is multiplying the delta in quantity by the item cost of the item, and getting a value that is too big for the money data type.

It's possible that something else is going on, but that's the first thing I'd look for...

Glenn Adams Tiber Creek C> Everytime I try to calculate my physical inventory, i get an error " overflow

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.