Re: [Axapta-Knowledge-Village] Periodic Journal/Recurring Entries
FOr automatially posting the journal , use ledgerjournalcheck , ledgerjournalcheck post/run method pass jouirnal lines as parameters (if it is difficult , go to journal lines form click paymentproposal button---create payment proposal button, see how parameters passed in the code for that click) then you can set the payment schedules in AR--?setup--payments--payments schedule there u setup the schedules and through you check the due date condition and write automatic journal posting code thanks Manoj - Original Message From: Sumit Loya [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, 24 September, 2007 5:11:36 PM Subject: Re: [Axapta-Knowledge-Village] Periodic Journal/Recurring Entries HI, You may be creating a journal for the same i guess. If it is from General journal or any related journal try passing the journal header record to LedgerJournalCheckP ost class. This class handles the posting of all the ledger journals. Regards, Sumit On 9/24/07, Khurram Zaki [EMAIL PROTECTED] com wrote: Hello Everyone, I have an Axapta 3 SP 5 based client who needs to have the following: He has certain recurring financial entries, for example Rent Expense ( Assume Rent Expense Account Debit by $ 100 and Cash Credit by $ 100) that the client wants to post AUTOMATICALLY on the 1st of every month till the time specified (lets say 12 times) I reckon this can be done via periodic journals/batch but failed to do the automatic posting part. Can anyone having experience in such a scenario explain what can be done? Thanks a million. Cheers! Khurram [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] !-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;} #ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#ff;text-decoration:none;} -- !-- #ygrp-sponsor #ygrp-lc{ font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom:10px;padding:0 0;} -- !-- #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family:Arial; clear:both;} #ygrp-vitnav{ padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} #ygrp-vital ul li .cat{ font-weight:bold;} #ygrp-vital a{ text-decoration:none;} #ygrp-vital a:hover{ text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} #ygrp-sponsor #ov{ padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ text-decoration:none;font-size:130%;} #ygrp-sponsor #nc{ background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o{font-size:0;} .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} blockquote{margin:0 0 0 4px;} .replbq{margin:4;} -- Forgot the famous last words? Access your message archive online at http://in.messenger.yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Changning the dimension group of items
Sorry, as a standard fit, once transactions are passed, you cannot change the dimensions. Every Inventory transactions points to a certain dimnesion combination (inventDimId). An item having transactions with one dimension grp cannot suddenly change the dimension grp and hence the inventory dimension combinations. Your workaround is to create a new item and discontinue usage of the older. On 9/27/07, madhubabu_r [EMAIL PROTECTED] wrote: I am getting this warning message when I am changing the Dimension Group of an Item in the Item Master. I had done some transactions on this item. Message (12:40:11) The new dimension group cannot be assigned. Other financial dimensions apply and physical inventory transactions might exist and/or financial inventory transactions are not fully settled. Is there any way out to change the dimension group of this item??? Thanks and best regards, Madhu [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Sharepoint with Dynamics Ax
Hi Hans, I tried to install sharepoint 3.0 according to the instructions given in the document but i am getting an error: Failed to register sharepoint services: An exception of type system.runtime.interopservices.comexception was thrown. Could not access the Search Service configuration database. Please help me in this matter. Thanks Regards, Mukesh On 9/20/07, Hans Kruiniger [EMAIL PROTECTED] wrote: Hi Mukesh SharePoint needs its own database, as you have discovered. To set up the portal, start with the admin menu, setup, internet, EP and go through the steps. I have attached a doc I have found useful for getting through some of the tricky problems that crop up. Best of luck :-) Hans [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Error loading vcgantt.ifd in Ax40SP2
I have tried what you suggested, but still having problems.. Any others who have anything to suggest??? Med vennlig hilsen Torgeir Toms Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne av Malcolm Burtt Sendt: 21. september 2007 17:00 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Error loading vcgantt.ifd in Ax40SP2 Hi Sounds like the problem I ran into last week. For us, it was caused by previous installations of the Gantt client Active control (from earlier versions of Ax). If it's the same for you, you can fix it as follows... 1. Find all copies of the file vcgantt.ocx 2. For each file, un-register it by executing the command below regsvr32 /u pathname (where pathname is the full pathname to the vcgantt.ocx file to be unregistered) 3. Now re-register the vcgantt.ocx file for the AX 4.0 SP2 client. regsvr32 pathname That should solve the problem. Regards Malcolm Burtt Touchstone People, Partnerships, Solutions From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Torgeir Toms Sent: 18 September 2007 12:57 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Error loading vcgantt.ifd in Ax40SP2 Hi When trying to access the Gant menu in Ax40 SP2 it returns an error saying it can not load vcgantt.ifd Anyone know what canbe the problem Med vennlig hilsen Torgeir Toms [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Cash Report
Hi, I dont think there is any standard report as such for cash flow statement. Probably you will have to create one such report. Regards, Sumit On 9/21/07, kamaraju80 [EMAIL PROTECTED] wrote: Hi Axapta professionals, I am very sure that Axapta can Generate very complex reports. But can i get a simple cash flow report showing cash receipts and cash payments for a particular period. Has any one worked on this? My client is asking for it. Please help me asap. regards, Kamaraju V, Hyderabad. Phone number 9908579426 [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Sharepoint installation error
Hi All, I tried to install sharepoint 3.0 but i am getting an error: Failed to register sharepoint services: An exception of type system.runtime.interopservices.comexception was thrown. Could not access the Search Service configuration database. Please help me in this matter. Regards, Mukesh [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Report Display
What we usually do here is that we keep, for example, the recId of the last Production Order Line (in your case) printed. Then when we get to print information about a Production Order Line we compare it with the latest one printed. If they are the same then we don't have to print info it. Make the field visible false or use display methode that have a value to return empty string or the value. regards, Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, Rajkumar [EMAIL PROTECTED] wrote: Hi all, I have a problem in displaying the report. I want to select report from Prodtable,Prodroute and ProdBom tables. Now the trick is I have selected all the records which is showing in the report. But I want to display the first line record and if the production order line has more records in prodbom table..then most of the fields should be hidden on the next line. The report should look like this. WrkCntr frmdate itemid(Prodbom) itmnme(prodBom) Opr# itemid (prodtable) 30012 12/3/2007 DAP-42DA2343 10 234242 -- -- DAS-34DA5432 -- -- -- -- FRG-64FG2456 -- -- I think the above format is clear. Any help on the same. How to hide the data for the next few lines in report dynamically. Regards
[Axapta-Knowledge-Village] Print to file
Hi, Anyone know a way to create a .prn file from a report? By .prn file I mean the file outputed when you print to a print to file printer in windows. I've found \Classes\ClassFactory\createViewer where the format is checked to determine what class will create the output. If I knew How to generate a .prn file, that's where I would launch my class. But first, how do I create a valid .prn using parameters passed to creatViewer()? regards, Steeve
[Axapta-Knowledge-Village] Third party PDF generator
Hi, Anyone have been able to implement the use of a third party PDF generation software? My biggest problem is being able to specify the filename of the PDF without user interaction. Feel free to provide any idea towards this. Thanks. Steeve...
RE: [Axapta-Knowledge-Village] Changning the dimension group of items
You can change as along as all inventtrans are closed. We have done this by writing off all the stock balance, change dimension then bring back in stock -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Akshay Sent: 27 September 2007 15:33 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Changning the dimension group of items Sorry, as a standard fit, once transactions are passed, you cannot change the dimensions. Every Inventory transactions points to a certain dimnesion combination (inventDimId). An item having transactions with one dimension grp cannot suddenly change the dimension grp and hence the inventory dimension combinations. Your workaround is to create a new item and discontinue usage of the older. On 9/27/07, madhubabu_r [EMAIL PROTECTED] wrote: I am getting this warning message when I am changing the Dimension Group of an Item in the Item Master. I had done some transactions on this item. Message (12:40:11) The new dimension group cannot be assigned. Other financial dimensions apply and physical inventory transactions might exist and/or financial inventory transactions are not fully settled. Is there any way out to change the dimension group of this item??? Thanks and best regards, Madhu [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
[Axapta-Knowledge-Village] Technical Training
Dear Members, Where can I get the Technical Training covering Programming in Axapta 3.0 in Bangalore for in-House Development / Reports. Best Regards, Irfan From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of meena lakshmanan Sent: Tuesday, September 25, 2007 1:19 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Tchnical Training U can take the technical training at Emporis Academy Private Limited, Chennai who are the CPLS partner for giving AX training. Lakshman - Original Message From: P.Saravana Kumar [EMAIL PROTECTED] mailto:p.saravanakumar%40tvssons.com To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Sent: Monday, September 24, 2007 3:08:58 PM Subject: [Axapta-Knowledge-Village] Tchnical Training Dear Members Where I can take the Technical Training covering Programming in Axapta 3.0 in India for in-House Development / Maintenance Regards, Saravanakumar [Non-text portions of this message have been removed] __ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mailp=summer+activities+for+ki dscs=bz http://search.yahoo.com/search?fr=oni_on_mailp=summer+activities+for+k idscs=bz [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] I want sum Debit and credit amount seperatly from amountMst from CustTrans Table
Hi I want to sum debit and credit amount separately from custtrans table and display using display method in report I have been tried element.sumpos(tableId,fieldId,1) But this method doesn't Work Plz help
[Axapta-Knowledge-Village] Minimum Stock Level - Step by step
hi all, can any one plesae guide the step by step guide for minimum stock level calculation on the basis of available formulas in Axapta Our client wants to calculate minimum stock level of item on the basis of service level or average lead factor please refer to some document or guide with step by step instructions for this functionality to be demonstrated looking forward to hear a kindful reply thanks in advance
RE: [Axapta-Knowledge-Village] Cash Report
Thanks. Can you give me any idea as to how I can create this report. Table name or any clue Regards, Kamaraju _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sumit Loya Sent: Thursday, September 27, 2007 3:27 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Cash Report Hi, I dont think there is any standard report as such for cash flow statement. Probably you will have to create one such report. Regards, Sumit On 9/21/07, kamaraju80 kamaraju_vudata@ mailto:kamaraju_vudata%40semanticspace.com semanticspace.com wrote: Hi Axapta professionals, I am very sure that Axapta can Generate very complex reports. But can i get a simple cash flow report showing cash receipts and cash payments for a particular period. Has any one worked on this? My client is asking for it. Please help me asap. regards, Kamaraju V, Hyderabad. Phone number 9908579426 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Does anyone who knows how to solve this issue?
Hi all, I got a Purchase order for 500$ , the supplier by mistake had sent me a invoice for 600$ and then he sent me a credit note for 100$. I need to register the credit note and invoice in the system for VAT period purpose. Now to invoice this Purchase Order i need to attach this wrong invoice amount and credit note together which would come to the actual invoice amount which is 500$ which helps me to Invoice the PO. How can i attach the wrong invoice and credit note together and attach it to the Purchase Order. Many thanks in advance Zeno ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Sharepoint installation error
Hi Mukesh, Please make sure that the user has full database admin rights. This error comes up when the user you are using to install don't have the access to config database in SQL server or not been added to SQL server as well. Regards, Waqas Butt Microsoft Business Solutions Consultant Mbl: +97150 1606879 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mukesh Kumar Sent: Thursday, September 27, 2007 2:31 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Sharepoint installation error Hi All, I tried to install sharepoint 3.0 but i am getting an error: Failed to register sharepoint services: An exception of type system.runtime.interopservices.comexception was thrown. Could not access the Search Service configuration database. Please help me in this matter. Regards, Mukesh [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]