Hi,
I have been working with SOP's Picking Ticket Form. I have created a calculated field that takes the item master shipping weight and multiplies it times the qty field in the picking ticket form to provide a total line item weight for what is being "picked." The individual line item calculation is working correctly.
However, the bottom line sum of this field at the report footer is incorrect. It is doubled.
I have checked and changed table linking. I have added the item master table and the shipping methods table to this standard report linked to the sales trx amounts work table, and the sales trx work tables. I have tried linking to the temp table this report uses as well. Nothing fixes the bottom line total.
Does anyone have any suggestions for other areas of the report definition that I could check?
Louis Cooper
*This post is locked for comments