/
ININF150 - Serial Number Tracking report has been updated to report all supported transaction types 7.02.00
ININF150 - Serial Number Tracking report has been updated to report all supported transaction types 7.02.00
- Beth Blok (Unlicensed)
- Mike Sheen
- Julie Hanlon
Owned by Beth Blok (Unlicensed)
Problem
Serial Number Tracking report had not been updated to for the new transaction types (warehouse transfers, work orders etc.) and only reported sales order transactions
Solution
A working knowledge of SQL Management Studio is required to complete this task.
Updated stored procedure and modified report are attached for download. Run the SQL script over the 7.02.00 database(s) and use Refresh from Files to import the updated report into the database.
Related articles
https://jiwa.atlassian.net/browse/DEV-7178
, multiple selections available,
Related content
Standard invoice lists all the serial numbers invoiced rather then the serial number applicable to the delivery - D02 and higher
Standard invoice lists all the serial numbers invoiced rather then the serial number applicable to the delivery - D02 and higher
More like this
Manual serial numbers printing on a sales order invoice report
Manual serial numbers printing on a sales order invoice report
More like this
POINF024 - Outstanding Warehouse Purchase Orders report Transfer field is too short
POINF024 - Outstanding Warehouse Purchase Orders report Transfer field is too short
More like this
Freight is incorrectly included in the total for invoices for snapshots > 1 in version 7.01.00
Freight is incorrectly included in the total for invoices for snapshots > 1 in version 7.01.00
More like this
Inventory reports have been re-formatted for readability
Inventory reports have been re-formatted for readability
More like this
LCINF020 - Inventory Booked in but Not Invoiced with a book in status
LCINF020 - Inventory Booked in but Not Invoiced with a book in status
More like this