In Sales order, user wants to use Valid from and Valid to date range

[Former Member]

Dear All,

Can you please guide me how I can enter Valid from & Valid to date range in SD Sales order? As per user requirement, they do not want to create Contract for this but direct Sales order by maintaining validity period. I do not know how to do this. Please guide me for this.

Thanks & Regards,

Saurabh

[Former Member]

Hi Saurabh,

just activate the billing plan in sales document type which will give the billing plan tab in sales order- Header. there you can you can enter the start date and end date.you can also go for further developments where you can also stop creating delivery or invoice creation further.

regards

Manohar

[Former Member]

Hi Saurabh ,

You can use the Rental Contract (MV) in VA41 for your requirement. You can gave billing plan for it.(Item Category MVN). try it out. You can generate the invoice from the Rental contract (MV).

Regards

Vinu

[Former Member]

Request to please close this message as it is resolved now.

Thanks a lot to all,

Saurabh

[Former Member]

Hi Sourabh

Can you please share with forum what did you do to resolve .it will help us to enhance our skill as well.

Regards

Sapsd

[Former Member]

Hi,

We had done Z-development in User exit for Additional Data B tab to include Valid from & Valid to date in Sales order with the help of ABAPer. Is there any option to close the issue which I raise in the forum?

Thanks & Regards,

Saurabh

[Jelena]

There is no Post Closing Fairy, unfortunately. Please mark the post as 'Answered' yourself and mark the helpful replies.

[former_member184555]

How is the billing done in your process? Is it through VF01, VF04 or through any scheduled job?

[Former Member]

Hi Saurabh,

This is not available in Standard SAP.  You can develop this using user exits :

First take the below inputs:

After the validity End date :

1. Delivery creation to be stopped?

2. If Delivery created but not yet processed....do we need to stop this also?

3. If PGI is dont and Invoice is not generate....do wew need to stop this also?

After getting answers for the above questions.

1. Define 2 date fields in the sales order Additional Data A screen

2. Make these fields as mandatory fields in your sales order entry screen

3. During Delivyer creation/PGI/Invoicing (as per the above requriements) you can check the validdity from and to dates from the sales order table and you can stop processing any of the documents.

Hope this helps in resolving your issue.

Regards

Raju

[Former Member]

Dear Raju,

We need to define Valid from & Valid to field as agreed in Additional data tab "A" or "B". But this is sales order related Billing and no delivery. Please suggest.

Regards,

Saurabh

[former_member184065]

Hi,

If Don't mind Please share your total scenario.Without scenario ,how to process it.

Thanks,

Naren

[jignesh_mehta3]

Hello Saurabh,

Firstly there is not SAP Standard solution to have Valid from & to dates in Sales Order. You will have to go for enhancement as suggested above.

But, since you have a Order to Billing scenario (without delivery), why not go for Contract - Billing Scenario by using Periodic Billing?

Thanks,

Jignesh Mehta

[Former Member]

Dear Naren,

As per User requirement, they have weekly to fortnighly data in the form of some Net values. Based on the weekly data, they will bill Customer based on Validity period range thru Sales order and then raise Invoice. But the issue is how to maintain Validity period in Sales order. If we can do that then User will bill Customer as per their Net values of their validity period. Please help.

Regards,

Saurabh

[Former Member]

Dear Jignesh,

Yes, It is order related billing. Can you please elaborate what is the process for Contract to direct raising Invoice for say 1 week or 2 week based on User requirement in the validity period?

Regards,

Saurabh

[jignesh_mehta3]

Hello,

As mentioned earlier, you case can be done with Periodic Billing in Contracts. You do not need to create Sales Order. The document flow will be Contract - Invoice.

As far as dates are concerned, they can be manually entered in Contract or pull from external system thru some enhancements.

Thanks,

Jignesh Mehta

[former_member184065]

Hi,

1. Just create a Contract through VA41 (Maintain the Condition record with Validity Periods before Create a Contract).

2. Create a Sales Order with Reference to Contract ( before Maintain the Copying Control b/w sales Order and Billing).

3. Create a Billing with reference the Sales Order in VF01.

If you have any Queries ,Please let me know.

Thanks,

Naren

[Former Member]

Dear Naren,

It is either billing directly from Contract or else, Sales order to bill. Contract to Order to Invoice is known but User wants direct from Order to bill or else, if any process related to Contract related direct Billing.

Regards,

Saurabh

[Former Member]

Hi Saurabh,

If this order related billing, it is much simpler.

It means that Billing should not be allowed, if the order is not in the validity.  If that is the case, you can achienve this by :

1. Add 2 fields in Additional data A ta (Valid from and To)

2. Store this data in VBAK table

2. In Sales Order to Billing Document copy control requriement routine add the logito check the valid from and to dates.

3. This requirement routine will stop the Billing document creation.

Hope this helps.

Regards

Raju

[jignesh_mehta3]

Hello Saurabh,

Just search the forum - Periodic Billing Plan & you will get all the necessary information on Contract - Invoice.

Thanks,

Jignesh Mehta

[former_member184065]

Hi ,

In sales Order doesn't have validity Periods.

This has been Demonstration in previous also by Mentors.Most of the People give the Validity periods with reference of the Contract for Sales Order.

Thanks,

Naren