Ceres5.03.06 - Improved Quantity Available

Modified on Wed, 05 Jun 2024 at 11:42 AM

Service Request: SR-0002885

Issue addressed: Slow performance during Quantity Availability calculations.

Objects Affected:

Type               ID                    Name

Table              313                 Inventory Setup

Table              14012555      Quantity Available Buffer SQL

Codeunit       14012258      Lot Management

Codeunit       14012396      SQL Qty. Available Management

Page               461                 Inventory Setup

Page               14012472      Item List Qualified


This release does present a change in system usage methodology. 


Resolution: With this release Ceres has been updated to use SQL Server Stored Procedures to perform some tasks when calculating quantity available. This feature can be enabled/disabled with the “Use SQL Qty. Available” flag on the General tab of Inventory Setup:

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article