Sage 100

 View Only
Expand all | Collapse all

Trying to modify the ""select invoices for payment

  • 1.  Trying to modify the ""select invoices for payment

    Posted 08-29-2017 09:47
      |   view attached
    Trying to modify the ""select invoices for payment"" panel to display the sort field from the vendor master. I am unable to open the panel in CO to look around. Is it possible to modify the panel? Thanks in advance.


  • 2.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 11:35
      |   view attached
    I opened the screen then opened it in customizer by hitting Ctrl + F9. Yet it doesn't appear to be allow any modification; no add-an-item options are available and right clicking to access the grid format isn't available, either. The panel name is attached.


  • 3.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 12:11
    I tried the same thing @MichelleTaylor1. Funny it opens it but you can't do anything with it.


  • 4.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 13:07
    So close. I think I will create a UDF in the invoiceheader table, then populate with the sort field when entering the invoice. Thanks all.


  • 5.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 13:30
    A/P > Common Entry > DSELECTINVS


  • 6.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 13:39
    Well, thank you very much @BrettZimmerman - That did get me into the panel to edit, but no cigar either. It appears to be only the open invoice header table fields that are available. You are unable to add any other tables. I did find this link regarding adding a link in an ALE lookup but it doesn't seem to fly with a panel modification. But maybe I am staring at it the wrong way. https://90minds-com.socialcast.com/messages/22736610?ref=stream


  • 7.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 13:58
    Bummer, although it looks like you can do it as follows (which I'm guessing will only work 'going forward' and not for existing invoices): 1. Create AP Invoice Header BO udf (based on Vendor Sort field) 2. Create AP Invoice Header Posting BO udf 3. Create AP Open Invoice BO udf


  • 8.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 14:01
    My thoughts exactly


  • 9.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 14:05
    Cool, wasn't sure if that's what you were referring to above.


  • 10.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 14:31
    Follow Brett to DSELECTINVS and when you find yourself on the blank window, just double click. You should get a List Box Definition and you can add items onto the 2. Format tab


  • 11.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 15:03
    But only items that exist in the selection. I was hoping that I could add the sort field value from the vendor master. This did not appear to be an option.


  • 12.  RE: Trying to modify the ""select invoices for payment

    Posted 08-29-2017 16:12
    Add the Sort field to AP Open Invoice as a Business Object and then it is available to add to the selection screen as a UDF