/
Non-physical inventory items used in Job Costing now appear in Transaction History tab

Non-physical inventory items used in Job Costing now appear in Transaction History tab

Owned by Beth Blok (Unlicensed)
Nov 25, 2019
1 min read

Problem

Non-physical inventory items used on jobs did not appear in the Transaction History tab of the inventory items - 7.00.175 and earlier

Solution

SQL skills required

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

Download the attached SQL script and apply to the relevant database

Related articles







Related content

Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01
Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01
Jiwa 7
More like this
Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
Jiwa 7
More like this
Job Costing
Job Costing
Jiwa 7
More like this
Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
Jiwa 7
More like this
JCMGT020 - Job Costing Actual Listing is not reporting all data types
JCMGT020 - Job Costing Actual Listing is not reporting all data types
Jiwa 7
More like this
Returning stock incorrectly allocated to inventory from Job Costing
Returning stock incorrectly allocated to inventory from Job Costing
Jiwa 7
More like this