RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?
Hi, Barry!! I'd like to do so, but the code is embedded in an huge Java program. I asked the Java programmers to give me the part where we made the test, and it's huge, however. Basically, it opens several COM sessions, and open a test table, and inserts 100 records in it. There's a startsinchronization time for the loops that makes the insert, so all COM sessions (and insert loop subprocesses) begin at same time. That's that way we discovered the error. And now I'm not physically in the customer that have that problem, so until next week I can't post it. You want it, however? Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS Bayliss, Barry [EMAIL PROTECTED] 09/03/2005 23:43 Por favor, responda a Axapta-Knowledge-Village@yahoogroups.com Para Axapta-Knowledge-Village@yahoogroups.com cc Asunto RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Raul, Are you able to post the code that generates the error? Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Sunday, 6 March 2005 6:54 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Yes, that solves the problem or duplicated RecId's inserted in several tables, but doesn't solve the insert-error issue... Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS -Preston A. Larimer [EMAIL PROTECTED] escribió: - Para: Axapta-Knowledge-Village@yahoogroups.com De: Preston A. Larimer [EMAIL PROTECTED] Fecha: 04/03/2005 20:34 Asunto: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Definitely duplicate recID?s is not what you want, the menu path I gave you runs the check on recids for all of your tables and corrects issues with them being duplicated, or the SystemSequences being out of kilter, every time Axapta has throw up the unable to insert record due to a duplicate caused by the recID, via com or standard Axapta this process has fixed my problem. Hope it helps you. -Preston From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 3:25 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Preston , the problem isn't that records are inserted with same RecId, but Axapta doesn't allow to do so!! If I deactivated the system-hidden indexes of many tables, Axapta would allow it... until next sinchronization!! And remember, there are several tables based on refRecId field and similar, so possibility of incoherence if I allow to insert duplicated RecIds looks dangerous... Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS -Preston A. Larimer [EMAIL PROTECTED] escribió: - Para : Axapta-Knowledge-Village@yahoogroups.com De: Preston A. Larimer [EMAIL PROTECTED] Fecha: 03/03/2005 15:39 Asunto: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Try Administration\Periodic\SQL Administration\Check Record Id?s(Button) - Preston Preston A. Larimer Professional Solutions Group, LLC [EMAIL PROTECTED] www.psgroupllc.com - Building a stronger link in the Axapta community chain, join us at From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Friday, February 25, 2005 4:03 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? I've got a problem. Several users via COM, using same COM session, sometimes invokes the error (Cannot insert a record in table X. The record already exists). X may be an apparently alleatory table. And I need to track so. Tool of log of database doesn't fit this... Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS -Bayliss, Barry [EMAIL PROTECTED] escribió: - Para : Axapta-Knowledge-Village@yahoogroups.com De: Bayliss, Barry [EMAIL PROTECTED] Fecha: 24/02/2005 23:26 Asunto: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Hello Raul, Why is it that you need to find the recID for before the insertion? Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Thursday, 24 February 2005 3:08 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? How can I find what RecId will be the next to be used, before inserting a record and
Re: [Axapta-Knowledge-Village] Hi
yes, the second database (in second system) should be able to be connected from the first machine using ODBC. --- panda arabinda [EMAIL PROTECTED] wrote: - HI Girish, Thanks for giving idea.But as per your solution the other database should be there in the intranet or not ? I think one application should be able to talk with the other database. is not it ? Regards Arabinda --- Girish Bhatkal [EMAIL PROTECTED] wrote: Hi santosh, Well almost everything is possible. But do they want just the Sales order and purchase order to synchronise. What about the inventory? even though you get a solution of having the same SO's and PO's created and posted, this could happen only if inventory is also updated. But if the other things are thought of then you could write code to read the data from another database (using to ODBCConnection). After getting the data you need to write a function to create the SO's and PO's. This function has to be written at both the applications (assuming they are just copy of the same application). Then setup to run this function in batch, set to run at the end of the day. hope this would help you. cheers, Girish --- Varden Morris [EMAIL PROTECTED] wrote: Hi santosh I think the solution would be journal entries. You can use standard Axapta to export the data from the SalesTable and SalesLine tables for the sales orders and the PurchTable and PurchLine tables for the purchase orders. After this you could then create tables in Axapta to hold the data from these tables so that you can use standard Axapta to import the data. You then need to write code to create journal entries from these tables and then use standard Axapta to post the journals. Varden Morris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226 Fax: (876) - 923 - 5372 Cell: (876) - 3833566 Email: [EMAIL PROTECTED] [EMAIL PROTECTED] santosh padhi [EMAIL PROTECTED] wrote:Hi all Hi all, My client's requirement is there is 2 location.there they wants to setup 2 separate application and database.There is no centrlize server. In 1 location they create 10 p.o and 15 s.o. In another location they creates 5 p.o and 10 s.o. on the same day all the p.o and s.o will synchronize.Mean in both of the location all the p.o and s.o record should updated.How it is possible? any solution highly appreciated. santosh Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - 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. - Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web Send instant messages to your online friends http://uk.messenger.yahoo.com __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ 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. __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
AW: [Axapta-Knowledge-Village] Need some tutorial
Hi Lokesh, you can buy these course materials from Microsoft. Best regards, Tobias Von: lokesh kant [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 10. März 2005 17:39 An: Axapta-Knowledge-Village@yahoogroups.com Betreff: [Axapta-Knowledge-Village] Need some tutorial Hi all, I am preparing for the Axapta Programing Certification exam. I found following name from the Microsoft Partnersource site which are helpful for this exam. can any body send me any of this guide. Axapta Development I (Training Manual/Courseware/eCourse) Axapta Development II Introduction to X++ (Courseware/eCourse) Axapta X++ Advanced (Training Manual/Courseware (upon availability)) Courseware will be updated and renamed to Axapta Development III X++ Advanced Axapta MorphX Integration (Training Manual/Courseware (upon availability)) Courseware will be updated and renamed to Axapta Development IV Thanks Lokesh Kant Do you Yahoo!? Yahoo! Small Business - Try our new resources site! 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. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 09.03.2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 09.03.2005
[Axapta-Knowledge-Village] What does 'ReIndex function exactly do
Hi, Admistration -Perioidic -SQL Admi - Index Actions - Reindex. What does Reindex do exactly?. I thought Index is used for better Searching the records in the Tables. Any help. -Padmaja Do you Yahoo!? Yahoo! Small Business - Try our new resources site! 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] Demand Planner
Greetings. Does anyone out there have diretc experience with installation of demand planner 1.1 with Axapta 3.0? If so, would you be willing to help me out with a configuration issue that is too long to describe here? thanks. Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE : [Axapta-Knowledge-Village] Question about Queries.
Here's a modified version that do what you wanted :
I used SalesLine just to check if it compiled.
Amount SumAmount;
Query queryA;
QueryRun queryrunA;
QueryBuildDataSource qbdsQ = queryA.dataSourceNo(1);
SalesLine salesL;
queryA = new Query(tablenum(SalesLine));
qbdsQ.addRange(fieldnum(SalesLine, LineNum)).value('Something');
qbdsQ.orderMode(OrderMode::GroupBy);
qbdsQ.addSortField(fieldNum(SalesLine, dataAreaId));
qbdsQ.addSelectionField(fieldNum(SalesLine, QtyOrdered), SelectionField::Sum);
queryRunA = new QueryRun(queryA);
queryRunA.setRecord(salesL);
queryRunA.next();
SumAmount += salesL.QtyOrdered;
Steeve...
-Message d'origine-
De : Roberto Pineda [mailto:[EMAIL PROTECTED]
Envoyé : 10 mars 2005 12:02
À : Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Question about Queries.
Hello to All
Is there a way to make a query that gives the same
result of doing:
select sum(FieldX) from TableX where FieldY ==
Something;
The way i found goes like this, but I am sure that
there should be a nicer way.
Amount SumAmount;
Query queryX;
QueryRun queryrunX;
TableX tableM;
queryX = new Query(tablenum(TableX));
queryX.dataSourceNo(1).addRange(fieldnum(TableX,
FieldY)).value('Something');
queryRunA = new QueryRun(queryA);
while(queryRunA.next()){
tableM = queryRunA.getNo(1);
SumAmount += tableX.FieldX;
}
It's too slow.
Thanks if somebody can help me.
Roberto
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Demand Planner
Hi My sincere advice: Stay out of the demand planner. There are too many issues and needs huge support (support for bugs in the system so its not chargeable). 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 worlds 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: donalddclarkii [mailto:[EMAIL PROTECTED] Sent: Friday, 11 March 2005 9:45 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Demand Planner Greetings. Does anyone out there have diretc experience with installation of demand planner 1.1 with Axapta 3.0? If so, would you be willing to help me out with a configuration issue that is too long to describe here? thanks. 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: RE : [Axapta-Knowledge-Village] Question about Queries.
Thanks a lot Steeve!
--- Steeve Gilbert [EMAIL PROTECTED]
wrote:
Here's a modified version that do what you wanted :
I used SalesLine just to check if it compiled.
Amount SumAmount;
Query queryA;
QueryRun queryrunA;
QueryBuildDataSource qbdsQ = queryA.dataSourceNo(1);
SalesLine salesL;
queryA = new Query(tablenum(SalesLine));
qbdsQ.addRange(fieldnum(SalesLine,
LineNum)).value('Something');
qbdsQ.orderMode(OrderMode::GroupBy);
qbdsQ.addSortField(fieldNum(SalesLine, dataAreaId));
qbdsQ.addSelectionField(fieldNum(SalesLine,
QtyOrdered), SelectionField::Sum);
queryRunA = new QueryRun(queryA);
queryRunA.setRecord(salesL);
queryRunA.next();
SumAmount += salesL.QtyOrdered;
Steeve...
-Message d'origine-
De : Roberto Pineda
[mailto:[EMAIL PROTECTED]
Envoyé : 10 mars 2005 12:02
À : Axapta-Knowledge-Village@yahoogroups.com;
development-axapta@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Question about
Queries.
Hello to All
Is there a way to make a query that gives the same
result of doing:
select sum(FieldX) from TableX where FieldY ==
Something;
The way i found goes like this, but I am sure that
there should be a nicer way.
Amount SumAmount;
Query queryX;
QueryRun queryrunX;
TableX tableM;
queryX = new Query(tablenum(TableX));
queryX.dataSourceNo(1).addRange(fieldnum(TableX,
FieldY)).value('Something');
queryRunA = new QueryRun(queryA);
while(queryRunA.next()){
tableM = queryRunA.getNo(1);
SumAmount += tableX.FieldX;
}
It's too slow.
Thanks if somebody can help me.
Roberto
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en
Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
Sharing the knowledge on Axapta.
Yahoo! Groups Links
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
Yahoo! Groups Sponsor ~--
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Onhand on particular date
Hi , Is it possible to calculate the onhand on particular date?here em doing this by subtracting all the transaction till that date.Is this is a right way to do so??? Thanks And Regards Nitesh 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.
