Sage 100

2017 Premium. I am trying to create a VI job and the AR_Customer table isn't one of the available selections. Why would this happen and how can it be corrected?

Is the data dictionary messed up?

is it possible someone restored the SQL customer table with different ownership?

Doug yes there a few tags for V/I in the dictionary. You can DFDM Providex.ddf then at bottom change Key No to ByName then type AR_CUSTOMER Once you're on the record on Field 9 there are 2 items you can look at: The BUSOBJ= must include ""AR_Customer_bus"" The extnTBL.ImportExclude should be equal to 0 not 1 There are more fundamental things also like A/R not being activated in TST company or like Lee said you have tables owned NOT by dbo (because of the way the DB was restored or attached or the way a wizard was used to copy a DB).

@AlnoorCassim extnTB.BUSOBJ="""" Is there any chance that adding the AR_Customer_bus is going to create any damage? They have DSD Multibin, ScanForce, and some custom mods.

I can't imagine any mod removing that on purpose. Might be an install routine that didn't merge properly. Normally I would say just add that in yourself (after backing up DDE, DDF, KDF, etc) because that entry is primarily for exposing tables to VI and for flowing UDFs through _Upd objects, not for regular programming. You would add not just AR_Customer_bus but whatever else you see on your own system for the same version. Alternatively reinstalling A/R would do the same thing. Also to answer your question, I can't see how adding this hurts the mods in place unless they are doing something non-standard. My official answer is ask the mod developers about adding this entry. They may need their own _Bus or _Upd classes added for AR_Customer on top of what Sage adds. Therefore in the end, the best non-hack approach here maybe reinstall A/R then reinstall the mods. If this is clear as mud, call me or send chat.

Thanks Alnoor. I will probably back up the dde, ddf and kdf files then risk it.

I used syzcon, dd and added the missing business objects to the data dictionary. All seems to be working as intended. Thank you!

Cool. I didn't know you had the DD.

It happened to be previously installed by one of the developers, so I used it.