Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Raheel Rao]

Hi all,

 

We’re using expense management and when importing transactions where the card number is for example ‘6080’, we get below message in the data management import job.

Results. The credit card import can’t be completed because the card ending in 6080 is a credit card number and is not allowed in the system. Please correct the import file to contain numbers in the format entered in the employee credit card form.
Results. Validations failed while writing entity record

These 4 digits are what identify a card(employee) in the bank’s transaction file. I also get similar error when I try to setup 6080 as the card number under HR>Employee>Expense>Credit Card but have found a work around where i’ll start with 16080 and it will let me save the last 4 digits. It’s same issue on PU31/10.0.7 and PU33/10.0.9.

The overall workaround I did was I changed the card number to something that system would accept but cannot continue doing that as the transaction file will always have 6080 and what if in future there is an actual card with the number i’m using here.

Has anyone else faced this issue with credit card transactions import? How did you resolve it? Let me know please.

 

Thanks,

Raheel

——————————
Raheel Rao
Solution Architect
Hickory Farms
IL
——————————

[Robert Lerner]

Hi Raheel.

Have you tried this:

1. Navigate to Human resources > Workers > Employees
2. Locate the employee with the credit card discussed
3. Then on the Action pane select Expense > Edit > Employee mapping and per diem
4. Once clicked on that button, you’ll get a message that the mapping has been done
5. Try upload the file again

Robert

——————————
Robert Lerner
Ducks Unlimited Canada
Stonewall MB
——————————
——————————————-

[Kerstin Newman]

I have to be honest, never came across that specific error before – but we’re on 10.0.8/PU32, and our file comes in with ************1234 as the number, and that’s how I entered it into the employee record, although it is not showing the * in the employee record at all.
There is a setting in the expense management parameters that determines how your credit card numbers are stored in the system:

You might want to play around with that to see if it helps? Good luck!

——————————
Kerstin Newman
Business Analyst
StarTech.com
London ON
——————————
——————————————-

[Raheel Rao]

Robert, that only allows us to setup the vendor and per diem which was already in.

Kerstin, that parameter worked! I changed to ‘hash card number’ and re-imported the same file and it worked.

Thanks both of you for your feedback!

p.s. Last challenge(hopefully) is to write up a script that re-formats the bank transaction file which right now comes in with unnecessary repeated heads and characters.

——————————
Raheel Rao
Solution Architect
Hickory Farms
IL
——————————
——————————————-