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