Importing csv files into Opera3 VFP for purchase ledger

claire-craig

Happy Monday everyone,

Just reaching out to see if anyone else has come across an issue with importing into the purchase ledger using CSV files.  I have a site who are still on 2.93.02 and their import into their purchase ledger (which they do monthly) is failing this morning.

I have brought their data back and a copy of the csv files and narrowed this down to the supplier account code being numeric, it is 199 but no matter how I reformat this in excel and save to a new csv I keep getting Rec 1 Invalid Entry (PT_HELD)

If i import it to a supplier account which is alpha/numeric, eg 199A it works fine???

Going crazy trying to suss what is going on and hoping someone out there has cracked this one before :-)

Regards

Claire

0811181026417683.xls

Steve Loader

Hi, Claire,

Yes, I had the same issue when trying to import all numeric Sales/Purchase codes.

We had named the codes in keeping with the associated VAT code so, for example, Sales Code 1 was associated with VAT code 1, etc.

Received the self same error when attempting to import the codes.

Couldn't find any way round it except, as you have suggested, to rename the codes to alphanumeric (e.g. V1, V2 etc.), and the import worked.

It seems to me as though the importer looks at the content of the fields of the first record imported, and second guesses their data type (i.e. it's an all-numeric code therefore data type is numeric). It appears not to do the sensible thing and use the data dictionary!

I raised an Incident in Infor Xtreme, but since the migration to Infor Concierge, most of my previous Incidents have been lost or closed, and I have no idea whether this request is still active within the system. Shambles!!

I hope that helps.

Steve