x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 139 subscribers
  • Views 119 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
David J Young

Order number on Open Items panel

SUGGESTED
Posted By

I'm trying to display the order number from either the SINVOICED or SINVOICEV table in the "Open Items" left panel for A/P-A/R accounting payments.

I have it all setup, but the value is always <empty>.  I know there is data that could be displayed, it's just not fetching it or displaying it from the table, and I'm not sure why.  Any thoughts?

I've added line 2 & 3 to the DU6 object:

Then I added this to the selection screen:

I've also tried this:

Using this discussion as a reference:

 Purchase Receipts: Show PO on left list 

  • 0
    SUGGESTED

    David, sometimes I create a script and a funprog where I pass some parameters and get the information as a result.

    SCRIPT NAME = ymydll.src

    funprog find.information(parameter1, parameter2)

      value integer parameter1

      value char parameter2

      local char res

      declare tables

      find values (filter, read, for, whatever) 

      res=desired value

    end res

    ============================

    Then, in the object left list browser, you can call this function this way:

    func ymydll.find.information([F:DUD]DUDTYP, [F:DUD]DUDNUM)

    It will return a string showing what you need.

    You can't use this column as a filter on the browser.

    I hope it helps

  • 0

    Have you tried just adding the the Table SINVOICEV and the field INSORDNUM (no expression) to the selection list?

*Community Hub is the new name for Sage City