For Data Validation Errors, the documentation used to state Table Name and Field Number, for reveiw and repair. It changed to just list field name and I find that the field in question can be "anywhere" in DFDM and is not where expected often. From customer to customer (based on how many times they have migrated); I find the fields randomly listed.
Original Message:
Sent: 10-02-2023 21:19
From: Jeff Schwenk
Subject: File Layout for SO Header History v2023
Of course they have more important things to do. If only they did them. But when Sage under resources Sage 100 while focusing on the Intacct, we must be grateful for the little things they toss your way.
------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------
Original Message:
Sent: 10-02-2023 17:53
From: Kevin Moyes
Subject: File Layout for SO Header History v2023
It's always been that way. Look at your upgraded systems and you'll find UDF's listed before newly added fields.
Yes, it's frustrating, but it works, and I personally think Sage programmers have more important things to do vs. worrying about field order (especially considering enhancements and UDF's...).
Tip: if you use CR to list the fields, you can sort them alphabetically.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 10-02-2023 17:03
From: Jeff Schwenk
Subject: File Layout for SO Header History v2023
Interesting. Good to know. But isn't this what the migration utility is all about? When you migrate, it rearranges the layout. Or perhaps they should rewrite the file layout document, so we don't waste our time looking. Perhaps they can explain at our next tech meeting.
------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
Original Message:
Sent: 09-29-2023 20:41
From: Robert Wood
Subject: File Layout for SO Header History v2023
It's that they add new fields to the end of the table. If you have a new install, they will appear in the same order as the File Layout.
--Robert Wood
352-615-5898
--
Sent from my portable brain
Original Message:
Sent: 9/29/2023 7:56:00 PM
From: Jeff Schwenk
Subject: RE: File Layout for SO Header History v2023
Found it...... At the end of the table like most others. So is the file layout incorrect is does the table display incorrectly?
------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
Original Message:
Sent: 09-29-2023 11:13
From: Kevin Moyes
Subject: File Layout for SO Header History v2023
Mine there was v2023 demo data. Yours is probably converted data, where the field would be added to the end.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 09-29-2023 10:44
From: Brett Zimmerman
Subject: File Layout for SO Header History v2023
Yeah weird, my 'shipexpiredate' field is also at bottom, as well as 'ordertype' - in both v2023 and v2022. Whatcha got going on there, @Kevin Moyes? lol
------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
Original Message:
Sent: 09-29-2023 08:57
From: Beth Bowers
Subject: File Layout for SO Header History v2023
Weird - my 2023 shows this (very last field):
------------------------------
Beth Bowers
(269) 358-0989
Original Message:
Sent: 09-28-2023 19:07
From: Kevin Moyes
Subject: File Layout for SO Header History v2023
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON