x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 6 replies
  • Subscribers 89 subscribers
  • Views 2816 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
seshasai

Unable to read line level data

Posted By

Hello

I am trying to read data from SO_SalesOrderDetial

i tried setting key value to read data for a given sales order

i am able to get data using GetResultSet but i am not able to read values like price , ordered etc

and when i am trying to use getvale i am not able to select the sales order

Parents
  • 0
    Can you post the relevant portion of your code? From your post it is not clear what language or methods you are using to execute the code.
  • 0 in reply to TomTarget
    i am trying to build a 3rd party application using c# to read sales order and create a xml ,

    and i have also added the sample code that i am using

    *********************************************************************************************************************************************
    *********************************************************************************************************************************************

    OrderLineObject.nGetResultSets("QuantityOrdered$", "UnitOfMeasure$", Quantity, PointOfTitleTransfer,
    "SalesOrderNo$ = " & Chr(34) & SONumber & Chr(34) & " AND LineKey$=" &
    Chr(34) & Snumber(i) & Chr(34), "", "")
    Qunt = (Split(Mid(Quantity, 3, Len(Quantity) - 3), Chr(138)))
    POT = (Split(Mid(PointOfTitleTransfer, 3, Len(PointOfTitleTransfer) - 3), Chr(138)))


    'If Not (CBool(OrderLineObject.nSetKeyValue("SalesOrderNo$", SONumber))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    'If Not (CBool(OrderLineObject.nSetKeyValue("LineSeqNo$",lineseq(i)))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    'If Not (CBool(OrderLineObject.nSetKeyValue("LineKey$", Snumber(i)))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    'If Not (CBool(OrderLineObject.oLines.nSetKey(Onumber(0)+lineseq(i)+Snumber(i)))) Then MsgBox(OrderLineObject.sLastErrorMsg)

    If Not (CBool(OrderLineObject.nGetValue("TaxAmt", taxam))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool( OrderLineObject.nGetValue("QuantityOrdered", qua))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool(OrderLineObject.nGetValue("UnitPrice", unitprice ))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool(OrderLineObject.nGetValue("ExtensionAmt", Totalprice ))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool(OrderLineObject.nGetValue("QuantityOrdered", qua))) Then MsgBox(OrderLineObject.sLastErrorMsg)
Reply
  • 0 in reply to TomTarget
    i am trying to build a 3rd party application using c# to read sales order and create a xml ,

    and i have also added the sample code that i am using

    *********************************************************************************************************************************************
    *********************************************************************************************************************************************

    OrderLineObject.nGetResultSets("QuantityOrdered$", "UnitOfMeasure$", Quantity, PointOfTitleTransfer,
    "SalesOrderNo$ = " & Chr(34) & SONumber & Chr(34) & " AND LineKey$=" &
    Chr(34) & Snumber(i) & Chr(34), "", "")
    Qunt = (Split(Mid(Quantity, 3, Len(Quantity) - 3), Chr(138)))
    POT = (Split(Mid(PointOfTitleTransfer, 3, Len(PointOfTitleTransfer) - 3), Chr(138)))


    'If Not (CBool(OrderLineObject.nSetKeyValue("SalesOrderNo$", SONumber))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    'If Not (CBool(OrderLineObject.nSetKeyValue("LineSeqNo$",lineseq(i)))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    'If Not (CBool(OrderLineObject.nSetKeyValue("LineKey$", Snumber(i)))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    'If Not (CBool(OrderLineObject.oLines.nSetKey(Onumber(0)+lineseq(i)+Snumber(i)))) Then MsgBox(OrderLineObject.sLastErrorMsg)

    If Not (CBool(OrderLineObject.nGetValue("TaxAmt", taxam))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool( OrderLineObject.nGetValue("QuantityOrdered", qua))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool(OrderLineObject.nGetValue("UnitPrice", unitprice ))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool(OrderLineObject.nGetValue("ExtensionAmt", Totalprice ))) Then MsgBox(OrderLineObject.sLastErrorMsg)
    If Not (CBool(OrderLineObject.nGetValue("QuantityOrdered", qua))) Then MsgBox(OrderLineObject.sLastErrorMsg)
Children

*Community Hub is the new name for Sage City