Skip to content

Instantly share code, notes, and snippets.

@webbyworks

webbyworks/ap-opening-balance-monthly.txt

Last active August 29, 2015 14:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save webbyworks/ece0df0286fcab356794 to your computer and use it in GitHub Desktop.
Save webbyworks/ece0df0286fcab356794 to your computer and use it in GitHub Desktop.
Download ZIP
Calculating the Opening Balance for the month.
Raw
ap-opening-balance-monthly.txt
if ( isBlank( ASSUM.CF.WeekNum ), 0,
if ( ACCT.CF.OBal = 0,
if ( ASSUM.CF.WeekNum = 1,
ACCT.CF.CBalMonthly[time=this-1,Weeks=Week 4]
+
ACCT.CF.CBalMonthly[time=this-1,Weeks=Week 5]
, 0 )
, ACCT.CF.OBal )
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment