2010 Mar 30 9:13 PM
Hello All,
Has anybody here used Paying Company codes? I have two company codes 3000 and 9123. The Paying company code for 9123 is 3000 (this can be setup in transaction FBZP->All company codes).
I created two Non-PO invoices (FB60) for each company code with the same vendor
INV1 - $200 - Company code 3000 - vendor 0134.
INV2 - $100 - Company code 9123 - vendor 0134.
I went to transaction F110 (Payment run) and created payments for these two invoices. One payment was created for each invoice in the BSAK table
BSAK contents
Payment Row 1for INV1 - Comp code 3000 - Vendor 0134 - BELNR - 2000000045 - BLART - ZP
Payment Row 2 for INV2 - Comp Code 9123 - Vendor 0134 - BELNR - 2000000005 - BLART - ZV.
The PAYR table has the check information with VBLNR = 2000000045 (BELNR from Payment 1) for the combined amount of $300.
Imagine I have only the Payment 2 row. Does anybody know how I can get to the PAYR row with VBLNR = 2000000045 from Payment Row 2? There should be some table which connects 2 payments for the same check number.
Any input appreciated.
Thanks,
Ganesh.
2010 Mar 30 9:24 PM
Moderator message - Welcome to SCN. In BSAK, they should both have the same clearing document number (from the cheque) Rob
2010 Mar 30 10:39 PM
If i understood correctly, in BSAK- you can see AUGBL (Clearing Document) & BELNR (Invoice Document). In PAYR table you can see the clearing document in VBLNR and Check number (CHECT).
2010 Mar 31 2:23 AM
Thanks for the quick responses.
Hello Rob - In BSAK, only Payment Row 1 (with BLART=ZP) has AUGBL (clearing doc) as the same as the VBLNR from the row in the PAYR table. The Payment Row 2 (with BLART=ZV) has a different AUGBL than the row in PAYR. But I want to get to that PAYR row using the details in Payment Row 2 which I have no way to do.
Hello Satya - I have two payment rows in BSAK. One with BLART=ZP and another with BLART=ZV. The BLART=ZP row has the same AUGBL as the VBLNR in PAYR. So, I can easily find out the check number for Payment Row 1. But for the Payment Row 2 with BLART=ZV, I am unable to find the check number. Payment row 1 and Payment row 2 was paid with the same check (total check amount is $200+$100= $300). How can I find out the check number using the details in Payment Row 2?
Thanks.
2010 Apr 01 8:51 PM
I found the answer to this problem. If you are the BLART=ZV row (Payment Row 2) and want to find out other related payments use the BELNR, GJAHR and BUKRS on the payment row to query the BVOR table and grab the value of the BVORG column. Now, use that value in the BVORG column to query the BVOR table. Now, you will have a bunch of related payments.
Enjoy,
Ganesh.