I think this is a bug that has been around for a long time – maybe back to Vantage 6.1. Not sure about the cost ramifications but there has been a known issue with scrap calculations that make the required quantity of material (including the scrap) be wrong. Especially when percentages are used rather than a fixed number of pieces of scrap.
The long a short of it is what is added to the material quantity for the job is not the calculated scrap but number of pieces or the percentage number. I suppose this then gets multiplied by the unit cost making that also be incorrect. It has been driving me nuts lately trying to get the Job Traveler to show a correct amount to issue to the job because we have added a BPM check when ending activity and reporting quantity to make sure sufficient material was issued. It’s a hard exception to it stops them if they have not issued enough.
Example job is for 50 pcs with 5% scrap so 2.5 pcs rounds up to 3 for 53 pcs. Material required per piece is 4 lbs so 53 X 4 would be 212 lbs. But what gets calculated is 200 + 3 for 203 lbs and they will be under issued. Cost would be low too. If required qty is less than 1 (like .5) I could see it going the other way when adding scrap pcs instead of quantity of material. We are on 10.0.700.4 and it is still just like when we were on Vantage 6.1. We’ve mentioned it to Support and they can duplicate it but it has never been fixed as far as we know (we skipped 8 & 9).
-Todd C.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 29, 2015 4:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quoting with material scrap costs not calculating properly - 9.05.702A
Our quote worksheet is not calculating the material cost correctly if we are use scrap.
Example: Line is for qty 1 EA
Material is a resin with .05 LBS per part
Unit cost of the material is $121.44 per LB
This calculates on the worksheet correctly: $121.44 x .05 = $6.072
If we add 30% scrap for the material, the worksheet calculates our material cost incorrectly as $8.50080 instead of $7.8936 ((121.44 x .05) x 1.30) per part
If I change the quantity break from 1 EA to 1,000 EA, then I get the right cost of $7.8936 per piece.
Anyone else experience this? Is there a fix for it?
When I called support, they said it had something to do with the UOM. Thanks in advance for any help!
Bethany Rye
Epicor Business Analyst
PTI Engineered Plastics