Page 1 of 1
Order balance from register screen
Posted: Fri Jan 31, 2014 2:42 pm
by smadderla
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.
Re: Order balance from register screen
Posted: Fri Jan 31, 2014 5:39 pm
by Lisa Ennis
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).
Re: Order balance from register screen
Posted: Fri Jan 31, 2014 7:18 pm
by smadderla
Select
Re: Order balance from register screen
Posted: Wed Feb 05, 2014 4:36 pm
by Lisa Ennis
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