Friday, July 20, 2018

Important Tables and Classes in Inventory Module

Tables :-

EcoResProduct             --- This is a base table for the inherited tables that follow next.

EcoResProductMaster --- This table holds information on products that can have variants (color, size, and so on.). Within the application, these products are referred to as product masters.

EcoResDistinctProduct ---A distinct product is effectively a product that does not have variants (it is not associated with inventory dimensions color, size, and so on).

InventTable                     ---This table contains information about the released items.

InventItemGroup           ---This table contains information about item groups.

InventDimGroup            ---This table contains information about a dimension group.

InventTableModule        ---This table contains information about purchase, sales and inventory specific settings for items.

InventModelGroup        ---This table contains information about inventory model groups.

InventItemSalesSetup    ---This table contains default settings for items, such as site and warehouse. The values are related to sales settings.

InventItemPurchSetup  ---This table contains default settings for items, such as site and warehouse. The values are related to purchase settings.

InventItemInventSetup  ---This table contains default settings for items, such as site and warehouse. The values are related to inventory settings.

InventItemLocation        ---This table contains information about items and related warehouse, and counting settings. The settings can be made specific based on the items configuration and vary from warehouse to warehouse.

InventTransOrigin         ---This was a new table added in AX 2012 and is effectively used to
join InventTrans table to the origination (sales line, purchase lines, inventory adjustment, and so on) transaction line via the InventTransOrigin tables.

InventTransOrigin tables---There are multiple tables such as InventTransOrigin Salesline and InventTransOriginPurchLine, and they are fundamentally used to link the transaction origin document to an inventory transaction record.

InventSum                     ---This table contains information about the present and expected
on-hand stock of items. Expected on-hand stock is calculated by looking at the present on-hand values and adding whatever is on order (has been purchased but not arrived yet).

InventTrans table is what I like to call the parent table of all transactions. NO matter what is performed a record will be written to this table when posting occurs. The inventTrans table represents a flow of inventory transactions as data leaves and enters a company for example. If a product is ordered a status field will be set to ordered. If a item is transferred from one warehouse to another warehouse the status will then be set to transfer. The inventory transactions table is typically used for very detailed inventory reports.

InventDim table is table that holds the combinations of inventory attributes assigned to items at they progress through inventory transactions. For example, an item can be located in many different warehouse, at may different sites, and stored in certain locations. Imagine the number of combinations that can be associated with an items its endless. 

Below are the inventory dimensions AX uses to segregate items as they process through the system :

InventColorId       --- Item table contains information about colors.
InventSizeId          --- Item table contains information about item size.
ConfigId                --- table contains information about available configuration of the various items.
InventBatchId       --- table contains information about batches.
InventSerialId       --- table contains information about item serial numbers.
InventLocationId  --- table contains information about warehouses.
InventSiteId          --- table contains information about sites.
wmsLocationId     --- table contains information about locations.
wmsPalletId          --- table contains information about pallets.

CLASSES :-

InventSum The InventSum classes are used to find the on-hand information about a certain item at a certain date. The InventSum classes are not structured in a hierarchy as the previously mentioned classes.

InventOnHand class is used to find the current on-hand information.

InventMovement classes are used to validate and prepare data that will be used to generate inventory transactions. The super class in the hierarchy is the abstract class called InventMovement.

All the classes related to the inventMovement class will be prefixed with InvMov_
For example, InventMov_Sales is used to validate and prepare inventory with sales line transactions, or InventMov_Transfer, which is used when dealing with inventory transfer journals.

InventUpdate classes are used to insert and update inventory transactions. Whenever a transaction should be posted, the updateNow() method in the InventUpdate subclass will execute. The super class in the hierarchy is the InventUpdate class, and the other classes in the hierarchy are prefixed ‘InventUpd_’.

For example, InventUpd_Estimated is used whenever an item line is entered in the system that will most likely generate a physical transaction in the future. A good example can be a sales order line that has the on-order sales status. When a line like this is entered or generated in AX, the InventUpd_Estimated is triggered so that the inventory transactions will reflect that the item is on-order can is taken into consideration when the same item is ordered.

InventAdj :Whenever an adjustment to an inventory transaction takes place, the InventAdj classes are used. The adjustments typically occur when you are closing the inventory.



Source :- https://mfmujahidmim.wordpress.com/2015/12/17/microsoft-dynamics-ax-the-inventdim-table/

5 comments:

  1. This is really interesting, you’re a very skilled blogger.
    I have bookmarked this article page as I received good information from this.

    Best ERP Software Providers in Hyderabad | Best Sales Management Software in India

    Best ERP Software in India | Best Cloud ERP Software in Hyderabad

    ReplyDelete
  2. ERP Software for Small Business | ERP GOLD
    ERP Gold is leader in erp solution for small business .Our erp solutions are easy to manage and customizable as per organization needs. So Customized to your workflow needs, equipped with modules like accounting, inventory, order processing and shipping all-in-one, this is what offered in ERP softwares for small business. For more details, get in touch with us!
    Features that ERP Gold Inventory software offers :
    • It is cloud based with SSL connection
    • Business Operation Integration
    • Top Level Security with SSL
    • Adaptability with fast deployment

    For more information, visit our website : https://www.erp.gold/
    Or Get in touch with us: 1-888-334-4472
    Address: Suite 183411, Shelby TWP, MI 48318
    Email us: support@erp.gold

    ReplyDelete


  3. Sara Hayat Design For Your Business . . .
    Sara Hayat is the founder of Sara Hayat Designs, a modern and artful furniture brand with a signature perspective on shape and luxury material.
    Why Sara Designs . . .?
    There is something to be said about surrounding yourself with beauty and reminders that nudge you into fulfilling the vision you have for yourself. The power of aesthetics and beauty has a way of leaving us changed. Forcing us to see and feel beyond what we could’ve imagined possible. This shift in perception and feeling can be in a Vermeer painting or a song on the radio that pushes you outside of yourself. It can also be the beautifully imagined and designed furniture pieces in your home.
    -
    When designing my pieces, I wanted to create something that would be beautifully distinctive yet functional. I am proud to say we have been granted 10 design copyrights and have several more pending.
    But coming up with designs was challenging in more ways than one. Every part of the piece has been thought out from the ground up. From the materials used to joinery techniques, to how different elements of the piece will come together, we wanted to make sure they serve their intended purpose in your home.
    If you need high quality wood furniture, get in touch with us!
    https://sara-hayat.com/pages/sara-hayat-furniture

    ReplyDelete

How to enable the dimension fields based on the Item selected on the form.

[Form] public class KMTShipFromWarehouses extends FormRun {     InventDimCtrl_Frm_EditDimensions        inventDimFormSetup;     /// &l...