Checking Freight CHARGES

·         Open Freight invoice from admin inbox

·         Open  Freight Masterfile

 

 

·         Get the DATE RANGE of the invoice

·         From the first date to last date in the invoice

For example:

 

 

 

·         Go to PINNACLE

·         Management – Sales Report – S12 Full invoice

 

·         Parameters

 

·         Date Range – Select Date Range then enter the date range from the invoice

·         Order By – Invoice #

·         Click ok

 

 

·         Click  Save to Excel

·         Save excel to desktop

·         Excel File will appear

·    delete column B,C,D,E,F,G,H,I & K this columns is not needed for checking

·     After deleting copy column A invoice number and B freight total

 

·         Paste into Freight Masterfile and sort data by the invoice number

 

·         The invoice numbers and amount in red colour are from in pinnacle

·         The invoice numbers in white are from AXIOM

·         Now let’s check the invoices

If the difference of invoice amount from PINNACLE is below $20.00 it is okay

Ex:

 

If the invoice number is from EBAY even if it has no charge in Pinnacle or above

$20.00 in difference they are also okay

 

If the supplier is SMASH REPAIRS, EBAY, PANEL & PAINT or BODY REPAIRS suppliers they don’t need to pay for the freight

 

 

 

 

NOTE:

What if the difference of the invoice is over $20.00 and not from EBAY or Smash Repairs supplier?

 

(Toll Ipec) Update the Freight Issues Table enter the following Details:

- JJ reference number

- Amount charge by Ebay

- Amount charge by Toll IPec

- Parts 

 

After updating Table email ebay@jjautoparts.com.au advising table is updated

link to Freight Issues Table:

FREIGHT ISSUES table