Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

PT FIle Edit

Error CODE

FIX
NEW HOST SITE LIST

From Bev at Pacific Pride this list is all hosts and sites as of 080120  It does not have the old host and sites in it. So you can at least get the base information for the new host and or site.

All_Sites.csv 

1

Hosts not in Xref File. Contact FleetCor for host information and sites tied to host number.   HOST missing: 779

Host 953 Error  1  The host is in the host file, but it appears to have a control code or something in the company field of the record. Open the file maintenance, hosts, key in host 953 and enter, it will open the record for host 953. enter to the company number field.  hit the delete key 2 or 3 times, then enter down until the Update appears and update the record. Now check the edit The error1 (and several others ) for host 953 should be gone.

3

new site code not found. There have been a few new site numbers not in the site file x-reference of 072120. Call Fleet core to get information on the site number either enter new site, or if site is a different number change site in HOLD FIle

missing sites Contact FleetCor for information to be added. Dont forget to add Tax by site information for the site as well.

know missing sites from Cross Reference file: 098064,098502,098503,098504,098506,098635,098638,     

5Your new host number does not have the company field set. Go to host file maintenance and enter the company number in the company field.
12

Missing tax code for the product.  Some sites were selling for example product 45. this was switched in the PT to 46. the Site Tax detail file does not have a record for product 46.  To fix open the tax file maintenance screen. Find the product you/they were selling. Likely 45 and the latest date for it,. That will likely have the same taxes as you need. Then enter down to the product code change it to the one you need and then enter down until you can do update. That will add a tax record for the product for that site. I have seen that to be mostly product 46 at most sites, that previously had 45. 


 

28Vehicle number on a type 1 card.  Remove the vehicle from the transaction in the hold file. You will either need to assign the new host to the card in the card file, or change the host in the hold file to the old host number to update.  There is an issue with the vehicle information in the PT file. FleetCor is aware and supposed to be working on a fix.
32

Identity invalid. The PT file is not sending the Identity field from the PACPRIDNET.COM website set up on the card. It is sending the PPSI Account number.  FleetCor is aware and working on a fix.

You can update the information in the HOLD file.  you will need to set the host to the old host or change the card as in error 28. You can enter the correct identity code for the card and update.

For Those that have Identity numbers different than the Customer number. Go to Periodic menu,  Run the Reassign Identity & Card Type. Choose A fo audit to see what the hold file has verses the card file. To only change the card file to match what is in the hold file for the Identity choose I and run. It will change all of the cards tagged in the hold to what the hold file has as the Identity number. 

34This is selling Site Host does not match the Owning host number where the Product was purchased.   There have been a few Site controllers that were set with the wrong site info.   To validate, check the host number in the AFS Site file for the site the transaction says it was at.  If it does not match to the selling host the transaction said it occured at then you have a site host mismatch.  Call FleetCorr to verify the host and site the transaction occurred at.  Then either adjust the transaction to match what they say, or if the transaction is correct, then look to make sure the host for the site in the site file is what FleetCor says it is.  Also check to make sure the Host they say the site belongs to is in the host file.  Also both the transaction AND the AFS site file may be different than what FleetCor says they should be. If that is the case you will have to change both the AFS Site record, and the transaction record. Also check that the host FleetCor gives you is in the host file in AFS.
351.Make sure you have loaded the OPIS cost/price file for the matching day of the transaction. Lagging transactions, may not have an old enough OPIS price record.  If the Product is a new product for your site. Inform Fleet core that you need the costs for that product included in the OPIS File for your site(s).  Get a cost and taxes and go to the MAINT>PRICES>OPIS PRICE record, and enter a cost record for your site and product and date that is missing .
35 on reversal recordsThe reverse transaction from FleetCor5 are coming in the PT file with out any original ransfer cost in them.  So since the cost is zero the application goes to the OPIS cost file to get a cost and it is not there because the cost file is only for PPSI Network sites. Not retail sites. Why can they not send the reversal to include the original trans cost on the retail. To fix: list the Edit with the error 35 reversals. You will need the amount that shows in the Unit Cost field.  1 Go into Maintain Hold file records. Find the reversal record and go to the UNIT Cost field enter the cost from the original transaction less the amount showing in the bad edit with the error 35.  This will be the transfer cost. This will clear the error 35, and clear the bad ransaction.
Retail site not pricing as Retail

See V101patch above. To Fix.  log out of Autofueling.   Download the V101Patch-setup.exe to downloads above. Run as administrator. DO NOT SAVE the v101patch folder to program files, save it to your autofuel folder.  When it runs it will ask the same questions as the V101install did Source Drive, target Drive, mod version, server folder if applicable. It will then backup the programs folder and apply the patched program.  Patch load Complete.


Product 1,2,3 being sent instead of 42, 43, 44,. for some sites.
  1. It has been reported that some sites that use to send 42,43,44 are now sending product codes 1,2,3.   These sites may have old tax by site rates for those product codes.  A. Check the Tax detail by site in Tax file maintenance. for the site in question and check the date of any tax records for products 1,2,3 and the rate. The latest date and rate for a product will be what is being used.  B. if they are bad rates, on old old dates. pick the latest date for the product in question, enter down and put in a new date, and then enter the correct rate, and update. That will create a new tax record for that site, product and date.    
Factor TAX GroupsIf you have Factor tax groups set  for specific sites in the Tax Definitions file. You will need to add the Definitions defined for the old site number to the new site number.  If you do not have specific sites set in the Tax Definition then the global definitions will work with the new sites without adjustments.   You may have to contact Factor to set up the new sites in your GL import on Factor.
OPIS COST By SITE

The Opis Cost by site has just 2 figures. A Base cost, and then a Taxes Figure.  The Base is made up of Base Cost Plus ,08 Network markup Plust .05 haul rate for Gas or .06 Haul rate for Diesel.

Taxes are lump sum, and may or may not include all the local environmental or fees.  If you have a break down of you local taxes, Take the number in the file and subtract out the Fed and State Excise taxes. Then the amount for LUST and OIL SPILL.  That should leave the local ENV and Fee's amount.  There could be rounding differences.  

Tax rate updates

The PT file does not add new sites or update tax rates like the LOCBILL File did. To change rates globally, use the global tax rate change menu in tax file maintenance.  Make a backup before you run any tax rate changes just to be safe.        

...