Hello ,
Kindly please help me with the below queries,
How to identify if a transaction is Open or Closed in the GeneralJournalAccountEntry table.
Hello Mahek :-)
Hope you got your issues fixed / questions answered in the meantime.
If this is the case then please verify the answers to get this thread completed.
Many thanks,
Ludwig
Thank you For your help :)
No. It usually means that no document date has been entered when posting the transaction.
[quote user="Mahek"]How to identify if a transaction is Open or Closed in the GeneralJournalAccountEntry table.[/quote]The GeneralJournalAccountEntry table is not enough to identify if a transaction is open or closed.
You rather need to check the subledger transactions related for example in the custtrans or vendtrans tables
There you can find information on settlements that have been made and based on that you can calculate the open amount.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (