- Client is on V6.0

- we have written a report that will pick up the optional fields from the OEINVDO table using the OEAUDD as the source as we require the fields from this table.

- in the INVDD & INVDO table the LINENUM field increments as 32 / 64 / 96 / 128,etc.

- In the AUDD table the LINENUM field increments as 1 /2 /3 /4 / etc.

- So there is no problem to divide the INVDO field by 32 (and this works fine)

- HOWEVER - we occasionally get the AUDD LINENUM field that has its own range of numbers (one example 3 / 4 / 5 / 6) (another example 9 / 10 / 11 / 12), but the INVDO file still has the 32/64/96/128, so when we do the divide, they do not match anymore ???

- Does anybody know what is causing this problem and why would the OEAUDD table now have these weird numbers, as this now stops the report form working properly

I have been working on this for several days now to find a way around this, trying to use other tables, but can not get the match to work - any and all help would be most welcome.

much appreciated.