I am attempting to import vendor invoice history from mas90 through the general journal in Navision. I have already imported the vendor master file with no problems and have gotten the invoice history as far as the journal. My problem is that when posting, there are many invoices that have the same document number assigned to them and the same posting date(for example, when entering expense checks for employees through A/P, the accountant used the date as the invoice number. What is the easiest way to correct this and allow the invoice history to post without causing problems when I bring in the payment history. I have tried making external doc number not mandatory, but this still did not help. Thanks Amy
Making a unique document number is probably the best solutions. The user can still find the invoice by date since Navision has “any field” searching. Jim Hollcraft NCSD, NCSP, MCSE, CNE, MCP, MST aka Skater http://drilldot.com Unauthorized Navision News
Jim, Thank your for your prompt response. What will need to be done on the payment history import to make sure that I do not end up with a huge mess and no way to quickly apply the payments to the correct invoices. AJ
With duplicate document numbers, you have a problem doing this anyway. Allowing import into Navision of duplicate document numbers will not making importing payment history easier. Jim Hollcraft NCSD, NCSP, MCSE, CNE, MCP, MST aka Skater http://drilldot.com Unauthorized Navision News
Dear Amy, I understand your problem. It takes lot of time and effort to recreate the old history invoice and make them unique. The easiest way is to block this code and then post the journal only for the opening entries and then deblock the code for the future. You can contact your solution centre for assistance. It may not be the correct way but it sure saves a lot of time and effort!! Rohith Kamath Senior Consultant The Naviworld Group
Thanks for all the help. To close, I found that Mas90 creates a sequence number when a duplicate invoice number is generated. I was able to modify my dataport to include this number as part of the invoice number. Thus, I was able to post the vendor history. AJ