Jbase Report Problem

  • Andi
  • Topic Author
  • Visitor
  • 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

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
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

Attachments:
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
  • 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