Customer and Vendors list without transactions

[former_member317998]

Dear All,

Is there any T-Code to view Customers and Vendors list for which no transactions were done.

Regards

KS

[Former Member · Accepted solution]

Hi Sudarshan K,

--Their is no T.Code for Customer and Vendors list without transactions.

--T.Code F.1A is Customer / Vendor Statistics

--Check this link for Customer & Vendor list for account group.

Regards

Pradeep

[former_member317998 · Accepted solution]

Hi Pradeep,

Thank you very much for your reply, my requirement is like this, for example there are 5000 customer and Vendors, in this for 50 Customers or Vendors there is no single Sale or Purchase transaction, as a user point of view is there any T-Code to view list of Customer and Vendors.

Regards

KS

[Former Member · Accepted solution]

Hi Sudarshan K,

--No T.Code to list the Customers/Vendors without any transactions.Once Transaction are done for the customer/vendor they will store in the tables.

-- *FBL5N* -Customer Line items

-- FBL1 -Display Vendor Line Items

--If you want to view Customers/Vendors list without any transactions you have go for enhancement But based on your client requirement.

Regards

Pradeep

[Former Member · Accepted solution]

Dear Sudarasan,

You can try T.Code for customer S_ALR_87012081 and select object list in output type and run T.code S_ALR_87012186.

Just see which customer and vendor contain 0 value. If customer and vendor contain 0 value that means there is no transaction on that customer and vendor.

Regards,

Sandip Shaktavat