just to add to my original posting... the idea of loading historical invoices into the tables is just 2 tables custinvoicejour and custinvoicetrans. If you want info in any other tables then potentially direct load is maybe not what you want these 2 tables are enough to give you historical sales reports (which I assume is the main reason for having such data) but as mentioned wihtout cost unless you do a modification like I mentioned. To add I think the mod I suggested about the cost will work fine also in the std AX olap cubes (as they use the costvalue method) but of course for any OLAP cubes done outside of AX you would need to follow the same logic of checkign if inventtrans records or a value in the new historicalcost field
_____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Subbu Sent: 15 April 2009 06:56 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 Hi Varden, He can use DoInsert() method absolutely no problem. but, how can he create SalesIds that link between SalesInvouceJour/SalesInvoiceLines tables. Trans tables have inventTransId which links to SalesLine And also, the story does not stop at just these tables. If the vendor has non po invoices, then he has to post in LedgerJournalTable/LedgerJournalTrans. Remebember, if his customer wants to view the report by customer num, discounts , tax ,surcharges, tax on surcharges, tax exempt on surchares oh yeah, its just not those two tables. He has also look into ledgerJournalTable/Trans tables for Non PO/SO invoices and make sure that he has properly taken care of GL side postings. I am not sure if his customer would consider to maintain his whole SO/PO invoice history in a seperate company rather than the existing transactional company. Some people would prefer to maintain the history in a seperate company or ask them to use TARGIT or something similar. Just a thought. Wanted to say that its just not two tables when the orders have discounts,Sales taxes ( each state has its own tax ) and surcharges. My 2 US cents. Kind regards, Subbu Sr. Application Developer. Certified double master in functional as well as technical. Sunny Delight Beverages company --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com, Varden Morris <vard...@...> wrote: > > Usually in these kinds of data imports we assume that the data is clean and valid. So we would use the doInsert() method on the table buffer as oppose to the insert method. This method skips all validation and enhances performance. > > Varden Morris > Varalth Solutions Inc. > 693 Abbottsfield Road NW > Edmonton, Alberta T5W 4R4 > Canada > (780) 752-0406 > www.varalth.com > > CONFIDENTIALITY NOTICE > > This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. > > > > > ________________________________ > From: Michael Franchino <michael.franch...@...> > To: "Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com" <Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com> > Sent: Tuesday, April 14, 2009 1:44:09 PM > Subject: RE: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 > > > > > > James, > > Did you have to remove the relationship validations on the tables to bring the data in? Specifically, how did you get around the fact that the salesOrder in the salesId did not exist in the SalesTable? > > > mcaConnect > Michael Franchino > > Office: 973-726-8809 X214 Mobile: 201-213-6079 Fax: 973-726-4552 > www.mcaconnect. net > Gold Certified Partner-Inner Circle Member > Microsoft Dynamics AX--People Ready Software > > From:Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of James Flavell > Sent: Monday, April 13, 2009 9:37 PM > To: Axapta-Knowledge- vill...@yahoogro ups.com > Subject: RE: [Axapta-Knowledge- Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 > > > > > > Hi Michael, > > I have loaded sales and purchase invoice directly into the cust/vendinvoicejou r and lines. The one thing to note is the cost is not available since this comes from inventtrans (which I did not bother to create). > > If the customer wants the cost (usually they will be willing to accept without if you tell them how much more it will cost) then either you have to create inventtrans records (possible either via code or via import data as SO and post invoices) or just modify so that there is a new field on the invoice lines called 'historical cost' and then modify the cost method on the lines such that if there is zero cost returned from inventtrans search then return the value in the historical cost (I have not done this but looked at doing it and it should be a nice and clean mod from what I saw of the code) > > All the best > Let us know what you decide on > Thanks > James > > > > ________________________________ > > From:Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of Michael Franchino > Sent: 14 April 2009 02:34 > To: Axapta-Knowledge- vill...@yahoogro ups.com > Subject: [Axapta-Knowledge- Village] Loading Legacy History (Sales Invoices & Vendor Invoices) to standard AX 2009 > I have 2 customers that wish to take their legacy history and load it into AX. They don't want to have us create separate tables to view/report on this data. They would like to be able to run standard AX reports for Customer Invoices/Vendor Invoices. > > Has anyone successfully loaded this type of history into AX from a legacy system? >