Sage 100

Client on 4.50.4. Recently the Repetitive Invoice look-up in Entry stopped working for one of their companies; still works in another. I tried to replace ALE files from backup, didn't work. Had Sage send me default ALE files, didn't work. No custom look-ups in place. Created custom look-up to force it, worked in company that always worked & not in the other. Removed it & tested again, doesn't work. Sage is at a loss as well. Says it could be the module parameters file, but not familiar with this.

Can you define not working? any errors?

In case it's a dictionary problem add a dummy UDF to Repetitive Invoice Header. If it fixes the lookup then remove the UDF.

Not working means a blank look-up. Nothing is there. No errors reporting.

I tried to add a UDF to refresh the data dictionary & it didn't help.

I've had success with this resolving lookup issues where data was showing up in the wrong columns. I've never seen it where nothing shows up. Make sure you have a good backup before trying it. 1.Select File, Run. 2.Enter SYZCON in the Program field 3.Click OK. 4.At the prompt, enter O=NEW(""SY_ACTIVATION_BUS"",%SYS_SS) 5.Press ENTER. 6.At the prompt, enter PRINT O'ACTIVATE(""y/y"",""xxx"") oy/y = module code (for example: A/R,S/O, C/I, I/M) oxxx = company code o1 is returned if the command was successful o0 is returned if the command failed 7.At the prompt, enter bye 8.Press ENTER.

Dana, I don't have a solution but we are experiencing the same. Ever since we upgraded to 2014, our AR Invoice Data Entry lookups are always empty. Tried everything but nothing worked. The only way to see what's in the open batches is to either print or use the arrow buttons to scroll thru each invoice. Everywhere else the lookups work fine.

@KennyDaniel I had a similar issue with the Shipping Data Entry lookup. It was an issue with the GL_CompanyActiveBatch.m4t. https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20MAS%2090%20and%20200/Gated%20Customers/Warr_Svc_Support%20Plan/500266.html

@KerryEsser . I think this applies to older versions. In any case, I followed the instructions and still no luck. My Batch still showing empty when i do a lookup even though I have several entries in there. In fact, when i first select the batch header gives me the correct number of entries and correct totals.

@MaryJoKrueger Sage suggested this too & it didn't work. I did get the ""1"", but it didn't help.

Dana, is this in AR or AP? There are 2 lookups on each of those screens, Customer/Vendor number and the reference. Which lookup is not working? I'm assuming that it is the reference field lookup that is blank no matter which customer/vendor you have selected. Try looking at the table AR_RepetitiveInvoiceHeader or AP_RepetitiveInvoiceHeader using Data File Display Maintenance to see if there are corrupted records, or maybe records are missing a division number? Do you see anything odd in that table.

Finally got a fix. Had to replace the module parameters file, AR_Options, & it worked! Thanks for the suggestions everyone! http://infosource.sagesoftwareonline.com/infasp/kdb.asp?isresolutionconceptid=1836

Dana....I tried going to the link you posted for fixing the ALEs...got an error...could you repost...thanks

See if this one works. https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=35811&sliceId=1&cmd=displayKC&dialogID=6194&docType=kc&isLoadPublishedVer=&stateId=6195&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

got the link....hopefully it will fix the issue...THANKS