Import Data to new Sales Quotation with DTW

[Former Member]

I'm hoping someone can advise me on the correct procedure of importing the body & rows of a new sales quotation document using the DTW.

Using the templates oQuotations\Documents.xlt and oQuotations\Document_Lines.xlt I have a macro that copies cells from an Excel sheet into these .xlt forms and saves them as Filename (Body).txt and Filename (Rows).txt.

When importing these files into DTW on the 'Choose Data file(s)' screen I have selected the Filename (Body).txt file for the 'Documents' and the Filename (Rows).txt for the 'Document_Lines'. When these have processed, the DTW shows an error of "1 item not imported" and the following in the error log:

No - Status - Key - Reason

1 - Created Failed - / - Invalid total (OQUT.DocTotal)Application-defined or object-defined error65171

What is this error message saying? I have added a figure in the DocTotal field and the same appears... I'd prefer not to add the DocTotal during the import of the Body as the Rows document has all of the figures associated with it.

Many Thanks in advance.

[Former Member · Accepted solution]

Hi Garry

Is this a newly implemented Database? If so, a common problem is that you forget to create periods for previous year/(s) for importing. The other common error is adding account determination to the current year only and not creating for previous years too. Check the above 2 items and let me know if you still have an error.

Kind regards

Peter Juby

[Former Member]

Hi Garry

Are you using the price field or Unit Price. Please use unit price on the rows and let me know if this solves the problem.

Kind regards

Peter Juby

[Former Member]

Thanks Peter,

I have amended the sheet so that the cost is in the UnitPrice field.

This seems to have helped a little, but now DTW returns this error:

No / Status / Key / Reason

1 / Created Failed / / Non-Valid PeriodApplication-defined or object-defined erroroQuotations

Any ideas on what's the next step?