x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 14 replies
  • Answers 1 answer
  • Subscribers 118 subscribers
  • Views 3297 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
cobbler

How to get Child or sub file (table) level data from Sage VB Script

SUGGESTED
Posted By

Hi All,

  I need to display a message box on Shipping Data Entry interface.  I can get data from "SO Sales Order Header"  and "SO Shipping Data Entry" and "Customer....".

On Custom Office using trigger of ""SO Shipping Data Entry"" and Pre-Write.

But, I could NOT get MEMO data from "SO Sales Order Memo" using the same logic code.  Please help!  Thank you all.

retVal = 0
oCust = 0
memo_code = ""

SET oCust = oBusObj.AsObject(oBusObj.GetChildHandle("SalesOrderNo"))

retVal = oCust.GetValue("MemoCode$", memo_code )
retVal = oScript.SetError("MEMOCODE string - is not blank! " & memo_code )

' set oCust = oSession.AsObject(oBusObj.GetChildHandle("SalesOrderNo"))  --- tested
' Set oCust = oSession.AsObject(oBusObj.GetChildHandle(“CustomerNo”)) --- sample

Parents
  • 0

    For the memo info, you are likely either going to have to query the memo info through ODBC within your script or get a handle to SO_SalesOrderMemo_Bus and either set each key value, set a browse filter, or use GetResultSets to get the data you want as sales order entey does not create a child object for the memo table like it does for the customer number and salesperson number.

Reply
  • 0

    For the memo info, you are likely either going to have to query the memo info through ODBC within your script or get a handle to SO_SalesOrderMemo_Bus and either set each key value, set a browse filter, or use GetResultSets to get the data you want as sales order entey does not create a child object for the memo table like it does for the customer number and salesperson number.

Children

*Community Hub is the new name for Sage City