The problem is that there are only 2 definable cost fields in Adagio Inventory. We use most recent cost for the most recent cost. We use standard cost for our sales reps to determine commissions. We use definable cost 1 for blended cost which is required for prorating with POA. We have only 1 remaining cost field.
19" - 29" TV's for example have a recycle fee of $10.07 in Ontario. In Alberta, the same 19" - 29" TV has a recycle fee of $25.
Your solution is good for collecting and remitting recycling fees for one province but we are required by law (so I've been told) to collect and remit for multiple provinces.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario