Today I got one new update with Item Master, Now I’m going to share with you those thing. Update Financial Dimension from X++ code.
Using upload method initially I have updated the Item masters in AX without updating the Financial Dimension. After that I realised I was missed it, then I got the JOB for updating those financial Dimension without affecting any Master. Really it was reduced my time and headache. I’m going to share those things to all AX team in the world.
This Job is updated based on the Item Master so just type the Financial Dimension in ‘*****’ and then update the Item group instead of ‘#####’.
Create a new Job and copy this below code and Paste and run.
Inventory dimension Batch number is a primary input /output dimension and must consequently be specified in AX 2012
Dynamics there is 4667 records is there. I mentioned below.,
|PurchRFQLineMap ( Request for quotation lines 4 )|
|BankGroup ( Bank groups 5 )|
|RFIDProcessStructureTmp ( RFID process structure 6 )|
|BankAccountTable ( Bank accounts 7 )|
|BankAccountTrans ( Bank transactions 8 )|
|BankChequeLayout ( Check layout 9 )|
|BankChequeTable ( Check table 10 )|
|BankDeposit ( Bank deposit 11 )|
|BankTransType ( Bank transaction type 12 )|
|BOM ( BOM lines 18 )|
|BOMCalcTable ( Calculation 19 )|
|BOMCalcTrans ( BOM calculation transactions 20 )|
|BOMConfigRoute ( Configuration route 21 )|
|BOMConfigRule ( Configuration rules 22 )|
|BOMMap ( BOM lines 23 )|
|BOMParameters ( BOM parameters 24 )|
|BudgetTmpControlStatistics ( Budget control statistics 25 )|
|BOMTable ( Bills of materials 26 )|
|BOMVersion ( BOM versions 27 )|
|BudgetMap ( Budget map 28 )|
I got keep getting this type of Maximum Buffer size while making the entry on during all transactions like Purchase order, Sales order, creation of Master data and so on. Then finally I got the solution to reduce this type of issue.
The total, internal size of the records in your joined SELECT statement is 7100 bytes, but Microsoft Dynamics is by default parameter tuned not to exceed 49152 bytes.
It is strongly recommended that you split your tables(s) into smaller units.
Alternatively, you have to specify a Maximum buffer size value of 70 Kbytes or higher on the ‘Database Tuning’ tab page in the Microsoft Dynamics AX Server Configuration Utility. The default value is 24 Kbytes.
Exit Microsoft Dynamics Immediately, and follow the directive above. Use of the table(s) will cause unpredictable results.
Reason: When you run the AX application it need some space to process the data or making of any transactions. For that application is going to allocate some space for make the process. In case if the size is getting filled of then the application may through this type of error and waring message on your screen.
Cannot create record in Dimension history for documents (InventReportDimHistory). Type: None. The record already exists. in AX 2012
During the time of Invoice posting I got some error based on the table. Then i realized the solution.
Error: Cannot create record in Dimension history for documents (InventReportDimHistory). Type: None. The record already exists.
Reason: When you are making any entries in case of any mistakes if you done during the Posting of any transaction you may get this type of error Infolog may display on your screen. So once if you got this type of message you cannot do another transition based out of this same like that. First of all, you need to solve this issue, for that below steps might solve the solution for you.
In AX 2012, while creating purchase requisition for the created item (procurement category assigned). Items not appearing in item lookup.
For created Procurement categories need to map the Items in that Category. There is have two methods to link those items in the mentioned category.
Goto Procurement and sourcing >> Setup >> Categories >> Procurement categories
Product has a production type that does not allow creation of BOM or formula
If you are making the Production order initially you need to select the BOM parent item. Based on the BOMs lines the Production order is to be created. If in-case you got any issues like below, then follow the given procedure. You will get a solution for making a Production order.