x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 3 replies
  • Subscribers 111 subscribers
  • Views 970 views
  • Users 0 members are here
Browse Forums
Announcements
311
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
4k
replies
Partner Cloud
57
topics
117
replies
Payroll, Time Tracking, and Job Cost
794
topics
1k
replies
Reporting and Analytics
984
topics
3k
replies
Sage CRM for Sage 100
166
topics
361
replies
Technical and Installation
2k
topics
10k
replies
Year-end Forum
90
topics
237
replies
John Pan

SO_SalesOrderMemo_bus SetValue on field Attachment not work

Posted By

we use a external BOI to maintain sales order memo, to validate attachment file path is valid, below script works for all other memo fields except Attachment. Does SetValue not work on field Attachment?

retChk(oSS.nSetDate("S/O", Today.ToString("yyyyMMdd")), oSS)
retChk(oSS.nSetModule("S/O"), oSS)
Dim obj1= oSS.nLookupTask("SO_SalesOrder_UI")
RetVal = oSS.nSetProgram(obj1)

'set up bus object
soORDER = oPVX.NewObject("SO_SalesOrderMemo_bus", oSS)

'set SalesOrderHeader key: SalesOrderNo
retChk(soORDER.nSetKeyValue("SalesOrderNo$", so_SalesOrderMemo.SalesOrderNo), soORDER)
retChk(soORDER.nSetKeyValue("MemoCode$", so_SalesOrderMemo.MemoCode), soORDER)
retChk(soORDER.nSetKeyValue("SeqNo$", so_SalesOrderMemo.SeqNo), soORDER)
retChk(soORDER.nSetKey(), soORDER)


retChk(soORDER.nSetValue("MemoDesc$", so_SalesOrderMemo.MemoDesc), soORDER)
retChk(soORDER.nSetValue("MemoDate$", so_SalesOrderMemo.MemoDate.ToString("yyyyMMdd")), soORDER)
retChk(soORDER.nSetValue("ExpirationDate$", so_SalesOrderMemo.ExpirationDate.ToString("yyyyMMdd")), soORDER)
retChk(soORDER.nSetValue("ReminderStartDate$", so_SalesOrderMemo.ReminderStartDate.ToString("yyyyMMdd")), soORDER)
retChk(soORDER.nSetValue("ReminderEndDate", so_SalesOrderMemo.ReminderEndDate.ToString("yyyyMMdd")), soORDER)
retChk(soORDER.nSetValue("AutoDisplaySetting$", so_SalesOrderMemo.AutoDisplaySetting), soORDER)
retChk(soORDER.nSetValue("Attachment$", so_SalesOrderMemo.Attachment), soORDER)
retChk(soORDER.nSetValue("MemoText$", so_SalesOrderMemo.MemoText), soORDER)

retChk(soORDER.nWrite(), soORDER)

Parents Reply Children
  • 0 in reply to BigLouie

    Thank you Big Louie, I did try attachment text using UNC, like C:\Shipping\Notice1.pdf, \\servername\shipping\Notice1.pdf, none of them work, it pop up this error message, if I do not update attachment, all other memo fields can be saved without issue, like memo desc, memo text, etc.

  • 0 in reply to John Pan

    if I use SO_SalesOrderHistoryMemo_bus, it works, I can add or update memo with attachment text in SO_SalesOrderHistoryMemo

    soORDER = oPVX.NewObject("SO_SalesOrderHistoryMemo_bus", oSS)

    I also test PO_PurchaseOrderMemo_bus and PO_PurchaseOrderHistoryMemo_bus, both can add or update memo with attachment text without error.

    only SO_SalesOrderMemo_bus not allow SetValue to attachment?

*Community Hub is the new name for Sage City