User Tools

Site Tools


rpsc_matrix_load

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
rpsc_matrix_load [2016/04/14 11:25]
sjackson [How to get things ready for import into System Five]
rpsc_matrix_load [2016/04/14 11:25] (current)
sjackson [Pitfalls and things to watch]
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 ​database, or items that are no longer used and need to be removed. Here is a way to quickly check this figure:+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 ​database, or items that are no longer used and need to be removed. Here is a way to quickly check this figure:
   * 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 ​database) is used as a price list made up of price lists from each of your suppliers. It is important to understand what the purpose of the Virtual Warehouse is so you can make sure parts that should be in the Virtual Warehouse are not placed into regular inventory. If a part is not normally stocked, and it is not a special order item and is not seasonal item then it should not be an inventory item. To rephrase: If a part is stocked, or is a special order item or is a seasonal item it should be an inventory item; if one of those is not true then it should be a Virtual Warehouse item/part.+The Virtual Warehouse (Formerly known as the Auxiliary ​database) is used as a price list made up of price lists from each of your suppliers. It is important to understand what the purpose of the Virtual Warehouse is so you can make sure parts that should be in the Virtual Warehouse are not placed into regular inventory. If a part is not normally stocked, and it is not a special order item and is not seasonal item then it should not be an inventory item. To rephrase: If a part is stocked, or is a special order item or is a seasonal item it should be an inventory item; if one of those is not true then it should be a Virtual Warehouse item/part.
  
  
rpsc_matrix_load.txt ยท Last modified: 2016/04/14 11:25 by sjackson