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-Village@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-Village@yahoogroups.com" > <Axapta-Knowledge-Village@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? >
