?
Solved

How to delete Sales Orders having billing transactions (invoice)?

Posted on 2003-03-10
5
Medium Priority
?
2,493 Views
Last Modified: 2013-12-08
The Sales Orders (tables: VBAK, VBAP) having discount which base on rebate agreement were WRONGLY created. The status of the Sales Orders are 'Open'
and invoice(tables: VBRK, VBRP), billing transactions were also WRONGLY generated for them.

It is easy to delete a sales order not having billing transactions.
But, How to delete a Sales Order which already had billing transactions?
I have tried to use the transaction code, VF11 to delete the Billing transactions from the tables, VBRP and VBRK. But, the transactions didn't be deleted and other billing transactions which used to cancel the billing amount were created. The invoice couldn't be deleted so the sales orders also  couldn't be deleted.

If any Sales Order having invoice, is it no way to delete them?
Please suggest if any other method can solve this problem.
0
Comment
Question by:leo_wh_cheung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:sharadd
ID: 8108187
Hi leo,
If invoice documents are created for Sales Order then the sales order cannot be deleted.

If you try to delete invoice it won't delete the invoice also , instead it will create reverse invoice. Now this way your Sales order status will be open but you cannot delete this Sales order as it has some documents ( invoices ) linked to it.

If you want to use the same sales order number...
What you can do is you mark the items of this sales order as blocked for invoice, blocked for shipping ( if you have shipping for this item ) and then create a new item with correct values.

Now in reporting and printing of order you can discard the wrong item.

This sales order item status will remain open. If you want this status to be completed then you will have to update the status in table VBUP directly.

if you want to delete this sales order and do not want to use the same order number then

The second choice is you update tables manually. ( Though I won't recommend it ).

it is a very tedious process in which you will have to delete number of records in many tables. The tables you can find out in Archive object SD_VBAK.

The third choice is to try to archive this sales order.
Though I haven't tried it but I think you can try with options like not checking Accounting documents, not checking document flow records for this sales order.

I hope this will help you.

Sharad.

0
 

Author Comment

by:leo_wh_cheung
ID: 8109906
Hi Sharad,

The third choice that you mention:
Though I haven't tried it but I think you can try with options like not checking Accounting documents, not checking document flow records for this sales order.

Do you know what transaction code or any process to configure the document flow?

The sales orders(ZSB1) generated provision for the customers(no delivery is needed for those S/O). In the normal process, payment needs to be made for the provision in order to complete the payment cycle of the rebate process (transaction code:VB02).
The payments are not made to the customer because the sales orders were wrongly created. But, if I do so, the payment cycle cannot not be completed.
Is there any solution to complete the payment cycle without making the payment?

Leo
0
 
LVL 3

Accepted Solution

by:
sharadd earned 2000 total points
ID: 8116785
Hi leo,
Document flow records are in table VBFA.

To archive SD sales order use transaction SARA and in object name enter SD_VBAK. and follow the procedure of archiving.

This will delete Sales order but will not delete invoice documents ( table VBRK, VBRP ). As you have already cancelled the invoices ( ie. Negative posting ) I think you don't have to worry about the rebate processing as net invoice amount would be zero and there will be no rebate for these invoices. And as net invoiced amount is zero there won't be any payment.

If you are using SAP's standard payment run then you can run the payment run and see if there are any payment pruposal for this customer.


I hope this will help you.

If you need further help feel free to ask.

Sharad
0
 

Author Comment

by:leo_wh_cheung
ID: 8323915
Sharad,

Sorry for the late reply. The monthly payment cycle is OK! Thanks a lot!

Regards,

Leo
0
 

Author Comment

by:leo_wh_cheung
ID: 8323923
Sharad,

Sorry for the late reply. The monthly payment cycle is OK! Thanks a lot!

Regards,

Leo
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question