cancel
Showing results for 
Search instead for 
Did you mean: 

Invoiving at the Month End

Former Member
0 Kudos

hi all,

My Requirement is I want to do the Invoicing only at the month end even though my order has been raised at the begining of the month. The system should pick up billing date only on the last day of the month.

I have tried the Periodic Billing Plan option. Billing date is at the end of the month but the amount is getting distributed over the 12 months period depending upon the net vaklue of order which should not happen. Is there any setting that the same order value should be there in all invoices. as per my experience this is not possible in billing plan.

Also i have maintain the Factory calender in the Customer Master Record but I am not able to have the biiling date at the month end. System is only picking up required delivery date.

Please suggest me neccessary settings.

Thanks,

Farhan.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Prashant

Try the following :

If, for example, a customer wants to consolidate the invoices you send out, you can predefine the billing schedule in a calendar in the system. During billing, the system automatically proposes the appropriate billing date from the calendar.

Procedure

The system proposes the billing schedule from the customer master record of the payer. You can change the value manually in the sales document.

with regards

Sundar

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

For this,we have two options.

1.Manually,maintain the billing date as the date required for you.Here also in two ways we can do this.

One way is:Goto the T.Code "VA02".

Enter your order number.

Goto Header-->Billing Document.

Maintain the billing date as the date required for you.

Save.

Create the billing document by using VF01/VF04, the billing date will be the date maintained in order.

Another way is:While creating the invoice,manually enter the billing date as teh date required for you in the over view screen.

2.By implementing an ABAP code.

Write an ABAP code for this such that the billing date id defaulted as a particular date.

Ask your ABAPer for this change.

Regards,

Krishna.

Former Member
0 Kudos

hi

assign the factory calender "AM" in the "Invoice list" field for the "Payer" only.When you crete th Billing document, system will automatically take the last date of the month.

Create billing document in VF04 for collective processing.

Former Member
0 Kudos

hi

I hsve maintained the AM Entry in CMR but still when I have raised the sales order and billing still the system is picking up billing date as required delivey date. Shall i remove the tick from Propose delivery date in VOV8 settings and then try to to the blling again.

I am raisinfg the standard sales order and stahndard invoice F2 without billing plan.

Thanks,

Farhan

Former Member
0 Kudos

Hi

Even if the propose delivery date is activated,it will not affect.

But, first you check, who is your "PAYER". The factory calender "AM" must be assigned to the customer master of the PAYER in the "INVOICING DATES" field. No other settings are required.

You can find the payer,in the sales order at header level > partner function tab or you can check the Customer data of your Sold-to-party.

Whoever is the Payer, assign the factory calender to his master data.

After assigning the Factory calender to the Payer, create a new Sales order and proceed.

Edited by: pradyumna on Oct 29, 2009 7:07 AM

Former Member
0 Kudos

Hi,

My Payer and Sold to Party are same. I have checked that also. Even when i am rasing the sales order and billing system is picking up Billing date depending upon lead time mentioned in sales order.

Shall i make changes in Factory Calender.

Regards,

Farhan.

Former Member
0 Kudos

Hi,

Create a new factory calender in OVR3 tranasction code or SCAL with only the last day as working and remaining all as Holidays.

Assign this to the Customer master PAYER-->BILLING TAB->INVOICE DATES

Then it will work.

Or else,

If you want to do it automataically, schedule the Job for SDBILLDL program on every month end.

So this job will pick all the documents which were pending till that date and generates the Billing.

Try any of the above and revert back if it resolves.

regards,

santosh

Former Member
0 Kudos

Hi Santosh,

I have created one Factory Calendar Z8 and I have mentioned the Sunday as working day. I need one clarification from you.

My invoice date should be the month end date. Also Do I need to mention Holiday Calendar ID. When I am trying to save it is askling for Holiday Calendar ID. If yes which one should I select.

Thanks.

Farhan.

Former Member
0 Kudos

Hi,

There is no need to maintain Holiday Calendar ID.

Can you check if you have configured the calender correctly? Go to display of calender and display year. check only month end day should be working. other wise the solution suggested will not work.

I think you will have to define special rules to make last day of month as working in the customized factory calender Z8.

Thanks.