Total sum of transactions equal to zero??
- Moe_T24
- Topic Author
- Offline
- Senior Member
- T24 Technical
Less
More
- Posts: 57
- Thank you received: 1
6 years 10 months ago #21577
by Moe_T24
Best Regards
Total sum of transactions equal to zero?? was created by Moe_T24
Hi all,
I know that in T24 any transaction is recorded in one of 3 tables (STMT.ENTRY , CATEG.ENTRY , SPEC.ENTRY) , right?
If I take sum of all entries in all 3 tables at some point like all transactions happened on a particular day,shouldn't that add to zero or not ?
Please if anyone can can explain more on transactions recording, as I am extracting some reports and the net amount of all transactions doesn't add to zero.
Thanks .
I know that in T24 any transaction is recorded in one of 3 tables (STMT.ENTRY , CATEG.ENTRY , SPEC.ENTRY) , right?
If I take sum of all entries in all 3 tables at some point like all transactions happened on a particular day,shouldn't that add to zero or not ?
Please if anyone can can explain more on transactions recording, as I am extracting some reports and the net amount of all transactions doesn't add to zero.
Thanks .
Best Regards
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
6 years 10 months ago #21581
by VK
Cheers
VK
Replied by VK on topic Total sum of transactions equal to zero??
Hi
Have you calculated local or foreign currency?
Have you used booking or value date?
What the difference is like? Huge or small amount?
Have you calculated local or foreign currency?
Have you used booking or value date?
What the difference is like? Huge or small amount?
Cheers
VK
Please Log in or Create an account to join the conversation.
- Moe_T24
- Topic Author
- Offline
- Senior Member
- T24 Technical
Less
More
- Posts: 57
- Thank you received: 1
6 years 10 months ago #21582
by Moe_T24
Best Regards
Replied by Moe_T24 on topic Total sum of transactions equal to zero??
I tried both in local and foreign,and used booking date.
The difference is huge over 200,000.
There are some STMT.ENTRY record ids that begin with F?What are those entries?
The difference is huge over 200,000.
There are some STMT.ENTRY record ids that begin with F?What are those entries?
Best Regards
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
6 years 10 months ago #21583
by VK
Cheers
VK
Replied by VK on topic Total sum of transactions equal to zero??
Hi
"F" are forward entries, they obtain "regular" ID when the value date comes.
Have you checked your figures against EB.SYSTEM.SUMMARY and GL?
"F" are forward entries, they obtain "regular" ID when the value date comes.
Have you checked your figures against EB.SYSTEM.SUMMARY and GL?
Cheers
VK
Please Log in or Create an account to join the conversation.
- DUBLIN
- Offline
- Elite Member
Less
More
- Posts: 202
- Thank you received: 29
6 years 10 months ago #21597
by DUBLIN
Replied by DUBLIN on topic Total sum of transactions equal to zero??
Hi,
Another reason for your "unbalance" could be the fact that you are including off-balance sheet transactions from SPECs . e,g, FOREX Forwards ...
Another reason for your "unbalance" could be the fact that you are including off-balance sheet transactions from SPECs . e,g, FOREX Forwards ...
Please Log in or Create an account to join the conversation.
Time to create page: 0.081 seconds