We have historically done modifications in-house. As such, we just went through an upgrade and I did not make modifications to spsoGetNextSONo. I think I this is the classic case of trouble reproducing errors. Let's try a different approach. Below is a code excerpt from the stored procedure that I believe is the source of the error:
IF @_iTranType = 801
BEGIN
SELECT @_lRecordsFound = COUNT(*)
FROM tsoSalesOrdLog WITH (NOLOCK)
WHERE TranNo = @_lPaddedNumberStr
AND TranType = 801
AND CompanyID = @_iCompanyID
IF @_iUseSameRangeForBlanket = 1
SELECT @_lRecordsFound = COUNT(*)
FROM tsoSalesOrdLog WITH (NOLOCK)
WHERE TranNo = @_lPaddedNumberStr
AND TranType = 802
AND CompanyID = @_iCompanyID
IF @_iUseSameRangeForQuote = 1
SELECT @_lRecordsFound = COUNT(*)
FROM tsoSalesOrdLog WITH (NOLOCK)
WHERE TranNo = @_lPaddedNumberStr
AND TranType = 840
AND CompanyID = @_iCompanyID
END
Assume the following:
- tciTranTypeCompany.NextTranNo = 2 for TranType = 801.
- There exists a record in tsoSalesOrdLog for TranNo = 2 and TranType = 801.
- There are no records in tsoSalesOrdLog for TranNo = 2 and TranType = 802 or 840.
- UseSameRangeForBlanket and/or UseSameRangeForQuote = 1.
Using these assumptions, the above code will return @_lRecordsFound = 0 at the end of the IF @_iTranType = 801 block. In my testing, I added
and @_lRecordsFound = 0
to both IF statements for blankets and quotes to achieve the correct result.
I hope this might help in reproducing the problem. Again, thank you for your time - I really appreciate that you (Sage) are responsive to my questions on a user forum.
