AccSoft Consulting Group

ERP, Retail and eCommerce solutions designers and developers

+1 888-929-3266
Email: info@accsoft.com

AccSoft Consulting Group
100 Consilium Place, Suite 200 <br> Toronto, ON M1H 3E3 <br> Ontario, Canada

Open in Google Maps
QUESTIONS? CALL : 888.929.3266
  • Home
  • Dynamics GP
  • Retail
  • Microsoft 365
  • Dynamics 365
  • BLOG & STORIES
  • Contact Us
CONTACTUS
  • Home
  • Inventory Management
  • Archive from category "Inventory Management"
August 18, 2022

Category: Inventory Management

Fashion Inventory Matrix in Microsoft Dynamics GP

Friday, 04 February 2022 by AccSoft Evangelist
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.

https://youtu.be/–vjJFzLw1E

 

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.

Fashion Inventory Matrix for Dynamics GP

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.

dynamics gpfashion inventoryinventory matrixmanage inventory in gpManage Items in GPmatrix featuresmatrix invoicingMicrosoft Dynamics GP
Read more
  • Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Inventory Management, Mobile, Technology
No Comments

Uploading inventory items from Microsoft Dynamics GP to Magento eCommerce

Friday, 17 December 2021 by AccSoft Evangelist
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.

GP Login Page

Step-2: Click on the E-commerce button in the left navigation bar.

GP Navigation Bar

Step-3: Click on the Data Synchronize link in the utility Section.

utility section

Step-4: Select items module from the drop-down menu.

drop-down menu

Step-5: Hit the process button and the items will start uploading to Magento instantly.

data sync

inventory uploaded to magento

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

  1. On the Admin sidebar, go to System > Data Transfer > Export.
  2. For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
  3. 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

  1. On the Admin sidebar, go to System > Data Transfer > Export.
  2. For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
  3. 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.
  4. 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

  1. On the Admin sidebar, go to System > Data Transfer > Import.
  2. For the Entity Type menu, choose Stock Sources. As a result, the export only extracts data for products with an SKU.
  3. Select configurations for the Import Behavior.
  4. Select the .csv file to import.
  5. 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.

dynamics gpecommerceeCommerce Solutions for Microsoft Dynamics GP - Magentoinventoryinventory managementmagentoMagento eCommerceMagento Inventory from GP
Read more
  • Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Inventory Management, Technology
No Comments

Recent Posts

  • How to add a Role in Business Central

    Business Central offers us to work in a differe...
  • How to Define Early Payment Discount in Business Central

    Business Central allows facilitates customers a...
  • How to Create Vendor in Business Central

    Vendor card in Business Central saves vendor da...
  • How Bank Deposit works in Business Central

    This blog covers how Bank Deposit works in Busi...
  • Microsoft Shopify Connector for Dynamics 365 Business Central

    Microsoft Shopify connector easily integrates B...

Recent Comments

  • bigcommercedev on Microsoft Shopify Connector for Dynamics 365 Business Central
  • Customization - Microsoft Dynamics CRM: Add custom Field on Microsoft Dynamics CRM: Export Customizations

Archives

  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • May 2021
  • May 2018
  • August 2017
  • August 2015

Categories

  • Add-on
  • Business Central
  • Dynamics 365 BC
  • Dynamics GP
  • eCommerce Solutions for Microsoft Dynamics
  • Inventory Management
  • Magento
  • Microsoft 365
  • Mobile
  • Retail Software (RMH)
  • Technology
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Loading

Dynamics GP

  • GP Data Migration & Upgrade
  • GP Features & Functionality
  • GP Solution Development
  • GP – Accsoft Services

Retail POS

  • RMH Software Implementation
  • RMS and RMH Support
  • Software Customization services
  • Retail POS Add-on

Microsoft 365

  • Overview
  • Microsoft 365 for Business
  • Features
  • Microsoft 365 Plans

Dynamics 365

  • D365 Business Central – Financial
  • D365 Business Central – Operations
  • Dynamics 365 – Sales and Service
  • D365 Business Central – Business Intelligence

Loading

  • GET SOCIAL

© 2021 All rights reserved. AccSoft Group of Companies

TOP