Accounts Payable Import Tips and Tricks

Common Errors and Resolutions

Supplier not found

Error Description: Line 13: Supplier Fashion by Nicole could not be found.
Resolution: The supplier name in the import file (column D - supplier_company_name) does not match with a supplier in the system. Check to make sure that the name matches. The complete name needs to match.

Negative balances come through as zero amounts

Error Description: No error is shown on the import, but negative supplier amounts show as 0 on the bills.
Resolution: The amount in the import file needs to be formatted with -, not (). So if the Supplier balance is that they owe you $500, then the amount should be -500.

Error Description: Bill - description can't be blank.
Resolution: This is due to the Make Supplier’s Inv # Required and Unique per Supplier setting is enabled. 
Need to modify the template by adding two columns: description and internal_ref (both required).