POINF022 Replenish Reorder Report - incorrect formula for UoM items - 7.02.00.00 and earlier only

Owned by Beth Blok (Unlicensed)
Last updated: Jun 14, 2019
1 min read

Problem

Where the current stock on hand is more than minimum level quantity and the item has a purchasing UoM ticked, quantities are being incorrectly suggested for re-order

Solution

SQL Skills are require

A working knowledge of SQL Management Studio is required to complete this task

Download and apply the attached stored procedure to correct the report