Summary
The Customer Site Mapping screen allows you to move demand for a particular Customer into a target site.
The most common example of this is when you have occasional fulfillment for a customer out of a non-default warehouse for that customer, but you would like to re-map that demand back to the default warehouse so that it is handled correctly for future transactions and demand history is shown as it "should" have happened
You can access this by going to Admin --> System Configuration --> Customer-Site Mapping
NOTE: This mapping is at the Customer level of detail, so you can map entire customers at once. If you need to map specific customer-ship-to locations at one time, you can use the Customer Ship To Site Mapping
Column Description
To add a new mapping, click the "+" icon at the right hand side of the grid. A new line will appear for your new record, and you can enter the values you want for your mapping. When you've entered the information you want to, click the "Save" link near the right-hand side of the grid. Be sure to hit the "Save" link before adding a new record.
IMPORTANT:
- These mappings are applied during the data import step of StockIQ's morning processing, so you will see the effect of these records only after the next FULL refresh of StockIQ.
- Open orders are not remapped. Any open demand will show at the correct warehouse out of which it will be fulfilled so that inventory projections are correct. Once closed, the order will be remapped
Customer Code - The unique customer code (typically a numeric or string identifier) for this customer. (Not the customer Name, since these are frequently duplicated in ERP systems)
Site - The to which you want demand remapped. Demand from ANY site will be remapped into this target site unless you specify a single source site (see next column)
Source Site - Optionally, a source site from which you want demand remapped. If specified demand ONLY from this site is mapped into your new target site.
Date Effective - When you would like this rule to start being applied
Date Expires - When you would like this rule to stop being applied (this is not commonly used)
Start Date -The first date for which you want records mapped from the old item to the new item. Any sales to this Customer for the Old Item BEFORE this date will NOT be mapped. If left blank, all records before the End Date will be considered (This is not common)
End Date - The last date for which you want records mapped from the old item to the new item. Any sales to this Customer for the Old Item AFTER this date will NOT be mapped. (This is not common)
Note - Any note you wish to apply to the record to help you remember why you put it there in the future.