Sage 100

Sage 100 v2016 - Is it me or something not right in Denmark. I am in account inquiry and I want to drill down on a GL transaction. The drill down viewer appears with the GL transaction in question. Now I want to get creative by adding a button to the panel. The button needs to read the journal number and posting date fields on the panel in order to retrieve the PD associated with that transaction. I know I am getting greedy but the only information available is the GL account information NOT the GL detail posting table information. Am I thinking incorrectly? What is the logical reason to only display the GL account information and NOT the GL detail posting table. Since I don't thing I am going to get what I want, is there any workarounds for this? Presently, when I post a JE, I save a PDF of the supporting detail for that JE (via a button script) To retrieve the PDF, I need the source journal, journal register number and the posting date from the journal drill down panel. TIA.

Just asking - can't you do that ""Prompt for associated PDF during journal/register printing"" to save a pdf with a journal? And then it would all be in paperless and you wouldn't need this?

OF course. But when you use associated PDF's, if you have multiple JE's being updated at once you have to combine all of the supporting documents into one PDF. You then have to go searching paperless for the update in question and look though the PDF to find the one you want. What I am trying to accomplish is a one to one association so that when you are drilling down into the JE, you click and viola, there is the supporting document. Much much faster. I am expanding on an a script that I provide my clients to display the vendor invoice when drilling into the invoice history. One click and the invoice documentation appears.... Or customer purchase order and shipping documents in SO invoice history. The one other place that I have run into this limitation is in BOM inquiry. Ease of use is critical and associated documents, while nice, is not easy to use.

Well, you just GO, Mr. Schwenk! Or in this case, not, since it appears that Sage hasn't given you what you need...

Alas, so close but so far!!!!

I might pull out the Malgrem example from back in the day where he created a reversing JE from this panel. It might give me some clues. Also, maybe create a script that allows the user to key the three bits of information that is needed. Not exactly perfect but keeps me in the ball game. And maybe even Diane Coffman a quick win request for the v2020 release. Hmmmm.

Try drawing your button elsewhere on the panel. I know for Lines tab buttons, you need to put the button in a specific spot to have it work from the perspective of the detail table.

Calling any and all button script gurus - As noted above, I have a button script that pulls data from the Sage panel (vendor number, invoice number and date. I want to modify this script to pull data from a GL panel. Unfortunately, the Source Journal, journal number and journal date fields are not available on the GL drill down viewer panel. So my question, is there a way to open parameter prompt window to key this information, store the data as temp fields and then use these temp value to supply data to the rest of my script?? I am stumped!!! @AlnoorCassim, @RandyMarion, @MarcCregan, @DougJenkins, @KevinMoyes @other gurus.......

You should be able to have an input box with Standard (just Google for the vbs commands), but not Advanced / Premium (if you want access to business objects within the same script).

Got it to work. Not as hard as I thought it would be.