BUG fix: Unpaid Reserves not updating properly on posting

Fix Unpaid Reserves quantities after posting. Find lines where Reserved Quantity differs from Quantity Remaining, then correct the Unpaid Reserve Information quantity (fixed from v23.31.24.0).

Posting sales order lines with Unpaid Reserves (UPR) were not properly updating the Posted Qty. (Base) or Qty. Remaining (Base). This has been fixed in release V23.31.24.0 (29/03/24).

Prerequisites

• Unpaid Reserves exist.

Issue

For a period after a Microsoft Hotfix, Posted Qty (Base) and Qty. Remaining (Base) fields were not being updated correctly when a sales order was posted that contained lines originating from a UPR. The underlying reservations and item ledger entry stock balances are correct. Where stock is low or most stock is held in unpaid reserve, item availability may show a negative figure.

Fix

The fix involves identifying which records are wrong using the Unpaid Reserve Item Lines page and then manually amending the UPR Information quantity to reflect what's remaining now.

To correct the unpaid reserve record:

• Navigate to the Unpaid Reserve List and click on any Quantity (Base) figure. This opens the Unpaid Reserve Item Lines page.
• Once on the Unpaid Reserve Item Lines page remove all filters.
• Personalise the page and add the field Reserved Quantity to the list somewhere near Quantity Remaining.

  
• Export the list to Excel and highlight the rows where Reserved Quantity <> Quantity Remaining. These are the records that need to be amended.
• For each incorrect UPR, open the Unpaid Reserve Information page and amend the Quantity value.

  

  If in doubt you can navigate to the Item Ledger Entry list page filter using the entry number in the Source Info field and view Remaining Quantity and Reserve quantity to see if there is any free stock and who else might have that stock reserved.

Contact the Bevica team if you have any questions.