|
midrange.com
Here is the CL that is executed from the group-job menu. Program R0449
does some error checking & then populates MBIBCPP. Program AMVGYXFR is the
one that actually processes the offline-file. That is how we get around it
being dedicated.
PGM
DCL VAR(&USER) TYPE(*CHAR) LEN(10)
RTVJOBA USER(&USER)
CLRPFM FILE(MBIBCPP)
CALL PGM(R0449)
CALL PGM(AMVGYXFR) PARM(' ' '1' '1')
SNDBRKUSR USER(&USER) MSG('Check for an error listing +
report that may have been generated. Any +
customers listed on the error report did +
not get added to the customer master. +
They will have to be added manually.')
ENDPGM
Steve Jones
"Eric Wolf"
<eric_a_wolf@xxxx
ail.com> To
Sent by: "MAPICS ERP System Discussion"
mapics-l-bounces+ <mapics-l@xxxxxxxxxxxx>
sjones=hpproducts cc
.net@xxxxxxxxxxxx
Subject
Re: Loading new Customers or
07/09/2003 04:22 Ship-to from Offline
PM
Please respond to
MAPICS ERP System
Discussion
<mapics-l@xxxxxxx
e.com>
How do you get it to not be in dedicated mode to run?
Eric
----- Original Message -----
From: <sjones@xxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Sent: Wednesday, July 09, 2003 12:30 PM
Subject: Re: Loading new Customers or Ship-to from Offline
>
>
>
>
> Eric:
>
> We do offline load of customers from a users group-job menu. The user
gets
> customer information from a third-party in MS-Excel format & sends that
to
> the I-Series. We then take that file & do the offline-load process.
Does
> this sound like what you are looking for?
>
> Steve Jones
>
>
>
> "Eric A. Wolf"
> <eric_a_wolf@xxxx
> ail.com>
To
> Sent by: "mapics" <mapics-l@xxxxxxxxxxxx>
> mapics-l-bounces@
cc
> midrange.com
>
Subject
> Loading new Customers or Ship-to
> 07/08/2003 05:24 from Offline
> PM
>
>
> Please respond to
> MAPICS ERP System
> Discussion
> <mapics-l@xxxxxxx
> e.com>
>
>
>
>
>
>
> To the list,
> Has anyone come up with a way to load customers or ship-tos as part of a
> nightly process ie. scheduled offline load?
>
> My customer wants to create a function to allow users (not only in the
> Credit dept) to be able to load customers/shiptos in a "batch" file and
> post the data using the Offline functions after having cleaned
up/formatted
> the data. The reason for this request is to standardize the addresses to
> follow a more stringent format. We are trying to use a format that
follows
> the USPS standards and also use a product called PER/ZIP that will verify
> the address and return the Zip+4 postal codes, as well as, correct any
> spelling or punctuation errors. FYI - it is a neat tool for those that
are
> having a similar problem.
>
> MAPICS requires the first address line to be filled in, however, the USPS
> standard is that the line directly above the City/State/Postal code to be
> the delivery address. To add to this problem, the PER/ZIP product wants
> to know which positions in the file being verified has the Delivery and
> Seconday address. My idea is to always use the Address line 3 for
delivery
> address (could be a PO Box or a street address).
>
> My solution so far has been this: Bill-to Address Line 1 = ATTN: ACCOUNTS
> PAYABLE
> Ship-to Address Line1=
> RECEIVING DEPT.
> This satisfies the MAPICS standard but to resolve the
> spelling/punctuation/validation problem, I cannot use the user exit since
> the Credit dept is the only one who can activate the customer, apply
credit
> limits, etc. However, allowing others to create the customer alleviates
> duplicate entry into a Lotus database.
>
> Any ideas/suggestions would be appreciated...
>
> Eric A. Wolf
> Independent MAPICS Consultant
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> 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@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> 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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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 mailing list archive is Copyright 1997-2025 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.
