4Site
Support Request System
View Patch #60.001.087
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03869 -
Stock data dump
Symptoms:
Required data dump of the current stock on hand for each catalogue item sorted by commodity and site. Columns as per below. Site Expense Element Commodity Code Catalogue Number Description of Item Unit Price Qty on Hand Value of stock on Hand Data is required in Excel or csv with all information contained on a single row so a pivot table will be able to be applied. Can this script be set up on our system so we can dump the information routinely
Solution:
The requested data has been retrieved and provided in an Excel file. For routine execution, a new "Current Stock on Hand" View under the "Stores" category has been created in the Query Utility which can be used to export the data to Excel as required.
Browse Patches
Find a Patch
Return to Request System Menu
