Calling a Macola screen from Flexibility

[jbelk11]

Good afternoon....

I am using Macola ES 9.5.100

We would like to have a button on the Power Price Inquiry screen (OEPDSPRC) that only displays the open quotes for the specified customer number and item number. Presently, if you click the default "Open Orders" button, it will display all open orders for the item number specified.

I have managed to create a button that calls a UserForm displaying the summary information in a ListView (had to add a reference to Microsoft Windows Common Controls). Now, I would like to provide drill-down capabilities to actually view the specific quote (similar to how Macola does it). Instead of reinventing the wheel (which I could do), I was hoping to be able to modify the DblClick event on the ListView to open the specific order using the Macola screen.

I have looked at "Flex - How to Call a Macola Screen from Flexibility" written by Victoria Aiken on the portal. However, renaming FjMacExe.exe does not have the effect shown in this document If you bring up the OE/View/Order/Invoices screen, enter an open order number, rename FjMacExe, then double-click the file....it opens right up with no error message. However, if you rename FjMacExe prior to opening OE/View/Orders/Invoices, you do get the error message.

Has anyone ever done this?

Thanks

Jen

 

[dgillz]

Please cite the document number in question.

honestly I tried for 10 years to do this in Progression but they (Exact) said it was impossible. If I can do this from ES I am really interested myself.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[jbelk11]

Hi Don....

The document number is 17.513.944

So far, I'm heading down the path of recreating the Order View screen....but it just seems silly to recreate the wheel.

Jen

 

[NEmacGuy]

Tori's technote has been out there for awhile. If you are having an issue, I would give her a call. She is outstanding. I know we used this function somewhere and worked fine. You want to rename the the FJMACEXE.EXE before you open the window, and you should get the error message, which will expose the required parameters. Tried it as Tori technote lists, and worked first try.

 

[dgillz]

I got this to work, but the OEINQQRY screen does not have focus and it is not displaying the credits. As soon as I figure the rest of this out I will post the code here.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

The trick to this was the parameter had 21 trailing spaces. It was not clear from Tori's document how many spaces there were.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

OK here is the code to open the screen. I created a push button called open quotes.

Private Sub OpenQuotes_Click()
Dim FJParam1, FJParam2, FJParam3, Pad As String
Pad = String(20, " ")
FJParam1 = "OEINQQRYOEOEMENUNNN "
FJParam2 = Mid(macForm.ConnInfo.Server & Pad, 1, 20)
FJParam3 = Mid(macForm.ConnInfo.Database & macForm.ConnInfo.User & Pad, 1, 20)
ShellExecute 0, vbNullString, "FjMacExe.EXE", FJParam1 & FJParam2 & FJParam3, "C:\MACOLA~1", SW_SHOWNORMAL
End Sub

Module basAPI I used verbatim from the document # referenced.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html