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

Regarding third Party Sales scenario

Hi Friends,

We have a problem regarding third party sales.

The process that we follow for third party sales is a standard one in which we create the Sales Order - PR - PO - GR (optional) - IR and the sales invoice.Initially in our Business a material may be manufactured internally or the same material can be procured from outside. Hence the item category group of the material has been maintained as BANS so that the system determines TAS as the Item Category in the sales order while it can also be changed to TAN if and when required.

When we create the Third Party sales order and enter the material the system automatically determines TAS. Recently however business has decided that material procured from outside will never be manufactured inside and viceversa. This means that the item category of a material which was both procured from outside and manufactured internally was being changed manually in the sales order is to be stopped. Now since there are large number of users involved the training that was imparted to the users regarding the change in the item category not to be done was not carried out properly. Because of this reason many users were still changing the item category from TAS to TAN and the other way round frequently.

Now to overcome this issue a user exit was (even though a simple configuration change would have sufficed) used based on the following criteria:

When the Sales Order Type: OR

Item Category group : BANS

The item Category will always be : TAS

And

When the Sales Order Type: OR

Item Category group : NORM

The item Category will always be : TAN

This means that if a user as a habit changes the item category manually in the sales order from TAS to TAN , the item category will come back to TAS and viceversa. This is working fine however when a user tries to create a Invoice for these materials ( for which the user has tried to change the item category manually in the sales order from TAS to TAN or viceversa) the system throws an error which states that " No open Quantity exists for billing"

Can you please help me out on this issue as to why this error is coming.

Regards,

J Nagesh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jan 08, 2013 at 06:22 AM

    Hi Nagesh,

    (Incidentally my name is also Nagesh 😊)

    Yes ....I agree with JP that it is really surprising that you used User Exit to restrict the change of Item categories in the sales order. This could have been very easily achieved by controlling the Item Category Group in the material master.

    Anyway since you have already used a User Exit things may have got complicated since along with fixing the of the item category in the sales order you will also have to fix other relevant fields that go along with the Item category.

    Since you say that the error that you are getting is "No open Quantity exists for billing" this has got something to do with the incorrect billing relevance. As you said that users as a habit sometimes change the item category manually and the user exit comes back to the original one ...please check when the item category comes back to the original one is the billing relevance coming back the original as it should be? This could be the issue.

    Bye,

    J N Murthy.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi J N Murthy,

      Thank you...that indeed was the problem. The Billing relevance also used to get changed along with the Item category the first time around and when it changed backed to TAS the Billing Relevance used to remain as A instead of F.

      We solved the same by adding one more line in the existing user exit so that the system will always pick up the billing relevance assigned to the relevant Item Category.

      Thanks once again....it has solved a long existing issue!!

      Nagesh.

  • Posted on Jan 08, 2013 at 08:43 AM

    was being changed manually in the sales order is to be stopped

    To control this, in VOV4, leave the tabs "MItCa" as blank so that users can't do any manual change.

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2013 at 01:04 AM

    J Nagesh.

    Userexit? Surprising!

    Few observation.

    See, in your material master you can't have more than one Item Category Group Determination.

    When you have material relevant for 3rd Party sales, you have Item Cat Grp as BANS.

    Now, the Item Cat determination would be:

    Sales Order Type Item cat grp default Item cat m. Item Cat OR BANS TAS

    TAN

    But why this is required or relevant for 3rd Party Sales?

    If this controlled, automatically, user will not have option to change the item category in sales order.

    Now, for

    "No open Quantity exists for billing"

    Its very basic query related to 3rd Party Sales billing. And you would find many discussion related to this error message in SD Space.

    Kindly search. You can use search term as:

    - SAP Message no. VF032

    - SAP No open Quantity exists for billing

    Regards, JP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2013 at 03:35 AM

    i guess the reason of this error message is you put your code in a wrong userexit which means it do change the item category but the value coming from item category is still there

    take a look at the data consistence in your SO

    rds

    sl

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2013 at 06:47 AM

    Hi,

    you can also do in other way.create a seperate Sales order Type- Third party sales and do Item category Determination only for this Document type with combination of NORM and TAS.

    This Fecilitates the user of not changing the Item Category Manually in the sale order or changing the item category as BANS in the material master or using any user Exit

    This new doc type is only used for Third Party sales and not for normal sales.

    As per this the Schedule line-CS picks Automatically.

    Sivavasireddy

    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.