× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. December 2002

RE: Customer shipments YTD

Joan,

Patrick's solution works fine for many of our customers. A trigger program
over the MTHACT(S) to
a corresponding set of YTDACT(S) can be performed very easily and give you
the flexibility
to generate endless queries which should satisfy any executive.

Jack Roughgarden
Custom Systems Corp
973-726-0202 x210
http://www.cussys.com



                      "Shrader,
                      Patrick"                 To:       mapics-l@midrange.com
                      <pshrader@wkep.co        cc:
                      m>                       Subject:  RE: Customer shipments 
YTD
                      Sent by:
                      mapics-l-admin@mi
                      drange.com


                      12/05/02 12:51 PM
                      Please respond to
                      mapics-l






Joan,

If you haven't done so, you may want to look at the MTHACT files, which is
not an inexpensive ($1,000 or so) "enhancement" to COM. It won't help your
past history, but is it a good "data-warehouse" for your sales history. If
you archive the file at each month end you can build some very easy and
cheap Excel Queries and PivotTables across them to get hundreds of reports.
My management team uses them exclusively. A lot cheaper than Analytics
(though not as powerful), and you can link to your sales history and item
balance information as needed.

Patrick


-----Original Message-----
From: McCready, Joan [mailto:Joan.McCready@metaltekint.com]
Sent: Thursday, December 05, 2002 12:36 PM
To: 'mapics-l@midrange.com'
Subject: RE: Customer shipments YTD


Thanks, Bob.

YABPREP wouldn't work - the sales VP needs YTD by customer so he can do
analysis by industry, by sales reps, etc. etc. As for FRx or Crystal
Reports
- no $$, besides I already have IWP.

       -- Joan

-----Original Message-----
From: Bob Tenney [mailto:bobtenney@earthlink.net]
Sent: Thursday, December 05, 2002 11:11 AM
To: mapics-l@midrange.com
Subject: Re: Customer shipments YTD


Joan, You might consider an inquiry against the sales accounts in IFM's
ledger summary ( YABPREP) file or an FRx report. IFM balances are updated
automatically when you create an invoice. As long as you keep your
invoicing
current with your shipments this will give you the info that you need.

If you are looking for COM-based report you might consider Crystal Reports.
I have been experimenting with this product and have found that it can
produce attractive reports without impacting AS/400 performance

Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Crystal Reports
828-526-8976
Visit www.tenneypubs.com for books about
IFM, FRx, COM, Cost Accounting,
General Ledger Interfaces, and
Info WorkPlace
----- Original Message -----
From: "McCready, Joan" <Joan.McCready@metaltekint.com>
To: <mapics-l@midrange.com>
Sent: Thursday, December 05, 2002 12:06 PM
Subject: RE: Customer shipments YTD


> Michael -
>
> Yes, they must be SA files - I have them, but both are blank...
>
>      Thanks - Joan
>
> -----Original Message-----
> From: Michael.Huber@plymouthwater.com
> [mailto:Michael.Huber@plymouthwater.com]
> Sent: Thursday, December 05, 2002 10:48 AM
> To: mapics-l@midrange.com
> Subject: RE: Customer shipments YTD
>
>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Two files I use are: CUSTSA (Customer) and ITEMSA (Item), we have SA
> installed so they may be SA files.
>
> ----------------------------------------------------------------------
> ----
--
> -----------
> Michael K. Huber
> Applications Development & AS/400 Operations
> Plymouth Products, Inc
> 502 Indiana Ave
> Sheboygan, WI 53081
> Phone: (920) 451-9417      FAX: (920) 803-3541     Mobile: (920) 698-0013
> <http://www.plymouthwater.com>
>
> ----------------------------------------------------------------------
> ----
--
> -----------
> Confidentiality Note:   This e-mail message and any attachments to it are
> intended only for the named recipients and may contain confidential
> information.  If you are not one of the intended recipients, please do
> not duplicate or forward this e-mail message and immediately delete it
> from
your
> computer.
>
>
>
>
>
> "McCready, Joan" <Joan.McCready@metaltekint.com>
> Sent by: mapics-l-admin@midrange.com
> 12/05/2002 10:36 AM
> Please respond to mapics-l
>
>
>         To:     "'mapics-l@midrange.com'" <mapics-l@midrange.com>
>         cc:
>         Subject:        RE: Customer shipments YTD
>
>
> Connie -
>
> Thanks - that gives me the detail, but... Does MAPICS have a running
> total field anywhere, or does a program have to loop through the
> detail and accumulate every time my sales VP wants to see sales YTD???
>
>         - Joan
>
> -----Original Message-----
> From: Connie Webb [mailto:cwebb@grahamwhite.com]
> Sent: Thursday, December 05, 2002 10:08 AM
> To: 'mapics-l@midrange.com'
> Subject: RE: Customer shipments YTD
>
>
> MBF9REP..
>
> Connie Webb
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
> post a message email: MAPICS-L@midrange.com To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/mapics-l.
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
> post a message email: MAPICS-L@midrange.com To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/mapics-l.
>
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
> post a message email: MAPICS-L@midrange.com To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/mapics-l.
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
> post a message email: MAPICS-L@midrange.com To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/mapics-l.
>

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@midrange.com To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@midrange.com To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.