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 recordScenario: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 DimensionAttributeLevelValueSolution:Access the open the table DimensionAttributeLevelValue filter the record by Display Value field with the desired record to delete like customer number or employee number...

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 2012Solution :Go to Organization Administration > Common > Number Sequence > Number Sequence find ITH-DEV-4-##### > Status List and Delete ...

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

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

Read more...

Failed to Find Workflow AX 2012

 Failed to Find Workflow AX 2012Select a.RECIDfrom SYSWORKFLOWMESSAGETABLE a Where a.ROOTCORRELATIONID not in(Select b.ROOTCORRELATIONID from SYSWORKFLOWTABLE b) and a.MESSAGELIFECYCLESTATE = 1 SELECT * FROM SYSWORKFLOWMESSAGETABLE AS AWHERE A.RECID = 5650958646  Update SYSWORKFLOWMESSAGETABLE Set MESSAGELIFECYCLESTATE = 2 where RECID =5650958...

Read more...

X++ Exception: [Microsoft][SQL Server Native Client 11.0][SQL Server]Length of LOB data (5934000) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.

 X++ Exception: [Microsoft][SQL Server Native Client 11.0][SQL Server]Length of LOB data (5934000) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.SOLUTION : Change Max Text Replication Size to -1 and...

Read more...

Export data from AX to CSV file through X++

 TextBuffer          textBuffer = new TextBuffer();    FileNameFilter      Filter = ["CSV file", "*.csv"];    FileName            FileName;    #WinAPI    LedgerJournalTrans  LocLedgerJournalTrans, TxtLedgerJournalTrans;    ;    super(); FileName = winapi::getSaveFileName(infolog.hWnd(), filter, @"c:\...\desktop", "Save as CSV file","csv","Create Payment Permata");    if(!FileName)        return ;    while select...

Read more...

Confirm PO Error : The source document lines cannot be finalized until the status is Confirmed in AX 2012

 Confirm PO Error : The source document lines cannot be finalized until the status is ConfirmedSOLUTION : Open AOT > Table > BudgetSourceTracking In Table BudgetSourceTracking find this PO Number => change the status from Draft to Confirmedand try to Confirm your...

Read more...