RE: [Axapta-Knowledge-Village] Re: Start batch-job automatically
I wish there was, that was provided by our product support Sorry Rocco From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of taulbert2000Sent: Friday, 11 November 2005 4:03 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Re: Start batch-job automatically Hi Rocco,Thanks, that works fine.But an other question: Is there any documentation about those startup-commands? Perhaps there are more commands which could be useful for us or anybody else in the group?Tom--- In Axapta-Knowledge-Village@yahoogroups.com, "taulbert2000" <[EMAIL PROTECTED]> wrote:>> Hi group,> I'm looking for a way to automatically start an existing batch-job in > Axapta 3.0 every time, when the server restarts. Any ideas?> Tom> Sharing the knowledge on Axapta. 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.
RE: [Axapta-Knowledge-Village] Start batch-job automatically
C:\old\Axapta\Client\Bin\ax32.exe -startupcmd=BATCH_service place this in the shortcut place the shortcut in the startup Getting past the server logon was the only problem which I never overcame..but as soon as it did it loaded axapta and the batching program Good Luck Rocco From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of taulbert2000Sent: Thursday, 10 November 2005 5:04 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Start batch-job automatically Hi group,I'm looking for a way to automatically start an existing batch-job in Axapta 3.0 every time, when the server restarts. Any ideas?Tom 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.
RE: [Axapta-Knowledge-Village] Web Radio Buttons
Yes, Thankyou that is great, But I am still stuck To get the selected Value, do I put this webradiobuttonname.selection() in a method in the design field or on the datasource. What saves the selection to the Database?, also I have only three enums to select from and the Portal Page Shows four, unsure where the fourth one comes from and what it was for. Rocco From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paulius CerniauskasSent: Thursday, 10 November 2005 2:34 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Web Radio Buttons Create BaseEnum, set it's style to Radio BUtton.Add radiobutton web control to your web form andspecify enum you just crated.set this web control AutoDecalration to Yes.Get the selected value:WebRadioButtonName.selection(). --- Rocco Giumelli <[EMAIL PROTECTED]> wrote:> Hi all> > Does anyone know what the trick is in getting the> webradio button to work in> the Axapta web portal?> > Thanks in advance.> > > Rocco Giumelli> > Rocco Giumelli> > IT Manager> > Metric Australia Pty Ltd> > 15 Roberts Street> > Bellevue WA 6056> > > > One Company One Solution> > Ph: 08 9374 5331 Fax: 08 9374 5333> > > > CONFIDENTIALITY NOTICE> > This electronic communication (including any> attachments) is intended only> for use by the named addressee(s) and may contain> legally privileged and/or> confidential information. If you are not the> intended recipient of this> electronic communication, you are put on notice that> any dissemination,> distribution, copying or use of the information> contained in this electronic> communication (including any attachments) is> strictly prohibited. If you> have received this electronic communication in> error, please immediately> notify me by return electronic communication and> permanently delete the> original, any copies and any print-outs of this> electronic communication.> > > > Metric Australia Pty Ltd is not responsible for any> changes made to an> electronic communication (including any attachments)> other than those made> by Metric Australia Pty Ltd.> > > > > > Paulius CerniauskasPhone: +37062049339ICQ: 280959446 __ Yahoo! FareChase: Search multiple travel sites in one click.http://farechase.yahoo.com Sharing the knowledge on Axapta. 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.
[Axapta-Knowledge-Village] Web Radio Buttons
Hi all Does anyone know what the trick is in getting the webradio button to work in the Axapta web portal? Thanks in advance. Rocco Giumelli Rocco Giumelli IT Manager Metric Australia Pty Ltd 15 Roberts Street Bellevue WA 6056 One Company One Solution Ph: 08 9374 5331 Fax: 08 9374 5333 CONFIDENTIALITY NOTICE This electronic communication (including any attachments) is intended only for use by the named addressee(s) and may contain legally privileged and/or confidential information. If you are not the intended recipient of this electronic communication, you are put on notice that any dissemination, distribution, copying or use of the information contained in this electronic communication (including any attachments) is strictly prohibited. If you have received this electronic communication in error, please immediately notify me by return electronic communication and permanently delete the original, any copies and any print-outs of this electronic communication. Metric Australia Pty Ltd is not responsible for any changes made to an electronic communication (including any attachments) other than those made by Metric Australia Pty Ltd. 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.
[Axapta-Knowledge-Village] Hand Signing teh Web Portal on a PDA POCKET PC
Previously Posted Hi All I am trying to create a webform that will accept a hand signature on a PDA Device using the stylus (Receive the client hand signature on-site). So I have guess that either it uses a field like a container to contain an image in the field on the record which can be written to the database, or open a word document which is loaded like a report than the container field is an image which can be edited by the PDA Stylus . Or it will use _javascript_ to accept the signature and than send it to the wright spot on the database. Please , if anyone can point me in the wright direction including outsourcing this issue we are interested. Rocco Giumelli Rocco Giumelli IT Manager/Payroll Officer Metric Australia Pty Ltd 15 Roberts Street Bellevue WA 6056 One Company One Solution Ph: 08 9374 5331 Fax: 08 9374 5333 CONFIDENTIALITY NOTICE This electronic communication (including any attachments) is intended only for use by the named addressee(s) and may contain legally privileged and/or confidential information. If you are not the intended recipient of this electronic communication, you are put on notice that any dissemination, distribution, copying or use of the information contained in this electronic communication (including any attachments) is strictly prohibited. If you have received this electronic communication in error, please immediately notify me by return electronic communication and permanently delete the original, any copies and any print-outs of this electronic communication. Metric Australia Pty Ltd is not responsible for any changes made to an electronic communication (including any attachments) other than those made by Metric Australia Pty Ltd. 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.
[Axapta-Knowledge-Village] Hand Signing teh Web Portal on a PDA POCKET PC
Hi All I am trying to create a webform that will accept a signature on a PDA Device using the stylus(Receive the client signature on-site). So I have guess that either it uses a field like a container to contain an image in the field on the record which can be written to, or open a word document which is loaded like a report than the container field is an image which can be edited by the PDA Stylus . Please Help Rocco 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.
RE: [Axapta-Knowledge-Village]
Hi Harry yes I see, The temp table will than be there so the List is free from the large Inventtable (Essentially lookup once than select from temp table) I can create the Table with only the items that apply to one Employee's warehouse only (Blokes in Vans Each van is a Warehouse in our system), and then the lookup that up on a reduced table that i will than in turn use for the Inventid lookup, with itemid, description and Onhand Value. I Think I understand Do you have an example of how we could do this Thankyou harry Rocco From: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 April 2005 5:18 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] hi time from brain storming. How about create a tmpInventTable... Fill up this table when the form is loaded or first lookup is made ...use item id from this table for look up and then select the row from normal inventtable on the basis of item id from tmpInventTable huh? regards harry Rocco Giumelli <[EMAIL PROTECTED]> wrote: Hi Frank/Harry Yes, I have, it did help the speed a little. I guess I am Trying to say is that can a Lookup Method cache the details (Itemtable) so it does not try to load the same lookup on every line of the web form as they enter it. Rocco From: Frank Werner-Vohrer [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 1:47 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Hi Rocco, have you looked whether it is a server based method or a client? A serverbased should be quicker. FrankRocco Giumelli <[EMAIL PROTECTED]> wrote: Hi All I am in the middle developing a Web portal PDA for our service personel on the road. When I put in the Itemid on the Web Form, the default lookup for the item table, is very slow on the PDA device, but on the internet browser (On the PC) it seems much quicker. When I Remove the Itemid field from the web form the PDA returns to an acceptable speed. My guess is that it is trying to load the whole item table on every line of the web form as it refreshes or adds a new line Does anyone know of a way so I can keep the lookup functionality, but maintain the speed on the PDA Device Thanks in Advance Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 Sharing the knowledge on Axapta. Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village]
Hi Varden I guess you mean the property call caschelookup on the item table. have down, it seems a Little Quicker now, I think that and what harry had to say about creating a Temp Table and load from there.. Thanks Friend From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 April 2005 2:41 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Rocco You can look at the CacheLookup property on the table. It is not recommended to cache tables that are frequently updated but since the inventory table should be fairly static you may consider do this by setting the property appropriately. Varden Morris J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 - 5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Rocco Giumelli <[EMAIL PROTECTED]> wrote: Hi Frank/Harry Yes, I have, it did help the speed a little. I guess I am Trying to say is that can a Lookup Method cache the details (Itemtable) so it does not try to load the same lookup on every line of the web form as they enter it. Rocco From: Frank Werner-Vohrer [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 1:47 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Hi Rocco, have you looked whether it is a server based method or a client? A serverbased should be quicker. FrankRocco Giumelli <[EMAIL PROTECTED]> wrote: Hi All I am in the middle developing a Web portal PDA for our service personel on the road. When I put in the Itemid on the Web Form, the default lookup for the item table, is very slow on the PDA device, but on the internet browser (On the PC) it seems much quicker. When I Remove the Itemid field from the web form the PDA returns to an acceptable speed. My guess is that it is trying to load the whole item table on every line of the web form as it refreshes or adds a new line Does anyone know of a way so I can keep the lookup functionality, but maintain the speed on the PDA Device Thanks in Advance Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 Sharing the knowledge on Axapta. Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! MessengerShow us what our next emoticon should look like. Join the fun. Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village]
Hi Frank/Harry Yes, I have, it did help the speed a little. I guess I am Trying to say is that can a Lookup Method cache the details (Itemtable) so it does not try to load the same lookup on every line of the web form as they enter it. Rocco From: Frank Werner-Vohrer [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 1:47 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Hi Rocco, have you looked whether it is a server based method or a client? A serverbased should be quicker. FrankRocco Giumelli <[EMAIL PROTECTED]> wrote: Hi All I am in the middle developing a Web portal PDA for our service personel on the road. When I put in the Itemid on the Web Form, the default lookup for the item table, is very slow on the PDA device, but on the internet browser (On the PC) it seems much quicker. When I Remove the Itemid field from the web form the PDA returns to an acceptable speed. My guess is that it is trying to load the whole item table on every line of the web form as it refreshes or adds a new line Does anyone know of a way so I can keep the lookup functionality, but maintain the speed on the PDA Device Thanks in Advance Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 Sharing the knowledge on Axapta. Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village]
Hi All I am in the middle developing a Web portal PDA for our service personel on the road. When I put in the Itemid on the Web Form, the default lookup for the item table, is very slow on the PDA device, but on the internet browser (On the PC) it seems much quicker. When I Remove the Itemid field from the web form the PDA returns to an acceptable speed. My guess is that it is trying to load the whole item table on every line of the web form as it refreshes or adds a new line Does anyone know of a way so I can keep the lookup functionality, but maintain the speed on the PDA Device Thanks in Advance Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 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 the Yahoo! Terms of Service. <>
RE: [Axapta-Knowledge-Village] Country-Specific
We are using it in Australia From: taulbert2000 [mailto:[EMAIL PROTECTED] Sent: Wednesday, 23 March 2005 9:13 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Country-Specific Hi group,does anybody know, for which countries Axapta 3.0 is available?Thanks,TomSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Negative Inventory
I glad to see that inventory is a issue for all. We started with negative inventory and this allowed all transactions to post easily.. But where is the control. What is your True Inventory Value? Who would know. Now the Negative is unticked and people are doing their jobs properly and the slow and painful learning cycle begins. I guess, your company needs to have spare time to solve the inventory issues as they occur. Rocco My 0.02c From: frodnew57 [mailto:[EMAIL PROTECTED] Sent: Saturday, 12 March 2005 1:43 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Re: Negative Inventory Russell wrote:> > ... We are engaged in a debate in whether or not to implement the system allowing inventory to go negative. I am not a fan of this setup. > > Does anyone have any thoughts of whether this is advisable, or under what conditions this should be considered?>I would agree that in a perfect world the inventory should never go negative. Unfortunately, at every company I have worked with, the world has not been perfect, so allowing negative inventories was necessary. I look at this way: If due to unknown errors by unknown employees the inventory is wrong, do you want the system to stop employee X from trying to correctly perform his job because the system believes he is creating an error causing the inventory to go negative. Often times this employee is not in a position to correct or troubleshoot the error anyway. My $.02. BruceSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?
Thanks Guys
It seems that I am not left with many
choices
I will see if microsoft will bend the rules because of the
misinformation by it's own MBS Partner. Wish me Luck
Rocco
From: Varden Morris
[mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 March 2005 7:16
PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re:
[Axapta-Knowledge-Village] how to minimize blocking on axapta
?
That is right, Standard Edition is limited to 2Gb of memeory and cannot
take advantage of AWE. You can check this site for more info:
http://www.microsoft.com/sql/evaluation/overview/default.asp
VardenSAS <[EMAIL PROTECTED]> wrote:
Dear Rocco ,
As far as I know AWE memory only possible
on SQL 2000 Enterprise edition .
- Original Message -
From:
Rocco
Giumelli
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, March 08, 2005 10:46
AM
Subject: RE: [Axapta-Knowledge-Village]
how to minimize blocking on axapta ?
Hi Varden/SAS
Can you explain 'We already enabled AWE
Memory'.
When we deployed Axapta no mention by our MBS
Partner was given to the type of SQL we needed to own, We Purchased
SQL Standard Edition, and of Late I discovered that this version is not able
to Handle 3Gb of RAM. There is also no upgrade path from Standard to
Enterprise.
Before I get the boss to spend more cash on this SQL
Upgrade, do you know of any way to get SQL to use 3GB of RAM on the Standard
Edition.
ps. Also any Tips on Table
Indexing.
Rocco
From: Varden Morris
[mailto:[EMAIL PROTECTED] Sent: Monday, 7 March 2005 7:15
PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject:
Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta
?
Hi Sas,
Please let us know the cause of your problem when you look at the
code.
SAS <[EMAIL PROTECTED]> wrote:
Dear Verden ,
In my opinion , as long as the disk
performance is not bottle neck ( ex. Avg disk queue
lenght <= 2 X number disk ) it is not necessary to modify
raid configuration.
for memory , we already enabled AWE memory
.
thx
sas
- Original Message -
From:
Varden
Morris
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Saturday, March 05, 2005 1:24
AM
Subject: Re:
[Axapta-Knowledge-Village] how to minimize blocking on axapta ?
Hi Sas
The hardware
looks good to me, away from the RAID 5 for the database. RAID 5 does not
give good performance for writing since it involves the calculation of
parity. I made a mistake in my first email to you. We do not use RAID 15
but RAID 10. RAID 15 also involves parity. It is a combination of RAID
10 and RAID 5. RAID 10 is a combination of RAID 1 (mirror) and RAID 0
(striped). You
only use 50% of your storage but you get good performance for
writing.
Did you configure windows
and SQL to see 3G of memory and over? There are some tools that you can
use to find the exact problem. They are costly but they work. Spotlight
for SQL and windows work well. It shows up all the flaws. Our consultant
used it to solve our problems and we are currently in the process of
purchasing the software. Sometimes the log file disk could be running
out of space and you dont know and this slows down the entire system.
The problems are endless and many.
The code could very well be
a problem too. Have you done a lot of customization? If this is the case
you may have code that is inefficient.
SAS <[EMAIL PROTECTED]>
wrote:
Dear Verden,
my Hadrware configuration , Database
server , 4 Proccessor 3.0 Ghz , 8 GB RAM , Quorum : 2 Disk raid
1, Tempdb 2 Disk raid 1 , database 7 Disk Raid 5 , all disk are
Fibre channel 2 Gb disk 15K rpm . For application server 2
Proccessor 3.0 Ghz , 2 GB RAM .Concurent user 70
users .
I tought my hardware configuration are
enough , So I suspect it's bacuse our coding .
my experience tuning hardware ,
OS and SQL server only give 10% improvement, table indexing
also improve the performance . and now we are investigating our
coding.
thx
sas
- Original Message -
From:
Varden
Morris
To: Axapta-Knowledge-Village@yahoogroups.com
RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?
Hi Varden/SAS Can you explain 'We already enabled AWE Memory'. When we deployed Axapta no mention by our MBS Partner was given to the type of SQL we needed to own, We Purchased SQL Standard Edition, and of Late I discovered that this version is not able to Handle 3Gb of RAM. There is also no upgrade path from Standard to Enterprise. Before I get the boss to spend more cash on this SQL Upgrade, do you know of any way to get SQL to use 3GB of RAM on the Standard Edition. ps. Also any Tips on Table Indexing. Rocco From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Monday, 7 March 2005 7:15 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Sas, Please let us know the cause of your problem when you look at the code. SAS <[EMAIL PROTECTED]> wrote: Dear Verden , In my opinion , as long as the disk performance is not bottle neck ( ex. Avg disk queue lenght <= 2 X number disk ) it is not necessary to modify raid configuration. for memory , we already enabled AWE memory . thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, March 05, 2005 1:24 AM Subject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Sas The hardware looks good to me, away from the RAID 5 for the database. RAID 5 does not give good performance for writing since it involves the calculation of parity. I made a mistake in my first email to you. We do not use RAID 15 but RAID 10. RAID 15 also involves parity. It is a combination of RAID 10 and RAID 5. RAID 10 is a combination of RAID 1 (mirror) and RAID 0 (striped). You only use 50% of your storage but you get good performance for writing. Did you configure windows and SQL to see 3G of memory and over? There are some tools that you can use to find the exact problem. They are costly but they work. Spotlight for SQL and windows work well. It shows up all the flaws. Our consultant used it to solve our problems and we are currently in the process of purchasing the software. Sometimes the log file disk could be running out of space and you dont know and this slows down the entire system. The problems are endless and many. The code could very well be a problem too. Have you done a lot of customization? If this is the case you may have code that is inefficient. SAS <[EMAIL PROTECTED]> wrote: Dear Verden, my Hadrware configuration , Database server , 4 Proccessor 3.0 Ghz , 8 GB RAM , Quorum : 2 Disk raid 1, Tempdb 2 Disk raid 1 , database 7 Disk Raid 5 , all disk are Fibre channel 2 Gb disk 15K rpm . For application server 2 Proccessor 3.0 Ghz , 2 GB RAM .Concurent user 70 users . I tought my hardware configuration are enough , So I suspect it's bacuse our coding . my experience tuning hardware , OS and SQL server only give 10% improvement, table indexing also improve the performance . and now we are investigating our coding. thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 04, 2005 12:58 AM Subject: RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Rocco If disk queue and swapping are acceptable for the object server during peak periods this should be an indication that the object server(s) is ok. We had 1G of memory and two Pentium III processors in two object servers. The disk queue was high as a result of the processors not being able to adequately manage the requests from the clients. Also, there was a lot of swapping resulting from the memory not being enough. For some reason this resulted in the database locking up.Rocco Giumelli <[EMAIL PROTECTED]> wrote: Hi Varden Can I ask, We have recently upgraded our SQL Server, But the application server we didn't becasue when I look at the task manager the machine does not do much, system idle is running 90% + , and the Networkwork interface runs at less than 10% on 100 link most of the time. Has Scsi Hard Drive. It indicates to me that an upgrade is not needed.. Would you agree? Rocco From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 March 2005 7:59 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject:
RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?
Hi Varden Can I ask, We have recently upgraded our SQL Server, But the application server we didn't becasue when I look at the task manager the machine does not do much, system idle is running 90% + , and the Networkwork interface runs at less than 10% on 100 link most of the time. Has Scsi Hard Drive. It indicates to me that an upgrade is not needed.. Would you agree? Rocco From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 March 2005 7:59 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? The two main things I know can affect blocking are hardware and code. I have experienced major blocking as a result of hardware. I understand the technical concept involved but I do not have all the details at hand. You can use one server as the application and database server but this may not be ideal for your situation. The best configuration for top performance is at least one database server with a SAN unit for the data and an application server that may also be the object server if you are going 3-Tier. You may optionally use a different server for the object server. One object server should be adequate for up to one hundred users. Over that you may use two in load balancing mode. Now blocking can be a result of the existence of a bottle neck with your hardware. The client in a 2-tier configuration and the object server in a 3-tier configuration constantly make requests to your database sever that include reading and writing of data. The communication link between the client/object server in such a situation needs to be high speed (I believe fiber may be the best medium). In addition to this the internal speed of the disks (you also have fiber disks) it also important. When requests are made to the database server the disks need to be able to process the requests as fast as possible otherwise one request may be waiting on another to be completed which results in blocking. Several of this may occur that lead to severe blocking. The storage unit for the database should also be a combination of RAID 10 and RAID 15. RAID 10 is just striping while RAID 15 is a mirror of a RAID 10. Since the data files are very important you should but then on the RAID 15 and since the temp database and log files are not so critical you should put them on RAID 10. This will speed up the read/write process for the database and thus reduce blocking. RAID 5 saves you space but it is not ideal for read/write intensive operations since the process involves parity calculation. The technology of the quad processor is advanced and can help in a big way. I do not know the details about this but I know it works. If the specification of the application sever is not good enough this can also lead to blocking. I have personal experience where the database server was upgraded and the blocking was still the same. After upgrading the application server there was a major difference. You must always have enough memory in your servers to ensure that there is not much caching. When you have over 3G of memory you need to enable windows to use it. You also need to enable Microsoft SQL to use over 3G (if you are using MSSQL). The last thing is coding. You should ensure that transactions in the application are short. This means ensuring that you use tts.begin and tts.commit or tts.rollback in very short blocks of code where it is necessary. Otherwise tables/records may be locked in a waiting transaction that results in major blocking. Hope this will be of some help to you. Varden Morris J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 - 5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED]SAS <[EMAIL PROTECTED]> wrote: Dear all,Do you have any experience how to minimize blocking on axapta ?would you mind sahring your experience,thxsasSharing the knowledge on Axapta. Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: AW: [Axapta-Knowledge-Village] reporting tools and Axapta
Well thankyou for your response, it seems no matter what the volume of business, we have to always get up in the middle of the night to fix something, or do something that the computers should do for us. Subuu, Are you P&L's expressing the view of profit from the G/L perspective using the Axapta Dimensions (3), and than broken down by transaction type, Hour, Item,Cost, and their Categories Group Types. Or is income derived through the Sales Orders using Item Numbers to derive the balance of your dimensions with the item's Item group,Manufacture, and any others you have added. I thought MS OLAP Analysis server that came with SQL Server provided a good way to get the dimensions back to a level where the data was easily spilt. Create a XL = Excel Spreadsheet and plug that back into the OLAP Cube with a Pivot Table The data you would want to see is preset into the Pivot Table and This Prints Nicely and refreshes easily ( so long as it is connected to the source (lan,wan,citrix) and is specific enough to keep many Excel links or worksheets to various financial/Project info you need to present. Back to realty, The volume of your problem shows me that Maintenance is a problem we both have. Rocco From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Sunday, 27 February 2005 2:18 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: AW: [Axapta-Knowledge-Village] reporting tools and Axapta Hi Rocco, We didn't buy Axapta OLAP for our reporting. Let me briefly give me my project scenarios. We had to develope P&L reports in Various currencies. The problem with the format of the P:&L is , some of the rows in the P&L had to be shown by Cost center /department wise while someoter rows direct account wise. And as you know Axapta can not handle multi dimensional financial reporting. Hence we opted for Targit. Waht happens is : Targit also can not handle multi dimensiona reporting if it uses Axapta database. The problem is not with the Targit. Its the problem with Axapta. Why because, TARGIT database is directly coupled with Axapta Live database so are the tables are mapped to directly with Targit tables. So we run the DTS packae to refresh the TARGIT data base so that it will fetch the data as in Axapta at the aprticular point of time. It lead to enough maintenace. Like suddenly they used to post some entries and they would like to see asap. Then I wake at the midnight, and refresh the Targit EM in order to show the latest data. Hence I created those reports in Axapta using some temp tables etc etc.. Now we are using targit only for sales reporting. Because sales data we get from XL files from outside the company. Hence we upload those data ( getting rid of Axapta tables ) in to self created tables in Targit. Hence we can show reports like anyway we wanted as its not using axapta database ( or the mapped to axapta tables ). Shipement history by location,by customer, by product , bar,pie etc tec etc etc... Numerous cubes and dimesions have been created to show the reports in various dimesions for these data which came from XL. Presently, we are uploading approximately 10M records in the sales/shipment history. The performance is good. I would say, it depends upon ur reports formats( financial ). If the reports are half single dimesional and half the report is multiple dimesional, its not Possible in targit if they are connected to axapta DB. but if you want two seperate reports, with one report single dimesional and the other report mutli dimesional, its possible in targit. But in the same report, with mixed dimensional its not possible. we have to manually created hundres of calculations which slows the targit perofrmance . its very cumbersome to make any changes to that type of reports. I am not very sure if I have answered your Q . but if you need anymore clarifiacations, please contact me as we are using Targit since 6 months. And we know what Targit can do also. Thanks & Regards, subbu Rocco Giumelli <[EMAIL PROTECTED]> wrote: Hi Subbu Do you like the OLAP that is within Axapta or a SQL Bolt-on ? Multi dimension is critical in our workplace. My major concern is that Axapta Internal OLAP will slow everything else down while it builds the cubes or does anything quick and easy for the boss.. Can you explain 'can't handle multiple dimensional financial reports' like Branch & Department & Purpose , or do you mean more than that. Thankyou for taking the time to express an opinion. Rocco From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Saturday, 26 February 2005 1:52 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: AW: [Axapta-Knowledge-Village] reporting tools and Axapta We are currently using TARGIT ( denmark ). Its good for Sales shipment/Sa
[Axapta-Knowledge-Village]
Hi All. I was Switching servers from a Play to a live and in the live environment When I access the webpage link I get this after logon AxaptaCOMConnector.Axapta.1 error '80042041' Error executing code: object not initialised. Stack trace: \Classes\\itemTxt \Classes\WebSession\ParseArgs - line 109 Error executing code: object not initialised. Stack trace: \Classes\\itemTxt \Classes\WebSession\ParseArgs - line 109 /enterpriseportal/i_axapta.asp, line 4 I have tried to revert all things associated back to sys layer, But no Good,Any Help please ! Rocco Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: AW: [Axapta-Knowledge-Village] reporting tools and Axapta
Hi Subbu
Do you like the OLAP that is within Axapta or a SQL Bolt-on
? Multi dimension is critical in our workplace.
My major concern is that Axapta Internal OLAP will slow
everything else down while it builds the cubes or does anything quick and easy
for the boss.. Can you explain 'can't handle multiple dimensional financial reports' like Branch &
Department & Purpose , or do you mean more than
that.
Thankyou for taking the time to express an
opinion.
Rocco
From: Subrahmanyam Mamidi
[mailto:[EMAIL PROTECTED] Sent: Saturday, 26 February 2005 1:52
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re:
AW: [Axapta-Knowledge-Village] reporting tools and Axapta
We are currently using TARGIT ( denmark ). Its good for Sales
shipment/Sales related stuff. But I prefer Axapta for Financial reports.but hey,
TARGIT can't handle multiple dimensional financial reports..
best of luck.
regards,
subbu"Leberbauer, Herbert - News"
<[EMAIL PROTECTED]> wrote:
Hi Willem!
Maybe it was already mentionend, but did you take a look
at Business Analytics (BA) from Targit? They have some cubes for Axapta,
and it doesn't touch Axapta too. It only connects to the DB where Axapta is
located and transfers the data to its own DB (which is MS SQL). But there are
DTS possibilities in SQL Server getting data from Oracle, so this should be no
problem.
On the other side until now we have BA only
implemented with MS SQL (both for Axapta, and BA). But the response from our
customers is very good.
I'm also interested on how you'll solve this
situation.
regards
Herbert
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Gesendet: Freitag, 25.
Februar 2005 15:52An:
Axapta-Knowledge-Village@yahoogroups.comBetreff: RE:
[Axapta-Knowledge-Village] reporting tools and Axapta
Yes, I mean 15,000,000 records, our
financial guys are spoiled and are registering everything. I will post a solution, hopefully i will find someone
very soon, I am looking since 6 months for one.
"Rocco Giumelli"
<[EMAIL PROTECTED]>
25/02/2005 15:42
Please respond
toAxapta-Knowledge-Village@yahoogroups.com
To
cc
Subject
RE:
[Axapta-Knowledge-Village] reporting tools and
Axapta
Does mio Mean 15,000,000 Records
I Lose
performance after 100,000 and You have to be smart with the design , which I
am sure you are, otherwise it falls over (Mircosoft our friends), Incude
Cubes with Filters to reduce Unneccessary Data Out of my
league Please put a post on how you went , I was think of buying it for
Axapta Good Luck
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Friday, 25 February
2005 10:41 PMTo:
Axapta-Knowledge-Village@yahoogroups.comSubject: RE:
[Axapta-Knowledge-Village] reporting tools and AxaptaHello, Small problem, Rocco, we
are working on Oracle. We installed SQL Analysis server but the performance is not good
enough. Certain
tables contain more then 15 mio records ...
Kind regards,
Willem
"Rocco Giumelli"
<[EMAIL PROTECTED]>
25/02/2005 15:32
Please respond
toAxapta-Knowledge-Village@yahoogroups.com
To
cc
Subject
RE:
[Axapta-Knowledge-Village] reporting tools and
Axapta
I Gather you
bought the Licences. It Would be interesting to see how you
went. I did it on the cheap by Installing the Sql Analysis server into
your SQL Server and Use Excell Spreadsheets to Make them Pretty for the
bosses. Rocco
From: willem_baelde
[mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005
10:28 PMTo:
Axapta-Knowledge-Village@yahoogroups.comSubject:
[Axapta-Knowledge-Village] reporting tools and AxaptaHello,has someone
experience with a reporting tool or cube on Axapta ?Can someone
recommend one ? kind regards,Willem
BaeldeSharing
the knowledge on Axapta.
Do you Yahoo!?Yahoo!
Mail - Helps protect y
RE: [Axapta-Knowledge-Village] reporting tools and Axapta
Now you have my curiosity..
Our Accountants Bought Vision which is really Quick to
calculate and meant for the accountants as it populates excel spreadsheets
easily, Again with the cleaver Design.
It is Not a Cube, any Help ??
Vision Product Support
Consultant
Direct: +61 (0)8 9213 3840
Australasia and EMEA: [EMAIL PROTECTED]
Americas: [EMAIL PROTECTED]
Thanks
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005
10:52 PMTo:
Axapta-Knowledge-Village@yahoogroups.comSubject: RE:
[Axapta-Knowledge-Village] reporting tools and Axapta
Yes, I mean 15,000,000 records, our
financial guys are spoiled and are registering everything. I will post a solution, hopefully i will find someone very
soon, I am looking since 6 months for one.
"Rocco Giumelli"
<[EMAIL PROTECTED]>
25/02/2005 15:42
Please respond
toAxapta-Knowledge-Village@yahoogroups.com
To
cc
Subject
RE:
[Axapta-Knowledge-Village] reporting tools and
Axapta
Does mio Mean 15,000,000 Records I Lose performance
after 100,000 and You have to be smart with the design , which I am sure you
are, otherwise it falls over (Mircosoft our friends), Incude Cubes with Filters
to reduce Unneccessary Data Out of my league Please put a post on
how you went , I was think of buying it for Axapta Good Luck
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005
10:41 PMTo:
Axapta-Knowledge-Village@yahoogroups.comSubject: RE:
[Axapta-Knowledge-Village] reporting tools and AxaptaHello,
Small problem, Rocco, we are working on
Oracle. We installed
SQL Analysis server but the performance is not good enough.
Certain tables contain more then 15 mio
records ... Kind
regards, Willem
"Rocco Giumelli"
<[EMAIL PROTECTED]>
25/02/2005 15:32
Please respond
toAxapta-Knowledge-Village@yahoogroups.com
To
cc
Subject
RE:
[Axapta-Knowledge-Village] reporting tools and
Axapta
I Gather you bought
the Licences. It Would be interesting to see how you went.
I did it on the cheap by
Installing the Sql Analysis server into your SQL Server and Use Excell
Spreadsheets to Make them Pretty for the bosses.
Rocco
From: willem_baelde
[mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005 10:28
PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject:
[Axapta-Knowledge-Village] reporting tools and AxaptaHello,has someone experience
with a reporting tool or cube on Axapta ?Can someone recommend one ?
kind regards,Willem BaeldeSharing the knowledge on
Axapta. Sharing the knowledge on Axapta.
Yahoo! Groups
Sponsor
ADVERTISEMENT
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 the
Yahoo! Terms of Service.
Sharing the
knowledge on Axapta. Sharing the knowledge on Axapta.
Yahoo! Groups
Sponsor
ADVERTISEMENT
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 the
Yahoo! Terms of Service.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] reporting tools and Axapta
Does mio Mean 15,000,000 Records I Lose performance after 100,000 and You have to be smart with the design , which I am sure you are, otherwise it falls over (Mircosoft our friends), Incude Cubes with Filters to reduce Unneccessary Data Out of my league Please put a post on how you went , I was think of buying it for Axapta Good Luck From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005 10:41 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] reporting tools and Axapta Hello, Small problem, Rocco, we are working on Oracle. We installed SQL Analysis server but the performance is not good enough. Certain tables contain more then 15 mio records ... Kind regards, Willem "Rocco Giumelli" <[EMAIL PROTECTED]> 25/02/2005 15:32 Please respond toAxapta-Knowledge-Village@yahoogroups.com To cc Subject RE: [Axapta-Knowledge-Village] reporting tools and Axapta I Gather you bought the Licences. It Would be interesting to see how you went. I did it on the cheap by Installing the Sql Analysis server into your SQL Server and Use Excell Spreadsheets to Make them Pretty for the bosses. Rocco From: willem_baelde [mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005 10:28 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] reporting tools and AxaptaHello,has someone experience with a reporting tool or cube on Axapta ?Can someone recommend one ? kind regards,Willem BaeldeSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] reporting tools and Axapta
I Gather you bought the Licences. It Would be interesting to see how you went. I did it on the cheap by Installing the Sql Analysis server into your SQL Server and Use Excell Spreadsheets to Make them Pretty for the bosses. Rocco From: willem_baelde [mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005 10:28 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] reporting tools and Axapta Hello,has someone experience with a reporting tool or cube on Axapta ?Can someone recommend one ? kind regards,Willem BaeldeSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Web Time?
Hi Jesmond
I found this code helpful on the portal
edit TempStr LocalstartTime(boolean _set, TempStr
_timeStr){ TempStr ret;
if (_set)
{ _timeStr = StrKeep(_timeStr,
'0123456789:.,');
msm_svccalltable.LocalStartTime =
str2time(_timeStr); }
ret = time2strHM(
msm_svccalltable.LocalStartTime);
return ret;}
Rocco
From: jesmondus [mailto:[EMAIL PROTECTED]
Sent: Friday, 25 February 2005 4:50 PMTo:
Axapta-Knowledge-Village@yahoogroups.comSubject:
[Axapta-Knowledge-Village] Web Time?
Hi all,I want to have a field to input TIME in the
Enterprise Portal. Since there is no Web Time control, what do you propose
to use
instead??regJesmondSharing the
knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village]Hi Rocco
Thankyou Shruti/Varden
Sometimes the easiest things are the most
obvious..
Rocco
From: Shruti [mailto:[EMAIL PROTECTED]
Sent: Friday, 11 February 2005 9:30 PMTo:
Axapta-Knowledge-Village@yahoogroups.comSubject: Re:
[Axapta-Knowledge-Village]Hi Rocco
Regards::Shruti JainEuroinfo Systems Pvt. Ltd.C-126, Sector -
2Noida - 201301 (U.P.)Phone :- +91-120-2520414
Hi Rocco
I feel that u need to select the table
"Projinvoicetable" first to update values on it.
Or u can try this out:
ttsbegin;
select for update Projinvoicetable;
/*
specify ur code here
*/
ttscommit;Rocco Giumelli
<[EMAIL PROTECTED]> wrote:
Hi
All
I am Trying
to put some code in that will change a Field on a Different table when
the change on the custtable field is Modified
Custtable
form\Datatsource\custtable\field\blocked ( this is a enum
custvendorblocked)
Change New Field
on Invoiceprojecttable (A tick Box)
It Can not edit
a record as the record has never been selected
Missing
something
Thanking you
all
public void
modified(){
ProjInvoiceTable
Projinvoicetable;
CustVendorblocked Blocked;
super();
custtable.AccountNum =
Projinvoicetable.InvoiceAccount;
if(custTable.Blocked ==
CustVendorBlocked::All) Projinvoicetable.ECL_Blocked =
Noyes::Yes; Projinvoicetable.doUpdate();
If(custtable.Blocked ==
CustVendorBlocked::Invoice)
Projinvoicetable.ECL_Blocked = Noyes::Yes;
Projinvoicetable.doUpdate();
If(custtable.Blocked ==
CustVendorBlocked::No) Projinvoicetable.ECL_Blocked =
Noyes::No; Projinvoicetable.doUpdate();
Projinvoicetable.doUpdate();
custTable_ds.refresh();
}
Rocco Giumelli
IT MANAGER
Metric Australia Pty
Ltd
Assistance is only the Beginning
893745331
Sharing the knowledge on Axapta.
Do you Yahoo!?Yahoo! Search presents - Jib
Jab's 'Second Term' Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: locked in counting journal
Hi Yifat/Harry On the item form, select the setup button, than warehouse items, it shows a list of possible warehouses for the item you are looking at. I believe there should be an entry in here to represent the item that would actually be in stock for that warehouse. In our stocktake, it keep locking the items, until I entered the warehouse number in here. I don't understand why Axapta does not do this for us, We are on Axapta 3.0 sp1, maybe they have fixed it I do need run a job that will populate this table based on what is actually in stock in all warehouses for all items. I believe this will need to be populated before we create the counting journals. Rocco From: truserv_pm [mailto:[EMAIL PROTECTED] Sent: Saturday, 12 February 2005 2:39 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Re: locked in counting journal If I can add a comment here. We are in the middle of an implemenation and during our testing found that the counting journal locked the items during the countm which was fine. But after the count was complete the items remained locked. MBS in Fargo (USA) provided a fix for us for this. Perhaps you can source this fix through your MBS contacts. --- In Axapta-Knowledge-Village@yahoogroups.com, "Yifat Halili" <[EMAIL PROTECTED]> wrote:> Hi there,> > > > I wonder if we are all talking about the same thing?> > > > I am saying that if I create counting journal and delete it with out> posting it, and the parameter "lock items in counting journal" is on,> then Axapta does not always unlock all the items in the> inventitemlocation table... and the client complains. It seems as though> I will have to have this bug fixed in Axapta.> > > > As for Rocco, I think you are talking about creating a counting journal> per warehouse, per location... and if you don't set the> inventitemlocation per item per warehouse then your stock sheet will not> be per item per warehouse... is that what you are talking about? > > > > __> > Yifat> > www.exordia.co.za <http://www.exordia.co.za/> > > > > From: Harry Deshpande [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 10, 2005 9:55 PM> To: Axapta-Knowledge-Village@yahoogroups.com> Subject: RE: [Axapta-Knowledge-Village] locked in counting journal> > > > Hi Rocco> > > > Give me a couple of days something urgent has come up (when something> goes wrong it goes wrong everywhere and it seems all of our clients have> logged priority one calls) *s*> > > > Regards> > > > harry> > > > > > From: Rocco Giumelli [mailto:[EMAIL PROTECTED] > Sent: Thursday, 10 February 2005 5:04 p.m.> To: Axapta-Knowledge-Village@yahoogroups.com> Subject: RE: [Axapta-Knowledge-Village] locked in counting journal> > > > Hi Harry> > > > I may have crossed-paths on problems, Was You problem the same as this> one?> > > > Anything to add?> > > > > > > > This was My Experience> > > > My first experience with Annual Stocktaking was quite miserable. Firstly> I had created my counting journals too early and the Stock on hand was> taken as at the date of printing the journals, Do not print your> journals too early for processing, Duplicate your system and than print> them out so you can get everyone ready. Creating the Counting jounral on> the day of the stock take. In my circumstances , we operate about 15> Warehouses national, and each Item Number must have a cross reference in> the item form, under setup called warehouse items. Each Item number> needs to have the associated warehouse loaded into here so. otherwise> axapta locks the item number against the first warehouse that is> processed. I thought this cross-reference would have been created by the> actual transactions for that item in the warehouse where it has been> used. (Otherwise when Stocktake is processed it keep saying that the> item was locked, and it stops the flow)> > > > Now I am on Axapta 3.00 sp1 , so I not sure whether this affects you,> but I hope they have solved this problem in the next release. I am Sure> there is other things that I Missed completly, GOOD Luck!> > > > Rocco> > > > A Response that I received Late Last Year> > > > I don't know why the inventitemlocation table is not populated> automatically; all I know is that I had to populate the table in several> of my implementations. I did get clever and used a csv import into> Axapta. This made the process much quic
RE: [Axapta-Knowledge-Village] locked in counting journal
Hi Harry I may have crossed-paths on problems, Was You problem the same as this one? Anything to add? This was My Experience My first experience with Annual Stocktaking was quite miserable. Firstly I had created my counting journals too early and the Stock on hand was taken as at the date of printing the journals, Do not print your journals too early for processing, Duplicate your system and than print them out so you can get everyone ready. Creating the Counting jounral on the day of the stock take. In my circumstances , we operate about 15 Warehouses national, and each Item Number must have a cross reference in the item form, under setup called warehouse items. Each Item number needs to have the associated warehouse loaded into here so. otherwise axapta locks the item number against the first warehouse that is processed. I thought this cross-reference would have been created by the actual transactions for that item in the warehouse where it has been used. (Otherwise when Stocktake is processed it keep saying that the item was locked, and it stops the flow) Now I am on Axapta 3.00 sp1 , so I not sure whether this affects you, but I hope they have solved this problem in the next release. I am Sure there is other things that I Missed completly, GOOD Luck! Rocco A Response that I received Late Last Year I don’t know why the inventitemlocation table is not populated automatically; all I know is that I had to populate the table in several of my implementations. I did get clever and used a csv import into Axapta. This made the process much quicker. It is easy to populate the spread sheet once you have all the items, the warehouses and the locations. Also once the inventitemlocation is set up correctly, creating a stock counting journal is not a problem. If you create the journal per warehouse then the system locks the items in each respective warehouse (and location)… I hope this answers your questions. Basically the inventitemlocation is very important for stock counting in different warehouses. Regards, __ Yifat Halili Financial Systems Consultant Exordia - a division of PricewaterhouseCoopers SA Website: www.exordia.co.za From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February 2005 3:54 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi Confused. Why do u want to mass populate inventItemLocation from on hand inventory? Which fields to u want to mass populate? Regards harry From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 3:56 p.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi Harry Is it Per Item and Per warehouse? Do you have a way to Mass Populate the inventitemlocation table with the Current on hand inventory of Axapta? I would have thought this table would have been updated when items go into the Warehouse Thanking You Rocco From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 4:09 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi This is a bug with standard axapta. The flag is on table inventitemlocation. You will have to set this flag per item once a counting journal is posted. Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst & Young, and Ernst & Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world’s leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.cgnz.com/middlemarketsolutions CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachmen
RE: [Axapta-Knowledge-Village] locked in counting journal
Three Cheers for Harry Hip Hip Hooray!! rocco From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February 2005 3:58 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi Yifat! Actually that’s what I wanted to say..to suggest to modify standard axapta to update this flag *s* Being a bit presumptuous I guess *s* Regards Harry From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 7:37 p.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi Harry, I hope you are well. I know it is the inventitemlocation table, and I have explained to my client how to do this manually… I just wondered if there was some code change that could fix the bug. It appears that it is only once the journal is deleted and not posted that the items remained locked in the journal. Thanks. __ Yifat From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 4:56 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi Harry Is it Per Item and Per warehouse? Do you have a way to Mass Populate the inventitemlocation table with the Current on hand inventory of Axapta? I would have thought this table would have been updated when items go into the Warehouse Thanking You Rocco From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 4:09 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi This is a bug with standard axapta. The flag is on table inventitemlocation. You will have to set this flag per item once a counting journal is posted. Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst & Young, and Ernst & Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world’s leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.cgnz.com/middlemarketsolutions CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ. CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments. From: yifath1 [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 2:40 a.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] locked in counting journal Hi all,can anyone help me, axapta 3, sp 3, items are locked during counting is activated on the inventory parameters.However if a journal is created and then deleted, then some items still remain locked in journal... even though the journal no longer excists... what modification is required...?Many thanks in Advance.YifatSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village]
Hi
All
I am Trying to
put some code in that will change a Field on a Different table when the change
on the custtable field is Modified
Custtable
form\Datatsource\custtable\field\blocked ( this is a enum
custvendorblocked)
Change New Field on
Invoiceprojecttable (A tick Box)
It Can not edit a
record as the record has never been selected
Missing
something
Thanking you
all
public void modified(){
ProjInvoiceTable
Projinvoicetable;
CustVendorblocked Blocked;
super();
custtable.AccountNum =
Projinvoicetable.InvoiceAccount;
if(custTable.Blocked ==
CustVendorBlocked::All) Projinvoicetable.ECL_Blocked =
Noyes::Yes; Projinvoicetable.doUpdate();
If(custtable.Blocked ==
CustVendorBlocked::Invoice) Projinvoicetable.ECL_Blocked =
Noyes::Yes; Projinvoicetable.doUpdate();
If(custtable.Blocked ==
CustVendorBlocked::No) Projinvoicetable.ECL_Blocked =
Noyes::No; Projinvoicetable.doUpdate();
Projinvoicetable.doUpdate();
custTable_ds.refresh();
}
Rocco Giumelli
IT
MANAGER
Metric Australia Pty
Ltd
Assistance is only the
Beginning
893745331
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
<>
RE: [Axapta-Knowledge-Village] locked in counting journal
Hi Harry Is it Per Item and Per warehouse? Do you have a way to Mass Populate the inventitemlocation table with the Current on hand inventory of Axapta? I would have thought this table would have been updated when items go into the Warehouse Thanking You Rocco From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 4:09 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] locked in counting journal Hi This is a bug with standard axapta. The flag is on table inventitemlocation. You will have to set this flag per item once a counting journal is posted. Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst & Young, and Ernst & Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world’s leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.cgnz.com/middlemarketsolutions CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ. CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments. From: yifath1 [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 February 2005 2:40 a.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] locked in counting journal Hi all,can anyone help me, axapta 3, sp 3, items are locked during counting is activated on the inventory parameters.However if a journal is created and then deleted, then some items still remain locked in journal... even though the journal no longer excists... what modification is required...?Many thanks in Advance.YifatSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Usage Data
Hi Victor, YES YES. I did find them where you said they would be, but How do I extract this from their on a user by user basis? Thankyou for your reply. Rocco From: victor_zuev [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 2:22 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Re: Usage Data Hi,You can find this SysLastValue table if you expand the System Documentation / Tables node in AOT.--- In Axapta-Knowledge-Village@yahoogroups.com, "Rocco Giumelli" <[EMAIL PROTECTED]> wrote:> How Come I can't see this table in my list of tables ?> > _ > > From: Tony Depalo [mailto:[EMAIL PROTECTED] > Sent: Friday, 4 February 2005 2:07 PM> To: Axapta-Knowledge-Village@yahoogroups.com> Subject: RE: [Axapta-Knowledge-Village] Usage Data> > > I think sysLastValue table has that info?> Good luck> Tony> = > Tony DePalo B.Comp. > Technical Services Consultant > Moore Stephens Technology Australia > Business Building Strategies > > Phone (Direct): + 61 (7) 3100 0012 > Phone (Switch): + 61 (7) 3317 7877 > Phone (Mobile): 0407 634 748 > Fax: + 61 (7) 3221 0812 > Address: GPO Box 1396, Brisbane Qld Australia > E-mail: [EMAIL PROTECTED]> > Visit our web site: <http://www.moorestephens.com.au/tech>> www.moorestephens.com.au/tech > > Disclaimer: This email message and any accompanying attachments should only> be read by those persons to whom it is addressed and is not intended to be> relied upon by any person without subsequent written confirmation of its> contents. Accordingly Moore Stephens Technology Australia disclaim all> responsibility and accept no liability (including in negligence) for the> consequences for any person acting, or refraining from acting, on such> information prior to the receipt by those persons of subsequent written> confirmation.> > If you have received this email message and any accompanying attachments in> error, please notify us immediately by telephone (+61 7 3317 7877). Please> also permanently delete the message from your computer. Any form of> reproduction, dissemination, copying, disclosure, modification, distribution> and/or publication of this email message and any accompanying attachments is> strictly prohibited without the prior consent of Moore Stephens Technology> Australia.> > Moore Stephens Technology Australia is a registered trading name of Moore> Stephens HL Technology Pty Ltd and a member of the Moore Stephens> International Limited Group of Independent Firms.> > -Original Message-> From: Rocco Giumelli [mailto:[EMAIL PROTECTED] > Sent: Friday, 4 February 2005 3:58 PM> To: 'Eclipse Help'> Cc: Axapta-Knowledge-Village@yahoogroups.com> Subject: [Axapta-Knowledge-Village] Usage Data> > > Hi All> > tools/options/usage data> > Can someone please explain to me how it is possible to store the full set of> Usage data that is stored per user.> > I want to extract all data , then select reset usage data , then reimport> the extracted settings for all usage.> > As the system will crash often resulting in the reset of all data on a> regular basis. This is quite annoying to staff.> > > Rocco Giumelli> IT MANAGER > Metric Australia Pty Ltd> Assistance is only the Beginning > 893745331> > > > > > > > > > > > > > > > Sharing the knowledge on Axapta. > > > > 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]> subject=Unsubsc> ribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service> <http://docs.yahoo.com/info/terms/> .Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Usage Data
Title: Message How Come I can't see this table in my list of tables ? From: Tony Depalo [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 2:07 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Usage Data I think sysLastValue table has that info? Good luck Tony = Tony DePalo B.Comp. Technical Services Consultant Moore Stephens Technology Australia Business Building Strategies Phone (Direct): + 61 (7) 3100 0012 Phone (Switch): + 61 (7) 3317 7877 Phone (Mobile): 0407 634 748 Fax: + 61 (7) 3221 0812 Address: GPO Box 1396, Brisbane Qld Australia E-mail: [EMAIL PROTECTED] Visit our web site: www.moorestephens.com.au/tech Disclaimer: This email message and any accompanying attachments should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. Accordingly Moore Stephens Technology Australia disclaim all responsibility and accept no liability (including in negligence) for the consequences for any person acting, or refraining from acting, on such information prior to the receipt by those persons of subsequent written confirmation. If you have received this email message and any accompanying attachments in error, please notify us immediately by telephone (+61 7 3317 7877). Please also permanently delete the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this email message and any accompanying attachments is strictly prohibited without the prior consent of Moore Stephens Technology Australia. Moore Stephens Technology Australia is a registered trading name of Moore Stephens HL Technology Pty Ltd and a member of the Moore Stephens International Limited Group of Independent Firms. -Original Message-From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 3:58 PMTo: 'Eclipse Help'Cc: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Usage Data Hi All tools/options/usage data Can someone please explain to me how it is possible to store the full set of Usage data that is stored per user. I want to extract all data , then select reset usage data , then reimport the extracted settings for all usage. As the system will crash often resulting in the reset of all data on a regular basis. This is quite annoying to staff. Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service. <>
[Axapta-Knowledge-Village] Usage Data
Hi All tools/options/usage data Can someone please explain to me how it is possible to store the full set of Usage data that is stored per user. I want to extract all data , then select reset usage data , then reimport the extracted settings for all usage. As the system will crash often resulting in the reset of all data on a regular basis. This is quite annoying to staff. Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 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 the Yahoo! Terms of Service. <>
RE: Re: [Axapta-Knowledge-Village] Com Connector
Thanks Akin
That seems to be the easy answer
Rocco
From: akin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 January 2005 8:34 PMTo:
[EMAIL PROTECTED]Subject: Re: Re:
[Axapta-Knowledge-Village] Com Connector
hi
as I know we can use C++ or VB or delphi write a
Com+ proxy to connect to another com connector of axapter server,it work like
virtual server.
so we can deploy two connector
in one computer.
or Win2003 Enterprise you have
something called COM partisioning. You canrun several COM objects in their
own memory space.
And I heard someone has
done this by made a Com wrapper that works like
COMpartisioning
Hope it will help
you.
2005-01-25 19:44:17 您在来信中写道：
Hi Rocco,
As far as I know you will have to register both of them on separate
computers if you want to use both at the same time. Only one COM
connector can be registered and use on a compter at a time.
Varden Morris
J.
Wray & Nephew Ltd. - Group I.S.
234
Spanish Town
Road
Kingston
11, Jamaica,
W.I.
Phone: (876) - 923 - 6141 Ext.
2226Fax: (876) -
923 - 5372
Cell: (876) -
3833566Email: [EMAIL PROTECTED]
[EMAIL PROTECTED]
Rocco Giumelli
<[EMAIL PROTECTED]> wrote:
I am
having trouble establishing two seperate Com Connections one for my
Live & and one for Play System for Enterprise Portal Web
Access.
When I
register the Play Config File and go into my Live system the
test on the buisness connector says it is the Play system and vica
versa.
I am
missing the trick.
Under
Licences it has registered 2 Com Clients.
Rocco
Giumelli
Sharing
the knowledge on Axapta.
Do you Yahoo!?Yahoo! Search presents - Jib
Jab's 'Second Term' Sharing the knowledge on
Axapta.
= = = = = = = = = = = = = = = = = = = = = =
regards
akin
[EMAIL PROTECTED]
2005-01-25
Sharing the knowledge on Axapta.
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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Prinint Muliple Invocies
Hi all Has anyone found an Easy way to Print out multiple Invoices from the Projects\Inquiries\Invoice\Invoice. The Invoice Journal Won't do the Invoice print needs to look like it was printed Normally, not as a Journal Report. Previously Someone Suggested Using the projects\periodic\Invoice\PostInvoice, But this Only Prints If the Invoice Is Posted at that time, which is not our case because the Invoices have allready been posted. An Invoice Print for Existing Invoices Filtered by user criteria Please Help Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 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 the Yahoo! Terms of Service. <>
[Axapta-Knowledge-Village] Com Connector
I am having trouble establishing two seperate Com Connections one for my Live & and one for Play System for Enterprise Portal Web Access. When I register the Play Config File and go into my Live system the test on the buisness connector says it is the Play system and vica versa. I am missing the trick. Under Licences it has registered 2 Com Clients. Rocco Giumelli 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village]
Hi all When we have a Webgrid and when the 'showselectcolumn' is set for yes, I would like to retain the one that has been selected by the user and than use that as the record to init other web forms. Or should all datasources be in the same web form, so when the desired record is selected the refresh will only show that record and the releated webgrids that relate to the trans tables below it. so transactions can be processed against the record that has been Selected only. I hope this is clear thankyou all Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 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 the Yahoo! Terms of Service. <>
[Axapta-Knowledge-Village] Inventdimposted
Hi all I wonder if anyone can help.. I have modified the Inventdimpost Report in Axapta and I want to add a cloumn, that will give the date of last sale with inventrans.transtype::Project. and have this last trans date appear on this report Or is there another way to get from the Invent module a report that will give last trans date of this type, without listing all trans dates as the Inventory Transaction report does. Maybe a criteria that will be like = 'latest date' Thanking you Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 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 the Yahoo! Terms of Service. <>
RE: [Axapta-Knowledge-Village] change login Image
Change the Companylog.bmp to your own, in the application folder of Axapta Axapta\Application\Share\Include Rocco From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: Friday, 31 December 2004 11:50 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] change login Image where ?? on main menu or login dialog ??Mohammed Sadiq <[EMAIL PROTECTED]> wrote: Dear All We are in process of implementing Axapta. Can anyone tell me how to change the login image in Axapta. I want to change the default image when the user login. Thanks/RegardsSharing the knowledge on Axapta. Do you Yahoo!?Send holiday email and support a worthy cause. Do good. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] audit function on a field
Please explain audit function that is required here I Know in our business we had to purchase the Audit Logging System which works well in telling us who changed what and where in the system., otherwise enable the Created by and Modified by date stamping from the table properties also helped. Rocco From: jeroen_vangheluwe [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 December 2004 6:35 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] audit function on a field Dear,How can I put an audit function on a field?I would like to put the audit on Acc. recc. - Sales order-tab general - finish sales orderAcc. recc. - Sales order-tab setup - field pool creation salesorder lineThanks in advance,JeroenSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Need To Create a Job
Hi
all
I Need to create a
Job that is Going to Check the PurchCostprice from the Inventtablemodule against
the Weightedcostprice in the System and then if different Change the
Inventsum.postedvalue to be the true purchcostprice * the Posted
Qty
I have the following
but am losing direction. can anyone help
static void
doupdate_InventSum_PostValue_Fix(Args _args){
Inventsum
inventsum;
Inventtablemodule
Inventtablemodule;
amount
WeightedCost;
amount
Actualpurchprice;
amount
Actualpostedvaluediff;
ttsbegin; while select forupdate Inventsum where
inventsum.ItemId == inventtablemodule.ItemId
{ WeightedCost =
inventsum.costPricePcs(); ActualPurchPrice =
inventtablemodule.price;
if(Actualpostedvaluediff =
weightedcost - ActualPurchprice) ;
inventsum.PostedValue =
ActualPurchPrice * inventsum.PostedQty;
inventsum.doUpdate();
}
ttscommit;
Thankyou all and everyone have a good Festive
break.
Rocco
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] InitValue
Hi all Does anyone know the best practice to have Values automatically populated when creating new Records by using Contrl+N. I thought the InitValue Method on the forms datasource for the table I wanted the values to be on, was ok, but our partnersource begs to differ. I then move it to the Method initvalue on the table and put it after Super(); but it does not work. thanking you Rocco Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] annual stocktaking
YES, YES, YES, CSV Import sounds like the go. Thankyou From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: Friday, 10 December 2004 4:12 PMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] annual stocktaking Hi Rocco, I don’t know why the inventitemlocation table is not populated automatically; all I know is that I had to populate the table in several of my implementations. I did get clever and used a csv import into Axapta. This made the process much quicker. It is easy to populate the spread sheet once you have all the items, the warehouses and the locations. Also once the inventitemlocation is set up correctly, creating a stock counting journal is not a problem. If you create the journal per warehouse then the system locks the items in each respective warehouse (and location)… I hope this answers your questions. Basically the inventitemlocation is very important for stock counting in different warehouses. Regards, __ Yifat Halili Financial Systems Consultant Exordia - a division of PricewaterhouseCoopers SA Website: www.exordia.co.za From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 3:11 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] annual stocktaking Hi Yifat Do You Know Why The InventItemLocation Table Does Not Get Populated automatically, Since in our environment, the same item crosses dimensions and this InventItemLocation table remains static, Does Locking the items treat the lock on one warehouse, or does it apply to all, On our stocktake , I had to forever enter lines in here that matched the item to the warehouse. and slowed down the Whole Process, I could not find any documentation on how and especialy why it does not autopopulate. June 2005 , is coming up quick, and I would like to see Axapta create entries based on incoming and outgoing transactions from warehouse dimensions . Ideally a Job that ran just prior to the priniting of the countiong journals, that made a warehouse item entry Lock count against each warehouse & item. Thanking you very much. Rocco From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 December 2004 5:09 PMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] annual stocktaking Hi there, Rocco is correct, when Axapta creates a stock sheet it is snap shot of the way the items are at that point in time. Hence, one should not do any transactions once the stock sheet has been created, a good idea is to lock the items in the stock count. Axapta cannot handle movement of stock during the stock count. Another thing to keep in mind is the unit of measure, make sure that the people are counting in the correct unit of measure. i.e. the inventory unit of measure. For ease of use, we display the unit of measure on the counting sheet. Also one needs to consider if you are using standard costing or average costing. If you are using ave costing, when you count up, the system takes that stock at a zero cost unless otherwise specified – i.e. fill in the cost field in the stock counting journal. If you are using std costing there is no problem. Hope this helps. __ Yifat Halili Financial Systems Consultant Exordia - a division of PricewaterhouseCoopers SA Website: www.exordia.co.za From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 9:35 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] annual stocktaking Hi Stefan My first experience with Annual Stocktaking was quite miserable. Firstly I had created my counting journals too early and the Stock on hand was taken as at the date of printing the journals, Do not print your journals too early for processing, Duplicate your system and than print them out so you can get everyone ready. Creating the Counting jounral on the day of the stock take. In my circumstances , we operate about 15 Warehouses national, and each Item Number must have a cross reference in the item form, under setup called warehouse items. Each Item number needs to have the associated warehouse loaded into here so. otherwise axapta locks the item number against the first warehouse that is processed. I thought this cross-reference would have been created by the actual transactions for that item in the warehouse where it has been used. (Otherwise when Stocktake is processed it keep saying that the item was locked, and it stops the flow) Now I am on Axapta 3.00 sp1 , so I not sure whether this affects you, but I hope they have solved this problem in the next release. I am Sure there is other things that I Missed completly, GOOD Luck! Rocco From: Stefan Heidkamp [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 December 2004 3:09 PMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] annual stocktaking Hi to all,it's my fir
RE: [Axapta-Knowledge-Village] annual stocktaking
Hi Yifat Do You Know Why The InventItemLocation Table Does Not Get Populated automatically, Since in our environment, the same item crosses dimensions and this InventItemLocation table remains static, Does Locking the items treat the lock on one warehouse, or does it apply to all, On our stocktake , I had to forever enter lines in here that matched the item to the warehouse. and slowed down the Whole Process, I could not find any documentation on how and especialy why it does not autopopulate. June 2005 , is coming up quick, and I would like to see Axapta create entries based on incoming and outgoing transactions from warehouse dimensions . Ideally a Job that ran just prior to the priniting of the countiong journals, that made a warehouse item entry Lock count against each warehouse & item. Thanking you very much. Rocco From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 December 2004 5:09 PMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] annual stocktaking Hi there, Rocco is correct, when Axapta creates a stock sheet it is snap shot of the way the items are at that point in time. Hence, one should not do any transactions once the stock sheet has been created, a good idea is to lock the items in the stock count. Axapta cannot handle movement of stock during the stock count. Another thing to keep in mind is the unit of measure, make sure that the people are counting in the correct unit of measure. i.e. the inventory unit of measure. For ease of use, we display the unit of measure on the counting sheet. Also one needs to consider if you are using standard costing or average costing. If you are using ave costing, when you count up, the system takes that stock at a zero cost unless otherwise specified – i.e. fill in the cost field in the stock counting journal. If you are using std costing there is no problem. Hope this helps. __ Yifat Halili Financial Systems Consultant Exordia - a division of PricewaterhouseCoopers SA Website: www.exordia.co.za From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 9:35 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] annual stocktaking Hi Stefan My first experience with Annual Stocktaking was quite miserable. Firstly I had created my counting journals too early and the Stock on hand was taken as at the date of printing the journals, Do not print your journals too early for processing, Duplicate your system and than print them out so you can get everyone ready. Creating the Counting jounral on the day of the stock take. In my circumstances , we operate about 15 Warehouses national, and each Item Number must have a cross reference in the item form, under setup called warehouse items. Each Item number needs to have the associated warehouse loaded into here so. otherwise axapta locks the item number against the first warehouse that is processed. I thought this cross-reference would have been created by the actual transactions for that item in the warehouse where it has been used. (Otherwise when Stocktake is processed it keep saying that the item was locked, and it stops the flow) Now I am on Axapta 3.00 sp1 , so I not sure whether this affects you, but I hope they have solved this problem in the next release. I am Sure there is other things that I Missed completly, GOOD Luck! Rocco From: Stefan Heidkamp [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 December 2004 3:09 PMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] annual stocktaking Hi to all,it's my first annual stocktaking in Axapta 2.5 SP4 as administrator. Must I anticipate with many surprises ;-)? I'm thankfull of any tip (application and development). Best regards,Stefan HeidkampSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] annual stocktaking
Hi Stefan My first experience with Annual Stocktaking was quite miserable. Firstly I had created my counting journals too early and the Stock on hand was taken as at the date of printing the journals, Do not print your journals too early for processing, Duplicate your system and than print them out so you can get everyone ready. Creating the Counting jounral on the day of the stock take. In my circumstances , we operate about 15 Warehouses national, and each Item Number must have a cross reference in the item form, under setup called warehouse items. Each Item number needs to have the associated warehouse loaded into here so. otherwise axapta locks the item number against the first warehouse that is processed. I thought this cross-reference would have been created by the actual transactions for that item in the warehouse where it has been used. (Otherwise when Stocktake is processed it keep saying that the item was locked, and it stops the flow) Now I am on Axapta 3.00 sp1 , so I not sure whether this affects you, but I hope they have solved this problem in the next release. I am Sure there is other things that I Missed completly, GOOD Luck! Rocco From: Stefan Heidkamp [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 December 2004 3:09 PMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] annual stocktaking Hi to all,it's my first annual stocktaking in Axapta 2.5 SP4 as administrator. Must I anticipate with many surprises ;-)? I'm thankfull of any tip (application and development). Best regards,Stefan HeidkampSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village]
Hi Steve, John had Suggested this,Will try this . What code would make the class work? don't use date fields in your dialog. Use a date interval(--> ledger / setup /periods / dateintervals). On the table for dateintervals you'll find all methods to convert into from and to date (the dates that are returned depend on systemDateGet(). Best wishes John From: Steen Rabøl [mailto:[EMAIL PROTECTED] Sent: Wednesday, 1 December 2004 4:11 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Hi Create a class which set the correct date, then run the report. Best Steen Rabøl From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: 30. november 2004 04:02To: [EMAIL PROTECTED] Com; [EMAIL PROTECTED] ComSubject: [Axapta-Knowledge-Village] Hi, Can Someone please explain how we can create a report have it batched for a daily occurence, and have a date field in the query to represent the Previous two days from today, EG Run report this morning, at the moment I need to manual change the dates to the 241104..251104. Thanking you Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service. <>
[Axapta-Knowledge-Village]
Hi, Can Someone please explain how we can create a report have it batched for a daily occurence, and have a date field in the query to represent the Previous two days from today, EG Run report this morning, at the moment I need to manual change the dates to the 241104..251104. Thanking you Rocco Giumelli IT MANAGER Metric Australia Pty Ltd Assistance is only the Beginning 893745331 Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada 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 the Yahoo! Terms of Service. <>
