Error when Importing Sales Orders

SOLVED

Hello All, 

I am trying to import sales orders created from a third party. All works as it should, except when adding a discount to a line item. I get an error that says "ERROR: Line item extended price must be equal to line item unit price times line item order quantity". This is only when applying a discount. I can see in the text file that the math is correct, though it wont import. 

I thought it might be the third party software, so I made an order in Sage, exported it, and tried to import it as is. The orders that do not have any discounts import correctly, though the lines with discounts give the above error. 

Any help would be appreciated! Thanks!

Parents
  • 0

    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

  • 0 in reply to Vince Settipane

    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. 

Reply Children