I need to create the Aged A/R report as a fixed length text file (i.e. not delimited, each value must begin in a specific column). My search of these forums has revealed quite a bit about delimited, but not fixed length. Any ideas? And, for this report specifically (based on Report 10040), what trigger would I start writing output? I’ve sort of decided on a combination of STRLEN, MAXSTRLEN, and PADSTR. I was hoping there might be a more elegant solution. cheers, Matt. Edited by - matt_b on 2002 Jan 25 20:46:00
If there is a more elegant solution, please let me know. But for now, BFI (brute force and ignorance) has won the day.
We put the A/R Aging into a table daily. We use the Customer Care System (Has the aging stored in fields) and export it to a table (You can use ODBC if you want to). Or, you can write the aging to a Navision table and use a dataport to get it to fixed lengths. Yours in Software, /m