Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

A/P to A/R "wash"

Posted on by 240

My boss wants me to post an accounts payable invoice against an accounts receivable account being that our customer is also our vendor. I am using Microsoft Dynamics GP version 9.00.0270 and I don't know how to do this. I couldn't find the information in the manuals, so I was wondering: can anyone help me with this?

Thank you!

Deanna Oaks

*This post is locked for comments

  • Constance Gilleland Profile Picture
    Constance Gilleland 1,290 on at
    Re: Re: Re: Re: Re: A/P to A/R "wash"
    I don't know of any automated way to do it either. You would simply have to apply a payment in the amount of the purchase order in the Received field of the invoice. If you need to capture it line by line, you could enter a markdown amount for each line item. This would require manual entry, however.
  • Deanna Oaks Profile Picture
    Deanna Oaks 240 on at
    Re: Re: Re: Re: A/P to A/R "wash"

    Thank you for your help here!

    The purchase orders are entered under the PO module as normal orders. Sales Orders are entered under the Sales module as a quote, then entered as an invoice upon shipment. The PO is currently entered with receipts against it. The Sales Order is at teh quote stage.  Currently the vendor and the customer files are not linked.

    I asked about issuing a check, but they want this to reflect on the customer's invoice. I don't know how to get it there, the way it is set up.

  • Constance Gilleland Profile Picture
    Constance Gilleland 1,290 on at
    Re: Re: Re: A/P to A/R "wash"
    You may not have the refund checks module. If you have the Advanced Management enhancement plan, it should be available to activate. If you have a different enhancement plan, you would need to purchase the module for $500 from your partner. This may serve your needs. It would complete the business flow to issue a check to your customer rather than crediting their account. However, you may be able to capture the same information by using the SOP/POP link functionality or a drop-ship PO to the customer. How are you currently entering the orders?
  • Deanna Oaks Profile Picture
    Deanna Oaks 240 on at
    Re: Re: A/P to A/R "wash"

    Here is the situation:

    Customer A has shipped us goods to use in Product X. We receive the goods against a PO receipt. We will not be receiving an A/P invoice to clear out the PO Receipt. The agreement with Customer A is that we credit the A/R invoice for Product X by the amount of the PO Receipt. I need a way to clear the PO Receipt against the A/R invoice.

    So, from what I read above, I should go in and set up the refund checks module, then link the customer to the vendor account and issue the transaction from the refunds check. When I go into my version of GP, I do not have "refund checks" as a menu item under tools>>setup>>sales....could it by my machine, or is this instruction for a different version?

    Now, I am not generating a payable, but rather a receivable credit. Does that change the process? Please advise.

     

    Thanks!

    Deanna Oaks

  • Constance Gilleland Profile Picture
    Constance Gilleland 1,290 on at
    Re: A/P to A/R "wash"
    Hi. Are you trying to issue a refund to the customer? If so, you can use refund checks under Transactions>>Sales. If it's not set up yet, you will need to set up the module under tools>>setup>>sales>>refund checks. You will need to enter a suspense account for the transactions on this window. Once you've set that up, you can link existing customers to existing vendors under cards>>sales>>customer vendor. You can also create new records from here in order to establish the link. When you are all set up, the transaction entry is quite simple: just go to transactions>>sales>>refund checks, select or enter a payables batch and checkbook, then select the customer you wish to pay. The system will present you with the total credit due to the customer so that you can generate a payable for them.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans