Regarding third Party Sales scenario

[Former Member]

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.

[former_member1190345 · Accepted solution]

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.

[Former Member · Accepted solution]

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.

[Lakshmipathi]

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

[siva_vasireddy2]

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

[former_member241366]

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

[jpfriends079]

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