Skip to Content

A different Management Report

I shall be thankful if someone can give a clue on how to approach the following problem.

Suppose a company has many divisions (like Powder Division, Cold Extrusion Division) making different product lines and all these divisions are supplying to a common customer. The customer is treating the various divisions as different vendors and has allotted different vendor codes to each division. Please note each division has multiple plants.

In this case, is it possible for the supplying company to see data of all supplying divisions in a common report? The clientu2019s requirement is that Data should populate for sales, sales returns, payment terms, receivables etc.

While I could achieve sales datas by assigning some numeric value in one of the unutilised fields in customer master, I am unable to achieve the same logic for Payment Terms. For example, I have Maruthi as a customer with some 10 sold to party code in SAP to whom supplies are being made from different plants.

Now the requirement is only the text of customer should flow in the report and against this text, payment term should flow across the divisions what is maintained. For example,

	Division A     Division B     Division C

Maruthi	  DA 30	       DA 60	    DA 90

They dont want what payment term is maintain in sale order level but only interested to see from sold to party each division wise and that too in the above format

Any idea on how to achieve this logic which should not complicate the process ?? :-((

thanks

G. Lakshmipathi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 24, 2009 at 11:34 AM
    Data should populate for sales, sales returns, 
           payment terms, receivables etc.

    I could arrive at some logic on all above but for Payment Terms. Anybody is there to provide some suggestions on this ??

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 23, 2009 at 11:09 AM

    Hi

    Can't we use the details of payment terms in KNVV-ZTERM. I could see the payment terms maintained for a customer for different sales areas in customer master.

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for responding. My problem as I said above there are multiple codes for the same customer with same sales area. Also the Payment terms are different from one division to another. So In this case, how can I populate the data in line with the format shown above.

      Client's requirement is that only customer text should flow once despite the fact that there are some 10 sold to party codes (customer name is unique) who are serviced from different divisions / plants.

      Hope I have explained the requirement clearly !!!!!!!

      thanks

      G. Lakshmipathi

  • avatar image
    Former Member
    Jul 23, 2009 at 11:30 AM

    Hi Lakshmipathi,

    Are these customers maintained under customer hierarchy?

    Do you maintain the same search term for all the sold to parties used for the customer Maruti (for example)?

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded