Skip to Content
0
Aug 25, 2020 at 02:06 PM

BP Balance as at

144 Views

I have a query that returns the current balance of all BPs. What I want is to run the below query but also include a specific date i.e. 31/07/2020.

SELECT T0.[CardCode], T0.[CardName], T1.[MainCurncy], T0.[Balance], T1.[SysCurrncy], T0.[BalanceSys], T0.[Currency], T0.[BalanceFC] FROM [dbo].[OCRD] T0, OADM T1