A/P Matching 2 vendors

dale_draper

Well Known Member
I've got receipts against two different vendors that we want to pay through
only one of the two vendors. But we don;t seem able to AP match two vendors
on one voucher? Does anyone know how to do this? JDE doesn't (yet)

Vendor A ---PO Receipt
Vendor B ---PO Receipt
Vendor B---Voucher match A and B's receipts on one voucher.
 
I am going to try to recall some of my AP memories here. I think that you can do
this as follows:

Create two vouchers using voucher matching
voucher 1 payable to vendor A leave as is
voucher 2 payable to vendor B change the alternate payee to vendor A

Each voucher is recorded in the AP ledger information as per the PO and receipt,
although the checks get cut to a single vendor.

A7.3 cum 11 AS400 V4R5
 
The system will allow you to receive multiple receipts for multiple vendors, and
pay only one vendor as long as you setup the special payee number in the address
book.

vendor A has special payee of vendor A
vendor B has special payee of vendor A
vendor C has special payee of vendor A




____________________Reply Separator____________________
Subject: A/P Matching 2 vendors ~~0:4048
Author: <[email protected]>
Date: 01/16/2001 8:08 AM


I've got receipts against two different vendors that we want to pay through
only one of the two vendors. But we don;t seem able to AP match two vendors
on one voucher? Does anyone know how to do this? JDE doesn't (yet)

Vendor A ---PO Receipt
Vendor B ---PO Receipt
Vendor B---Voucher match A and B's receipts on one voucher.






--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=4048
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Without more detail I'm taking a basic approach in my response. You could
change the Payee field in voucher entry or in speed release to reflect vendor
B address number for both vouchers.

Sandra Scribner
SCB Enterprise Solutions
401-421-9910 ext 16
[email protected]
[email protected]
 
The problem is that both vendors still exist as payees separately.
The reason we have receipts against one and want to pay the other is that
the newer vendor purchased part of the original vendors business and PO's
were recevied against the old vendors AB#. We still purchase from the
original vendor.
It's not a problem if you only AP match vendor A and pay vendor B,
the problem is when AP/PO matching A+B and paying B.


>
 
Provided that you book the receipts separately to different vendors one
could only change the "Alt Payee" field in the voucher. (in the fold area).
If this is always the case for these vendors then change also the address
book and the vouchers automatically will pick the correct alternate payee
upon creation.

So both the invoices should have the same Alternate Payee (Vendor B in your
case)

The best way to settle then the payment is thru the Automatic Payment
Processing procedures. The Create Payment Group program (P04570) has the
processing option 6 to do exactly this.

Im not sure but you cannot pay both vouchers together thru manual payment
processing. Of course you can still pay the separetely.
 
The Alternate Payee field is not available on the 4314 (Match Voucher to
Open Receipt ) screen, only the 4105 (standard Voucher Entry).

>
 
Dale, you need to create the vouchers first and then using either standard
invoice entry or speed release change the alternate payee.
 
This override in the payee field (found in the fold area) will be for the
line within the receipt in question only. The override at the line level of
the voucher doesn't change the Supplier Master payee information for either
Vendor A or B thus will not impact future transactions for Vendor A or B.
Scenario: You have 1 PO receipt with 3 lines/ products, where 2 lines need to
be paid to Vendor A and the third to Vendor B.

If my understanding is incorrect could you provide an example. Will this be
an on-going concern or is it a timing issue based on Vendor B purchasing part
of Vendor A
inventory?

Sandra Scribner
SCB Enterprise Solutions
401-421-9910 ext 16
 
This is the scenario,

PO receipt #1 has vendor A as supplier
PO Receipt #2 has vendor B as supplier

Vendor B invoices on invoice XYZ and bills for both #1 and #2 on that
invoice.

I suppose I'm going to have to SQL update the vendor # in the F43121 file.


>
 
Dale,

There is a way to do the scenario that you described without doing SQL after the
fact.

In OW:
Enter in your invoice information on the 'Match Voucher to Open Receipts'
(supplier # is the one you want to pay)
Select the receipt for the 1st PO & return to the voucher match screen
Select the receipt for the 2nd PO - you will have to change the supplier # on
the 2nd screen (Select Receipts to Match) & return to Voucher Match screen
Your gross amount should total your invoice total. This will all go against
the supplier # that shows in the top half of screen.

We are on B732, so hopefully it will work on your release. Any questions you
can email directly at the address below.

Beth Cuda
Custom Edge, Inc.
[email protected]









dale draper <[email protected]> on 01/16/2001 03:09:47 PM

Please respond to [email protected]








To: [email protected]

cc: (bcc: Beth Cuda/CEI)



Subject: RE: A/P Matching 2 vendors ~~4048:4085









This is the scenario,

PO receipt #1 has vendor A as supplier
PO Receipt #2 has vendor B as supplier

Vendor B invoices on invoice XYZ and bills for both #1 and #2 on that
invoice.

I suppose I'm going to have to SQL update the vendor # in the F43121 file.


>


--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=4085
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Back
Top