Importing Sales Invoice History

Dynamics 365 for Finance and Operations/AX Technical Forum
1

I am trying to import sales Invoice history into Axapta via the Sales Journal and I cannot seem to get it right, I think I am going about it the wrong way. I am importing invoice history into the Sales table and Sales Line when I think I should be using CustinvoiceJour and custInoviceLine. Can anyone help with the best way to import Sales Invoice history or point me in the right direction Regards Newman

2

Hi Newman, If it not absolutely essential, I would just import only open transactions and balances. Any way, if you want to import sales invoice history, I feel the best way could be to - 1) import data into SalesTable and SalesLine tables (SO Order header and line) respectively 2) and to use SalesFormLetter class to post invoice. If you want some sample code, please drop me an email and I will send the same. Cheers, Harish Mohanbabu

3

Hi Newman, I just add some little extra: 1. Invoice data stored in CustInvoiceJour and CustInvoiceTrans table 2. If you import into SalesTable and SalesLine (this is the best way). Then use class SalesFormLetter.update() to post the SalesOrder. Khue Trinh