[Axapta-Knowledge-Village] Goods return for items already blocked
Dear all, Need opinion about how to handle return goods that in inventory we already blocked it? and what to do if we already change the setting in item group, for example we already changed the ledger account setting so it obviously different with the first we sell it. Thanks a lot, Anton
Re: [Axapta-Knowledge-Village] Re: Changing Inventory Valuation Method (urgent)
Hi, The transactions already being settled is not a part of this process, Only the transactions which are open gets effected with the new price and the new model. Because after changing the costing method, the system will settle the inventory only with the open inventory transactions. Before changing the inventory model group, close the inventory. All of the existing inventory transactions are at std cost price so no adjustment entry gets passed. After this change the model group to FIFO. Existing entries are already there with the std price and new entries will come at new purchase price. At the time of consumption system will calculate the costing with the FIFO method. Regards, Mukesh On Mon, Mar 23, 2009 at 2:19 PM, Axapta Consultant < consultant.axa...@yahoo.com> wrote: > > Yes I am using AX 2009, I have followed the following procedure, but still > the following messages is poping up on change of costing method. > > "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." > > Kindly help me out in this regard ASAP. > > Thanks > > > -- > *From:* edwardjosling > *To:* Axapta-Knowledge-Village@yahoogroups.com > *Sent:* Sunday, March 22, 2009 12:43:32 PM > *Subject:* [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- vill...@yahoogro > ups.com, > Axapta Consultant 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 > > > > > > -- Mukesh Mutreja # 09818421567
Re: [Axapta-Knowledge-Village] Need help in following scenario plz
Hi, As you are talking about advance against the PO. Make the payment journal and do the payment. As you mention already through the open transaction editing from the PO form you can settle the advance with the PO invoice. It will settle the PO amount with the advance payment that you need to select in the open transaction editing form. Regards, Mukesh On Fri, Mar 20, 2009 at 1:11 PM, Ali Jawad wrote: > Dear Champs! > > > > Please give your comments in the scenario below; > > > > In AX 2009, when I create a purchase order, I have following payment terms > or schedule > > · 30% advance > > · 50% on delivery > > · 10% installation > > · 10% final close out / Completion > > Now when I confirm the PO, at the same time I need to process 30% payment > that I will do through payment journal. > > Then later I receive material and invoice and I process 50% on delivery and > same with other payments. > > > > *Now,* > > Is there a way that while creating payment system should suggest me the 30% > or system should check this payment from PO. Or is there any link with PO. I > found one which is from Purchase Order detail window when you open à open > transaction editing, there you can mark payment with PO. What is the effect > of this marking? > > All I need is control by system linking advance/prepayment with PO. > > > > > > Your immediate response will help a lot. > > > > Kind Regards, > > Ali Jawad > > __ > > > -- Mukesh Mutreja # 09818421567
[Axapta-Knowledge-Village] DAX 2009 Upgrade Issue - Urgent
Hi, while doing Post synchronization during the DAX 2009 data upgrade, the cockpit is throwing some error while runnuing a job. Please find belew the error message registered in the Eventviewer at that time. Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 117 Date: 24/03/2009 Time: 1:41:57 PM User: N/A Computer: DEVSVR05 Description: Object Server 01: The database reported (session 4 (Admin)): [Microsoft][SQL Native Client][SQL Server]Invalid column name 'F2'.. The SQL statement was: "DECLARE @VTABLEID INT, @VNEXTRECID BIGINT,@TMP_ROW_CNT BIGINT; SET @VTABLEID = 2832; DECLARE C_F CURSOR FOR SELECT NEXTVAL FROM SYSTEMSEQUENCES WHERE ID = -1 AND TABID = @VTABLEID FOR UPDATE; BEGIN IF OBJECT_ID(N'TEMPDB..#DEL_UPGRADEBUSRELTABLE_TMP') IS NOT NULL DROP TABLE #DEL_UPGRADEBUSRELTABLE_TMP SELECT CONVERT(NVARCHAR(20),'') AS F3,BUSRELACCOUNT AS F1,RECID AS F2 , DEL_CUSTACCOUNT as F4 , DEL_VENDACCOUNT as F5 , DATAAREAID AS DATAAREAID, 1 AS RECVERSION, IDENTITY(BIGINT,1,1) AS RECID INTO [#DEL_UPGRADEBUSRELTABLE_TMP] FROM SMMBUSRELTABLE A WHERE (DATAAREAID= N'CH1') AND PARTYID = ' ' UPDATE #DEL_UPGRADEBUSRELTABLE_TMP SET F3 = [NT AUTHORITY\NETWORK SERVICE].FN_FMT_NUMBERSEQUENCE('',RECID,3,0); SET @TMP_ROW_CNT =( SELECT COUNT(RECID) FROM #DEL_UPGRADEBUSRELTABLE_TMP) OPEN C_F FETCH NEXT FROM C_F INTO @VNEXTRECID UPDATE SYSTEMSEQUENCES SET NEXTVAL = NEXTVAL + @TMP_ROW_CNT WHERE ID = -1 AND TABID = @VTABLEID; CLOSE C_F DEALLOCATE C_F INSERT INTO DEL_UPGRADEBUSRELTABLE (PARTYID,BUSRELACCOUNTID,BUSRELRECID ,CUSTACCOUNTID ,VENDACCOUNTID ,DATAAREAID,RECVERSION,RECID) SELECT F3,F1,F2 ,F4 ,f5 ,DATAAREAID,RECVERSION,rec...@vnextrecid FROM #DEL_UPGRADEBUSRELTABLE_TMP IF OBJECT_ID(N'TEMPDB..#DEL_UPGRADEBUSRELTABLE_TMP') IS NOT NULL DROP TABLE #DEL_UPGRADEBUSRELTABLE_TMP END; " For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. can anyone help me out in solving this error? Thanks and regards, Venkat.
[Axapta-Knowledge-Village] Microsoft Support Question
Hi, I work for an end client who are using AX3.0. We were trying to get rid of partner and went direct with MS for AX support. For 'Customer' support, they are asking about 60K+USD/annum for 30 hours. Here are my thoughts. 1. MS is always tier1 support. I feel they are one of the dumbest people i ever come across...For example, vendor aging report. Pathetic.. 2. MS support sucks for AX4.0 because of DIS.AOD file. They will not tell us the objects in question for the fix rather they will give the whole AOD file which will have every fix. It takes ages to extract the fix for some of the critical issues 3. Honestly, they are bugs in the system. They should be not charging us for fixing their bugs... 4. Documentation on the issue sucks 5. KB article information on some of the bugs are horrible. 4. I know/dealt with almost all each and every object in axapta... Do you know if we really need to pay 60K for support from MS? It feels to me that a lot of money for the services we get from them. Are there any companies out there that they dont use MS support? I am interested to know... Appreciate any help. Kind regards, Subbu
[Axapta-Knowledge-Village] Re: Microsoft Support Question
--- In Axapta-Knowledge-Village@yahoogroups.com, "Subbu" Hi Subbu, I am also working at client End using AX 3(sp5). We also faced a lot of problem from support vendor. From last one & half year we are going with without support. Till now I am managing all queries, report development & required customization PRASANNA wrote: > > Hi, > > I work for an end client who are using AX3.0. We were trying to get rid of > partner and went direct with MS for AX support. > > For 'Customer' support, they are asking about 60K+USD/annum for 30 hours. > > Here are my thoughts. > > 1. MS is always tier1 support. I feel they are one of the dumbest people i > ever come across...For example, vendor aging report. Pathetic.. > > 2. MS support sucks for AX4.0 because of DIS.AOD file. They will not tell us > the objects in question for the fix rather they will give the whole AOD file > which will have every fix. It takes ages to extract the fix for some of the > critical issues > > 3. Honestly, they are bugs in the system. They should be not charging us for > fixing their bugs... > > 4. Documentation on the issue sucks > > 5. KB article information on some of the bugs are horrible. > > 4. I know/dealt with almost all each and every object in axapta... > > Do you know if we really need to pay 60K for support from MS? > > It feels to me that a lot of money for the services we get from them. > > > Are there any companies out there that they dont use MS support? > > I am interested to know... > > > Appreciate any help. > > Kind regards, > Subbu >
RE: [Axapta-Knowledge-Village] Microsoft Support Question
Hi Subbu, To be honest I have to agree on the direct MS support/consultanting services...they really know nuts about AX (i.e. still a long way from being a mature AX team). In terms of the front line dev I think that is a different story but I dont believe you will get direct access to them unless your case ends up being very serious and potentially damaging to MS As for fixes in AOD file I agree it can be a nightmare getting specific objects but I can understand from MS point of view why they do it that way rather than individual xpos per hotfix. If you push MS they will attempt to get you the specific objects but it can take a long time and can be quite frustrating. The KB search function also is not great which does not help your own attempts. I would suggest for 60k USD per annum you can get a very good support agreement with a partner, its just a matter of finding the right one. Not sure why you dropped your partner but I believe you can get good value if you find the right partner Of course the partner will probably make use of MS in certain situations (kernel bugs etc) but for sure they should be able to respond much faster and with better understanding and detail in the majority of cases and have other avenues/contacts to use in searching for solutions for you >From my experience with supporting customers (including remote support) a serious support agreement between customer and partner should be able to satisfy what you need but the focus of the agreement needs to be clear to both sides (e.g. is it to included technical as well as application and data etc) Since being a partner I am on the other side of the fence if you would like to chat on this topic feel free to look me up on skype djf1994 or send to my gmail Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Subbu Sent: 25 March 2009 06:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Microsoft Support Question Hi, I work for an end client who are using AX3.0. We were trying to get rid of partner and went direct with MS for AX support. For 'Customer' support, they are asking about 60K+USD/annum for 30 hours. Here are my thoughts. 1. MS is always tier1 support. I feel they are one of the dumbest people i ever come across...For example, vendor aging report. Pathetic.. 2. MS support sucks for AX4.0 because of DIS.AOD file. They will not tell us the objects in question for the fix rather they will give the whole AOD file which will have every fix. It takes ages to extract the fix for some of the critical issues 3. Honestly, they are bugs in the system. They should be not charging us for fixing their bugs... 4. Documentation on the issue sucks 5. KB article information on some of the bugs are horrible. 4. I know/dealt with almost all each and every object in axapta... Do you know if we really need to pay 60K for support from MS? It feels to me that a lot of money for the services we get from them. Are there any companies out there that they dont use MS support? I am interested to know... Appreciate any help. Kind regards, Subbu