Create an Excel Macro to review invoices
Budget: $20 – $100 AUD
We need a macro to review invoices. It should link the freight rate invoices to the standard rate card, destination zones and original order details.
For each line, review the postcode and the weight find the corresponding freight rate in both eParcel and eParcel wine services, and input these rates into separate columns in the freight invoices. Also, enter the product description and quantity in separate columns.
After that, compare the freight charges to the calculated rates and highlight the discrepancy between those rates.
For each line, review the postcode and the weight find the corresponding freight rate in both eParcel and eParcel wine services, and input these rates into separate columns in the freight invoices. Also, enter the product description and quantity in separate columns.
After that, compare the freight charges to the calculated rates and highlight the discrepancy between those rates.