x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 13 replies
  • Answers 3 answers
  • Subscribers 47 subscribers
  • Views 4397 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
beauneorders

Error when Importing Sales Orders

SOLVED
Posted By

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. 

  • 0 in reply to beauneorders

    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

  • 0 in reply to Vince Settipane

    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!

  • +1 in reply to Vince Settipane
    verified answer

    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

  • 0 in reply to Coleen Graber

    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?

  • 0 in reply to beauneorders
    SUGGESTED

    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

Reply Children
No Data

*Community Hub is the new name for Sage City