4Site
Support Request System
View Patch #50.013.018
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02076 -
Stock By Owner in V5 doesn't match V4
Symptoms:
1. The final totals on the Stock By Owner and Stock by Commodity don't agree. 2. The new v5 Stock By Owner doesn't agree with the previous version 4 if you run it for a period in last year and compare the two versions. 3. If the Stock by Commodity report has no transactions for the selected period it gets the error "statement has been terminated. Cannot insert NULL into lastmonthtotal" 4. Stock By Owner report title says Inventory by Owner and company name doesn't print.
Solution:
1. The Commodity version just does some extra calculations and sums it a little differently on the report. There were some issues with the initial data load. The reports are in balance now running for the original date that had problems. 2. I removed the join to pbitem and stock for unions 5-7. That was causing the difference between the old and new version of Stock by Owner. Those unions are for cases where the stock record doesn't exist in stocwhse therefore don't join back to a pbitem. So now it will print as a blank commodity for those 3 unions. That caused 11 transactions records to be skipped. The db has 4 stock items in stinitval that have no matching stock records. They also have 11 transactions. The only way this could happen is someone used SQL to delete the stock items. So they were being ignored by the new join which assumed all stinitval stock has a stock in stock table. 3. Put ISNULL around sums and set to 0 if null 4. Changed title to Stock By Owner Account to match Run Job Print company name again.
Browse Patches
Find a Patch
Return to Request System Menu
