4Site
Support Request System
View Patch #50.033.008
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02842 -
'Incorrect syntax error near =' changing requisition price
Symptoms:
Consider the following scenario. 1. Create a purchase requisition with one line, price 0.00. 2. Add a test line to the requisition. 3. Close the Purchse Requisition application. 4. Rerun the Purchse Requisition application. 5. Open the requisition added in step 1. 6. Double click on the text line, change the text and save. 7. Double click on the 0 price line and change the price. 8. Click Save. The following error will be displayed: An error occurred while attempting to update this purchase requisition line. Line 1: Incorrect syntax near '='. If you close the Purchse Requisition application, re-open the requisition but no not change the text line, the price can be successfully changed.
Solution:
The update of the upcount variable is only required on a change option.
Browse Patches
Find a Patch
Return to Request System Menu