Accounts Payable to Accounts Receivables Cash Receipts

SUGGESTED

I know there is the AR => AP function for this, but not an AP => AR.

We have clients that are both Vendors and Customers.

Lets say as a Vendor, we need to pay Invoice 0001 totaling $100 to them.

Lets say they are also a Customer and they need to pay us Invoice 50120 totaling $275

They send us a check for $175, with a credit memo for the $100 on the check.

How I've instructed AR to record this, is to make an adjustment to the Invoice in AP, reducing it to $0.
Then to enter a Credit Memo in AR, with invoice # 0001-CM , for example.
Then to do a cash receipt, and select invoices 50120 and 0001-CM as the invoices to pay.

would anyone do this a different way?

Thanks!

2013 ERP 100 Advanced

  • 0

    It would reduce it to 2 steps to transfer the AR balance to AP with the clearing function, leaving you 2 open items in AP that net to -0-.  Then either at that time or some later time, do an AP manual check entry beginning with "APP" to apply the invoice(s) and credit(s).  It also makes the original entries appear as paid,  instead of adjusted off, and saves the data entry person the concern of entering the adjustments to post to your GL account of choice instead of using the "normal" items.

  • 0
    SUGGESTED

    The AR => AP utility can be used to transfer credit balances for refund from AR to AP as well as apply AR balances against AP invoices.

    To apply an AP invoice to an AR invoice;

    1) Create a link between the vendor and customer under AP/Setup

    2) In AP/Period End, run the AP from AR Clearing Selection and be sure to set the flag on the option "A/R Transfer Amount Cannot Exceed A/P Balance Due".  Also, you can restrict the Customers processed based upon number to further refine your selection.

    3) Open AP from AR Clearing Entry to further refine your process.  Using your example, apply $100 of the AR invoice balance to the outstanding AP invoice, thus leaving a balance of $175.

    4)  Process the AP from AR Clearing Register and post.

    The above can be done either before or after you process and apply the $175 payment from the customer.