D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Closing Open PO's

  • 1.  Closing Open PO's

    Posted May 16, 2019 11:35 AM
    How do we close purchase orders in D365 that will never be invoiced?

    Christina Boster
    Kestra Medical Technologies
    Kirkland WA

  • 2.  RE: Closing Open PO's

    Posted May 17, 2019 12:46 PM
      |   view attached
    Hi Christina,

    There are 2 possible ways of doing this. The first example is during the normal operation, go to Accounts Payable > Purchase Orders >  All purchase orders. Then select one by one the PO's that you want to close and mark them as CANCELED with the button Purchase Order > Maintain > Cancel. Doing this you make sure that will no longer count nor in the inventory reserves neither the Vendor balance account.

    Second way, is the module close, when is performed, all the open (not invoiced) transactions are cancelled or deleted, this include the Purchase Orders. But normally companies perform this process annually, so I guess is so much time to have them open. 

    Michael Gonzalez
    Account Executive
    Dynamics Resources
    Venon Hills IL

  • 3.  RE: Closing Open PO's

    Posted May 20, 2019 02:13 AM
    Hi Michael,

    Could you please elaborate how to you initiate the "Module Close" functionality?


    Zvika Rimalt
    Functional Consultant
    Vancouver BC

  • 4.  RE: Closing Open PO's

    Posted May 20, 2019 12:03 PM
    We're still in AX 2009, and we have a number of purchase orders where we received the merchandise and never receive an invoice. We're a retailer - this is merchandise we resell, so we cannot cancel the purchase orders; we have to count the merchandise.
    • When the merchandise is received, the PO receipt causes a debit to our Received Not Invoiced inventory and A/P accounts.
    • One year after the merchandise is received, if there is no vendor invoice, we auto-generate
      • a journal entry moving the merchandise value from the Received Not Invoiced inventory account to our normal/primary inventory account
      • an invoice to clear the Received Not Invoiced A/P account,
      • a "payment" to clear the new invoice, crediting our "purchase variance" account. 
    We run this job once a month.

    Robert Menschel
    Lead Systems Engineer
    HD Supply Repair & Remodel
    Roseville CA

If you've found this thread useful, dive deeper into User Group community content by role