Personalization, Customization and Productivity Tools

[Chris_Mattson]

Any hints on which tables i should be using?

mas90 4.40

Thanks!!!

[DFeller]

You cannot use VI to delete records.

Dawn

[Chris_Mattson]

Can I use v/i to merge them to a junk b.o.m. part number?

[BigLouie]

No. VI basic function is to write records to tables. It does not have the logic to remove records and certainly not to merge them. In BOM you can use the Change Control to manage components.

[Chris_Mattson]

oh, this should work

http://community.sagemas.com/t5/Distribution-Manufacturing-and/Is-Deleting-Obsolete-Inventory-Items-...

At least v/i can populate the table for me. I have about 4000 b.o.m.s to delete and didn't want to key them by hand.

[BigLouie]

Actually it will not. When you try this it will fail with the message that Bill of Materials exist.  Your best option maybe to use VI to Export the BOM file and then re-init and then re-import. If you want to try this method I cannot urge you strongly enough to do this in a backup company until you get it right.

[DFeller]

You can use BOI to delete though.

Dawn

[BigLouie]

---

DFeller wrote:

You can use BOI to delete though.

Dawn

---

That's easy for you to say, you're DFeller!

[Chris_Mattson]

Thanks Dawn!

I'm not certain how savvy my reseller is with BOI, but we are getting together to use v/i to import work order transactions so I will ask him about it then.

Thank you and BL for the suggestions!

[apttvss]

What is BOI?  I have successfully written a VI job to import BOM's but I have to manually delete them first.  I would like to automate deleting them too.  I am on version 4.3 and I don't see a BOI file.