How is the CA Balance field calculated in Cash Manager Bank Reconciliation?

This article has been archived. It is offered "as is" and will no longer be updated.
TechKnowledge Content
NOTES:
1. Cash Manager first looks at the field values from the previous month's bank statement in the BANKREC table:CuryStmtbal - CuryOutstandingChk + CuryDepInTranst 
2. It then adds all CuryReceipts and subtracts all CuryDisbursements in CASHSUMD based on criteria in the following example:

where CpnyId like '0060' (Company Id)
and BankAcct like '1030' (Bank Account)
and BankSub like '000000000000' (Bank Subaccount)
and TranDate > '2000-04-28' (date of previous bank reconciliation)
and TranDate <= '2000-05-31' (date of current bank reconciliation)

This article was TechKnowledge Document ID: 125448
Properties

Article ID: 873583 - Last Review: 01/06/2015 16:38:09 - Revision: 3.0

  • Microsoft Dynamics SL 2011
  • Microsoft Dynamics SL 2011 Service Pack 1
  • Microsoft Dynamics SL 6.5
  • Microsoft Dynamics SL 6.5 Service Pack 3
  • Microsoft Dynamics SL 7.0
  • Microsoft Dynamics SL 7.0 Service Pack 2
  • Microsoft Dynamics SL 7.0 Service Pack 3
  • Microsoft Dynamics SL 7.0 Service Pack 4
  • kbnosurvey kbarchive kbmbsmigrate KB873583
Feedback