View source | Discuss this page | Page history | Printable version   

How to Manage Prepaid Invoices in Receivables

Contents

Objective

There are companies which do not wish to extend credit to specific customers:

In this situations a particular payment term is agreed upon the parties which implies a total or partial payment of an order or an invoice, otherwise the goods will not be delivered to the customer.

It is important to remark that a sales invoice created from a prepaid sales order will inherit the order payment information whatever it is.

Recommended articles

Managing prepaid invoices requires a clear understanding on how to create a Sales Order and a Sales Invoice as well as how to register a Customer Payment.

It is recommended as well to understand how to setup a Payment Term and how to launch the Payment Report.

Order prepayment: execution steps

In Openbravo, the company in this example will have to agree a specific payment term with its customer, create a sales order for the goods requested and then register a partial payment of the order before issuing later on the corresponding sales invoice.

Payment term configuration

As already mentioned, the company in this example needs to create a specific payment term to reflect what was agreed with its customer.

A "Prepay" payment term can be created as shown in the image below:

Invoices in Receivables01.png

Above means that the customer will have to pre-pay a 50% of the total order amount and the rest 30 days after the invoice date.

Please note that, prepay payment term has a header and a line:

Sales Order creation

As already mentioned the first step is to create a Sales Order according to the customer needs.

In this scenario the parties have agreed a specific payment term which can be filled in the corresponding field of the sales order header.

Invoices in Receivables02.png

The main field it’s needed to take into account when managing prepayments is the field Invoice Terms which needs to be selected as “Immediate”, otherwise it would not be possible to prepay that order. In Openbravo that means that the order will not be shown as a suitable order to be paid in the payment in window where customer payments are registered.

Once every required data is filled in, the Sales Order need to be Booked as every time an order is completed a Payment Plan is created for that Order.

In other words, it is not possible to record payments against orders which are not completed and therefore do not have already a payment plan linked to them.

Payment creation and accounting

Payments received from the customer are registered in the payment in window. Openbravo allows to register customer payments received againts sales orders and/or invoices.

The main fields to fill in the header section of the payment in window are:

Invoices in Receivables03.png

Then, it is possible to register customer payment details by using the process button named “Add Details”.

A new window is shown named "Add Payment In" where it is required to specify the "transaction type" to which the payment is related to, that could be orders and/or invoices.

The company in this example needs to choose "Orders" and then the order which is going to be partially paid.

Invoices in Receivables04.png

Note that in the "Add payment In" window:

Once everything is filled in, press the button Process.
The payment is recived and deposited in the bank at the same time, that means that a deposit transactions is created in the Financial Account window, in the "Transaction" tab.

Just created payment can be post in the Payment IN window by pressing the process button Post if:

The posting will look like:

Account Debit Credit
In Transit Payment In Account 863.20
Customer Prepayment 863.20

It is possible to check once more the Payment Plan of the sales order in this example.

The sales order payment plan includes now the payment registered in the Payment Details tab.

Payment check

Back in the Sales Order, it’s possible to check the recently created Payment Plan with its Payment Details.

Invoices in Receivables05.png

To summarize:

Pre-Paid invoice management and accounting

There are several ways to create a sales invoice from an order, one of those is Create Invoices from Orders.

This process allows to enter data such as the business partner and a given data range to narrow down the orders to be invoiced.

Invoices in Receivables06.png

Once a Sales Order is selected the process button automatically generates the corresponding invoice.

The invoice created will inherit the payment plan of the order.

In this example:

Invoices in Receivables07.png

Above situation it is also reflected in accounting, as purchase invoice posting will look like:

Account Debit Credit
Customer Receivable 863.20
Customer Prepayment]] 863.20
Product Revenue 1,660.00
Tax Due 66.40


There is a report named Payment Report which allows to monitor every payment received or made.

In this example this report shows in an intuitive way:

Invoices in Receivables09.png

In this example, the last step is to register the customer payment of the invoice, 30 days after the invoice date. A payment received from a customer can be registered in the system two ways:

Invoices in Receivables10.png

Once this new payment is processed the sales invoice changes to fully paid. In other words the "Payment Complete" check box of the invoice is now selected.

Invoices in Receivables11.png

Finally, the "Payment Report" shows now the invoice as fully paid, in Openbravo terms it is shown as "Deposited not Clear".

Invoices in Receivables12.png

Invoice prepayment: execution steps

In Openbravo, the company in this example will have configure a payment method which allows to post the prepayment as soon as it is received, create a sales invoice for the goods requested by its customer and register the prepayment of the invoice earlier than the invoice date.

Payment method configuration

The payment method to be used needs to be configured in order to allow the posting of the prepayment as soon as it is received, therefore the "Deposited Payment Account" can be specified in the field "Upon Receipt Use".

PaymentInconf.png

Note that the checkbox "Automatic Deposit" is also selected. That means that the payment received will be automatically deposited in the financial account.

Sales invoice creation

First step is to issue the sales invoice dated on October 30th, 2012 for instance. The issued invoice can be completed as soon as it is properly filled in.

SalesInv.png

Payment creation and accounting

Next step is to register the prepayment of the invoice in an earlier date than the invoice date, for instance October 15th, 2012.

Above is done by using the "Add Payment" button. The "Payment Date" field needs to be modified as required.

PrepaidReceivables AddPayment.png

Once processed a payment received is created in the "Payment In" window and besides the deposit of that payment is automatically registered in the corresponding financial account.

The payment received can be post from the "Payment In" window.
Payment receipt posting looks like:

PosPaymentIN.png

Above posting reflects the moment in which the customer receivable is cancelled by the prepayment, which is also cancelled by the recognition of the payment deposit.

Sales Invoice posting

Last step is to post the sales invoice to the ledger.

Invoice posting looks like:

PrepaidReceivables InvoicePosting.png

Above posting reflects the moment in which the customer receivable is accounted, however customer receivable is already cancelled by the prepayment.

Result

This completes the creation and processing of:

Retrieved from "http://wiki.openbravo.com/wiki/How_to_Manage_Prepaid_Invoices_in_Receivables"

This page has been accessed 20,822 times. This page was last modified on 12 December 2012, at 10:08. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.