https://docs.google.com/spreadsheets/d/1zfdNI1wTGpkB5q0O3sxOrmb0Hjjt4_kEvOdTq91Apa4/edit#gid=1543307754
Record the following in Masterfile from the invoice:
Column A - DATE OF PURCHASE - this is the invoice date from auction company
Column B - PURCHASE FROM - This is auction company and location
Column C - SUPPLIER INVOICE NUMBER -This is invoice number
Column D - REGO NUMBER -This is car registration number ,if unknown mark as unknown
Column E - STOCK # - Get stock number from the table. Drag the cursor to get the next stock#
Column F - LOT- This is lot number from auction house
Column G - YEAR - Car year model
Column H - MAKE - Car Make i.e holden
Column I - MODEL - Car Model I.E commodore
Column J - INV AMOUNT - this is ex gst amount on towing invoice
Column K - INV AMOUNT W/TAX- this is with gst amount on towing invoiceColumn L - PROJECTED SALES - See Part 5 BID BUDDY
Column M - SUGGESTED BID - See Part 5 BID BUDDY
Column N - CRAIG GERLACH INV - Get details from Craig Gerlach invoice (This will be filled out once we have their invoice)
Column O - TOWING INV NUMBER - Get details from Towing invoice (This will be filled out once we have their invoice)
Column P - TOWING SUPPLIER - Get details from Towing invoice (This will be filled out once we have their invoice)
NOTE:
If REGO/LOT number from TOWING INVOICE isn't showing in the table, ask referral details from the towing company and then ask confirmation from that person to authorise invoice.
For SPECIAL CARS, use TOW REQUESTS tab and create a doc, make sure to share to everyone, and paste screenshot from courier