Hi Guys/Dolls merry xmas

Version: NAV 2009 SP1
Database:SQL
I am trying to import details from a spreadsheet to import Sales invoice lines. The import creates A header and lines into the Sales Header and Lines table. The spreadsheet provided also has VAT values which I cannot import in? When I calculate with NAV there is rounding differnces.
Is there anyway I can import the VAT value and keep this fixed. Also to be a pain some invoices have settlement discount.
thanks for your help. This is a horrible one.
Thanks
ADARTIHS
Comments
Why? are you getting an error or something?
Have you tried importing that value into a variable and then mapping it to it's proper field?
Validate(Taxfield,Your Variable);
http://www.BiloBeauty.com
http://www.autismspeaks.org
For "screw up" i mean that nav has its own logic, and based on it, it calculates the vat, but when interfacing with external programs, you usually want the data to be perfectly the same in nav and external system, and this is hard to do when facing with vat differences and roundings. The only method i found (it's really odd, but it works fine) is to force all the values in: here's the code (put it in the loop for the lines). before reassigning the values, remember to run
lCUReleaseDoc.PerformManualRelease(lTBSalesHeader);//lCUReleaseDoc is Release sales document codeunit
I know that's not the way nav works, but we couldn't find another way...if there's one and someone knows it, please suggest it to us
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog