MSF903 and MSB904

[VonSchau]

Have you somebody any experience with using MSB904 batch or input table MSF903? We would like use this but there are many unanswered questions in the documentation. B-(

 

[BobwInco]

We use msb904 extensively at Inco Ltd to load data originating from non MIMS systems. We are using MIMS 3.013.
We may be able to answer your questions.

 

[VonSchau]

We want to use MSB904 for input of cost transactions from Oracle Financials to MIMS Work Orders. In our case MIMS is used only as a source of technical values and all financials values comes from OFA identified by Work Order Number. We assume to use transaction type MJV.
Because we have not enough information about sequential file type used as input for MSB904, it could help as some example of file MST903 with real data or documentation where we can find this information. We didn’t find it In official Mincom Info Pack.
Thanks very much.

 

[sb98]

Hi Von,

Usually we use this step to do interfacing into MIMS system,
Interface Lattice ke MIMS

1. Generate mst903.txt files from other system
The file format can be found in the data dictionary
for file msf903.
Copied the file into mims system and block the file to
become 316 sequential block
2. Run MSB904 to load mst903.txt
3. Check the result by run report MSR908
4. Check the batch in MSO919 option 6 or option 5
5. Run MSB919 to load the transaction into jurnal file
(MSF900)
6. Check the result in MSO901

Regards,

SB98

 

[VonSchau]

Hi SB98,
Thanks, the sequence of using import file it’s clear now. But we don’t know where have to be placed the mst903.txt files in Mims file system. Is any special directory where the script looking for input file? Can I set this directory?

Regards,
VonSchau

 

[sb98]

Hi Von,

Put the file (mst903) in work directory ../mims_run/work, since all the batch program will look for files in that directory

Regards,

SB98

 

[VonSchau]

Hi evrybody,
Thank to all for answers and help. We made the progres but we have still problems.When we run batch MSB904 for import of external transaction, the is always some error in MSF903 table file. There are error codes WORK_ORDER_ERR=2718 and ACCT_CODE_ERR=2718 in record type M.
We suppose that a problem could be either in contents of MST903 interface file or maybe in configuration of finance module.

We use Costing Option 6, Equipment Number is given from Work Order, User defined Cost Categories are used.

Has anybody idea, where could be a problem?
Is anywhere a list of all error codes with possible reasons?

 

[colinh]

Hi Von,

To find out what error message number 2718 means, go to screen MSO011 and enter Table type: ER,
Table Code: 2718. You should get the Description "Account Prohibits Equipment Entry".

The next step is going to MSO960, enter the Account number that is giving you problems, and check the value under the EQ column. You've probably got a N in there.

Change it to O-optional, or maybe M-mandatory....
(maybe see the accountant before changing this flag)

Hope this help
Colin