Order balance from register screen

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
smadderla
Posts: 16
Joined: Fri Nov 02, 2012 5:31 pm

Order balance from register screen

Post 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.
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: Order balance from register screen

Post 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).
Lisa Ennis
Senior Report Developer
SoftPro
smadderla
Posts: 16
Joined: Fri Nov 02, 2012 5:31 pm

Re: Order balance from register screen

Post by smadderla »

Select
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: Order balance from register screen

Post 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
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply