Skip to Content
author's profile photo Former Member
Former Member

Sales Order Billing plan change log

HI Sd Gurus,

Our client has a requirement to develop a report in which they want display change log of billing plan net value, i.e if the sales order item is created in period 01 with the billing plan net value of rs 100/-, report should show 100 and if the value is changed in period 02 to rs.150/- it should show "latest-Initial Value= 150-100=50" in period 02. This value can be changed by any reason in the sales order( change in item price, setting ROR to the item etc..)

We initially developed a logic based on item cumulative condition price but this is not working if the billing plan has more that one line(i.e periodic billing) the total value is divided into periods and cumulative condition contains the value of only one line

Therefore I used value of CMPRE and developed a logic to calculate the net value by using formula( Value of CMPRE/1+taxes). This is working for all scenarios but sometimes CMPRE is not present on few items then this logic is getting failed.

Request any of you to help me to develop a logic to display correct value in all the scenarios, Its kind of emergency please

Regards,

Subash

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Aug 21, 2016 at 10:49 AM

    Subash,

    What about exploring CDHDR / CDPOS tables? If someone asks a change log for an SD document, those tables would be the first ones I'd take a look at.

    Add a comment
    10|10000 characters needed characters exceeded