× 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.






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 thread ...

Follow-Ups:
Replies:

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.