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

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Integrating Purchase Orders and Purchasing Card Programs

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    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.

  • Community Member Profile Picture
    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
    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
    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.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans