My current favorite Y Problem this time of the year:
“I need a list of items and their values shipped by state”
This can be a complicated problem with drop-shipments, one-time only shipments, complicated business arrangements, etc.
The X problem: For Tax reasons, I have to report business with specified government agencies. These can be States or Countries and the sales has to be reported regardless if any tax is due. So far, the easiest solution I have found is to use what Epicor already supplies: Sales Tax reporting. You set up codes for the various reporting agencies (with zero rate if necessary), assign them at Order time (maybe using defaults on ship to records to help) and then run the standard Epicor Sales Tax report. Done.
It’s the one solution that handles situations like:
“Ship the product to the integrator in State A and they will ship the solution to customer in State B”
“Ship product to Port Forwarder in State A but report the sales in country B”
which are not picked up correctly in a BAQ of packing slips.