Sage 100

 View Only
  • 1.  Due to selection criteria, client almost always pr

    Posted 12-05-2018 14:07
    Due to selection criteria, client almost always prints invoices from Sales Order history using the **A/R Reports** menu command ""Invoice History Printing"" (Panel is not Customizable). Does anyone know a trick, short of an MD, to default ""Invoice Type"" to ""Sales Order""?


  • 2.  RE: Due to selection criteria, client almost always pr

    Posted 12-05-2018 15:01
    I didn't test this but if you add a UDF doesn't show in the selection criteria of the report?


  • 3.  RE: Due to selection criteria, client almost always pr

    Posted 12-05-2018 21:22
    Thanks for the response. How come one always sees how poorly worded a question is after it's posted? My goal is to set a default for the ""Invoice Type to Print"" field in this form (""Invoice History Printing""). It always uses ""Accounts Receivable"" as the default.


  • 4.  RE: Due to selection criteria, client almost always pr

    Posted 12-06-2018 11:16
    Even if you can't access the panel via custom office, you can create a UI post load event script on another panel accessible via customizer and then DFDM CM_UIScriptSettings and the record created on the panel and change the library and panel fields, remove old keys when prompted. After changing the record, compile the UI scripts again and clean up any orphaned *M4L.vbs files left over in MAS90\CM\Script that are not used Pretty sure i have a post on here with more detail.


  • 5.  RE: Due to selection criteria, client almost always pr

    Posted 12-06-2018 11:34
    Damn your good! Thank you very much!


  • 6.  RE: Due to selection criteria, client almost always pr

    Posted 12-06-2018 11:38
    Not sure i need to tell you but i would use `oUIObj.InvokeChange` to set the value, i imagine it needs to be set to ""A"" or ""S"". i'll confirm in a bit.


  • 7.  RE: Due to selection criteria, client almost always pr

    Posted 12-06-2018 11:47
    I stand corrected. According to the program variables, the field name is ""DB_ModuleType$"" and the valid values are ""Accounts Receivable"" and ""Sales Order"" (exactly as they appear in the drop box).


  • 8.  RE: Due to selection criteria, client almost always pr

    Posted 12-06-2018 12:02
    Quick update, while testing with the debug window, InvokeChange DID cause the panel to reload the grid but did not change the value displayed in the drop box. Calling the UI object's RefreshSCRN() method DID cause it to display the updated value. You could also use `oUIObj.SetControlProperty ""DB_ModuleType"", ""Value$"", sNewModuleType` to update the value displayed instead of RefreshSCRN().