[Axapta-Knowledge-Village] Webform lookup doesn't work
Hi I work on the webform EPCSSCheckOut and I want to add a lookup on the control 'WebGroup_DeliveryStreet'. When clicking the lookup button the user are able to select between the customers delivery or alternative delivery addresses. I use the class webTableLookup to create the lookup. the same way it's done on the control 'WebGroup_DeliveryCounty' on the same form. My lookup looks up values from the address table. My first problem is that I don't get a lookup button! My second problem is that I'm unable to debug in the enterprise portal even though the setup is done. Any help will be appriciated, thanks Koffidan
[Axapta-Knowledge-Village] import data to Counting journal
Hi I have imported records to counting journal (inventJournalTrans) by use of Axapta standard import functionality. The imported records looks good. But each record in the counting journal should create a invent movement - create an inventTrans record. That doesn't happen! I have looked at the Counting form and tried to execute the code on the modified method on item id and Counted field plus the table update method - these methods usually creates an update invent movement. Nothing happens! Do you have any idea of how I can update this programmically, I would appriciate a suggestion - I have approx. 30.000 records and I don't look forward to enter them manually into the journal :-) Regards Irving 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] Deleting files in a folder
Hi I want to delete files in a folder, I have made following code: void deleteFilesInFolder(filePath _inputPath) { object cIo; fileNameinputFile; filePathinputPath = _inputPath; ; inputFile = this.SearchInputFile(inputPath); cIo = new CommaIo(inputFile,'r'); while(inputFile) { winAPI::DeleteFile(inputFile); //Get the next file... inputFile = this.SearchInputFile(inputPath); cIo = new CommaIo(inputFile,'r'); } } where SearInputFile has the following code: FileName SearchInputFile(filePath _Path) { container fileInfo; int findhandle; filePathfilePath; FileNamefileNameTmp; ; fileNameTmp = _Path; filePath = fileNameTmp; if (subStr(fileNameTmp,strlen(fileNameTmp)-1,1) == '\\') { fileNameTmp = fileNameTmp + '*.*'; } else { fileNameTmp = fileNameTmp + '\\*.*'; filePath = filePath + '\\'; } fileInfo = winAPI::FindFirstFile(fileNameTmp); findHandle = conpeek(fileinfo,1); fileNameTmp = winApi::FindNextFile(findHandle); fileNameTmp = winApi::FindNextFile(findHandle); winAPI::FindClose(findHandle); if (fileNameTmp) return filePath + fileNameTmp; return ''; } My problem is, that I find the first file again and again, each time I try to delete it with winAPI::deleteFile(Filename). What is I doing wrong, I want to go throught the folders files and delete them. Regards irving 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: Deadlocks and try/retry
--- In Axapta-Knowledge-Village@yahoogroups.com, ontariodiver [EMAIL PROTECTED] wrote: Hi I have had a similar situation/experience. If you use ttsbegin/ttscommit, then check where you are using them. When you use a tryCatch construction together with ttsbegin/ttscommit and get a deadlock, you go to the first catch (exception::deadlock) OUTSIDE the outermost ttscommit. If your catch (exception::deadlock) is inside the outermost ttscommit, you will never pick up the catch. Regards Irving Hi all, I have a situation where it seems that deadlocks are not picked up by catch. Any ideas? It looks similar to this class 1: Try { method in class 2 } catch (exception::deadlock) { retry } class 2 method: { step 1:insert sales lines into invoice step 2:update custom status field in new table } What is happening is Oracle reports a deadlock and processing stops at step 1. I would have thought class 1 would catch the deadlock and do a retry, but it doesn't. Do i have to do the try/retry in class 2 as well? I am using Axapta 3.0 SP3. 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] Changing posted VAT in Invoice Approval Journal
Hi What do you do when you have posted the wrong VAT amount in the Invoice Register Journal? Invoice Total: 250.00 VAT: 50.00 But you accidentally post 55.00 as VAT and of course then 195.00 as Invoice Total. When I come to the approval, I want to change the posted VAT amount to the correct so that I am able to post the correct invoice total. I have tried to create Journals where Amounts in journal includes VAT and journals where Amoount in journal excludes VAT. But I don't seem to be able to post the correct amounts - it specifically doesn't want to post the VAT. How do you do it? Regards Irving 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] Calculate Tax per line
I create records in the Invoice Register Journal from my code. Depending on the conditions, I have to change the tax amount on some journal lines. I know the new tax amount: Example: Amount incl tax Credit Amount = 200.00 VAT percentage = 25% Tax amount = 40.00 (Value is not represented in the ledgerjournalTrans) I want the tax amount to be new tax amount = 45.00 after I have inserted the journalline. So first I have to check if the current tax amount (40.00) is equal to the new tax amount (45.00). If not I have to change the tax amount to 45.00. How do I do that? Regards Irving 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] Getting af number from a numbersequence
Hi I import records directly into the Invoice Register Journal and in the process I have to get a journal number for the imported records. I do this like this: newJournalNum= false; if (!ledgerJournalTable.journalNum) { ledgerJournal= new LedgerJournal(); if (ledgerJournal) { ledgerJournalTable.journalNum = ledgerJournal.newJournalNum(true); newJournalNum= true; } } It seems to go fine, but after a while I get an error when I try to create a new Invoice Register Journal, it tells me that the number is already used. When I go to Basis/Setup/number sequence and find the number sequence for the Invoice Register Journal and select the button clean up/Current, I'll get a list of all the journal numbers I have used and I can see that the status is Free or Active. But I'm looking at posted journals! It looks like I have to do more than just pick a new number, do you know what I have to do? Regards Irving 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: File axdat.udb
Hi Varden sorry to say, but the attachment isn't stored. I don't know how to get my hands on it :-) You could upload it as under FILES - just a suggestion. Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris [EMAIL PROTECTED] wrote: Hi Irving Please see attachment. Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner Suite 2000, 500 - 4th Ave SW Calgary, Alberta, Canada T2P 2V6 (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca Irving [EMAIL PROTECTED] wrote: Thanks The customer didn't buy a licens to run AOS, so it's a 2-tier installation without a AOS. That has become the big question, who or what is locking the file? Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Mayle, Michael [EMAIL PROTECTED] wrote: Irving, That file is the Axapta user database file. That is what keeps track of who is logged into each server. This is where the information is stored for when you look at administrator-users-online users. If the AOS is stopped, you can delete the file, otherwise, you cannot because it is in use. The server will regenerate a new one. --Michael -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Irving Sent: Tuesday, December 27, 2005 4:03 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] File axdat.udb Hi Do you know what this file - axdat.udb - is used for? Can I delete it? Can't start Axapta, it tells me that this file is locked but I can't see how. Do you have any idea? Regards irving 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. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. Yahoo! Groups Sponsor ~-- Help the victims of the Pakistan/India earthquake rebuild their lives. http://us.click.yahoo.com/.cYGuB/leGMAA/cosFAA/kGEolB/TM ~- 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] Transaction text in Invoice Register Journal
Hi Is it possible to setup auto generation of transaction text in the Invoice Register Journal. I know you can setup auto generated transactions text on path Basic/Setup/Transaction text - but I can't find an option for the Invoice Register Journal. Regards Irving 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. 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: Transaction text in Invoice Register Journal
Hi Jay Thanks for your suggestion! The functionality you suggest isn't auto generating transaction text. You are only able to select transaction text from the Invoice Register Journal. What I'm looking for is a functionality which generate transaction text like 'Invoice 05-112' or 'Vendor 100' or 'CostCenter Shop No. 3' etc. Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Jayaprakash M. [EMAIL PROTECTED] wrote: Irving, Yes, it is possible to setup auto generation of transaction text for Invoice Register Journal in the below mentioned path The transaction text created in the below mentioned path will be displayed in the Invoice Register Journal's transaction text combo box. Main Menu - General Ledger - Setup - Journals - Journal Text form. I think this should solve your problem. Regards, jay -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] Behalf Of Irving Sent: Wednesday, December 28, 2005 2:49 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Transaction text in Invoice Register Journal Hi Is it possible to setup auto generation of transaction text in the Invoice Register Journal. I know you can setup auto generated transactions text on path Basic/Setup/Transaction text - but I can't find an option for the Invoice Register Journal. Regards Irving Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business http://groups.yahoo.com/gads? t=msk=Business+finance+coursew1=Business+finance+coursew2=Business +to+business+financew3=Small+business+financew4=Business+finance+co nsultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6 s=185.sig=I8jDsORmsaYn0BeqghcJ2w finance course Business http://groups.yahoo.com/gads? t=msk=Business+to+business+financew1=Business+finance+coursew2=Bus iness+to+business+financew3=Small+business+financew4=Business+finan ce+consultantw5=Business+finance+magazinew6=Business+finance+school sc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA to business finance Small http://groups.yahoo.com/gads? t=msk=Small+business+financew1=Business+finance+coursew2=Business+ to+business+financew3=Small+business+financew4=Business+finance+con sultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6 s=185.sig=v9sWAno7Kz4WuL8Tadcdhw business finance Business http://groups.yahoo.com/gads? t=msk=Business+finance+consultantw1=Business+finance+coursew2=Busi ness+to+business+financew3=Small+business+financew4=Business+financ e+consultantw5=Business+finance+magazinew6=Business+finance+schools c=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA finance consultant Business http://groups.yahoo.com/gads? t=msk=Business+finance+magazinew1=Business+finance+coursew2=Busine ss+to+business+financew3=Small+business+financew4=Business+finance+ consultantw5=Business+finance+magazinew6=Business+finance+schoolsc =6s=185.sig=qphRINaNuVm_6bwoQxgUmg finance magazine Business http://groups.yahoo.com/gads? t=msk=Business+finance+schoolsw1=Business+finance+coursew2=Busines s+to+business+financew3=Small+business+financew4=Business+finance+c onsultantw5=Business+finance+magazinew6=Business+finance+schoolsc= 6s=185.sig=1RfnhYZpV99RKWRZzSH4gA finance schools _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=Unsubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- 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: File axdat.udb
Thank you! This is good. --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris [EMAIL PROTECTED] wrote: I am sorry 2 becuase you will not be able to see the two screenshots. I believe that you are using the NTFS files system. When using this file system you have two permissions to consider, which are the NTFS permission and the share permission. The NTFS permission on a folder is shown below for the Administrators group on the local computer. You should at least check the write permission for a group to allow the group to write to files in this folder on the computer (interactively) or from another computer (over the network using the share). From the properties of the shared folder select the security tab. After selecting the permissions button from the sharing tab the following screen will appear. By default the Everyone group has read permission. If you require everyone to be able to write to this folder you should check the Change permission. Irving [EMAIL PROTECTED] wrote: Hi Varden sorry to say, but the attachment isn't stored. I don't know how to get my hands on it :-) You could upload it as under FILES - just a suggestion. Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris [EMAIL PROTECTED] wrote: Hi Irving Please see attachment. Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner Suite 2000, 500 - 4th Ave SW Calgary, Alberta, Canada T2P 2V6 (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca Irving [EMAIL PROTECTED] wrote: Thanks The customer didn't buy a licens to run AOS, so it's a 2-tier installation without a AOS. That has become the big question, who or what is locking the file? Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Mayle, Michael [EMAIL PROTECTED] wrote: Irving, That file is the Axapta user database file. That is what keeps track of who is logged into each server. This is where the information is stored for when you look at administrator-users-online users. If the AOS is stopped, you can delete the file, otherwise, you cannot because it is in use. The server will regenerate a new one. --Michael -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Irving Sent: Tuesday, December 27, 2005 4:03 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] File axdat.udb Hi Do you know what this file - axdat.udb - is used for? Can I delete it? Can't start Axapta, it tells me that this file is locked but I can't see how. Do you have any idea? Regards irving 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. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615
[Axapta-Knowledge-Village] File axdat.udb
Hi Do you know what this file - axdat.udb - is used for? Can I delete it? Can't start Axapta, it tells me that this file is locked but I can't see how. Do you have any idea? Regards irving Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- 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: File axdat.udb
Thanks for the quick answer, but I didn't give you the complete pickture of my situation, sorry: When I logg on to the server as Administrator (or myself) and try to log on to my two tier Axapta installation, I'm told that the file Axdat.udb is locked by another process and that Axapta can't start. It doesn't help me to delete the file. There is no other Axapta running on the server, I have checked my task manager. When I logg on to my own laptop, mapping axapta location on server, and try to logg on to my two tier installation, Axapta starts up. I logg on to the same application!!! I don't know the problem, but I must be able to logg on to Axapta from the server, do you have an idea? Regards irving --- In Axapta-Knowledge-Village@yahoogroups.com, kumar gaurav [EMAIL PROTECTED] wrote: hi irving, search this file in your client and application folder and check it's property . May be it's read only property is checked. I have faced same type of problem with other files. I belive it shd work, bye Irving [EMAIL PROTECTED] wrote: Hi Do you know what this file - axdat.udb - is used for? Can I delete it? Can't start Axapta, it tells me that this file is locked but I can't see how. Do you have any idea? Regards irving Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Send instant messages to your online friends http://in.messenger.yahoo.com Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- 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: File axdat.udb
Thanks The customer didn't buy a licens to run AOS, so it's a 2-tier installation without a AOS. That has become the big question, who or what is locking the file? Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Mayle, Michael [EMAIL PROTECTED] wrote: Irving, That file is the Axapta user database file. That is what keeps track of who is logged into each server. This is where the information is stored for when you look at administrator-users-online users. If the AOS is stopped, you can delete the file, otherwise, you cannot because it is in use. The server will regenerate a new one. --Michael -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Irving Sent: Tuesday, December 27, 2005 4:03 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] File axdat.udb Hi Do you know what this file - axdat.udb - is used for? Can I delete it? Can't start Axapta, it tells me that this file is locked but I can't see how. Do you have any idea? Regards irving Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- 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] Database experts
Hi I really need to know how to run Axapta 3.0 on a MSDE, I can't seem to make it work and I can't find any instruction on how this is done. Do you know how? thanks regards Irving Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- 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: Posting Vendor Misc Charges
Hi Sun Fen Thank you for your answer. What you are saying, is that if I add up all the financial postings, then I can see the missing 25.00 on the inventory receipt account where it should be because misc charges on line add to the inventory value. Ok, What is TL? Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Sun Fen Chen [EMAIL PROTECTED] wrote: Hi Irving, I think the result is correct. The following journal will be created upon invoice: Inventory receipt 1,025 Misc charge 425 AP 1,450 Misc charge on the line is debited to item with the amount of 25 so will add up to inventory value (cause debit type = Item) Misc charge 2511 will add up 450 will add up to AP because you specify customer/vendor as credit type on the misc charge and this will increase our payable The help in Axapta explains this. You can also find it in TL user manual Regards, Sun Fen On 12/21/05, Irving [EMAIL PROTECTED] wrote: Hi Do you know of a document or such like that describes how to manage vendor misc. charges? Or are you able to explain there use? Then I'm very interested! It's the way they are posted that confuse me. I have a situation where a misc charge (450.00) on the head is debited on ledgeraccount 2511 and credited on the vendor and at the same time I have a misc charge (25.00) on the line, that is debited on the Item and credited on ledgeraccount 2511. I get the following ledgerposting concerning Misc Charges: 2511 425.00 I expected the following concerning Misc Charges: 2511 450.00 2511 -25.00 When I look at the transaction origin I can see that there is posted 25.00 on the Items financial transaction. Can you explain? Thanks. Regards Irving Sharing the knowledge on Axapta. Yahoo! Groups Links -- Regards, Sun fen Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/cosFAA/kGEolB/TM ~- 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] SQL-Database setup
How do you setup Axapta 3.0 to run on a MSDE database? Regards Irving Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/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: How to remove the hard coded path form the code while reading the flat files
I have just made a quick import of some files, I have done it like this - hope it helps: If you don't want to hard code the path to your folder 'ReadFlatFiles' you have to create a parameter field where appropriate, lets say on table 'FlatFileTable', so the user or administrator are able to enter the path. For that you need to define a field on table FlatFileTable of type 'Filepath'. Create a form with the table FlatFileTable as datasource. Remember to create element method filePathLookupTitle: FilePath filePathLookupTitle() { return ; //This method is called from outside the form, from the formhelp on the EXDT } Now you have the filepath! Create a class with a method called 'readfile' void readfile(filename _filename) { boolean emptyFile = true; ; fileRead = this.OpenAsciiFile(_filename, R); ttsbegin; while(fileRead.status() == IO_Status::OK) { c = fileRead.read(); if (conlen(c)) { emptyFile = false; this.insertRecord(c); numberOfRecords++; } } if (emptyFile) { if (!this.warningFileEmpty()) throw error('@SYS62664'); } ttscommit; fileread = null; } AsciiIo openAsciiFile(FileName _filename,Str _mode) { AsciiIo FileOpen; ; FileOpen= new AsciiIo(_filename,_mode); if (FileOpen.status() != IO_Status::OK) { throw Error(@SYS19358+_filename); } FileOpen.inRecordDelimiter('\r\n'); FileOpen.inFieldDelimiter(';'); return FileOpen; } The method insertRecord() is where you transfer data from container to Axapta table(s). I know it works, but I admit I didn't use winapi - sorry :-) Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, gurazadasr [EMAIL PROTECTED] wrote: Hello, My requirement is to remove the hardcoded directory path from the code while reading an flat file in to the system and to read all the files which are contained in that particular folder for example if I have a folder by name 'ReadFlatFiles' which contains 10 flat files, I want to read all the files one by one without hardcoding the file name at the same time I should not specify any specific directory name like C:\\...or D:\\ i.e just by mentioning the folder name, I should able to read all the files contained in that folder. I heard that it can be done through WinAPI classes, but I am not sure whether it can be done through it or not also till now I did not work on those classes, if you have any sample code or any suggestions on WinAPI class or to solve the above problem are greately welcome. Regds SG Yahoo! Groups Sponsor ~-- Make a difference. Find and fund world-changing projects at GlobalGiving. http://us.click.yahoo.com/jy2rEC/PbOLAA/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: MST Round-off error in Invoice Approval Journal
Hi Sun Fen Thank you for your suggestion, but it didn't solve my problem. It's when I post general expence invoices in the Invoice Approval Journal, that I get a penny difference. Regards Irving --- In Axapta-Knowledge-Village@yahoogroups.com, Sun Fen Chen [EMAIL PROTECTED] wrote: Hi Irving, After you fetch the voucher (after fetching it will not balance), you have to click Function - Purchase order. When you post the Invoice approval journal, have you clicked Function - Purchase order in the Invoice journal line? This will post the purchase order invoice from Invoice journal. Regards, Sun Fen On 12/5/05, Irving [EMAIL PROTECTED] wrote: Dear All Thanks for the input, but I'm afraid it didn't solve my problem. The different account are set up correctly so I'm able to post penny differences. I can find round-off setup at GL/Setup/Exchange Rates, but I can't find any setup concerning secondary currency. Any input will be welcome, Thanks Regards koffidan --- In Axapta-Knowledge-Village@yahoogroups.com, Tarek Saleh [EMAIL PROTECTED] wrote: Dear Asrar The penny differances must have an account in GL befor setup its parameter thes account is located in the system accounts setup (GL\setup\posting\system accounts) and u should define a ledger account for thes penny differance system account befor setup the parameter, and about the folowing error you should check the vendor posting profile and the vendor setup for currency. Feed back after testing All the best Tarek saleh Asrar Ahamed [EMAIL PROTECTED] wrote: Hi, Set up penny difference field under GL/Parameters/Ledger. Thanks, Irving [EMAIL PROTECTED] wrote: I have posted an invoice in the Invoice Register Journal: Then I go to the Invoice Approval Journal and fetch the posted voucher/invoice. When I post the Invoice Approval Journal I get the following error message: Message (08:23:39) Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '0,01', amount MST '0,01', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '-25,25', amount MST '-25,25', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '13,88', amount MST '13,88', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7521', amount currency '11,38', amount MST '11,38', alternative amount '0,00', currency 'DKK', text '' Voucher 'god-00159', date '09-11-2005', account '7411', amount currency '-126,25', amount MST '-126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7412', amount currency '126,25', amount MST '126,25', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '7421', amount currency '-101,00', amount MST '-101,00', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3731', amount currency '55,50', amount MST '55,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '6321', amount currency '45,50', amount MST '45,50', alternative amount '0,00', currency 'DKK', text 'test' Voucher 'god-00159', date '09-11-2005', account '3781', amount currency '0,00', amount MST '-0,02', alternative amount '0,00', currency 'DKK', text 'Øredifferencer, Bilag god-0015' The transactions on voucher 'god-00159' do not balance as per '09- 11- 2005'. (Company currency: 0,00 - secondary currency: 0,00) Posting has been cancelled. I don't understand why I get this message, please help, thanks. Regards - To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. - Win a Yahoo! Vespa NEW - Yahoo! Cars has 3 Vespa LX125s to be won Enter Now! Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Tarek Abd_Elhalim - Yahoo! DSL Something to write home about. Just $16.99/mo. or less Sharing the knowledge on Axapta. Yahoo! Groups Links -- Regards, Sun fen Yahoo! Groups Sponsor
[Axapta-Knowledge-Village] Update datasource from Class
Hi When updating vendor invoices from the invoicepool form, you click the button 'Purchase order' and you get the Posting Invoice form (PurchEditLines). I would like to update all lines (datasource PurchParmLines) from a class. So far I have done the following in Main: PurchParmLine purchParmLine; FormDataSourcepurchParmLine_ds; int i = 0; ; purchParmLine = _args.record(); if (purchParmLine.dataSource()) purchParmLine_ds = purchParmLine.dataSource(); for (purchParmLine = purchParmLine_ds.getFirst(true) ? purchParmLine_ds.getFirst(true): purchParmLine_ds.cursor);purchParmLine; purchParmLine = purchParmLine_ds.getnext()) { // Some processing i++; } On the menuitem used on the form PurchEditLines, I have set the property MultiSelect to Yes. On the invoice I'm trying to update, I have two purchase lines, but my counter only counts to one because it's only the record the cursor is standing on that I find. How can I get access to all the lines? Regards irving Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/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/
Re: RE : [Axapta-Knowledge-Village] Update datasource from Class
Thank you SO much - it worked :-D Regards irving --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert [EMAIL PROTECTED] wrote: Remove the parameter true in your call to getFirst(). With true you're asking for only the _selected_ lines. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] De la part de Irving Envoyé : 5 décembre 2005 09:55 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Update datasource from Class Hi When updating vendor invoices from the invoicepool form, you click the button 'Purchase order' and you get the Posting Invoice form (PurchEditLines). I would like to update all lines (datasource PurchParmLines) from a class. So far I have done the following in Main: PurchParmLine purchParmLine; FormDataSourcepurchParmLine_ds; int i = 0; ; purchParmLine = _args.record(); if (purchParmLine.dataSource()) purchParmLine_ds = purchParmLine.dataSource(); for (purchParmLine = purchParmLine_ds.getFirst(true) ? purchParmLine_ds.getFirst(true): purchParmLine_ds.cursor);purchParmLine; purchParmLine = purchParmLine_ds.getnext()) { // Some processing i++; } On the menuitem used on the form PurchEditLines, I have set the property MultiSelect to Yes. On the invoice I'm trying to update, I have two purchase lines, but my counter only counts to one because it's only the record the cursor is standing on that I find. How can I get access to all the lines? Regards irving Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/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] Purchase Invoice amount round-off
Hi I got a customer, which receives purchase invoices where the VAT amount or Invoice amount has been rounded off, Ex. Purchase Invoice Amount = 3187.50 Purchase VAT amount = 637.50 But the actual invoice from the vendor is saying Purchase Invoice Amount = 3188.00 Purchase VAT amount = 638.00 The custemer use the invoice register journal when they receives invoices and for Purchase Orders they use the Invoice Pool to update the Invoice. In the Invoice Pool they now have a problem because the posted invoice says: Purchase Invoice Amount = 3188.00 and the Axapta Purchase Order says Purchase Invoice Amount = 3187.50. Are you suppose to use the round-off field on the total-form no matter if the round-off is on the VAT or on the Invoice Amount? How does this influence the cost prices for the items on the Purchase Order? Do you have another suggestion on how to solve this? Any help is welcome, thanks! Regards Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/F9LvrA/dlQLAA/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] XML
Hi Do you have a good idea about how to get started with XML concerning import or export of XML documents to Axapta? If you do, please let me know. Thank you in advance! Regards Koffidan 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] Form date-lookup control results in error
In SalesTable I have a date field 'Delivery Date'. Whenever the user changes the date, I have to update a new logtable If the user agrees to that. Modified på control 'SalesTable_DeliveryDate': public boolean modified() boolean ret; SalesLine salesLine; ; ret = super(); if (ret) { if (Box::okCancel(Skal leveringsdato rettes på alle linier, DialogButton::Ok) == DialogButton::Ok) { ttsbegin; while select forupdate salesline where salesline.SalesId == SalesTable.SalesId { salesLine.ConfirmedDlv = SalesTable.DeliveryDate; salesLine.update(); newLogTable::CreateLogRecord(); } ttscommit; } } return ret; Whenever I use the lookup control, it runs the method modified twice, and thereby generates two log records. If I enter a new date manually using my keyboard, it runs the method modified one time and thereby generates one log record. How do I solve this problem? I only want one log record no matter how I enter the new date. Regards Irving Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/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/
Re: RE : [Axapta-Knowledge-Village] Std filter records on form transferred to functionality
Thanks steve, but I did try that. I have tried to transfer the data (args.record(tablename)) to class, and then step through them using getfirst and getnext, but it's only when I manually mark the records that it works. The customer wants to be able to filter records (ctrl + F3), and then nothing more than push the button - they might have more than 100 records plus the want to save time. And since Axapta are able to filter the records, the used selection must be attainable. I have also tried to transfer datasource query and queryrun. The query gives me all records in the form, it doesn't filter the records. The queryrun only gives an output depending on which record the cursor is standing on. I hope someone have some idea. Regards Irving --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: I don't know how to get that filter but what I would do in that case is use getFirst and getNext method on the FormDataSource to browse the selected record. Maybe that will help you. Regards, Steeve... -Message d'origine- De : Irving [mailto:[EMAIL PROTECTED] Envoyé : 22 octobre 2004 09:26 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] Std filter records on form transferred to functionality Hi The user are able to used Axapta standard 'Filter records ctrl + F3' in the invoice pool or any other journal. Now I want to transfer the filter to a function where I auto approve records. In the auto approve function I want to use the filter to select the records, I'm going to approve. Are you able to help me? Regards Irving Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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] Std filter records on form transferred to functionality
Hi The user are able to used Axapta standard 'Filter records ctrl + F3' in the invoice pool or any other journal. Now I want to transfer the filter to a function where I auto approve records. In the auto approve function I want to use the filter to select the records, I'm going to approve. Are you able to help me? Regards Irving Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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] Printing several pages of text in one field
Hi First, thank you for the help I have received so far! Now, I'm printing af report with two fields. One of the fields is a description (memo) of documentation needed to an item. This description can easily be two-three pages of text. Now, I calculate the height of the field, I can see some of it on the screen, nothing comes out when I print it but it I save the report in a file on the harddisk then I get all the text. Sadly, the customer wants to print the report. Do anyone have an idea? Regards Irving Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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] Move system messages
Hi When you are running Axapta, you will get different kinds of prompts and boxes with warnings, questions or the like - system messages. Those messages are always in the center of the screen. I have to run Axapta on a very small screen, so it will be good if I could move those messages so they would appear where I tell them to appear. Do you know how to move a message? Regards Irving Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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/