Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5208

	People Online:
	Visitors: 438
	Members: 0
	Total: 438

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Lawson 10.1 PO20.1 Comment Upload

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Jon S

New Member

Posts: 1

9/26/2023 12:54 PM

Hi y'all,

I have recently built an upload for some pretty repetitive POs that I make regularly, and I've ran into an issue.

Currently, we add a trailer comment to each of these POs that is unique to each PO, which means comment codes can't be used.

I was wondering if anyone knew where in the upload wizard I could find the PO comments? I know that they are stored seperatly and merely linked to the PO, but for the life of me I have not been able to find where that is in the upload wizard interface. I know that one of the self-contained worksheets can access the comments, but I couldn't understand the VBA enough to understand how it accomplished that.

I've considered using temporary comment codes, but once again I can't find where the text of the actual comments are in the upload wizard.

Anyone have any hints or advice on this, or is my best bet to just manually add the comments before releasing them manually?

John Henley

Posts: 3353

9/26/2023 10:34 PM

Hi Jon. I'll start by saying what you're trying to do can't be done with the "normal" upload wizard. Comments are stored in extra tables that are related to the primary tables. With the upload wizard you are only uploading against forms. If you want to get more understanding of how attachments work in Lawson, see:
https://lawsonguru.com/Ar...chments-in-Lawson-v8

As for using the "self-contained" workbooks, they can take some work to get installed and configured, because they are very specific to certain versions, but they are powerful. In the case of the PO comments workbooks, they do use some Lawson APIs (getattach/writeattach) that work with comments and add them using Lawson-supported logic.