Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Import credit card tra...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Import credit card transactions into D365. How do raise the invoice payable to the credit card company and not to the employees?

(0) ShareShare
ReportReport
Posted on by lmai 2,432

Hi All, 

We have credit cards with BOA.  These credit cards are giving to our employees to use for business purposes.  On the monthly basis, we import these credit card transactions into D365.  When we post those expenses transactions in D365, it hits AP (create liability) creates invoices to these employee vendors. 

Hotel expense (debit)  $2,600

Car rental (debit) $1,400

AP (credit)  $4,000

Because it hit AP, it created the invoices to employees A, B, C, D that incurred the expenses.

We don't want this result.  We wanted that it create one invoice to the credit card company which is BOA so that we can pay back BOA.  Thanks so much!

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Import credit card transactions into D365. How do raise the invoice payable to the credit card company and not to the employees?

    Thanks!  It work!

    pastedimage1670511596399v1.png

  • Verified answer
    Ramit Paul Profile Picture
    Ramit Paul 22,293 Most Valuable Professional on at
    RE: Import credit card transactions into D365. How do raise the invoice payable to the credit card company and not to the employees?

    Hi Kim,

    You can create a vendor as BOA and select offset account type as vendor and select that vendor from vendor list.

    When you post expenses, your liability should post into that vendor

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Import credit card transactions into D365. How do raise the invoice payable to the credit card company and not to the employees?

    Thanks, Amit, for your response.  Yes, the payment method is already the credit card company, BOA.  When posted the expenses, the invoices are created for the employees instead of for BOA.  Right now, the Offset account type is Worker.  Should it be something else?  Am I missing something in other places?  Thanks!

    pastedimage1670505092770v1.png

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,293 Most Valuable Professional on at
    RE: Import credit card transactions into D365. How do raise the invoice payable to the credit card company and not to the employees?

    Hi,

    Are you using D365 Finance and operations expense management?

    If yes, you can create a vendor as credit card company and add that vendor into a payment method in expense management.

    With the above setup any credit card transactions posted with the payment method will post to the vendor you created as credit card.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans