Re: Offline Item Master Load

Matthew,

If you are new to this forum - welcome aboard.

We are at XAR4 and load part numbers from an RPG program residing as a
menu option in Inventory Management.

You need to appreciate that just loading a part number into the Item
Master file is not very useful by itself. There are other files that
need information such as ITEMBL <item balance>, MBBZREP <item base
price>, MBB2CPP <item master extension>, and PSTRUC <BOM>. Also some
companies have auxiliary or shadow files to hold info that MAPICS files
do not. We load our own ITEMBLX file.

I only know enough about VB and SQL procedures to know that I would not
want to complicate your task by mixing those into the process.

If you want a copy of our RPG program then email me privately. You
would have to strip out all of our company specific code and add your
company specific code.

Greg



-----Original Message-----
From: matthew.irvine@xxxxxxxxxx [mailto:matthew.irvine@xxxxxxxxxx]
Sent: Thursday, February 21, 2008 3:45 PM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] Offline Item Master Load

Hello all,

First off I am a complete MAPICS newby. Now to the question. We use a
configurator program that generates a new part number and a BOM for the
new part outside of MAPICS. We need to be able to automate a method to
load the new part to the system without putting the system into
dedicated mode. Ideally we would like to use a VB app or a SQL stored
procedure to accomplish this. We are running MAPICS XA Release 4.0. Is
this possible?
Can anyone direct me to some helpful information? Thank you in
advance!


Matthew Irvine
Programmer/Web Developer
email: matthew.irvine@xxxxxxxxxx