[Axapta-Knowledge-Village] Explosion report
Hi All There is a report in Ax that can be printed from the Explosion window (example: Production -- Production Orders -- Inquiry -- Explosion). Click on the print preview button will print the report ReqTransExplosion. This report can only be printed from the Explosion window. I have a requirement to print this report for every planned and firmed production order. How easy or difficult will this be to accomplish? Regards Eddie
[Axapta-Knowledge-Village] Re: Statistical Transactions.
Hi there We have used the cost accounting module for this purpose as well as then use these for cost allocations across dimensions. Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, yifath1 ymer...@... wrote: Hi there, Did you or any one find out what the journal type : Statistical transaction is used for. I can not seem to find any information about this. I have a similar request to Abdollah, i need to store statistical information in AX. any help would be greatly helpful. Thanks Y - -- In Axapta-Knowledge-Village@yahoogroups.com, Abdollah Mostafa abdollah777@ wrote: Dear Carsten Jim thank you for your support i've already found a journal type called statistics Transactions (on the journal names form), but actually i don't know where can i find (and then use) it for posting. as we are all know that a journal of type daily appears on the GL journals, and a journal of the type customer payment appear on the AR Payment journal. the quistion is, where can i find and use the journal of the type statistics Transactions? also i've found a field called quantity on the general journal (lines) form, but it seems to be informational only (not functional) your feed back is highly appreciated have a nice day On 5/13/07, abdollah mostafa abdollah777@ wrote: Dear all Hope all things are going fine with you i've a little query that: Does Dynamics AX support unit accounts that are used for statistics? unit accounts that i mean, are accounts used to post non-financial amounts like nuber of employees, number of equipments or number of telephone calls made this month(a call center case) as my customer strongly need this information to be printed on his financial statements. i know that this feature is available from Dynamics GP , but even if it doesn't provided from Dynamics AX , is there a work arround or any solution that can provide this information. thanks in advance [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Fixed asset Project
Hi Yifat Wouldn't you classify this as an investment project? What version are you running on? Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, yifath1 ymer...@... wrote: hi All, Is it possible to purchase a fixed asset against an internal project? I.e. the business set up a project in AX in order to manage the costs of setting up its new office and IT infrustructure. All the equipement and furniture, and paintings etc are purchased against the project, but become fixed assets... Any ideas? Thanks Yifat
[Axapta-Knowledge-Village] Re: Slow performance on Misc Charges on Purchase Orders
Hi James We use Ax2009. In the table properties I see the CacheLookup value is set to NotInTTS. Are you refering to this value? --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell djf1...@... wrote: Check if the table is set as Tablecache FULL (meaning all records will be loaded into the users session when the user first accesses the table). If it is change it to NONE _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 06 August 2009 20:38 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Slow performance on Misc Charges on Purchase Orders Hi All We are experiencing very slow performance (about 10minutes to load!) when trying to load misc charges on purchase order header. I have noticed that the MarkupTrans table contains some 870 000 records (this is due to auto misc postings on sales order lines). Will this be the cause of the slow performance and if so how do one go about to improve? Regards Eddie
[Axapta-Knowledge-Village] New weighted average closing/settlement logic - AX4.0
Hi All We are currently investigating the new weighted average settlement logic as in Ax4.0. When we run the closing, it came up with an error saying that for account xxx, a dimension cost center must be specified. We have dimension validation on all accounts. By investigating which transactions this is causing, we noticed it is the new totaled transactions - especially the purchased ones. I understand why there cannot be a dimension on that transaction and also come to realize that when there is a default dimension on the item, it would populate this transaction with that dimension. The problem is that we have to track profit and loss by cost center. My question is that why are these transactions being adjusted? Would it be the same logic as for instance transfer orders where a receipt is being adjusted and is populating the item with a default dimension the only way? Any comments would help. Thanks Eddie
[Axapta-Knowledge-Village] On hand inventory adjustment - Date
Hi all We need to do a on-hand adjustment to revalue inventory as of a certain closing date. The date which wee need to do adjustments are on the 31/3. Closings have been done until 30/6. When doing a on-hand adjustment selection from the 31/3 closing, the posted quantities and values of the items are that of 30/6. This means that we need to reverse all the closings after 31/3 in order to an accurate adjustment. Is this normal behavior and if so, what would the reason be? We run Ax2009 Sp1. Thanks in advance Eddie
[Axapta-Knowledge-Village] Search on City/Postcode/Country - Ax2009
Hi All How do one search customer and or vendor accounts records based on the address details like city, postalcode and country in AX2009? Regards Eddie
[Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions
Hi James Using version 3.0 SP6. Closing was done on the 30/04/2009. The next closing was done on the 31/5/2009. Various cancellations/re-closings happened on both these dates. When investigating cost of sales, I reconciled the difference to the closing adjustments (which is normal). By looking at the specific item transactions in question, I discovered that although some issues (sales order) was financially closed on 30/4/2009, settlements (adjustments) still was done on these transactions on the 31/5/2009. To me this do not make sense? Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell djf1...@... wrote: So Edward what version are you using, what have you done (e.g. canceling close) and what do you see happening? I have not seen the problems I have heard about canceling closing but to be honest I have managed to now have to do too many cancels On Jul 5, 2009, at 2:19 PM, edwardjosling wrote: Closed in this instance refer to the the particular inventory transaction (receipt and issue) to be financially closed, i.e. is has been fully settled. Thus the transaction will be date stamped with the particular closing date. I must concur that there should be no ways that such a transaction can be further adjusted. I have read that some problems have occurred in Ax 3.0 when closings have been cancelled. I wonder if this could be my problem... --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell djf1994@ wrote: Sorry to add but please define what you mean by closed? If you close inventory does not mean that the inventory trans in that period are all closed (the field on the inventrans called Open becomes No). If the inventtrans is not closed then of course you can do adjustment and end up affecting it. If the inventtrans is closed then there should be no way for you to touch that transactions (unless you cancel closing and then of course it is no longer closed) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of George Burrell Sent: 03 July 2009 05:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions This is normal. Even in a closed period, if a Purchase Price is adjusted (e.g. through Close/Adjust Adjustments etc), the impact of that has to flow onto issues of stock if they are linked to that Purchase transaction. Don't confuse this with the GL impact, which of course be felt on the current date. Look at it another way - what do you think should happen if you close a period 5 days into a new month, and you realise that a Purchase Price in the closed period is wrong? George
[Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions
Closed in this instance refer to the the particular inventory transaction (receipt and issue) to be financially closed, i.e. is has been fully settled. Thus the transaction will be date stamped with the particular closing date. I must concur that there should be no ways that such a transaction can be further adjusted. I have read that some problems have occurred in Ax 3.0 when closings have been cancelled. I wonder if this could be my problem... --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell djf1...@... wrote: Sorry to add but please define what you mean by closed? If you close inventory does not mean that the inventory trans in that period are all closed (the field on the inventrans called Open becomes No). If the inventtrans is not closed then of course you can do adjustment and end up affecting it. If the inventtrans is closed then there should be no way for you to touch that transactions (unless you cancel closing and then of course it is no longer closed) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of George Burrell Sent: 03 July 2009 05:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions This is normal. Even in a closed period, if a Purchase Price is adjusted (e.g. through Close/Adjust Adjustments etc), the impact of that has to flow onto issues of stock if they are linked to that Purchase transaction. Don't confuse this with the GL impact, which of course be felt on the current date. Look at it another way - what do you think should happen if you close a period 5 days into a new month, and you realise that a Purchase Price in the closed period is wrong? George
[Axapta-Knowledge-Village] Inventory closing adjusting already closed transactions
Hi all Working in Ax 3.0 Sp6. I have noticed that the inventory close is adjusting issues already closed by a previous close. I'm under the believe that once a transaction is fully settled, this will not be adjusted again. Have anyone encounter this or is this normal? Thanks
[Axapta-Knowledge-Village] Re: Ax2009 CRM
Hi Craig Hope you are well. Yes, indeed, I'm at a client running CRM in Ax2009. Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Craig Fidler cfid...@... wrote: Hi All, Anyone have a customer that is running CRM in Ax2009? Regards Craig
[Axapta-Knowledge-Village] Firming orders
Hi All When trying to firm planned orders, we receive the following error: Cannot edit a record in Net requirements (ReqTrans). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record. The steps are: Production--Planned Production Orders--select planned order--Inquiries--Explosion--Planned Orders From the planned orders window, we select all orders (production and purchase orders) and select firm. When trying to firm, we receive the error. Anybody come across this? We use AX2009 SP1. Thanks Eddie
[Axapta-Knowledge-Village] Re: Subcontracting production
Thanks! Currently we are using one coverage group for the production (BOM) item as well as components. I've created now a separate group for the components and added the 30 days re-order margin for the bom item coverage group. Quickly tested and it seems to work. Thanks for the help!! Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, dynamics_man dynamics_...@... wrote: Eddie Do not change the standard production leadtime to 60 days, since your production lead time is 30 days only. Add 30 days, ( your intimation advance timeline to your sub-contractor )in the coverage group, re-order margin for the production part. Try now, it will work. Dynamics_man --- In Axapta-Knowledge-Village@yahoogroups.com, edwardjosling edwardjosling@ wrote: Hi All I have a query and hope that someone can help. We are using BOM's for final products with one level of components. The company do not produce themselves, but is subcontracting the production. The company is responsible for buying the components to be delivered to the third party production facility. We use MRP (based on sales forecast) to derive production and purchases order and requirement dates. We use lead times for both production and components to derive delivery and order dates. The standard lead time for production is 30 days, but we need to give the instruction to produce 60 days before the order (thus an additional 30 days to standard lead time). We specify on the item coverage a production lead time as 60 days. Standard purchase lead time for components are 30 days. When the MRP has run and we do a explosion, the problem is that the requirement date for the components are 30 days from the order date on the production, thus we will buy the components 30 days early (because of the extended production lead time). We need to forward the purchase order date to reflect the actual requirement date for the component on the production order. Any help how to accomplish this would be appreciated. Eddie
[Axapta-Knowledge-Village] Subcontracting production
Hi All I have a query and hope that someone can help. We are using BOM's for final products with one level of components. The company do not produce themselves, but is subcontracting the production. The company is responsible for buying the components to be delivered to the third party production facility. We use MRP (based on sales forecast) to derive production and purchases order and requirement dates. We use lead times for both production and components to derive delivery and order dates. The standard lead time for production is 30 days, but we need to give the instruction to produce 60 days before the order (thus an additional 30 days to standard lead time). We specify on the item coverage a production lead time as 60 days. Standard purchase lead time for components are 30 days. When the MRP has run and we do a explosion, the problem is that the requirement date for the components are 30 days from the order date on the production, thus we will buy the components 30 days early (because of the extended production lead time). We need to forward the purchase order date to reflect the actual requirement date for the component on the production order. Any help how to accomplish this would be appreciated. Eddie
[Axapta-Knowledge-Village] Consolidated Sales Orders
Hi All We have the following requirement: We need to consolidate the pick, pack and delivery functions for sales orders with the same delivery address. We are looking at the shipment functionality, to group orders together, but it is obvious that this does not cater for this specific scenario, i.e. we need some modification to the shipment template to use the delivery name on the sales header/line for automatic addition to the shipment. Has anyone encounter a similar requirement? We want to use standard Ax as much as possible. We use AX2009. Thanks Eddie
[Axapta-Knowledge-Village] Re: Changing Inventory Valuation Method
Hi There I assume you are refering to Ax2009? I would suggest trying the following: - Make inventory zero - Do closing to settle all transactions (not sure if this would be necessary?) - Change model group to FIFO - Bring all inventory back in Other things to consider would be the costing version the item pricing is attached to. Not sure if that also should be closed? Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Axapta Consultant consultant.axa...@... wrote: Hi, How can I change the inventory model group from Standard Cost to FIFO of an Item which has got transaction and price is enabled with Standard Cost. If I change the inventory model group it prompts following message The item is set to be evaluated by inventory model âStandard cost'. The system cannot convert the item to be evaluated by an inventory model of type âTransactions settledâ only inventory models of type âTransactions not settledâ can be selected. Â I'll be thankful for quick response and solution. Thanks
[Axapta-Knowledge-Village] Validate Sales Tax code on Purchase Orders
Hi all We are using this parameter setting in the GL (GL/Parameters/Sales Tax) to validate the correct sales tax code. It is set to Error. For Sales Orders this is working, but is does not function from purchase orders. We have tested in standard applications as well and the same result. Does someone experiencing the same or can it be described as a bug? Using Ax2009. Thanks Eddie
[Axapta-Knowledge-Village] Intercompany Sales Order
Hi All We receive an error All inventory cannot be financially updated when trying to invoice a intercompany sales order. The error is due to an inventory item that will go into or has a negative financial cost value. The model group is set to allow financial negative inventory. Does anyone else experiencing this? What would the reason be for this validation? We use AX2009. PS. Settings on the endpoint is to force cost prices, with no editing allowed. Eddie
[Axapta-Knowledge-Village] Re: Inventory Aging by dimension bug!?
Hi James Good work. Thanks for sharing as we also have some clients using this. Just for your information, I have done some tests in Ax2009 with this report, especially running the new standard costing model, concluding that this report does not cater for the new model as it is based on an inventory close! Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell djf1...@... wrote: Dear friends, Based on what my programmer has checked and also discussed with some friends this is indeed a bug in AX4.0 and is also still there in AX2009!!! Supposedly when it was reported to MS they basically replied that they would not be fixing it and so it is up to the partner/customer to fix :o I have yet to submit a support requst to MS so dont know this is the official reply they will give Happy AXing in the new year Thanks James _ From: James Flavell [mailto:djf1...@...] Sent: 05 January 2009 14:20 To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: Invenotry Aging by dimension bug!? Hi everyone Happy New Year to you all!!! A great way to start the new year for me...with a bug ;) I have just investigated a customer's inventory aging report by dimension not being the same as the inventory value by dimension and found it seems the aging report just ingroes all inventsum that have Closed=YES! Such logic is of course wrong as it does not factor in when was the inventsum closed Example: 1) Purchased 1/1/2009 2) Sold 2/1/2009 3) Closing run 3/1/2009 4) Aging run on 4th with As at date 1/1/2009 - result report is empty The aging report (InvnetDimAge) is only in the SYS layer This is in a AX4.0 SP2 so was a little shocked to find noone in MS had found this by the second service pack. Has anyone else come across this problem? I will be looking to see if the latest DIS layer for AX4.0 SP2 has a fix but if anyone has it setup and running and can compare report InventDimAge to SYS that would be real helpful. Thanks James
[Axapta-Knowledge-Village] Ax2009 STD Costing + Inventory ageing
Hi All When running the new standard costing model in Ax2009, my assumption is that no closing procedure is required, thus no inventory settlements take place. Preliminary tests done on the closing with standard costing indicates that there is no settlements, thus leaving us with the stock ageing report that does not work in a standard cost environment. As we are dependent on this report in our current enviroment (AX4), this is a concern for us in AX2009 - to go for the new standard cost model and or redevelop a new stock ageing report? Do anyone have the same views/requirement? Thanks Eddie
[Axapta-Knowledge-Village] Change of stock journal number sequence: Closing don't finish
Hi All Have anyone experienced any problems regarding the changing of inventory number sequences and the influence of that on the inventory closing routine? We have changed the inventory journal number sequence as it has run out of numbers, and now when we try to close inventory, the closing don't finish. Thanks Eddie
[Axapta-Knowledge-Village] Re: Axapta Implementation- Partner Question
Hi David From experience, one key area would be that of the resources (and their dedication). I would go as far as to say that you need to careful study the resources experience - not only on the Ax product, but also industry / business knowledge. I have seen many implementations struggle because of this, especially where critical business decisions needs to be made in connection to the functionality of the system. There would always be some junior consultants on a project, but you need senior, experienced consultants to assist and guide you as a business in some system issues and decisions. Interview your resources might be an suggestion and don't be misled by certifications :) Eddie In Axapta-Knowledge-Village@yahoogroups.com, david50276 [EMAIL PROTECTED] wrote: I work for a company that after careful consideration has chosen Axapta as the ERP package we would like to implement. Our next step is a choice between two Microsoft partners for help in this implementation. Each one can provide good references. Each one can provide equal resources for the implementation. Each one has accountants and programmers on staff. Each has the same Microsoft partner status and staff with the same certifications. All reputations being equal, which would you choose and why? 1. A software company that sells and supports Axapta. 2. An accounting firm that sells and supports several ERP packages including Axapta. Thanks, David
[Axapta-Knowledge-Village] Partial Inventory Settlements
Hi All We have situation where have a lot of old inventory transactions that are only partially settled from the closing process. Some of these transactions dated as far as two years back! This is also causing wrong stock ageing information. We are using Ax 4, standard costing. Any help appreciated. Eddie
[Axapta-Knowledge-Village] Financial Dimensions on Transfer Orders - Inventory Closing
Hi All, Has anyone had experience with adding financial dimensions on transfer orders (AX4.0)? We are experiencing the problem that the inventory closing is posting adjustments to the inventory profit and loss account for transfer orders, but those accounts have a dimension validation - as we operate in different locations as separate cost centers. We also cannot use a default dimension on the item card, for the same reason above. Any feedback will be appreciated. Eddie
[Axapta-Knowledge-Village] Re: Transfer Order - Ship remain
Just for the record: The problem is related to the use of a default location set on the warehouse setup. As soos as the default value in the Default issue and receipt fields were removed, the update on the pick lit could be performed. However, the workaround is to set a default location on the item -- Warehouse items (specific for the in- transit warehouses) Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, edwardjosling [EMAIL PROTECTED] wrote: Hi All We have the following problem in Transfer Orders: We create a transfer order with quantity 4. Produce a picking list for quantity 4. The status of the transfer line is: Transfer quantity = 4 Ship remain = 4 Now we change the quantity on the pick list registration to say 200. After this change, the status on the transfer line is: Transfer quantity = 4 Ship remain = 200 Now we want to change the quantity on the pick list registration back to 4, but the following error occurs: Quantity ordered cannot be reduced because there are not enough open stock transactions with the Ordered status. The items are Purchased, Received or Registered. We are on 4.0 SP2 with all hotfixes applied. We've also applied a fix from MS related to a similar error from transfer orders, but still get the error on the given example. We've tested the same principle from a sales order and without this error message. In fact, the sales order deliver remaining quantity is set back to 4. Have anyone experienced this scenario? Any advice would be appreciated. Thanks Eddie
[Axapta-Knowledge-Village] Transfer Order - Ship remain
Hi All We have the following problem in Transfer Orders: We create a transfer order with quantity 4. Produce a picking list for quantity 4. The status of the transfer line is: Transfer quantity = 4 Ship remain = 4 Now we change the quantity on the pick list registration to say 200. After this change, the status on the transfer line is: Transfer quantity = 4 Ship remain = 200 Now we want to change the quantity on the pick list registration back to 4, but the following error occurs: Quantity ordered cannot be reduced because there are not enough open stock transactions with the Ordered status. The items are Purchased, Received or Registered. We are on 4.0 SP2 with all hotfixes applied. We've also applied a fix from MS related to a similar error from transfer orders, but still get the error on the given example. We've tested the same principle from a sales order and without this error message. In fact, the sales order deliver remaining quantity is set back to 4. Have anyone experienced this scenario? Any advice would be appreciated. Thanks Eddie
[Axapta-Knowledge-Village] Re: Transfer Order - Ship remain
Hi Abdelrhman Unfortunately, the picking list is already been generated. --- In Axapta-Knowledge-Village@yahoogroups.com, Abdel-Rhman El- Kady [EMAIL PROTECTED] wrote: Hi Eddie, while you are on the piking list form mark on the check box Reduce quantity and try me it help and if it work please inform me. Regards, Abdelrhman, -- In Axapta-Knowledge-Village@yahoogroups.com, edwardjosling edwardjosling@ wrote: Hi All We have the following problem in Transfer Orders: We create a transfer order with quantity 4. Produce a picking list for quantity 4. The status of the transfer line is: Transfer quantity = 4 Ship remain = 4 Now we change the quantity on the pick list registration to say 200. After this change, the status on the transfer line is: Transfer quantity = 4 Ship remain = 200 Now we want to change the quantity on the pick list registration back to 4, but the following error occurs: Quantity ordered cannot be reduced because there are not enough open stock transactions with the Ordered status. The items are Purchased, Received or Registered. We are on 4.0 SP2 with all hotfixes applied. We've also applied a fix from MS related to a similar error from transfer orders, but still get the error on the given example. We've tested the same principle from a sales order and without this error message. In fact, the sales order deliver remaining quantity is set back to 4. Have anyone experienced this scenario? Any advice would be appreciated. Thanks Eddie
[Axapta-Knowledge-Village] Re: Warehouse Management Query
Hi Anisha We've done it for one client. We are controlling it by validating a dimension value for the employee which is also attached to a physical warehouse. Drop me a mail or call me and I can explain further... Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, anishafakir [EMAIL PROTECTED] wrote: Hi We have a client that has mutliple warehouses they would like to prevent their staff posting into each other's warehouses. An example where they want to prevent this is on Transfer Orders. The shipping receiving staff is manned by one person. This person will either initiate the transfer order but he must not be able to receive into the 'TO' warehouse but he must be able to receive in his own warehouse if the transfer order was initiated by another person. How can we handle this AX? Is this a modification to the system or can standard functionality like Record Level Security help? Your comments and suggestions are most welcome. Thanking you in advance Regards
[Axapta-Knowledge-Village] Credit notes with standard costing
Hi everyone We are using Ax4.0 SP2 and use standard costing on all our products. When struggling through a inventory reconciliation, we discovered an alarming bug regarding how the inventory close handles sales credit notes. The scenario is as follows: Since the time from a original sales invoice, the standard cost for that item has been updated/changed (the item is a BOM with components and we use the auto report as finished setting to back flush from the sales line). Now the item is returned and we use the Functions -- create credit note function on the sales order. This automatically links the return cost price and lot id to the original sales line. We invoice the credit note. Now a closing is performed (with FIFO as the closing principle). Adjustments are now made to the WIP account (on the components), resulting in an imbalance from GL and inventory. I have done some research and came across a similar bug which was fixed in Version 3 - SP6. Do anyone have a similar scenario or insight into this? PS: We have discovered that when we enter the credit line manually, i.e. not linking the return lot id to the original transactions, the close handles differences correctly (sort of!!). Any help would be appreciated. Thanks Eddie
[Axapta-Knowledge-Village] Credit notes with standard costing
Hi everyone We are using Ax4.0 SP2 and use standard costing on all our products. When struggling through a inventory reconciliation, we discovered an alarming bug regarding how the inventory close handles sales credit notes. The scenario is as follows: Since the time from a original sales invoice, the standard cost for that item has been updated/changed (the item is a BOM with components and we use the auto report as finished setting to back flush from the sales line). Now the item is returned and we use the Functions -- create credit note function on the sales order. This automatically links the return cost price and lot id to the original sales line. We invoice the credit note. Now a closing is performed (with FIFO as the closing principle). Adjustments are now made to the WIP account (on the components), resulting in an imbalance from GL and inventory. I have done some research and came across a similar bug which was fixed in Version 3 - SP6. Do anyone have a similar scenario or insight into this? PS: We have discovered that when we enter the credit line manually, i.e. not linking the return lot id to the original transactions, the close handles differences correctly (sort of!!). Any help would be appreciated. Thanks Eddie
[Axapta-Knowledge-Village] Re: Expense Journal Error Message
Hi Possibly you can check the following: 1. Do you have an offset account for that journal line? 2. Set the rounding for each currency (General Ledger -- Setup -- Exchange rates) 3. Set the max penny difference value (as well as the one for secondary currency if you use secondary currency) in ledger parameters as conversion from currency values can casue rounding differences. Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, leroux_marica [EMAIL PROTECTED] wrote: Issue Description = User has an issue that everytime they try to post an expense journal from the Projects Module the get an error message. Error message: Vocher JE_730003, date 2008/02/28, account 110180, amount currency - 11.50, amount MST - 11.50, alternative amount - 11.50, currency ZAR, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: -11.50 - secondary currency: -11.50) Vocher JE_730003, date 2008/02/28, account 110180, amount currency 5.00, amount MST 5.00, alternative amount 5.00, currency USD, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: 5.00 - secondary currency: 5.00) Posting has been cancelled
[Axapta-Knowledge-Village] Re: URGENT: Material Requirment detail
Hi there, I would suggest that the easiest way would be to look at the Explosion for that particular production order. Production -- Production order -- Inquiries -- Explosion. This will give you a detailed view of the current material requirements and on-hand situation. Go to the critical on-hand tab. From there you can use the auto-report function to produce a printout. However, you will need to setup basic MRP plan, coverage group and parameters. It is suggested to include a dynamic plan for this. Hope this help Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Ax Consultant [EMAIL PROTECTED] wrote: Hi , We are using Production 1. I have created a production order, now from where can I get report/inquiry about the material requirement detail to produce that production order? e.g. i need a report with material quantity required to produce that SET(BOM) with Onhand details Componenet Required QtyAvailable onHand Qty Moreover, can I run Master Planning on a specific Production order? And how? - Looking for last minute shopping deals? Find them fast with Yahoo! Search. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Inventory min.order quantity
Hi all I would like to know if anyone has done modifications to split the inventory min.order quantity during master planning for production and transfer order quantity. We have the requirement to plan for a minimum production order quantity, but to plan for transfer quantities on actual requirements and or min/max levels from other warehouses. Currently there is no way to split these in standard Ax (4.0). (Item coverage only applies for safety levels and min/max) Thanks Eddie
[Axapta-Knowledge-Village] Deposit slip generated after transactions was reconciled in Bank
Hi everyone, Has anyone experienced the scenario where customer payments were reconciled in a bank reconciliation and then after the fact that it was reconciled, a deposit slip was generated from the payment journal and also with a different date as that of the original journal posting date? In our experience this causes: 1) The bank reconciliation to reflect a difference (because the transactions get unreconciled) 2) The Bank and GL is now out of balance (especially if the deposit slip date and the original posting date is in two different financial periods) The fact that you can generate a deposit slip after the fact the individual transactions were reconciled does not sound logic to me. Anyone experienced this before? Regards Eddie
[Axapta-Knowledge-Village] Transfers orders with min order quantity set - MRP
Hi all We have some economic production quantity runs for our products. In order to plan the correct quantities, we use the min. order qty field under the quantity tab on the items form. Now a complication arise when we want to do transfers to our sales branches, using minimum/ safety stock levels for the branches. We setup branches to be refilled from our main distribution warehouse. When the MRP is run, the planned production order quantities refelct correct, but the planned transfers also takes the min. order qty into consideration - which we don't want becasue the safety levels on the branches is much lower than the econimic/min order qty for production. Is there maybe anyone that can shed some light on how to approach this problem, i.e let planned transfer orders exclude minimum order quantity? Thanks Eddie
[Axapta-Knowledge-Village] Re: CRM
Howzit Criag No, this is a bug. Look in MS knowledge base. We've got an hotfix from MS to solve this. BTW - this was not the only issue with the quotation - we had also issues with different UOM's. Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Craig Fidler [EMAIL PROTECTED] wrote: Hi, Using Ax4 SP1 If the warehouse or ship dates have been changed on the quotation line when converting to Sales Order Ax reads the warehouse from the customer master and takes the ship as today. Is there a parameter I am missing ? Regards [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Credit Note Misc. charges
Hi Yifat I assume you use the Functions -- create credit note. You will notice there is a selection Copy misc charges. If you select only ome line and the misc charge has been allocated to that line, only that particular charge will be reversed - as in standard Ax Cheers Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, yifath1 [EMAIL PROTECTED] wrote: hi all, I just want to verify something. My client applies a misc. charge on the purchase order, let say $100 for 5 items, therefore, the misc. charge per item is $20. Then the client returns 1 item to the supplier. i have tested this and it appears that the whole misc. charge is reversed... $100 is this correct? I think some modification has been done on this version of Axapta 3. Please can some one just verify and tell me what should happen when credit note is created and posted. we are using misc. charge as landed cost - whereby it is debiting the item and crediting a different account. Thanks Yifat
[Axapta-Knowledge-Village] Re: Wrong Production Cost: wrong BOM consumption
Found the solution: It is critical that the reversal (BOM) be done at the exact same cost as the original BOM transaction for both RM and FG. To accomplish this, I used marking. After reversing the SO, the ave cost was correct. --- In Axapta-Knowledge-Village@yahoogroups.com, edwardjosling [EMAIL PROTECTED] wrote: Hi everyone! Hope someone can share their experience... A BOM item has been produced using wrong BOM consumption, resulting in a hugely inflated average cost. Sales issues have taken place with this inflated cost. To correct this issue, we did the following: 1. Reverse the production using BOM journal. (Needed to correct raw material consumption) 2. Post FG item with correct BOM consumption, thus correct cost. After these steps, the average costs is still inflated and cost of sales overstated. We then continued with the following: 3. Reverse sales orders with inflated costs 4. Re-invoice at new avg cost We then still have a wrong average cost price. To correct this, we adjusted the receipt transactions (original production orders) to the new cost price (inv management -- periodic -- closing -- adjustment -- transactions). The result is a debit to the stock adjustment account. After this, we proceed with a recalculation on the FG item to correct all transactions (issues) with the correct average cost. Can anyone shed some light if the above process is correct or are we missing something? Although the inventory looks ok, we are not convinced that the GL is correct and still need to test the result. Would appreciate any feedback. Eddie
[Axapta-Knowledge-Village] Wrong Production Cost: wrong BOM consumption
Hi everyone! Hope someone can share their experience... A BOM item has been produced using wrong BOM consumption, resulting in a hugely inflated average cost. Sales issues have taken place with this inflated cost. To correct this issue, we did the following: 1. Reverse the production using BOM journal. (Needed to correct raw material consumption) 2. Post FG item with correct BOM consumption, thus correct cost. After these steps, the average costs is still inflated and cost of sales overstated. We then continued with the following: 3. Reverse sales orders with inflated costs 4. Re-invoice at new avg cost We then still have a wrong average cost price. To correct this, we adjusted the receipt transactions (original production orders) to the new cost price (inv management -- periodic -- closing -- adjustment -- transactions). The result is a debit to the stock adjustment account. After this, we proceed with a recalculation on the FG item to correct all transactions (issues) with the correct average cost. Can anyone shed some light if the above process is correct or are we missing something? Although the inventory looks ok, we are not convinced that the GL is correct and still need to test the result. Would appreciate any feedback. Eddie
[Axapta-Knowledge-Village] Re: Inv - Manage planned order qty
Hi Anil According to the Ax help: Indicate whether the default quantity in the picking list journal is to control and write up corresponding stock transactions. If you do not select the field, the consumption quantity in the picking list journal is to control and write up corresponding stock transactions. Control means that there will always be a quantity in the stock transactions to satisfy the quantity in the journal lines. This means...if you select this option, the corresponding stock transaction(s) that are created when the picking journal line is created, are in accordance with the proposal quantity. It doesn't matter if you change the actual consunmption quantity, the stock tansaction don't change. The reason for this is for MRP and MPS planning Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Anil Kumar Sinha [EMAIL PROTECTED] wrote: Hi, Has anyone used the check box Inv - Manage Planned order qty on Production - Parameter - Journals tab - Picking List journal group? I think it is used to calculate BOM proposal quantity on Pick list. But I can not see any difference in BOM proposal whether I check it or not. Can anyone please let me know how it works? Regards Anil Sinha
[Axapta-Knowledge-Village] Auto-report as finished
Hi all We are faced with a situation where items marked as auto report as finished (on the item), don't get exploded in the MRP plan with Ax 4.0 Sp1. In version 3.0 these items were exploded in the masterplan. This cause that no planning can be done on components. Have anyone experienced the same? Eddie
[Axapta-Knowledge-Village] Re: Sales order requirement view from Master plan
Hi Harry, Yes, just after my post I got the futures inquiries window - thanks! Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi Did u check out inquiries-futures? Regards Harry -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of edwardjosling Sent: 27 March 2006 09:30 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Sales order requirement view from Master plan Hi everyone. We have many multi-line sales orders, each line the same delivery date (i.e. delivery date for the whole sales order). It is critical that as far as possible we don't want to do partial shipments, because many customers then cancel the remaining quantity. Therefore, the production planner needs to have an overview of each sales order from the master planning side to indicate which orders will not meet the required delivery date. Axapta do this by item (as each order can have more than one item on it), but we fail to see a form/screen/report that will show a summary of each sales order, indicating if the delivery date will be met or not. Anyone have an idea? Can this be done through customization? Regards Eddie Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Sales order requirement view from Master plan
Hi everyone. We have many multi-line sales orders, each line the same delivery date (i.e. delivery date for the whole sales order). It is critical that as far as possible we don't want to do partial shipments, because many customers then cancel the remaining quantity. Therefore, the production planner needs to have an overview of each sales order from the master planning side to indicate which orders will not meet the required delivery date. Axapta do this by item (as each order can have more than one item on it), but we fail to see a form/screen/report that will show a summary of each sales order, indicating if the delivery date will be met or not. Anyone have an idea? Can this be done through customization? Regards Eddie Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Priority scheduling of sales orders
Hi evryone! Hope someone can help me. The company manufactures and sell items. It happens that these items can go on a promotion. When this occur, these items should have a higher priority when it comes to production scheduling. For example, there is two sales orders for the same item, with the same delivery date. The one sales order for the specific customer is on a promotion and should take priority when scheduling is done. (The whole sales order is considered to be a promotion.) Anybody know how to solve this in standard Ax 3.0? Thanks Eddie Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Load Ledger Transactions
Nihar, This function is used to load already posted GL transaction vouchers into the journal, for example if you want to do reversal of a posted journal entry. In the dialog box, if you click on the select button, you normaly choose the voucher number that you want to load into the journal. Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, Nihar Saraiya [EMAIL PROTECTED] wrote: Hi All From where does the Axapta loads the transactions when 'Load Ledger Transactions' is used from General JournalLinesFunctionLoad Ledger Transactions. I am a bit confused here, since there is no dialouge box asking me the file i need to upload. Regards Nihar Saraiya, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. Yahoo! Groups Sponsor ~-- $15 provides a child with safe, clean water. Your gift can make a difference. http://us.click.yahoo.com/vp8GxB/icGMAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Interface Third-party Payroll - Axapta 3.0 SP3
Have a look on the Import account statement (transactions) function which is under the Functions button on in the general ledger daily journal. With this method you need to create the journal manually and load the file through this function. You can trace this function to a class where the file can be imported from - you only have to manipulate the import routine - Axapta takes care of the voucher number ect. Take a look at the class(es) LedgerInAccountStatement Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, synergy dubai [EMAIL PROTECTED] wrote: Hi Everybody, We are interfacing a third-party payroll (RB Payroll) with Axapta. The third-party payroll will generate a text file which will be posted to GL. The text fill will have two or more than two lines. One line is Ledger A/C Dr. and 2nd line is Bank A/C. Cr. Can any one through some light how can I automate generation of Journal Number and Line Voucher Numbers when I import this text file in Axapta. I want to post this journal through GL. I really appreciate if anybody has some information on this. Thanks, __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Cost of sales
Hallo all! Does anyone come across the situation where at time of invoice posting, cost of sales needs to be broken down into a material and conversion cost components to be posted on seperate ledger accounts? I know this is not standard Axapta, but if anyone has made modifications or reporting to reflect this I will be clad to hear some opinions. Thanks Eddie Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: cost accounting plus module
I had a look at it, but would also like to know if someone out there has some experience... Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, [EMAIL PROTECTED] wrote: Hello, Has someone experience with the cost accounting plus module by CIRCON ? Kind regards, Willem Baelde Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Cashflow forecasting report
Des, You need to use the financial statements under GL. when defining the columns, you specify the type as chasflow. Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, despo1812 [EMAIL PROTECTED] wrote: Hello to all I have set up the parameters for cash flow forecasting and have run the calcualtion job under G/L-Periodic. I would like to know where to find a report which shows all my obligations less anticipated payments/receipts to give me a cashflow requirement. Does anyone know if there is such a report available in the standard system? Kind regards Des Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Fixed Assets Structure report
Hi everyone Do anyone know if there is any way how to report asset transactions, using the fixed asset structure as defined on the asset register itself? My client has machines that consists of different parts and this will be reflected in the asset register as such - each part/addition will have a seperate aquisition date, service life ect. We are grouping these assets into a main group, i.e printing machines, but there is more than one of these main macines with additions. We are using a manual naming convention to group the simillar machines together, but I was wondering if there is anyone who has done something to report assets using the asset structure. Regards Eddie Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
