Importing items quantity, table 83 item journal line

whynotwi

as we are setting up a new company i have to import the quantity of items from our old system.
So far i have extracted the data from the old database and have inserted them into table 83 (item journal line). The number of items and the quantity seems to be fine. I'm just unsure about the fields "Quantity (Base)" and "Invoiced Qty. (Base)". Have both fields to be filled with the quantity ? Or do they have to be 0 ?

thanks in advance

kine

From your question I can see one thing:

you have not used VALIDATE function and you are assigning the values directly. Else the "Quantity (base)" will not be 0. This field is the main which must be filled in, not Quantity. If you fill only quantity and not quantity (base), the posting will be wrong. But the Quantity (base) will be automatically filled in when validating quantity or unit of measure, because it is calculated based on the selected UoM. I recommend to do one test:

fill one line in the journal manually with data you need to enter, look into zoom, compare the zoom with zoom of line imported through import. Check the differences. If all is same, good. If not, you need to think what is wrong. And do not forget that sometime you need to write into different tables too (in most cases the validation and other triggers should handle this).