Fashion Inventory Matrix in Microsoft Dynamics GP
Fashion Inventory Matrix provides a powerful solution for wholesale and distribution companies dealing with multi-dimensional inventory items. The Fashion Inventory Matrix helps companies provide top-of-line customer service, better manage inventories and improve the purchase ordering process.
If you have ever worked in apparel, footwear, luggage, or any industry that has complicated dimensions, then you’ll know how frustrating it is to create purchase and sales orders.
For example, a footwear wholesaler will need a specific item number for each item that specifies its style, size, and color. A brown hiking boots size 11 will have a different item number than a size 12; or from a black hiking boot of the same size; or even brown dress or shoes of the same size. In short, a change in each dimension will create a distinctly independent item number.
As you can see this means a simple order has become a frantic scavenger hunt for the item numbers needed to fill an order. Luckily, we have a solution that renders this tedious process obsolete: The Inventory Matrix for Microsoft Dynamics GP.
Fashion Inventory Matrix Features
- Create unlimited dimensions – E.g. brand, style, color, size, texture, thickness, etc.
- Create unlimited dimensions members– E.g. black. Brown, blue, green, etc.
- Create unlimited Product Lines – E.g. apparel, footwear, accessories, jackets, etc.
- Assign dimensions to product lines – E.g. type, brand, and style can be assigned to the apparel product line.
- Assign dimension members to product lines – E.g. members of the ‘Brand’ dimension can be assigned to the ‘Apparel’ product line.
Purchase Order Processing Features
- Enhanced Visibility – Visibility of all the available colors, sizes, and quantities assist the buying manager to determine which items need to be ordered.
- Optimum Inventory Levels – Inventory Matrix helps organizations significantly reduce their inventory holding and carrying costs. The 360-degree view available to buying managers and staff through Inventory Matrix enables them to see the quantities available, quantities on the sales order, or on a purchase order for every dimension. It also gives them the added ability to drill down to see which documents make up those quantities.
- Ease of Data Entry and Review – Buying staff can enter the quantities to be ordered in respective cells without the need to remember specific item numbers. After entering the quantities, they can conveniently move back and forth between pages. And review the order and modify quantities, if required, while in Matrix view.
- Matrix Invoicing – Print purchase orders in standard GP format or in standard Matrix format generally used in the industry.
- Analytical Reports – Includes comprehensive analytical purchase and inventory reports. It provides a detailed analysis of quantities in inventory and on purchase orders by different dimensions.
Sales Order Processing Features
- Improved Customer Service – Increased customer satisfaction, when customer questions were immediately answered.
- Enhanced Visibility – Visibility of all the available colors and sizes and available quantities, enable CSRs to up-sell and cross-sell. They can tell customer about a new color or style that is available. The customer may be interested in it.
- Ease of Data Entry and Review – CSRs can enter the order quantities required by the customer in respective cells. That too, without the need to remember the item numbers. They can review the order with the customer by moving back and forth between different pages and modifying the quantities.
- Matrix Invoicing – Print orders and invoices in standard GP format or in standard Matrix format, generally used in the industry
- Analytical Reports – Include comprehensive analytical sales reports which allow the analysis of sales by different dimensions.
For more information, please visit us at Microsoft Dynamics GP – Great Plains.
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.
- Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Inventory Management, Mobile, Technology
Uploading inventory items from Microsoft Dynamics GP to Magento eCommerce
Export Inventory from GP
It is easy to upload inventory items from GP to Magento. Items to be uploaded to Magento e-commerce are marked in GP. They should include quantities, multi-tier price levels, attributes, and meta information.
If the item is modified manually in GP, the data is updated as soon as the changes are saved. If the items are modified in bulk, for example, through export and import features, they can be updated when the next scheduled data transmission takes place. You can also use the procedure below to update it.
Step-1: Log on to Microsoft Dynamics GP.
Step-2: Click on the E-commerce button in the left navigation bar.
Step-3: Click on the Data Synchronize link in the utility Section.
Step-4: Select items module from the drop-down menu.
Step-5: Hit the process button and the items will start uploading to Magento instantly.
Importing and Exporting Inventory in Magento
For catalogs with a large number of products, use the native Import and Export features. Use it along with expanded Inventory Management options to update sources and quantities by SKU. So, you can add new sources and update inventory quantities for all or a specific source.
- Commerce automatically assigns the Default Source to your products when upgrading Commerce or importing new products. If you import products with a custom source assigned, the Default Source will still be added with a quantity of 0. To update sources and quantities, use these import instructions.
- Single Source merchants use import to update only product quantities. In short, all existing and added products are assigned to the Default Source.
- Multi-Source merchants use import to add multiple sources and quantities per row per SKU.
To import updates, firstly, export a CSV file for specific or all sources. Then, edit the CSV file and add a row per SKU for each source and quantity. You need the source’s code when adding a new source and adding quantities of stock. However, you cannot add or update stocks using import-export features.
Export product data for all sources
- On the Admin sidebar, go to System > Data Transfer > Export.
- For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
- Click Continue. The file generates and downloads to open and edit.
After updating inventory amounts and product data, import the file back into Commerce.
Export product data for a specific source
- On the Admin sidebar, go to System > Data Transfer > Export.
- For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
- Use the Entity Attributes to filter the exported products for a specific source. For source_code, enter the code for the source in the filter field.
- Click Continue. Consequently, the file generates and downloads to open and edit.
Finally, after updating inventory amounts and product data, import the file back into Commerce.
Import product data
- On the Admin sidebar, go to System > Data Transfer > Import.
- For the Entity Type menu, choose Stock Sources. As a result, the export only extracts data for products with an SKU.
- Select configurations for the Import Behavior.
- Select the .csv file to import.
- Finally, click Check Data and complete the import.
For more information, please visit us at Microsoft Dynamics GP – Great Plains
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.