cancel
Showing results for 
Search instead for 
Did you mean: 

As of date

Former Member
0 Kudos

Post Author: tmitchell

CA Forum: Formula

runnning a general ledger report need to set up a formula to show results "as of" a certain date for individual ledger accounts.

Any Suggestions

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Post Author: yangster

CA Forum: Formula

just put in gl_date <= (?as_of_date_para) in the selection criteria and you should be alright to do the sum of quantity you are aftersimply create a grouping on your items

Former Member
0 Kudos

Post Author: tmitchell

CA Forum: Formula

Either way will work prefer date parameter to match as of date

Former Member
0 Kudos

Post Author: yangster

CA Forum: Formula

what selection criteria are you after in terms of datewill someone be selecting a date range and you want the qty as of a certain date or will your date parameter match the as of date?

Former Member
0 Kudos

Post Author: tmitchell

CA Forum: Formula

Design set up as follows

With this how would you set up an "as of Date" in the gl_date? Would like to know the qty by inventory number as of a certain date ex: 4/16/2006

Former Member
0 Kudos

Post Author: GraemeG

CA Forum: Formula

Depends largely on the structure of your transaction and balances tables and whether the report is a full profit & loss/balance sheet or just for a selected account. What erp is it, what is the structure of the relevant tables and what do you want the report to look like?