Jbase Report Problem
- Andi
- Topic Author
- Visitor
-
10 years 1 week ago #17651
by Andi
Jbase Report Problem was created by Andi
hey All
my goal is to generate a report from t24 tables by using jbase query
the report must have the following fields from different files
1. account.title.1
2.account.number
3.opening balance
4.debit movement
5 credit movement
6 transaction date(value.date)
7 ending balance
8 description
and i got name as account.title.1 , account number as account.number, from FBNK.ACCOUNT file
and debit movement & credit movement as AMT.LCY from FBNK.STMT.ENTRY file.
the problem here is which field and from which file can represent the fields of opening balance,ending balance and descriptions and matched with the scenario of opening balance - debit + credit = ending balance.
i try to with the open.actual.bal as opening balance and working.balance as ending balance from FBNK.ACCOUNT file but they return the same value that contradict the above scenario
so how could solve this problem.
thank you
my goal is to generate a report from t24 tables by using jbase query
the report must have the following fields from different files
1. account.title.1
2.account.number
3.opening balance
4.debit movement
5 credit movement
6 transaction date(value.date)
7 ending balance
8 description
and i got name as account.title.1 , account number as account.number, from FBNK.ACCOUNT file
and debit movement & credit movement as AMT.LCY from FBNK.STMT.ENTRY file.
the problem here is which field and from which file can represent the fields of opening balance,ending balance and descriptions and matched with the scenario of opening balance - debit + credit = ending balance.
i try to with the open.actual.bal as opening balance and working.balance as ending balance from FBNK.ACCOUNT file but they return the same value that contradict the above scenario
so how could solve this problem.
thank you
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
10 years 1 week ago - 10 years 1 week ago #17653
by jpb
Replied by jpb on topic Jbase Report Problem
Maybe this helps
Attachment Balancesontheaccountrecord.zip not found
Last edit: 10 years 1 week ago by jpb.
The following user(s) said Thank You: Andi
Please Log in or Create an account to join the conversation.
- Andi
- Topic Author
- Visitor
-
10 years 2 days ago #17696
by Andi
Replied by Andi on topic Jbase Report Problem
thanks JBP but still the issue is not yet solved
Please Log in or Create an account to join the conversation.
Time to create page: 0.033 seconds