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
Next revision
Previous revision
rpsc_matrix_load [2016/04/14 11:24]
sjackson [What you need]
rpsc_matrix_load [2016/04/14 11:25]
sjackson [Pitfalls and things to watch]
Line 56: Line 56:
   - Import **qry-Step02-A,​ Matrix Parents.csv**,​ but make sure you save the results. We need to get the unique ID of the first Matrix Parent added for later use in a query to update Part Numbers   - Import **qry-Step02-A,​ Matrix Parents.csv**,​ but make sure you save the results. We need to get the unique ID of the first Matrix Parent added for later use in a query to update Part Numbers
   - **WARNING:​** I had a problem when first running this file because I ran it before the **qry-Step03-A,​ Matrix Children.csv** query. I was getting messages about the part already existing. I am trying to run things in this order to prevent this error. I have also Imported the new format sku into the item number field in System Five because I think this is the cause of the problem.   - **WARNING:​** I had a problem when first running this file because I ran it before the **qry-Step03-A,​ Matrix Children.csv** query. I was getting messages about the part already existing. I am trying to run things in this order to prevent this error. I have also Imported the new format sku into the item number field in System Five because I think this is the cause of the problem.
-  - **Caution:​** We need to test PO's for matrix parent items working because I don't know if we will have a problem if the Supplier is not attatched ​to the matrix parent. +  - **Caution:​** We need to test PO's for matrix parent items working because I don't know if we will have a problem if the Supplier is not attached ​to the matrix parent. 
-  - Import **qry-Step03-B,​ Matrix Children Kit Load** via a kit load which will attatch ​the child parts to the parent parts. +  - Import **qry-Step03-B,​ Matrix Children Kit Load** via a kit load which will attach ​the child parts to the parent parts. 
-  - Since the Item Number is now updated to the NewSKU format, it does not have any size inforamtion ​in it. Also we need to check about the clients searching methods to make sure things work for them. All of the updates for these can be done afterwards. ​+  - Since the Item Number is now updated to the NewSKU format, it does not have any size information ​in it. Also we need to check about the clients searching methods to make sure things work for them. All of the updates for these can be done afterwards. ​
   - Behavior: The system will not pull up matrix children when you search for the main parent part. ex: VOLCSHIMCRANE01 will only bring up the parent part in the search window at this time.   - Behavior: The system will not pull up matrix children when you search for the main parent part. ex: VOLCSHIMCRANE01 will only bring up the parent part in the search window at this time.
   - A query will need to be ran to update all Parts with a unique less than the first Parent Matrix Part Number<​code>​update Inventry set Part = Item where InvUnique < 10</​code>​ Just make sure you replace 10 with the unique number of the first Parent Matrix Part Number you loaded. Remember there are lots of parts that were not matrix parts that still have only a part number as the primary search method.   - A query will need to be ran to update all Parts with a unique less than the first Parent Matrix Part Number<​code>​update Inventry set Part = Item where InvUnique < 10</​code>​ Just make sure you replace 10 with the unique number of the first Parent Matrix Part Number you loaded. Remember there are lots of parts that were not matrix parts that still have only a part number as the primary search method.
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