Payment made and payment received

[pranav_gupata]

Hi Expert,

we need total Made payment either vendor or normal expenses as well total payment received from customer or others , i have seen number of transaction code where one by one .getting much time to make a report.

like table wise Vendor BSAK  and BSAD,BSAS in this report while take dump in Excel all payment made including Clearing Document number also calculate . so amount is not matched how much payment given . i mean double entry showing like advance case. Document type KA, KZ..

we need the report where how much payment made and how much payment received. as per Managment point of view.

Kindly help me for the same.

yr quick action will be highly appreciated.

Kind regards

Pranav Kr. Gupta

[former_member184878]

Hello,

maybe taking a look on table BKPF and searching for BLART = KZ (payment to vendor) and BLART = DZ (payment customer)

could be helpful for you.

You get BELNR GJAHR and BUKRS with  this information (KEY) you can find adocument in BSAK and BSAD.

In table BSEG you should find in field HKONT bank GL account.

This means that posting was against bank account.

Also take into account field WAERS if relevant for your business.

all the best erwin

[Former Member]

Hi Pranav,

consider the table PAYR for all payments have been done from your house bank.

along with that if you want to consider any open invoice combinations consider the the tables BSAS, BSAD & BSAK

[former_member198650]

Hi Pranav,

You can check the payments through  BANK GLs, for payments select all outgoing GLs and execute it. Here you have to select the doc.type KZ. For receipts select all incoming GLs and execute it. Here you have to select the doc.type DZ.  or

Run FBL1N & FBL5N with doc.types "KZ" & "DZ" and execute it.

Regards,

Mukthar