I am working on a report to get order balance from register screen.
can you please help me with queries to get order balance for a list of orders.
Thanks,
Sangeetha.
Order balance from register screen
Moderator: Lisa Ennis
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: Order balance from register screen
Hi Sangeetha, if you can let me know which version of our software that you are using, I can assist you with this (Classic or Select).
Lisa Ennis
Senior Report Developer
SoftPro
Senior Report Developer
SoftPro
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: Order balance from register screen
There are several functions in the database that will give you the balance. You will need to determine which funciton to used based on trust accounting or transaction date, and whether or not you want the balance for one ledger or for multiple ledgers. All of these are in the dbo schema.
IBABalancesByLedgerByTranDate
IBABalancesByLedgerByTrustDate
IBABalancesByTranDate
IBABalancesByTrustDate
LedgerBalanceByTACByTranDate
LedgerBalanceByTACByTrustDate
LedgerBalanceWithPendingAndHeldByTACByTranDate
LedgerBalanceWithPendingAndHeldByTACByTrustDate
LedgerInTrustAccountsByLedgerID
LedgersBalanceWithPendingAndHeldByTACByTranDate
LedgersBalanceWithPendingAndHeldByTACByTrustDate
LedgersBalanceWithPendingAndHeldByTranDate
LedgersBalanceWithPendingAndHeldByTrustDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTACByTranDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTACByTrustDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTranDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTrustDate
IBABalancesByLedgerByTranDate
IBABalancesByLedgerByTrustDate
IBABalancesByTranDate
IBABalancesByTrustDate
LedgerBalanceByTACByTranDate
LedgerBalanceByTACByTrustDate
LedgerBalanceWithPendingAndHeldByTACByTranDate
LedgerBalanceWithPendingAndHeldByTACByTrustDate
LedgerInTrustAccountsByLedgerID
LedgersBalanceWithPendingAndHeldByTACByTranDate
LedgersBalanceWithPendingAndHeldByTACByTrustDate
LedgersBalanceWithPendingAndHeldByTranDate
LedgersBalanceWithPendingAndHeldByTrustDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTACByTranDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTACByTrustDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTranDate
LedgersBalanceWithPendingAndHeldWithIBABalanceByTrustDate
Lisa Ennis
Senior Report Developer
SoftPro
Senior Report Developer
SoftPro