any one know to upload BOM from excel sheet or from a text file?
simple short answer: very carefullyThe 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 http://www.ryze.com/go/Al9Mac BPCS/400 Computer Janitor ... see http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.