I've tried to do an import also, in the DEMO company

I exported Quote 1791 from Capital Planners then edited it in NOTEPAD to be quote 1799 , no other changes

I then saved and tried to import back into DEMO, and the quote failed

Why?   The errors say the is a switch for discount in A/R not set (invoice Preferences)  and yes discount isnot checked by default

I then tried checking the discount ON and then reimporting and I still ERRORED

It is failing at the COST times QTY equals Extended price

Thanks for the info! Allow discount is checked for mine, so not sure that is the issue, as you when it is checked it still throws an error. 

Sage has to correct the import process for the SO and Quote, its in the math for checking the
Quantity * Sell Price = Extended (the error in the import report)

I think It should be
Quantity * (Sell price - Discount) = Extended

BTW  this goes back to the 2015 version

interesting- is there any hope that this will be corrected sometime reasonable? We are moving to a system where we will be importing orders more frequently, and if the error continues it will compromise efficiency!

I was also able to duplicate the problem and will write up for the Sage engineers.  One possible work around may be....since another program is creating the import file....and the price for the line item already include the discount and leave the discount blank.  Any thought or concerns with that work around?

Thanks

Coleen

I was also able to duplicate the problem and will write up for the Sage engineers.  One possible work around may be....since another program is creating the import file....and the price for the line item already include the discount and leave the discount blank.  Any thought or concerns with that work around?

Thanks

Coleen

Yes I believe this will be the way to go- though I look forward to a solution. With this work around, we will not be able to easily verify what discount that was given, without calculating it by hand. If the discount field was working as it should, we would simply be able to edit the order and change the discount as needed. 

In your experience, do these fixes take long to come into the product? Is it something that can be patched or updated on the fly or do we need to wait for a completely new version?

Beauneorders-

Unfortunately, for an issue like this, it would be hard for me to say.  However, I did send an additional note on this that this does affect everyone who tries to import with a line item discount.  If you would like to follow the Knowledge Base article, please refer to  #ID:88591 "Error: Line item extended price must be equal...."

Thanks,

Coleen