Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Epicor Units Forced to Whole Numbers

Status
Not open for further replies.

ChrisBlank

Programmer
Aug 7, 2013
4
Hello,

I need some serious help. Suppose I am using the configurator to order half of a gallon of paint per wall. The method rule would look something like this: JobMtl.QtyPer = (0.5) * Wall. Now let's say I only have one wall. If I run the configurator and input one wall, it will order "0" gallons of paint. I don't want to use the round function to fix this because I will be ordering much more material than I need in the end if I have more than one rule ordering the same type of paint.

Thanks for any help!
 
Found out what happened. When you copy to excel, the material quantities are forced to whole numbers. So be warned, the true quantity is only seen on the details page of that quote.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top