How to use a recurring Integration Endpoint for importing data
You are here
Dimension Inconsistency Clean Up
Do you use the inventory site dimension link? Let's review it's cleanup routine.
Dimension inconsistency cleanup
If you are using inventory site dimension link, it is a good idea to periodically use the dimension inconsistency cleanup. This will review all transactions and make sure the inventory to financial dimension link values are in sync. Typically this sync happens on activation of the site dimension link functionality. However, there are some cases where that may not catch everything or where something posted and a bug resulting in physical and financial dimension being out of sync. This is even more so true for databases that have been upgraded from AX 2009 to 2012 then to Dynamics 365 for Fiance and Supply Chain. This functionality will inspect all transactions and adjust financial dimensions accordingly. Behind the scenes this will ensure that the inventory dimension identifier for a given transaction source table, like sales order lines, matches the inventory dimension identifier on the inventory transaction(s) for that record.
Where is this in AX 2012
In Inventory Management > Periodic > Clean up, look for Dimension Inconsistency Clean up. This will run the process described above for the following tables:
- Confirmation lines (CustConfirmTrans)
- Backorder invoice lines (CustInvoiceBackorderLine)
- Customer invoice lines (CustInvoiceTrans)
- Backorder packing slip lines (CustPackingSlipBackorderLine)
- Customer ΓÇô packing slip lines (CustPackingSlipTrans)
- Quotation confirmation lines (CustQuotationConfirmTrans)
- Quotation lines (CustQuotationTrans)
- Inventory journal lines (InventJournalTrans)
- Quality orders (InventQualityOrderTable)
- Quarantine order (InventQuarantineOrder)
- Dimension history for documents (InventReportDimHistory)
- Transfer order line history (InventTransferJourLine)
- Transfer order lines (InventTransferLine)
- Transfer order line ΓÇô update table (InventTransferParmLine)
- Production BOM (ProdBOM)
- Project BOM journal transactions (ProdBOMTransProj)
- BOM journal transactions (ProdJournalBOM)
- Production journal transactions (ProdJournalProd)
- Routing journal transactions (ProdJournalRoute)
- Production report as finished (ProdParmReportFinished)
- Production orders (ProdTable)
- Project ΓÇô invoice lines, items (ProjInvoiceItem)
- Items (ProjItemTrans)
- Purchase order lines (PurchLine)
- Purchase order line ΓÇô delivery address ΓÇô update table (PurchParmLine)
- Request for quotation case lines (PurchRFQCaseLine)
- Request for quotation lines (PurchRFQLine)
- Request for quotation ΓÇô update line table (PurchRFQParmLine)
- Order lines (SalesLine)
- Voided sales order lines (SalesLineDelete)
- Sales order line ΓÇô update table (SalesParmLine)
- Quotation lines (SalesQuotationLine)
- Quotation line ΓÇô update table (SalesQuotationParmLine)
- Vendor invoice lines (VendInvoiceInfoLine)
- Posted vendor invoice lines (VendInvoiceTrans)
- Vendor ΓÇô product receipt lines (VendPackingSlipTrans)
- Receipts list lines (VendReceiptsListTrans)
- Vendor ΓÇô request for quotation lines (VendRFQTrans)
- Location journal lines (WMSJournalTrans)
- Inventory order transaction (WMSOrderTrans)
Where is this in Dynamics 365 for Finance and Supply Chain
This can be found in the same place as AX 2012 and is functionally identical. However, in the code this is marked as future obsolete so it will be removed in a future release. As of 10.0.18, this is still available. However, unless you have upgraded from AX 2012, this functionality will not work as expected. It expects that 2 hidden parameter fields have data in them and standard functionality in D365 no longer fills these fields in. This was marked as future obsoleted on 6/30/2020.
Other Versions
This is available in all versions of AX 2012 and AX 2009.