Skip to Content
-4

Need a report - list of customers that are not set up for billing in customer master

Hello SAP people,

Please help me with this: need a report - list of customers who are not set up for billing in customer master. The reason I am looking for this report is we recently ran into an issue where we billed a customer but that customer location was not set up to be billed too in customer master and will never be - company decision. So user is looking for this report to help them not assign customers to bill-to-party function which are not set up for billing.

Please help!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 19 at 09:31 AM

    Had I been in your position, first I would list out all the order types being used for a given sales area. Next, I would check what are the item categories assigned to those sale order types and finally, I pass all those item categories in TVAP table, where the field FKREL should be blank. Now you have a list of item categories which are not relevant for billing. If I am correct, it would be only one in your case. Now table join VBAK with VBAP where you pass that KUNNR and PSTYV and execute. You will get the desired result.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17 at 05:57 AM

    Hi,

    Based on which criteria do you decide that the customer is not going to be billed? Apart from Bill to party which user assigns later?

    list of customers who are not set up for billing in customer master

    What Account group does user select while creating such customers?

    Are there multiple people responsible for maintaining a customer master based on views ?

    Add comment
    10|10000 characters needed characters exceeded

    • but haven't set up the financial views for this

      Still, system would allow to generate billing document and that is why, I had not suggested this transaction code. Your original requirement is

      that customer location was not set up to be billed

      and I presumed, the partner functions are same in which case, OV50 will not give a correct picture.

      Also, as I already highlighted, item category not relevant for billing would be very minimal in which case, it would be better to cross check with one customer with the steps what I had suggested.