Sage 100

 View Only
  • 1.  Is there any way to add a link on the SO Lines tab

    Posted 03-23-2013 11:07
    Is there any way to add a link on the SO Lines tab that allows you to use the SO LInes UDFs? No matter where I've placed a link, it only brings up the SO Header UDFs for placement. I know I can add the UDFs to the actual line fields, but there are about 50 of them and I'd like to break them down into 4 different boxed screens.


  • 2.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-23-2013 11:20
    I think Dan Burleson has done something along these lines..


  • 3.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-23-2013 11:53
    Link type script allows for SO Line udf selection in the variables.


  • 4.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-23-2013 12:09
    I don't need a script, really - I just need 4 boxes that hold 10-15 variables each which are line-related.


  • 5.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-23-2013 18:05
    i guess I'm not understanding the term ""link"".


  • 6.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-23-2013 18:53
    If you want to add a button to pop a dialog that will let you add Line UDFs, it can't be done. Line UDFs can only go on the grid :(


  • 7.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-24-2013 10:09
    Oh, man, @AlnoorCassim , you're killing me. Or I should say, the client will be killing me...


  • 8.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-24-2013 23:08
    I checked it out and there is a way to do it but personally I would go for a mod or some perform logic as this is a bit cheesy, somewhat confusing and certainly time consuming. Customizer is not conducive to the idea of multiple dialog boxes for a single line. But I'd also like to say the initial premise of having to fill out 50 UDFs on a single line, whether on the grid or in 4 dialog boxes is time consuming data entry to begin with. And S/O Entry overall may just run slower managing all these fields. Here's what I mean by not conducive. Let's say you want 12 of the 50 line UDFs on Dialog Box 1. Now let's say you created 12 header UDFs with the same name (or nearly the same name). Now you put those 12 on the dialog since they live on the header. Next to those, off to the right you insert a Customizer button tied to a script. So the flow would go like this: User is on Lines tab. They click their mouse on Line 1. Then click your button that pops the 1st dialog box of 12 UDFs. They fill in the UDFs and click the script button to the right. It sets the value of those 12 values into the line UDF equivalents (don't even need to add those lines UDFs to the grid). Then they click the normal OK button on the dialog to close it (IOW 2 buttons to click in the dialog). The command to auto-click the normal OK button doesn't seem to work there. A workaround would be to have 12 event scripts (1 for each UDF) to replace the 1 button script). Now that's done, the users clicks Dialog box 2 for the next 12 or 13 UDFs and repeats. When they're done with dialog 3 and 4, they have finished Line 1! They move to the next line and press Dialog Box 1 again. The problem now is the values from Line 1 are still ""remembered"". We can't run a script when the dialog loads to clear them out so this becomes confusing. And I think they'll feel like they're in button click hell (unless you have 1 crazy dialog of 50 UDFs). Have you thought about adding the line UDFs to the grid and using the wide panel? This is a case where having secondary grid off to the right might makes sense.


  • 9.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-25-2013 05:27
    @AlnoorCassim - took a second for my eyes to come back from rolling into the back of my head. It wouldn't actually be that bad for the client as it sounds because only 1 set of these UDFs apply to each item, not all 4, but still... I'm going to show them the grid tomorrow and see what they say. (This is an install from hell I'd give away in a heart beat anyway, so this is just par for the course. I don't think I've ever worked with two people more dead set on sabotaging an install than the 2 customer service women.)


  • 10.  RE: Is there any way to add a link on the SO Lines tab

    Posted 03-25-2013 05:27
    @AlnoorCassim - and thanks for digging into this, by the way!