View source | View content page | Page history | Printable version   

Projects:Intercompanyinvoicing/Technical Documentation

The development of the module has been separated in three parts. First one consist on creating all the necessary fields and data. The other two consist on developing the necessary procedures to generate the matching orders and invoices.

Contents

Required new fields

Document Type window

Purchase and Sales Order window

Purchase and Sales Invoice window

Intercompany Orders

Create a new database procedure called INTERCO_CREATE_ORDER. This database procedure will be inserted in the C_Order_Post - Finish Process Extension Point. This way it will be called at the end of c_order_post. As for that, a new record has to be created in:

The database procedure has the following paramenters:

The database procedure will retrieve the following values trough ad_ep_instance_param table based on the given ad_ep_instance:

Procedure

This procedure has to create a new order when:

Once the order is created it has to be completed calling back the C_ORDER_POST procedure.

The only actions allowed for intercompany orders are, complete when is in draft status, unlock if there has been an error in previous processing and close when it is in completed status. Any other action has to raise an exception.

RAISE_APPLICATION_ERROR(-20000, '@ActionNotSupported@');

If the process fails it has to rollback the whole process, including the original order. This can be done raising an exception, doing a RAISE_APPLICATION_ERROR with an user friendly message.

Intercompany Invoices

Create a new database procedure called INTERCO_CREATE_INVOICE. This database procedure will be inserted in the C_Invoice_Post - Finish Process Extension Point. This way it will be called at the end of c_invoice_post. As for that, a new record has to be created in:

The database procedure has the following paramenters:

The database procedure will retrieve the following values trough ad_ep_instance_param table based on the given ad_ep_instance:

Procedure

This procedure has to create a new invoice when:

Once the invoice is created it has to be completed calling back the C_INVOICE_POST procedure.

The only actions allowed for intercompany invoices are, complete when is in draft status and close when it is in completed status. Any other action has to raise an exception.

RAISE_APPLICATION_ERROR(-20000, '@ActionNotSupported@');

If the process fails it has to rollback the whole process, including the original invoice. This can be done raising an exception, doing a RAISE_APPLICATION_ERROR with an user friendly message.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Intercompanyinvoicing/Technical_Documentation"

This page has been accessed 2,969 times. This page was last modified on 8 June 2012, at 05:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.