× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

COUNT DR AND CR TRANSACTION IN STMT

Start
Prev
1
Next
End

zaki_hyder
Topic Author
Offline
Premium Member

17 years 2 months ago #835 by zaki_hyder

COUNT DR AND CR TRANSACTION IN STMT was created by zaki_hyder

Hi All,

I want to count Dr and Cr transaction saperately and display on customer statement. I was trying to CALC but faild.

Please help me.

Best Regards

Please Log in or Create an account to join the conversation.

buddyvdb5
Offline
New Member

17 years 3 weeks ago #836 by buddyvdb5

Replied by buddyvdb5 on topic Counting number of Dr/Cr

In your enquiry, try something like

11. 2 FIELD.NAME..... ZERO
12. 2. 1 OPERATION... '0'
11. 3 FIELD.NAME..... ONE
12. 3. 1 OPERATION... '1'
11. 4 FIELD.NAME..... IF.DR
12. 4. 1 OPERATION... IF AMT.LCY LT ZERO ONE ZERO
11. 5 FIELD.NAME..... IF.CR
12. 5. 1 OPERATION... IF AMT.LCY GT ZERO ONE ZERO
11. 6 FIELD.NAME..... TOT.DR
12. 6. 1 OPERATION... T IF.DR

13. 6 COLUMN......... 14,+1
14. 6 LENGTH.MASK.... 5L0,
18. 6 DISPLAY.BREAK.. END
11. 7 FIELD.NAME..... TOT.CR
12. 7. 1 OPERATION... T IF.CR
13. 7 COLUMN......... 14,2
14. 7 LENGTH.MASK.... 5L0,
18. 7 DISPLAY.BREAK.. END

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.077 seconds