[Axapta-Knowledge-Village] Can not print the group totals in the report
Hi all, I am facing a problem in viewing the group totals in one of the reports.I did some settings which works just fine with other reports!!. 1- in the desgin I selected Generate from Spec. Query 2-I defined the fields need to be summed by selecting SumAll property of each field need to be summed 3-I added a AccountNum field under the Sorting menu of my data source to make the group totals printed each time this field value changes. BUT, the FETCH method of this report has been overwriiten to make the report read from a temp. table... PLease till if the fetch methods affects the printing of the group totals.And if yes please provide a solutio Thanks, Absi Fanar IT 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] Re: Very large item master
Hi We seriously thought about writting a tool to pump the data, but since our implementation deadline was tight w Does anyone have such a tool? Just curious. 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: Hemant Kumthekar [mailto:[EMAIL PROTECTED] Sent: Saturday, 12 February 2005 5:08 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Very large item master Hi, To upload Item Master, BOM , Routings with large amount of data, MS-SQL DTS is better option, other way is to create a CSV files. We had the same problem in one of our implementation where we had around 700K records in BoM it took us 5 hours to upload using CSV and the upload was done on directly on Server, though we used combination of Access/Excel and converting to Text (CSV) files , but I think using MS-SQL DTS is better option anytime. We seriously thought about writting a tool to pump the data, but since our implementation deadline was tight we thought of not doing that, but now we are re-thinking about it. HK Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hey sorry for my third mail on this. something else came into my mind..Actually I didn't have access to SQL database as my administrator did n't give me the access ( kidding ! ). Did you try to load directly in SQL using DTS?. how does sound. I guess its a worth to give a try.. Thanks, Subbu SDBC Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Just adding to my last email, at the end of the load, you need to run consistency check to make sure your data is valid. Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hi, Presently I am migrating master data into Axapta. 1. Axapta is relatively slow for Excel as it uses COM for communication. It took approximately 2 hours to upload ~ 9000 records in just only one Table ( invnetTable). So I wrote jobs that read from the flat file and Individually inserts into the Tables. And for every records in InventTable, there would a record in InventDim and InventItemLocation. By default Axapta takes 'Axapta' as the InventDimId. And then you need to map that in IntemLocation..if you have wares houses , then you need to InventDim::findorCreate to generate the inventId and attch it to the InventItemLocation.or you will not see them in the ItemMaster form. In the same way, I wrote jobs for ConfigTable for COnfigurations, reqItemTable for Item coverages and InventDimCombination for Cost prices. And then wares houses and locations blah blah...Its really pain...but If you can write jobs, that would be easier I feel...We use conversion studio..But I feel it handles multiple formats. but when it comes the data volume, it takes almost same time.. Please let me know fi you need anything as I have already written scripts... Thansk Regards, Subbu SDBC implementaion. Danny Gaethofs [EMAIL PROTECTED] wrote: Dear Lourens, The only way to get this done is by importing the data directly into Axapta from a flat file, CSV
RE: [Axapta-Knowledge-Village] locked in counting journal
Hi Rocco I am a technical person so mercifully I dont have this problem (explaining things-they-never-told-you-when-they-sold-you-axapta to end users) *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 dont 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 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: 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.com Subject: 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 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: 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 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.
[Axapta-Knowledge-Village] Safety Stock
Hi All, Would anybody have any explanantions/notes/documentations on how Axapta calculates Safety Stock(for service level or average issue methods)? Thanks very much in advance, Odin 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/
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.