Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Integrating Purchase Orders and Purchasing Card Programs

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Our company is heavily dependent upon the Purchasing module for Accounts Payable purchases and I like that there is a record of an expected invoice, and we can also control when the expense is recognized in the GL through PO receipts.  

We also currently utilize a purchasing card (p-card) program through our bank that allows cardholders to reconcile charges in the program, record project information, and even PO numbers if they apply.  The P-card program then will spit out a GL entry that can be pasted into SL Journal Entry to record the transactions.  Obviously projects are hit, but POs are verified in Excel outside the system. 

Our problem is there is no link between the PO receipt and the entry referencing a PO meaning we have to check for correct receipt amounts separately (we've automated this a bit) but more importantly the unvouchered receipts report becomes totally useless as those receipts will never get closed out in the traditional sense.  

I recently ran into an issue where I see three PO receipts hitting the GL activity but I can't find anywhere those PO numbers were referenced in our monthly p-card entries.  

My challenge is to get both benefits of having the control of a PO and Po receipt but being able to pay via p-card for the financial benefits.  Is there any functionality third party or otherwise that could allow us to link bulk transactions such as a P-card entry with PO receipts so they are getting closed out properly? 

Thanks, 

-Jon

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integrating Purchase Orders and Purchasing Card Programs

    Since SL2011 the manual check entry screen added an option to record an electronic payment type as well as hand checks, which would be appropriate for recording your bank payments of the imported expense vouchers.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integrating Purchase Orders and Purchasing Card Programs

    Sounds like you are paying the credit card bill through AP then?  

    Our payment gets drawn from our account monthly so we have been recording the activity through GL entries, but if there is a way it could be entered through AP...that would be interesting.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integrating Purchase Orders and Purchasing Card Programs

    Your description sounds similar to an interface we setup for a client with Concur, which is a web based platform for capturing expenses. The Concur interface allows users to select from a fixed list of values; in this instance the client maintains a list available GL accounts for charges on the web site.

    Expense reports are reviewed/approved, then downloaded weekly to SL for TI into AP.

    Additional information may be captured and passed back to SL, like PO #s and Project IDs, which could be used for matching in AP.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integrating Purchase Orders and Purchasing Card Programs

    We are not aware of any such functionality in SL nor any third party product.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans