rpsc_matrix_load
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
rpsc_matrix_load [2016/04/14 11:25 (8 years ago)] – [How to get things ready for import into System Five] sjackson | rpsc_matrix_load [2016/04/14 11:25 (8 years ago)] (current) – [Pitfalls and things to watch] sjackson | ||
---|---|---|---|
Line 93: | Line 93: | ||
=== Check to see if only the correct stock is being imported === | === Check to see if only the correct stock is being imported === | ||
- | We use a couple queries to produce a count of items in stock, and compare this with the items that are not in stock (qty = 0). This is a good indicator to bring your attention to missed steps or improper information being added to system five. As a rule of thumb if the percentage items stocked is less than or equal to 50% of the total number of inventory being imported the data has not been cleaned. It may contain items that should be in the auxilliary | + | We use a couple queries to produce a count of items in stock, and compare this with the items that are not in stock (qty = 0). This is a good indicator to bring your attention to missed steps or improper information being added to system five. As a rule of thumb if the percentage items stocked is less than or equal to 50% of the total number of inventory being imported the data has not been cleaned. It may contain items that should be in the auxiliary |
* Run the query **qryInfo-Percentage of inventory items in stock** | * Run the query **qryInfo-Percentage of inventory items in stock** | ||
* Use this formula to calculate the percentage of inventory items in stock: Stocked Items / Total Number of Items * 100 | * Use this formula to calculate the percentage of inventory items in stock: Stocked Items / Total Number of Items * 100 | ||
Line 107: | Line 107: | ||
== What is the Virtual Warehouse used for? == | == What is the Virtual Warehouse used for? == | ||
- | The Virtual Warehouse (Formerly known as the Auxilliary | + | The Virtual Warehouse (Formerly known as the Auxiliary |
rpsc_matrix_load.txt · Last modified: 2016/04/14 11:25 (8 years ago) by sjackson