any one know to upload BOM from excel sheet or from a text file?

simple short answer: very carefully

The thing is, when you manually key in anything to BPCS, it updates a bunch of files in sync with what you are entering. Oh yes you can dump anything into BPCS files, but then there is a high risk that BPCS will be broken, because the other files are no longer in sync with what you dumped in.

For example, there are fields in the IIM (item master file) that have counts of how many records in the BOM chains. These fields need to be correct for other BPCS programs to correctly navigate the records. For our labor reporting to work, there are fields that need to be in sync between FRT (routings) and MBM (BOM), plus we also have MPN (Engineering notes).

Suggestion: study what gets rebuilt by various reorganizations like BOM905, to see how much of what you corrupted, by your upload dump, gets fixed by the relevant reorganization programs. Also figure out what sequence to run reorgs and related programs such as a cost rollup ... you need CIC and CMF records added in sync with the new BOM records. How are they going to get there? Review all the files that get updated or added to, when you key in BOM manually, then figure out how those files are to be taken care of in your dump. There may be some help in the dump programs that come with BPCS ... take a look at SYS/23 menu.

Al Macintyre
BPCS/400 Computer Janitor ... see

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.