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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Using Purchase Order Module for Accruals

(0) ShareShare
ReportReport
Posted on by 195

To avoid using manual GL entries and to implement 3-way matching, we have begun using the PO module to process payables and to accrue for utilities at month-end. To recognize the expense, we determine the amount that should be accrued, and then Receive (but not invoice) the PO Items – this hits the expense account and a temp A/P account. When the invoice comes in the following month, we then Invoice the PO Items, which moves the balance from the temp account to Accounts Payable. The problem is that we do not communicate the PO# to the vendor, as we only use this system for our own purposes. Actually identifying a utility that that has been accrued for is easy to miss - we end up creating a separate PO for something that we really should be invoicing against an already created PO. Is there any way to flag a PO that has been received but not invoiced when entering a new PO under the same vendor? Essentially we need a way to flag POs with status "Received" when creating a PO for the same vendor. Our current process for this is to print out a list of Received POs, and match every utility invoice that comes in against the list to make sure we didn't accrue for it. As we have nearly 100 branches and are still growing, the process is becoming more tedious and time consuming. Thanks.

*This post is locked for comments

I have the same question (0)
  • Michael R.  Bloom Profile Picture
    130 on at

    If not already aware you may want to try using either of the following reports

    Smartlist-->Purchasing-Receiving Line Items-Shipments Received but not invoiced

    or

    Reports-Purchasing-Analysis-Received/Not Invoiced

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    You don't need to issue a PO to enter a receiving transaction, you can enter the receipt without a PO.  That might be a better option for you.  You should also run the Received not Invoice report or SmartList to identify receipts that haven't been invoiced.

  • zrisso10 Profile Picture
    195 on at

    I appreciate everyone's help thus far. The decision to use POs was not mine, but manangement insists this is how we are now doing things. Yes we currently are pulling the smartlist report of invoices received not invoiced, a process which has proven very time consuming. I need a way to be prompted when I'm entering a PO for a vendor that already has an open PO. Or maybe another way - prompt me when I'm receiving an item that is already received and not invoiced in another PO. Hopefully that makes sense - I know my request is a long shot because the PO module is not normally used in this manner.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    This is indeed a strange request. You say when your utility bill comes in you want to accrue this expense. How do you have a shipment of your electric bill? Do you receive in X number of KWh and do a matching invoice of KWh's? The only way you can get a warning would be to write a little VBA or VS code to scan your open PO's and then pop up a window to alert you to this fact.

  • Jonathan Fear Profile Picture
    on at

    Any update on the resolution? This is a post that is getting a large number of views so we would like to get a confirmed resolution.

  • zrisso10 Profile Picture
    195 on at

    We are accountants, and don't write code. So this is the "answer" assuming it works.

  • zrisso10 Profile Picture
    195 on at

    To be clear, I have no idea how to write code, so I cannot verify if this is a resolution or not. As I was pressured to mark the post as "answered" I will do so, and seek help elsewhere

  • Jonathan Fear Profile Picture
    on at

    No one is pressuring you. We simply want to know what the answer is so if another customer is running into this they can see this and go right to the answer.

  • zrisso10 Profile Picture
    195 on at

    So can you write some code for me to implement then?

  • Jonathan Fear Profile Picture
    on at

    No we wouldn't write you custom code. You would need to reach out to a partner that can do this for you.

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans