D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Credit Card Transaction Import Error/Cannot use credit card number

  • 1.  Credit Card Transaction Import Error/Cannot use credit card number

    Posted Mar 20, 2020 12:12 PM

    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Credit Card Transaction Import Error/Cannot use credit card number

    Posted Mar 23, 2020 08:55 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Credit Card Transaction Import Error/Cannot use credit card number

    GOLD CONTRIBUTOR
    Posted Mar 24, 2020 07:14 AM

    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Credit Card Transaction Import Error/Cannot use credit card number

    Posted Mar 24, 2020 03:46 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role