A financial dimension value is based on the LAND-00013 record and has been used on a transaction. You cannot delete the LAND-00013 record AX 2012

 A financial dimension value is based on the LAND-00013 record and has been used on a  transaction. You cannot delete the LAND-00013 record

Scenario:

Sometime user trying to delete a record from the customer master or any data that relates to financial dimension. So, user is facing above error upon deletion.

Reason:

Error occurred because data exists in the table DimensionAttributeLevelValue

Solution:

1. Access the open the table DimensionAttributeLevelValue 
2. filter the record by Display Value field with the desired record to delete like customer number or employee number etc etc
3. Select the filtered records
4. Delete the selected records
5. Then go back to customer master or where you facing the error
6. Now try to delete you will be able to delete

AX 2012: you can directly delete the record by opening table

Source : https://dynamicsaxtechstuff.wordpress.com/2015/04/16/how-to-delete-unused-financial-dimension/

Read more...

Cannot create a record in Fixed assets (AssetTable). Fixed asset number: ITH-DEV-4-00838, FA - Hand Held Scanners. The record already exists AX 2012

 

Cannot create a record in Fixed assets (AssetTable). Fixed asset number: ITH-DEV-4-00838, FA - Hand Held Scanners. The record already exists AX 2012

Solution :

Go to Organization Administration > Common > Number Sequence > Number Sequence 

find ITH-DEV-4-##### > Status List 

and Delete it.

Read more...

Cannot create a record in Ledger journal table (LedgerJournalTable) AX 2012

 

                    General Ledger > Setup > General Ledger Parameters > Number Sequence 

                    > Journal Batch Number > Gene_1

                    Click Status List > File Delete Error 

Read more...

Physical on-hand Inventory Plus Minus without License Plate

 

Physical on-hand Inventory 

static void ABUInventTransSolve(Args _args)

{

    InventTrans                     invTrans;

    InventTransOrigin               invTransOrigin;

    InventDim                       inventDim, iDim;

    /*while select invTransOrigin

        where invTransOrigin.ReferenceId == 'TO-000007756' &&

        invTransOrigin.ReferenceCategory == InventTransType::TransferOrderShip &&

        invTransOrigin.ItemId == 'P000371'*/

    select forUpdate invTrans

        join iDim

        join invTransOrigin order by ReferenceId asc

    where iDim.inventDimId == invTrans.inventDimId

    //&& iDim.InventLocationId == 'CNK'

    //&& invTransOrigin.ReferenceCategory == InventTransType::InventTransfer

    && invTransOrigin.RecId == invTrans.InventTransOrigin

    && invTransOrigin.ItemId == invTrans.ItemId

    //&& invTrans.StatusReceipt == StatusReceipt::Purchased

    && invTrans.RecId == 5655505580;

    {

        if(invTrans && WMSLocation::findInventLocation(iDim.wMSLocationId).sortCode > 0)

        {

            ttsBegin;

            inventDim.InventSiteId       = 'JBT';

            inventDim.InventLocationId   = 'CNK';

            inventDim.configId           = InventTable::find(invTrans.itemId).StandardConfigId;

            inventDim.InventStyleId      = InventTable::find(invTrans.itemId).StandardInventStyleId;

            inventDim.InventSizeId       = InventTable::find(invTrans.itemId).StandardInventSizeId;

            inventDim.InventColorId      = InventTable::find(invTrans.itemId).StandardInventColorId;

            inventDim.wMSLocationId      = '0079A-5-8';//ABUTallyLine::findFix(invTrans.ItemId, iDim.wMSLocationId, invTransOrigin.InventTransId).WMSLocationId;

            inventDim.LicensePlateId     = 'CNK-230919-999001';//ABUTallyLine::findFix(invTrans.ItemId, iDim.wMSLocationId, invTransOrigin.InventTransId).WHSLicensePlateId;

            inventDim.InventStatusId     = 'AVAILABLE';

            inventDim                    = inventDim::findOrCreate(inventDim);

            invTrans.inventDimId         = inventDim.inventDimId;

            invTrans.update();

            info(strFmt("%1 Location:%2 LP:%3  Status:%4", invTransOrigin.ReferenceId, inventDim.wMSLocationId, inventDim.LicensePlateId,  invTrans.StatusIssue));

            ttsCommit;

        }

    }

    //info("Done");

}

Read more...

Failed to Find Workflow AX 2012

 Failed to Find Workflow AX 2012

Select a.RECID

from SYSWORKFLOWMESSAGETABLE a

Where a.ROOTCORRELATIONID not in

(Select b.ROOTCORRELATIONID from SYSWORKFLOWTABLE b)

and a.MESSAGELIFECYCLESTATE = 1

 

SELECT * FROM SYSWORKFLOWMESSAGETABLE AS A

WHERE A.RECID = 5650958646

 

Update SYSWORKFLOWMESSAGETABLE Set MESSAGELIFECYCLESTATE = 2 where RECID =5650958646

Read more...