Re: Offline load OFFTRN

Yes, we also use PLM&C.  They are a perfect example of how awesome the 
TRDATA processing is.  I obviously prefer to have an automated OFFTRN load 
that we can use and I hope the MAPICS Developing Team can see all these 
arguments and discussions because this really bring powerful solutions to 
our companies.

Back to earth... in a very summarized manner, this is what you might need 
to do in order to use the TRDATA route:

1) Build your record content
NOTE: Practice before.  Use a test environment, for example, and stop the 
UJOBs so they do not process your test transaction until you determine all 
the fields loaded in that specific TRDATA record for that specific 
transaction code you are testing.

2) Get the Transaction # from MAPICS' Data Area ZNXTRN. 
NOTE: After using the current value, remember to increase the value by one 
and update the data area back.

3) Write the TRDATA record.

4) Activate the trigger for the UJOB.
For this, you have to determine the MAPICS data queue to use, depending on 
the transaction code:

      a) TA, ON, OF - DQJUA 
      b) All inventory transactions - DQJUC 

After having the correct data queue, you need to call the program QSNDDTAQ 
and do it as follows:

pdqjuc        plist 
              parm                    qname@ 
              parm      '*LIBL'       qlibr@ 
              parm      1             qfldl@ 
              parm      '1'           qfield@ 
              call      'QSNDDTAQ'    pdqjuc                 90


This will give you a starting point.

Good luck!



Peter Vidal 
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"Work while you have the light. You are responsible for the talent that 
has been entrusted to you."
Henri-Frédéric Amiel