Sequential Numbering

Kinetic ERP
1

Anyone have any ideas on how to create a sequential number in a BAQ. I am trying to get rid of bartender and we have a customer that requires a sequential number on a shipping label. It is currently being done with Bartender but I won’t need it anymore if I can figure out how to do this with a BAQ.

Thanks in advance

2

try something like this in the BAQ ROW_NUMBER() over (partition by QuoteHedTest.QuoteNum order by SFQuoteLines.LineNumber)

replace fields as needed. If you have any questions let me know.

1 Like