We are looking for a right way to write data into Navision: 1. Insert data into Navision by ‘Dataport’ 2. Use MSMQ Which way is better? And why? For data validation and integrity, which one is better? And whether data validation and integrity are important concerns in Navision while inserting data from another system? Thanks!
A lot will depend on the volume of data, it is often quicker to enter static data and opening balances by hand this way the customer takes ownership of the data, also they can tidy the data at the same time, things like address fields are often the wrong size or in the wrong columns and the Developers/Implementors end up tidying the data for the customer, which is fine until the Invoice hits the Customer or the project over runs. Static Data: Customers, Vendors,Items etc: These are fine by Dataport, remember to Validate things like Name/Description which will then fill in the “Search Name/Description”, best rule is to validate the fields as you would enter in the same sequence, if you was entering a manual record, being careful with Posting Groups and VAT Groups if used as these will set the Vat Rates and Posting Accounts. Quite often thier is the odd exception, which you will have to deal with. another tip is on before import record trigger , clear Variables and INIT; live Data: Dataport into the Journals or manual entry then check and post: Open Customer Ledgers etc: Create and Post the Documents or Journals. G/L Balances or History Journal balanced through a suspence account, exclude Debtor/Creditor and any other control accounts, if you are posting open documents, stock etc:. Inventory Through a journal, Important to get the costs right because the costs you Import when you run the adjust cost and post to the G/L will be the value of your stock. Then there are a lot of other tables which hang off of these which you need to enter by hand or Import!
David, Thanks for your answer! It is very helpful. I think I missed a important thing in my last statement. The reason we are looking for a right way to write data into Navision is that we want to integrate Navision and another system. The data exchange between these two systems is our concern. For my understanding, ‘Dataport’ transfers data in un-realtime, ‘MSMQ’ does in realtime. But for data validation and integrity, I don’t what is the difference?