This code has been developed by developers of this forum and available in the Free Source Code section. However, I have been trying to upgrade it and change the row(stock items) into column heading and column items (party names) into rows heading for better analysis of the report. However, I have failed till now. I wish I get some help in it. Thanks in advance to experts and senior developers.
Watch and study the Pname which is partyname and Iname which is Itemname. Interchange that and also re-align the fields........... It is not that hard............try it............ Collections will remain same....just re-align the data fields.
PName is the Party Name and IName is the Itemname...I had no confusion in that...however, i had problems in aligning the field
My dear friend .......it took me 5 minutes to re-align.................. first picture is as per your TXT file.......... Second picture is re-aligned...........
i have been scratching my head on this for quite a while now.. i altered the position of Pname and Iname too... But realigning the fields got me confused... I need some clue to get it right...
just follow my instructions..... interchange all INAME and PNAME.......... also there is one variable.... change it from Pname to Iname In Part:CBFK party .................. in repeat........ change the collection name from Item to party. Also in Report level...change this ------ Set : DSPRepeatCollection : "Smp Stock Item" There is one ... myformula .... it is like this ... 1 + 2 ............ change it to 2 + 1 Do not touch any collections........ That's all.
there is no error message.... the party name is shown in rows as we want but stock item is not visible nor is any data.
Set : DSPRepeatCollection : "Smp Stock Item" Local : Field : CFBK Rep Party : Set as : ##pname ===change to Iname. Obviously you have not done it properly.... nor read my instructions properly either
Sorry sir, I tried my best but got confused. Thanks for the guidance. I got the desired display but on pressing enter in the party name, stock item display box is opened. Should i do all the coding by altering every field or slight change will do?
look up in TDE..... search "display : ledger" .... watch, read, understand and then implement in your code.....
Thanks a lot for guiding despite your busy schedule. Done with this one. More importantly learnt new things. Thanks again.
$$StrByCharCode:8377 for currency symbol To get currency symbol, you will have to make the field as Name Field and not Amount Field. If that is so, then you will not get the TOTALS at the bottom.
In... [Collection: CFBK Party] Add this line ................... Aggr Compute : Amount : SUM : $Amount
Dear Sir, Partywise summary give error - " Function SVCurruntDate could not find orignal discription"
Dears, Function Sv Currunt date has error that i rectified now it showing. Thanks for response. Regards.