Skip to Content
author's profile photo Former Member
Former Member

As of date

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 07:36 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 05:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 05:56 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 06:36 PM

    Post Author: tmitchell

    CA Forum: Formula

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 07:28 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.