Skip to main content

Posts

Showing posts from March, 2013

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

Question and answers on report and other BOM Functionality in axapta

1. Other than the Reports folder, from where can the BOM calculation report be run? ANSWER - The BOM calculation report can also be run from the Item price form, by clicking Print. 2. Does circularity have to be a part of the BOM check process? How is this kind of check set up? ANSWER - No, circularity does not have to be part of the BOM check process. This check is automatically set up in the Inventory parameters form or when the Check circularity check box is selected in the Check BOM form. 3. What does the Append option in the Update lines field indicate in the Change BOM item form, and what is required when this option is selected? ANSWER - The item is replaced on a specific date and the chang is tracked, and both date fields must be filled in when the Append option is selected. 4. Which of the following is not included in the BOM line sorting option?(Select all that apply.) ( ) Line type ( ) Position (√) Item name ( ) Operation number 5. Which of the following reports is used to d...

Question and answer on BOM as finished in Axapta

1. At a minimum, what information must be specified to report a BOM as finished? ANSWER - - Date for reporting-as-finished - Item number and any existing configuration - BOM number - Quantity to be reported as finished 2. Explain the purpose of the Max. report as finished form. ANSWER - This form is used to inquire how much of a BOM can be completed based on the available on-hand inventory. 3. What is the difference between running the Report as finished periodic job process and the report as finished process from the Item form? ANSWER - The periodic job is used to report multiple BOMs as finished. Only an individual item can be reported as finished from the Item form. 4. What is the purpose of reporting a BOM as finished? ANSWER - To reduce on-hand quantity for component items and increase on-hand quantity for the parent item based on the BOM setup. 5. In Microsoft Dynamics AX 2009 the Report as finished form cannot be accessed from which of the following? ( ) Periodic folder ( ) BOM ...

Question and answer on Scrap and Measurement on BOM in Axapta

1. List the four rounding-up options. MODEL ANSWER - No., Quantity, Measurement, and Consumption 2. When is scrap specified? MODEL ANSWER - When the consumption of the raw materials used in the components of a BOM are calculated. 3. When are measurement configurations used? ANSWER - When calculating the consumption of the raw materials on each BOM line. 4. What measurement formula is used when consumption is not proportional to any dimensions of the finished item? ANSWER - Standard 5. Where can a user view how the cost price of an item with scrap has increased after calculation? ANSWER - In the Total cost price per unit field in the Complete BOM calculation form. 6. What is the difference between constant and variable scrap? ANSWER - Constant scrap is specified when the constant value is to be calculated only one time on the BOM line, regardless of how many items are produced. Variable scrap is a percentage value and is calculated as a percentage of the BOM line. 7. What are conversion...

Question and answers on Sales order with BOM in Axapta

1. Where are parameters set for how components are displayed in the Composed of - tree form? ANSWER - On the Setup tab in the Composed of – tree form 2. Can new configurations be added to a configurable item during the sales order process? If configurations can be added, what are the rules? ANSWER - Yes, a new configuration can be added during the sales order process, as long as the configuration rules do not prevent the configuration combination. 3. What four values can be transferred to a sales order line after the BOM calculation is run? ANSWER - Price, Quantity, Sub-BOM, and Subroute 4. What is the purpose of exploding a BOM on a sales order? ANSWER - –To display all BOM components on the sales order and the related documents, such as the packing slip or the invoice. –To verify when orders can be delivered to the client, based on the purchasing or production of components. 5. In the Sales order form, the configuration for a BOM item is specified on the? ( ) General tab ( ) Setup ta...

Question and answer on BOM Calculation in Axapta

1. What is the difference between opening the BOM calculation form from the Item form or the Periodic folder? ANSWER - The Item form runs the calculation for the selected item. Calculation for all BOM items can be run from the Periodic folder. 2. Regarding the Summary and Complete functions in the Item price form, what is the difference between the displayed content? ANSWER - The Summary function displays a summary of the price calculations by cost group for each BOM level. The Complete function displays the calculations for each BOM component line. 3. What function omits a BOM item from calculation? ANSWER - Selecting the Stop explosion check box in the Item form. 4. Where is the default Calculation group set up in Microsoft Dynamics AX 2009? ANSWER - In the Inventory parameters form 5. What does a BOM structure show? ANSWER - –How a single item or operation contributes to the price of its BOM level. –How much all items and operations on a particular level contribute to the overall pr...