Inventory Qty as At Report reports warehouse inwards incorrectly when In Transit is not used - 7.01.00 only

Owned by Beth Blok (Unlicensed)
Jul 03, 2018
1 min read

Problem

Transactions for Warehouse Transfers incorrectly reporting the receiving warehouse transactions as negatives instead of positives

Solution

SQL skills are required

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

Download and run the attached SQL script over the database(s) and import the corrected reported using Refresh from Files into the 7.01.00 database.