Skip to main content
King County Logo
Apr
30

Smart Spreadsheet and Axway FAQ

  1. Home
  2. Finance & Business Operations
  3. Special Districts, Cities and Towns
  4. Smart Spreadsheet and Axway FAQ

Smart Spreadsheet and Axway FAQ

Use the v2.1 Smart Spreadsheet. This is compatible with both the 32bit and the 64bit Excel. 
Use the v2.1 Smart Spreadsheet. This is compatible with both the 32bit and the 64bit Excel. 
Use the v2.1 "Smart" Spreadsheet. This is compatible with both the 32bit and the 64bit Excel.
Use the v2.1 Smart Spreadsheet. This is compatible with both the 32bit and the 64bit Excel.

You may have experienced a connectivity issue or there may be invalid characters, such as extra double quotes, in the file.

Go to Axway and double check the uploads monitor to check if the .XLS file was uploaded instead of the csv file. If so, try uploading and selecting the csv file.

The sum of the Invoice Amounts for all transactions does not match the sum of all Line Amounts. Check that the sum of the Line Amount equals the Invoice Amount for every transaction. Correct inconsistencies as needed.
Enter CA for State and Country.
The Invoice Number associated with the payment is already in Oracle EBS for the payee. Please verify you have entered the correct Invoice Number and are not duplicating a payment.
You have submitted a CSV file with the same file name in the past. If you are using an AP Smart Spreadsheet, simply re-export a new CSV file and upload through Axway.
Double check the zip code to match with the City and State, double check the spelling of the address as well.
Check if a valid Fund # is entered.
Send an email request to Special Districts to reject the file in BPM.
Contact Special Districts and we will open a Help Desk ticket.
Right click on the file then delete.

Try using a fresh "Smart" Spreadsheet. 

Re-enter the fund number.
Yes. The entire file is rejected and a new file needs to be submitted.
Try using a fresh spreadsheet.

Go to "Configuration" tab and update the vendor options in Row 26 - "Use Vendor Tab for Warrant Entry?" You can choose "Yes" or "No" in the drop down menu.

Go to the "Configuration" tab of the "Smart" Spreadsheet to change the email address.

Try using a fresh "Smart" Spreadsheet.
Use a fresh spreadsheet and to copy and paste the vendor list.
The work around is to copy and paste the information into the spreadsheet.
expand_less