Sage 100

I have a client that was recently acquired by another company and is requiring monthly exports of data to use with their own database.

They noticed that the export files have an extra blank column at the end which is causing some issue when they use the data and are hoping I could get rid of the extra column.

For example there is an export for the product line that has only the product line code and the description.  When it exports is delimited format the result is.  Note the extra column at the end of the line.

"ABC","ABC PRODUCT LINE",

"DEF","DEF PRODUCT LINE",

I've found that if I using the ASCII format (basically a fixed width columns), that we don't appear to get an extra column.

Checked all of the exports that I have been doing for them and noted that all of them have the extra column.  To be perfectly honest, I really don't know why it would be an issue for them, but that is beyond my control.

Thoughts?

You would think at this point that Sage would have an option added for this but in the meantime, add the following to the Before Write Perform Logic event.

..\VI\VI_RemoveTrailingSep.M4P

That works!   Thank you David.

..\VI\VI_RemoveTrailingSep.M4P