x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 87 subscribers
  • Views 1055 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
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
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
Kevin M

Full GL Account from SO line script (CostOfGoodsSoldAcctKey / SalesAcctKey)

SOLVED
Posted By

I'm starting a script for account segment substitution (CoGS / Sales accounts on specific SO lines), and before I start testing different methods for getting the formatted Account number based on the key values (ChildHandle, open a new object...) I'm wondering if there is a shortcut to go directly there?

For the "SetValue" I can pass in a formatted account number using this:

retVal = oBusObj.SetValue("AccountKey$", sNewAccount,"kACCOUNT")

Is there an equivalent "GetValue" I can use... like this?  (Guessing at the syntax... does not work):

retVal = oBusObj.GetValue("CostOfGoodsSoldAcctKey$", sCOGSAccount,"kACCOUNT")
retVal = oBusObj.GetValue("SalesAcctKey$", sSalesAccount,"kACCOUNT")

I remember problems testing previous scripts using GetChildHandle with GL accounts, and I'd prefer not to require access to GL_Account_svc for the script to function.

Parents
  • 0
    SUGGESTED

    How about this for retrieving the formatted account numbers in SO lines:

    sCostOfGoodsSoldAcctKey = "":retVal = oUIObj.GetValue("ML_CostOfGoodsSoldAcctKey",sCostOfGoodsSoldAcctKey)
sSalesAcctKey = "":          retVal = oUIObj.GetValue("ML_SalesAcctKey",sSalesAcctKey)
retVal = oSession.AsObject(oSession.UI).MessageBox("","sSalesAcctKey=" & sSalesAcctKey & "; sCostOfGoodsSoldAcctKey=" & sCostOfGoodsSoldAcctKey)

  • +1 in reply to connex
    verified answer

    I would think that would only work if your script is only executing on the currently selected line, however, if you are looping through lines than it would not work.

    Here is a list of "data sources" that you can use GetChildHandle on from the sales order Lines object.

    MAIN
ItemCode
UnitOfMeasure
SalesAcctKey
CostOfGoodsSoldAcctKey
TaxClass
CommodityCode
WarehouseCode
WarrantyCode
BillOption1
BillOption2
BillOption3
BillOption4
BillOption5
BillOption6
BillOption7
BillOption8
BillOption9
ItemDescription
APDivisionNo
VendorNo

    So you should be able to use the following.

    oBusObj.ReadAdditional "SalesAcctKey"
sSalesAcctKey = "" : oSession.AsObject(oBusObj.GetChildHandle("SalesAcctKey")).GetValue "Account$", sSalesAcctKey
oBusObj.ReadAdditional "CostOfGoodsSoldAcctKey"
sCostOfGoodsSoldAcctKey = "" : oSession.AsObject(oBusObj.GetChildHandle("CostOfGoodsSoldAcctKey")).GetValue "Account$", sCostOfGoodsSoldAcctKey

Reply
  • +1 in reply to connex
    verified answer

    I would think that would only work if your script is only executing on the currently selected line, however, if you are looping through lines than it would not work.

    Here is a list of "data sources" that you can use GetChildHandle on from the sales order Lines object.

    MAIN
ItemCode
UnitOfMeasure
SalesAcctKey
CostOfGoodsSoldAcctKey
TaxClass
CommodityCode
WarehouseCode
WarrantyCode
BillOption1
BillOption2
BillOption3
BillOption4
BillOption5
BillOption6
BillOption7
BillOption8
BillOption9
ItemDescription
APDivisionNo
VendorNo

    So you should be able to use the following.

    oBusObj.ReadAdditional "SalesAcctKey"
sSalesAcctKey = "" : oSession.AsObject(oBusObj.GetChildHandle("SalesAcctKey")).GetValue "Account$", sSalesAcctKey
oBusObj.ReadAdditional "CostOfGoodsSoldAcctKey"
sCostOfGoodsSoldAcctKey = "" : oSession.AsObject(oBusObj.GetChildHandle("CostOfGoodsSoldAcctKey")).GetValue "Account$", sCostOfGoodsSoldAcctKey

Children
  • 0 in reply to David Speck

    Thanks David.  That is what I was thinking of trying first, but remember (years ago) having intermittent issues in a similar script where the wrong Account's information was returned... however I'm fairly certain I wasn't using ReadAdditional back then, so maybe that will make things work smoothly.

*Community Hub is the new name for Sage City