Skip to main content

Posts

Microsoft Dynamics customer numbers by product

This is probable details of Breakdown of the Microsoft Dynamics customer numbers by product. Microsoft Dynamics® CRM 39,000 companies with 3 million users  Microsoft Dynamics® AX 18,000 companies  Microsoft Dynamics® GP 43,000 companies  Microsoft Dynamics® NAV 94,000 companies  Microsoft Dynamics® SL 13,500 companies Currently CRM,AX,GP,NAV and SL are famous product of Micrsoft dynamics ERP.

change an Sales order from status Delivered to open order in ax 2009

How to change an Sales order from status Delivered to open order in ax 2009? In the receive now enter negative quantity and post the packing slip by selecting option receive now before posting, that's for reversing the quantity posted and making it an open order again. Edit the quantity in the order lines of already existing / posted line and the order changes to open order or create a new line in the existing order the order changes to open order. The sales order will be received if all the lines are received. If one or more lines is open the whole service order will be open.

buffer size issue while adding more fields in SalesTable in axapta

If you are having buffer size issue while adding more fields in SalesTable. I thought to create a parallel table with SalesTable which could be used in future customization  and would associate this table on SalesTable form using SalesId relation on this new table with SalesTable. It works but only when You create new records in salesTable due to the relation defined between SalesTable and newly created table. However, it is not working with existing sales orders as there is not associated SalesId (from sales table) in newly created table. If You will go with this approach You have to run a job to update all SalesId from SalesTable to newly created table for existing records. These are other workaround rather than adding a new table or have ever come across with such requirement? 1) Insert Old Data from Orignal_SalesTable to New_SalesTable 2) Under Orignal_SalesTable, create(if not available)/see(if already) three methods, AosValidateInsert,AosValidateDelete,AOSValidateUpdate; T...

define the item coverage minimum in days instead of quantity

Problem: Is there a way (configuration, add on or something else) to define the item coverage minimum in days instead of quantity? For example, if in the last 30 days I had 3000 Pcs in sales of an item, that means that my average sales is 100 Pcs per day. If I have now 400 Pcs on hand, that means I have 4 inventory days. Then if I could set the minimum inventory as, let say 6 days, that should mean for AX a shortage of 2 inventory days (200 Pcs that I need to purchase, therefore a planned order should be generated by master planning). Solution: The core of your requirement is not the Item coverage, what you need is to auto-generate the sales forecast based on historical sales data. Then you can use the standard functionality of item coverage code Period and define the period as your forecast bucket. In that case you make the sure that the item requirement will collect whatever in the sales forecast. I think it could work fine: The calculated forecast will need to be created in a...

Error - You must set up periods for the fixed asset calendar

If you have created a General Journal for a fixed asset and while posting the journal you are getting following error “You must set up periods for the fixed asset calendar Calendar.” Than you can try following You can try to give that setup in GL > Setup > Fiscal Calendar if It did not contains periods. If It was originating due to wrong value assigned to Depreciation field in Depreciation profiles then this should be same as setup for Calendar value for value model associated with fixed asset.

Save value to Session view Variable in axapta Enterprise portal

If you want to Save value to Session view Variable in axapta Enterprise portal webform to use on other webform you can try below code declare variable and define macro variable. #define.TestType('TestSeq') TestType _TestSeq; //Then define loadviewstate method to load value to variable. public void loadViewState() { super(); if (this.viewStateContains(#_TestSeq)) _TestSeq= this.viewStateItem(#_TestSeq); } //Then define saveviewstate method to save value to variable. public void saveViewState() { ContainerClass cc; ; if (_TestSeq) this.viewStateItem(#_TestSeq, _TestSeq); super(); } Then you can store value to _TestSeq variable. Now you can use this variable value to running on other webform.

How Axapta could reach your business goal

If anyone running his business and his business is running on different branches then you may require ERP package to maintain your company daily transactional data like finance,trading operations,material handling,BOM type items. I think first you will think to buy Tally Package to maintain your finance data but due to some restriction you will go for some database type ERP package which can be easy to migrate with other package also. I will suggest Axapta is very good tools of ERP . Its cost is not much high it will cost you 1.5 lac to 2 lacs Rs. per user but Enterprise portal license is very cheap. If you able to do best customization in EP then its going to very cheap but you will be restricted in EP so you should buy at least 10 application user license. You can get lot of reports, modules like Sales,Purchase,production,HRM etc. Its very much user friendly. You can easy move to all master form by using column value like go to main table on right click which is monopoly of ...