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

 

SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account : 

and Delete the Bank Account

FINISH

Read more...

Data Driven & AI Transformation

Data Driven & AI Transformation

Introduction Wawan.AI : Smart Interview Powered By Gemini

Tuesday | 20 Agustus 2024 - Google Indonesia

A. PREDICTIVE AI

B. GENERATE AI

1. Effortless hirring, exceptional team.

2. Supercharging hiring with AI

3. Efficency, Objectiviry, and Innocations

Vertex AI Studio

Tune Gemini

Groundingx

Read more...

Decimal rounding of the physical remaining quantity in the unit is incorrect AX 2012

 

Decimal rounding of the physical remaining quantity in the unit  is incorrect AX 2012

Solution : in the table > Salesline > please input Unit in field SalesUnit.

Read more...

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...