Import Pay Bills Issue

[Shinta_Rigo]

Hi All,

Hope somebody can help me... I'm trying to import pay bill to my new company file but always get error "-251 Supplier not found. Pay Bill not imported." I've check the supplier already in the supplier card.

Thanks you,

[TingSpace · Accepted solution]

@Shinta_Rigo

Hey there!

I noticed that you're using the Record ID there (970), this can cause odd behaviour if it's not the correct ID in the database itself. Though I will mention that it is redundant if you're not matching using this criteria.

I personally re-created the Supplier and created a Purchase with the same date, amount & Supplier Invoice# and it allowed me to import this data without the Record ID. I would obviously encounter the same problem because of what I mentioned before as my Supplier Card does not have the same Record ID.

I'll assume you're matching using Co./Last Name, in which case if you remove Record ID it may allow you to import this type of data.

Let us know how you go!

~TingSpace

[Shinta_Rigo]

Hi @TingSpaceTingSpace,

Thanks for your reply. I've tried it and it's works. But when I try to import all the data, it's seems that import process only read the 3 first record and still with error BillDate error, etc. But I think I'll ignore this error because after I check the new comp file, the pay bill data already there (I assume it's from field amount paid from purchase service) but have different cheque number, payment date, etc. But it solve with edit it manually. 

Thanks a lot @TingSpaceTingSpace