web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Expense Categories for...
Microsoft Dynamics AX (Archived)

Expense Categories for Credit Card Import

(0) ShareShare
ReportReport
Posted on by Community Member

Hello, 

I have managed to import credit card transactions for expense management, in this example only one line. However, when I navigate to Enterprise Portal and create a new expense line, as you can see from the example, I cannot choose any of the expense categories which are currently set up. We have around 30 expense categories setup here and I would have expected the user to be able to select from the drop down of all categories. 

CC-Page.PNG

Is there a piece of setup I might have missed here which could be causing this?

any advice would be greatly appreciated on this as I feel like I'm so close to getting this process to work.

Regards, 

Bruce

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Bruce,

    Are the expense categories set to active in journals?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Active in Journals is ticked, yes. However, I noticed that allowed payment methods didn't include Credit Card. This has done the trick in bringing in the categories into the drop down.

    When I select 'add' Enterprise Portal doesn't add the credit card lines to the expense claim. I've tried doing this through adding new expense report and 'add unreconciled lines' when in an expense report and it just won't add the lines. Everything is filled in in the trvPBSmaindata table so guessing it must be a setup issue somewhere.

    Any ideas?

    Regards,

    Bruce

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Bruce,

    Has your payment method the parameter 'import only' set?

    If so, can you try to change that?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig, 'Import Only' is not ticked on the Payment Method. Have tried checking and un checking this and still getting the same issue.

    When I select 'add' Enterprise Portal loads information but the screen doesn't add anything. Have performed an IISReset as well to ensure no issue with EP.

    Regards,

    Bruce

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Bruce,

    Have you already checked LCS?

    There have been a couple of hotfixes released that deal with unreconciled travel expense transactions and alike.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    There is a PBS statement field and a PBSrecID field in the TrvExpTransTable, but I cannot find any relation to the TrvPBSMainData table. Is there something which should be populated in the TrvPBSMainData table which should be populated to allow this process to work and the PBSstatement field in the TrvExpTrans table to be ticked?

    I can't figure out at all why this process isn't working.

    Regards,

    Bruce

  • Community Member Profile Picture
    Community Member on at

    Hi Bruce,

    Typically when credit card transactions are imported, they come in with the expense category code provided by the card company.  You can map credit card codes to your expense categories by going to Expense Management>Setup>Calculations and Codes>Credit Card Category Codes.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans