Sage 100

Import into Inventory Override Auto Display Settings Just upgraded customer to 4.5 and all the memo's came over to never display . I can change the item memo to Auto display through VI but they want each item specific to a module . I don't see a file to import into in VI. Crystal has a file called IM_ItemMemoSetting. This is what I need. Does anyone know where this file is or how I can get the current memo's set correct with out doing it manually? They have several 1,000. Please tell me I am missing something :)

Here is a screen shot

How about importing to GL_CompanyMemoManagerSettings. This file writes to CI, Main, Memo Manager Maintenance

I don't see it in VI? But that file would work also.

Hey @JaneCavanaugh I can export from those files but looks like I can't import into them....

Go figure - nothing is ever easy. I see files for each module for memos. Maybe you could export for each module, change the setting and import back.

The memo's are for items and I need them to display in certain places. So I did looked at what you suggested but each module is for that module EX - PO module is for the memo for the PO . No place to say I want the inventory item to display. Thanks anyway!

It looks like IM_ItemMemo may have what you need and you can import to it.

I had the same issue previously. A client had memos (yes, plural) for almost every customer. The memos popped up EVERYWHERE, hence, no one read any of them. I couldn't figure out how to change the settings via import. So, they are still popping and being ignored.......and they continue to add new memos :)

You just gotta love that Sage gives them this feature and no utility to fix the records they already have. OR give us the files to fix them.... In the previous version they were on they chose where the memo would display a yes or no for PO- INV - SO and now they upgraded and none of that comes over.... so frustrating!!!

This is where the SQL version let's you get around Sage's planning to fail: UPDATE IM_ItemMemo SET AutoDisplaySetting = 'Y' takes care of all of the whole file, probably in less time than it takes to type that in.

Thanks Phil Just rub it in on what SQL can do !!! But we don't want all of them to be set to Y. It is based on the item and Memo... We are going to change the auto display that is for all modules and the balance of them will have to be done by hand. Sloppy Sloppy programming..... I sure do hope that when they upgrade to 2013 it all comes over right !!!

You can add WHERE clauses to the SQL to narrow it down.