topic Re: Paying company code in Application Development and Automation Discussions

Paying company code

Former Member — Tue, 30 Mar 2010 20:13:15 GMT

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.

Re: Paying company code

Former Member — Tue, 30 Mar 2010 20:24:11 GMT

Moderator message - Welcome to SCN. In BSAK, they should both have the same clearing document number (from the cheque) Rob

Re: Paying company code

Former Member — Tue, 30 Mar 2010 21:39:32 GMT

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).

Re: Paying company code

Former Member — Wed, 31 Mar 2010 01:23:27 GMT

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.

Re: Paying company code

Former Member — Thu, 01 Apr 2010 19:51:17 GMT

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.