Transaction History type Sales Order Outwards returns no data

Owned by Beth Blok (Unlicensed)
Last updated: Aug 16, 2017
1 min read

Problem

In the Transaction History tab of Inventory > Order tab, selecting the type Sales Order Outwards returns no data.

Solution

SQL skills are required

Sound SQL skills are required to complete this task.



The query controlling this return of data to this grid - usp_JIWA_Inventory_BuildGrid_TransactionHistory has been adjusted to to select all Sales Order Outwards records.  Corrected stored procedure is attached to implement as needed for versions  7.00.149, 7.00.157 and 7.00.175 only.