116

All retailers track their inventory physically and financially by retail stores. Setting up general ledger in Dynamics 365, we mostly setup account structure with 'retail channel' financial dimension (we can call it profit center, responsibility center etc. if it is setup as custom financial dimension) and that financiail dimenion is assigend to Retail Channels in Retail and Commerce Module. Setting up retail store also requires assigning a warehouse that tracks inventory for that store. All sales transactions that flow from Point of Sale System uses financial dimensions defined on the retail store. Sales, cost of sales, discount etc. are all posted using retail channel financial dimension in GL. 


However, when purchase order is created or inventory is adjusted for that retail store usiing inventory journals, financial dimensions are updated manually on these transacitons at line level (purchase order, inventory journals). It is required since inventory is tracked financially at warehouse (store) level. It takes considerable amount of time for the users to manually update financial dimensions on purchase order or inventory journal lines.


Historically, we have done a customization and assigend financial dimension to the warehosue that are defauled over to purchase order lines when the warehouse is selected or inventory journal lines as we select the warehouse.


Just like financial dimensions are setup on Vendors, customers, retail channels and other master data entities in Dynamics 365, it will be great to have same financial dimension framework extended to warehouses. These dimensions would then be defaulted on all inventory transactions that uses warehouses.

Category: Cost Management
STATUS DETAILS
Under Review
Ideas Administrator

Thank you for your feedback. This is a great suggestion! We will consider this in our roadmap.

 

Sincerely,

Anders Even Girke

PM, Microsoft 

Comments

Z

this became a "standard" customization in AX 2012 retail implementations...

Category: Cost Management

Z

This is a basic, fundamental need for retailers.  Please add.

Category: Cost Management

Z

This is essential for large retailers

Category: Cost Management

Z

Golob - That is definitely a solution but only applies to certain situations. It adds a lot of maitenance when you have a large number of stores. If we create sites per store, it would mean that we would have to create purchase and trade agreements for each site for a single product. Also, you would have a seperate cost by site which is not ideal if you are using costing method other than standard cost.

Category: Cost Management

Z

If you create a Site per Store you can use the Inventory dimension link function to accomplish this. Or am I missing something?

Category: Cost Management

Z

This would make life so much easier!

Category: Cost Management

Z

Every retail wants this! it is suprising it is not already standarded. 

Category: Cost Management

  • 1
  • 2