Hi, I'm new to Syteline and I'm trying to write a utility that can move/adjust inventory using ADO to access the database. The problem with this is that I'm not sure how to generate new material transactions. I can insert a new row in the matltran table, but getting a proper trans-num value is problematic.
My first idea was to use an aggregate function to get the last trans-num and increment to generate the new one, but this wouldn't work well because:
Thanks in advance.
PS - We are currently running Syteline 6.
My first idea was to use an aggregate function to get the last trans-num and increment to generate the new one, but this wouldn't work well because:
- It takes a LONG time to process.
- This doesn't guarantee a unique transaction number.
Thanks in advance.
PS - We are currently running Syteline 6.