Mapping and Shipping Costs - Must have Acumatica Experience!!!
Budget: $750 – $1,500 USD
1. Add a table called "Depots" and place under Inventory and Preference (see pic (1)). The table will have 2 columns
a. Zip
b. Depot
2. On the CS207510 screen add a column for "Trip Charge", this will be a $ value (see pic (2))
3. Add "Map Grid" field to FS300200 in the header
4. Add "Map Grid" to customer locations (AR303020) which which will be the closest Depot and "-" and zone (from 5-7) ***e.g. BUF-1, CVG-3, SYR-0***
5. Find the closest depot based on the distance from customer location zip code to the zip code of nearest depot from newly created Depots Table
6. Using google or bing API get the distance between the customer and depot
7. Using Shipping Zones select the appropriate zone
8. Populate step 3 with the above
9. When a new appointment is created (FS300200) automatically add a new line item for the non-stock item "T" and set the price based off the calculation from the customer location zone and add the price in column 3 of shipping zones (CS207510)
a. Zip
b. Depot
2. On the CS207510 screen add a column for "Trip Charge", this will be a $ value (see pic (2))
3. Add "Map Grid" field to FS300200 in the header
4. Add "Map Grid" to customer locations (AR303020) which which will be the closest Depot and "-" and zone (from 5-7) ***e.g. BUF-1, CVG-3, SYR-0***
5. Find the closest depot based on the distance from customer location zip code to the zip code of nearest depot from newly created Depots Table
6. Using google or bing API get the distance between the customer and depot
7. Using Shipping Zones select the appropriate zone
8. Populate step 3 with the above
9. When a new appointment is created (FS300200) automatically add a new line item for the non-stock item "T" and set the price based off the calculation from the customer location zone and add the price in column 3 of shipping zones (CS207510)