Dear Sir I am trying to develop a report which is a consolodated statement showing sales cost centre wise. i am unable to get total sales cost centre wise it shows only closing balance of each cost centre. I require voucher type wise totals for each cost centre i mean if sales returns are recorded through credit note i should be abloe to get total of such returns cost centre wise kindly advise me. herewith i am attaching my code
In your collection......you compute... SalesAmt : If $$IsSales:$VoucherTypeName Then $Amount Else 0 ... and so on with the other voucher types.
Amit sir one more help i have commission slabs defined at company level. commission is calculated based on collection slabs and their corresponding commission percentage how obtain commission rate based on the slab in which my net collections Fall please help me sir i am attaching modifies code of Incentive report as well incentive slabs code
You can use formula............. If Sales-CN > 0 and Sales-CN <= 10000 then (Sales-CN) * .05 Else + If Sales-CN > 10000 and Sales-CN <= 50000 then (Sales-CN) * .06 Else + If Sales-CN > 50000 and Sales-CN <= 100000 then (Sales-CN) * .07 Else (Sales-CN) * .08
no sir my commisson percentages should come from incentive slabs table it has to compare my netcollection amount and identify the commission against the slab in which my net commission falls
But you do not have any Date/Period constraints in your code.......... on what basis will you apply the slab?? In the current scenario of your code, it will take the average basis since no period/date exists.
You will need to define a Aggregate UDF also.......... in order for that value to be available in your report.
Aggregate UDF defined in Incentive slabs report with that aggregate udf i constructed collection IncentiveSlabscoll but in uploade file a small wrong was done instead of writting Type:IncentiveSlab:Company it was written as Type:Company:IncentiveSlabs
thank you for your help sir i could complete my task thanks a lot. Keep helping us Regards Varadha raju