• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

PO223.csv output "flip flops"

 2 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Mark
Basic Member Send Private Message
Posts: 17
Basic Member
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 Send Private Message
Posts: 1163
Veteran Member
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.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Mark
Basic Member Send Private Message
Posts: 17
Basic Member
10/13/2015 8:48 PM

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