Canada
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...@mcaconnect.net>
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
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?