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

PO223.csv output "flip flops"

2 Replies

0 Subscribed to this topic

40 Subscribed to this forum

Sort:

Author

Messages

Mark

New Member

Posts: 0

10/13/2015 3:34 PM

Has anyone noticed on PO223 that columns DD and DE swap places randomly? We seem to have them swap every 2-3 months.

JonA

Veteran Member

Posts: 1163

10/13/2015 4:13 PM

Sometimes it's hard to make sense of how Lawson converts reports to csv. In this case I believe that whichever comment field has data to display first determines which column the data falls in. The data in the csv is displayed in this order: Buyer Code, Vendor Number, PO Number, PO Line Number. If the first PO (going down the rows) to have comments has header comments rather than line comments then HEAD-COMMENT will be in DD. But if the first PO to have comments has only line comments then LINE-COMMENT will be in DD. If all the POs in the report have only line comments there won't be a column for HEAD-COMMENT at all and likewise if all the comments are header comments.

Mark

New Member

Posts: 0

10/13/2015 8:48 PM

Thanks Jon. Hate to say it but it sort of makes sense.