For tax reasons, I need to report all sales shipped out of my local city. I am using the shipping function in RMS, but it is not integrated with a carrier. I need a report which shows the sale amount, the ship-to city & state, and the date. I am happy to do this is sql, but I need to know what tables to use.
Thanks, Julie