VI Job for Work Orders

Started working at a new company that manufactures equipment and they are wanting to implement Work Orders for their jobs. Due to the increase of data entry etc, they have me looking at importing Work Orders instead of manually creating them. We utilize the BOM module for their required materials and Routing No's for Operations. When I do the VI Job into the Work Order Master table, I can import the Bill No and Routing No, but it is not auto populating the Operations and Materials tab like it would if we manually create the Work Order. How do I get those 2 tabs to auto fill based on the information that is in the Header tab of the import, or do I have to manually import the Operation Steps and Material Lines? I've figured out the Operations Steps import as a 2nd VI Job, but I haven't figured out how to import the Material Lines.

I have a little experience in VI, but it has been basic Customer, Vendor, and Item imports. This is a little above me head and being its the old framework isn't making it any easier for me to figure out. 

We are using Sage 100 v2014 if that helps.

Thanks,

Mike

  • 0
    From past experience, I believe you have to specifically import everything.

    When they get the work order module into the business frameworks object (coming from what I have heard), I hope that it will auto populate those sort of things like it does for other modules.
  • 0
    Hi Mike,

    WO.MASTER import updates WO1 & WO2 (Materials). WO.OPERDTL import updates WO3 (Operations)

    If your source file has WO1 & WO2 data on the same record, then you need to select "Header Information Included in Detail Line" on Configuration tab and properly define the Detail Record on the Records tab - a simple method is to double click "Detail Record", de-select "Perform Logic Only", change Relation to "Not Equal (<>)" and then click Accept. This will work as long as 1st column in source file contains data and you want to import that record.

    I would also suggest reviewing KB21323 - How to determine required fields for Legacy import jobs found in the knowledgebase.
  • 0 in reply to Sage100ERPHelper
    Hi Scott,

    I was successful in getting Work Orders imported with Material and Operations information. I am doing cleanup now to streamline the process and I need to test with real jobs and not 1-4 line import files...lol. So far so good though. I wouldnt of made it this far without your information. Thank you very much.