cancel
Showing results for 
Search instead for 
Did you mean: 

Sales order amount and Invoice amount

Former Member
0 Kudos

Dear all,

         i have a requirement, My client create one sales order for 10000, and they will create invoices w r t sales order for 1000, they will change the amount manually, they will create "n" number of invoices, but my client want total invoice amount should not more than sales order amount, is there any standard customization is there, please let me know,

for example

  sales order --- Rs.10,000        ----------->             Invoice-1 ----  Rs 1000

                                                                         Invoice 2 ----  Rs 1000     

                                                                        Invoice 3 ----  Rs 1000

                                                                         " "

                                                                          " "

           

                                                                        Invoice 10 --- Rs 1000

                                                                                          _________

                                                                                      

                                                                          Total          Rs.10,000

                                                                                  

Thanks

seshu

Accepted Solutions (0)

Answers (5)

Answers (5)

moazzam_ali
Active Contributor
0 Kudos

Dear Mattupalli

For this there is no standard way to control. You have to write your logic in program RV60AFZZ and user exit USEREXIT_PRICING_PREPARE_TKOMK. Please tell your ABAPER this logic and he will write logic as when ever billing document will be created system will go to its source document e.g Sale order and then system will check already created invoices w.r.t this sale order and there accumulative value. If accumulative value NETWR-VBRK is greater than sale order value NETWR-VBAK then You know what to do

Thanks

Former Member
0 Kudos

Set the copying control at item level, field Pos/neg quantity to +.

You can configure that through IMG>Sales and Distribution>Billing Documents>Maintain Copying Control for Billing Documents.. Select copying control for Sales Doc. to Billing Doc.

Thanks,

former_member182378
Active Contributor
0 Kudos

The effect of quantity in the target document (billing document) on the quantity or value in the source document can be set in VTFA, item level, field Pos/neg. quantity

If you can change quantity (that would inturn change value) in the billing document (rather than value in billing document, as you have mentioned), this could be a standard configuration.

former_member211616
Active Contributor
0 Kudos

You can Use the user EXit  for this

former_member211616
Active Contributor
0 Kudos

Hi Seshu ,

can u clarify r u going to change the old invoice now ? or u want to have the blocking to change in invoice ???

Regards

Ramesh

Former Member
0 Kudos

Hi Ramesh,

            Against one sales order they will create so many invoices, but the total amount of all invoice value should not exceed sales order amount.

Thanks

seshu

jignesh_mehta3
Active Contributor
0 Kudos

Hello,

You can control Quantity from Sales Order which means that if you have Sales Order for 1,000 & if you create multiple Deliveries then total quantity of Deliveries cannot be more than 1,000.

But when it comes to Amount there is not control in SAP Standard.

You will have to write a ABAP code in User Exit RV60AFZZ which will check for Sales order & all the Invoices created till date & compare the total Amount.

Thanks,

Jignesh Mehta

Former Member
0 Kudos

HI Jignesh Mehta,

         Thanks for your reply, As of now we are not creating delivery, and is there any standard way to control that.

Thanks

seshu

jpfriends079
Active Contributor
0 Kudos

One of the standard way of controlling this can be through Item Category's Completion Rule.

Where you can have Completion Rule as option E; Item is completed after full target value is referenced.

But might not be help or controlled on header doc level.

Former Member
0 Kudos

HI prakash,

     Thank you for your reply, system is not allowing me to put completion rule E, as system is telling it is only for billing plan, is there any way to put completion rule E for normal order related billing.

Thanks

seshu

jpfriends079
Active Contributor
0 Kudos

in that case, why don't you try for value contract based sales process.