Need a way to calculate cost at time of receipt

[JFullam]

We're looking for a solution for our client utilizing JDE in the paper industry. Truckloads of newsprint are brought to the dock. The truck may contain multiple grades/colors/widths of material. The newsprint is on rolls and the weight of each roll varies. Each roll has a unique identifier (lot number). The cost per pound may vary by grade/color/width within the same truckload. Cost is tracked at the roll (lot) level. The scenario is: A truckload of newsprint shows up at the dock. Paperwork indicates a total cost $50,000.00 and a total weight of 50,000 lbs. Currently, on their legacy system, there is a DOS program that calculates the per pound cost to be $1.00 when the two values are entered. Then as each roll is entered in pounds, it is multiplied by $1.00. The client wishes to use inventory adjustments and issues to do the "ins and outs" in JDE, since implementing the purchasing module is not in their current plans. They're objecting to the fact that JDE can't perform the calculation that their DOS legacy app does. Without creating a mod, is there a way to do this calculation, even if we had to use purchasing?

 

[peterban]

Hi,

I had a similar requirement at a timber client, where trucks would turn up with 30 m3 of timber but this was made up of 2x2, 3x1 etc at a total cost of 1000gbp but cost and quantity needed to be atributed at the "2x1" level.

To avoid a mod we did the receipt against a "Bulk" item (e.g. WOOD) and then used reclassification to bring in the correct items/quantities. Its laborious but works!

Hope this helps a little.

Warm regards

Peter