on 11-21-2007 4:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Post Author: tmitchell
CA Forum: Formula
Either way will work prefer date parameter to match as of date
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.