Skip to Content
author's profile photo Former Member
Former Member

How to use negative price and positive quantity in sales order

Hi, all!

I have an application that exports sales orders to SAP b1 database - I use the DI API pl36 for that purpose. What I want to do is to export some of the sales order lines with negative totals. I found out that if I set the quantity field of an order line to a negative number and then set the "single item price" of that line to a positive value then I get in a negative line total. Then I tried to set line quantities to be positive and single prices to be negative because negative quantities in a sales order sound strange. It did not work - to my amazement the order lines once more had negative quantities and positive single prices (SAP b1 somehow switched the negative sign).

How can I achieve that quantities stay positive and prices are negative?

Thanks in advance

PS: The SAP B1 client application itself does not allow to set a negative single price for an order line - tried it and got an error message saying "Invalid total". Are there any settings that block this behavior?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 02:11 PM

    This is just the SBO business logic - negative quantities possible, yet negative prices not possible.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.