Omitting Records

  • Follow


FM10
I have a Ledger with a chart of acccounts; wages, rent, production,
office. I want to create a sub-summary report sorted on the chart of
accounts but there is one account - wages, all records of which I want
omited. Can you advise me on the script steps?

Thanks
0
Reply Buckbuck 3/28/2011 5:38:23 AM

On Mar 27, 11:38=A0pm, Buckbuck <buck.matthe...@yahoo.com> wrote:
> FM10
> I have a Ledger with a chart of acccounts; wages, rent, production,
> office. I want to create a sub-summary report sorted on the chart of
> accounts but there is one account - wages, all records of which I want
> omited. Can you advise me on the script steps?
>
> Thanks

Use Constrain Found Set []
Set it to Omit records when chart =3D Wages

DJ
0
Reply David 3/28/2011 2:41:33 PM


"Buckbuck" <buck.matthew74@yahoo.com> wrote in message
news:cbab39bc-9221-4227-b197-14a15d4b7d8d@34g2000pru.googlegroups.com...
> FM10
> I have a Ledger with a chart of acccounts; wages, rent, production,
> office. I want to create a sub-summary report sorted on the chart of
> accounts but there is one account - wages, all records of which I want
> omited. Can you advise me on the script steps?
>
> Thanks

Before going to the report layout, simply perform a Find (either manually or
set-up a Script to do it) that leaves out those unwanted records.

     - Go into Find Mode on a Layout using the correct Table.

     - Enter the appropriate dates for the report into the date field
       e.g.    "1/1/2001...6/1/2011"

     - Create a new Find Request (from the Records menu) and
       click on the Omit checkbox in the side Status bar and
       set the appropriate field to "Wages".

     - Perform the Find.

     - Sort the Records.

     - Go to the Report Layout and print / preview it.


Helpful Harry   :o)



0
Reply Your 3/28/2011 8:27:59 PM

2 Replies
225 Views

(page loaded in 0.069 seconds)

Similiar Articles:













7/15/2012 9:04:17 AM


Reply: