Warrenty Invoice Tracking

[Former Member]

I am facing a problem in developing a new report at ABB. let me explain the scenario.

Requirement from the customer:

Aim: For confirming warranty of a product, as per Warranty Policy, products are under warranty for 18 Months from Date of dispatch. Each module is traceable using Sr. Number.

Input : Serial No

Output: Material number, Sales Order No, Invoice No, Invoice date and LR details.

Business Process

1. Client is selling a product (module) directly to customer, that module having one-year warranty period.

If customer returns the module they have to find whether that module's invoice date falls within the warranty period.

Currently there are finding the invoice date through IQ03 (Transaction) History. that module having serial number and while receiving that module from customer they know only serial number, from that serial number they want to identify sales order number, invoice number and invoice date.

In this case since the module is directly linked with sale order, we can find sale order number from VBAP table and Invoice Number and date from VBRP and VBRK tables.

2. In some cases that Module is fixed in a panel and sales order is created for that panel.That module has defined as a component in the BOM of the Panel .They are not maintaining serial number for panel.Customer is returning module alone without panel to the client due to some complaint. As per client there is no data available from customer, except serial no of that module.So they have to find out in which sales order they used that module and have to find the invoice number and date for that order.Serial no is unique for that plant and the same module has been used in many number of Panels.

Here we unable to find out the Panel no, for which that particular serial number& module number combination has been issued.In display of a material document for a GI to a production order we can able to see the serial numbers and production order no.But we are unable to find the table relationship between serial number and production order.If we find the production order no. from that we can find sales order and other parameters.

That module is an external procurement item.While making GRN with 101 movement type,for a purchase order they are using barcode scanner and serial number generated in backround.

Referred tables

EQUI,OBJK,SER03,SER05,SER00,SERI,MSEG,AUFK,AUKO,EQSE,RESB,STPO,MAST,VBAP,VBRP,VBRK

If any of you has come across this scenario or if there is any other solution for this, pls.let me know.

Pls.revert back for further inputs regarding this.

Regards

Usha

[Former Member]

Hello Usha,

It looks u will have to study the req. carefully but from what I gather, can we do this way. If we create an custom table which will hold plant wise WR no wise SO. After this u need to enhance the SO screen to update this Custom table.

So when u get the module, u get the SR no from which u will be able to get the SO from our table and so on .. Also u can add warrenty date by enhanceing the So screen and updating this field when u invoice.

Second case is module is part of Panel. here also u will be def the module as BOM component in SO and our table will hold the WR no. So when u get back ur module u will be able to connect the SO number and the module through our table.

Hope this might have give u some direction.