View source | Discuss this page | Page history | Printable version   
Main Page
Upload file
What links here
Recent changes

PDF Books
Add page
Show collection (0 pages)
Collections help


How to Manage Prepaid Invoices in Payables



There are vendors which do not wish to extend credit to their customers:

In this situations a particular payment term is agreed upon the Company and the vendor which implies a payment against a Purchase Order or Purchase Invoice, otherwise the vendor will not deliver the goods to the company. The parties could agree a total prepayment or a partial prepayment.

Please note that a purchase invoice created from the prepaid purchase order will inherit the payment information whatever it is, whether it is a total prepayment or a partial prepayment.

Recommended articles

Managing prepaid invoices requires a clear understanding on how to create a Purchase Order and a Purchase Invoice as well as how to register a Vendor 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 acknowledge a specific payment term agreed with its vendor, create a Purchase Order and make a payment before the goods are delivered to it.

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 vendor.

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

Invoices in Payables01.png

Above means that the Company will have to pay, a 25% of the total order amount and the rest 30 days after the vendors Invoice Date.

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

Purchase Order creation

As already mentioned the first step is to create a Purchase Order which contains the goods that the company needs.

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

Once every required data is filled in as appropriate, the Purchase Order needs to be booked as every time an order is completed a Payment Plan is created for that Order.

HowToManagePrepaidInvoicesPayables PO.png

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 made to a vendor are registered in the payment out window. Openbravo allows to register vendor payments created against purchase orders and/or invoices.

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

HowToManagePrepaidInvoicesPayables PaymentOut.png

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

A new window is shown named "Add Payment" 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.
Once done the amount to pay is shown as not editable in the field "Actual Payment Out".

HowToManagePrepaidInvoicesPayables AddPayment.png

Note that in the "Add payment Out" window:

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

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

The posting will look like:

Account Debit Credit
Vendor Prepayment 206.25
In Transit Payment Out Account 206.25

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

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

Payment check

Back to the Purchase Order, it is possible to check the recently created Payment Plan with its Payment Details.

HowToManagePrepaidInvoicesPayables POPaymentPlan.png

To summarize:

Pre-Paid invoice management and accounting

The company in this example can register the Goods Receipt before registering the vendor invoice by using the process Pending Goods Receipts.

This process allows to introduce the exact amount of goods received from the vendor against each purchase order line.

HowToManagePrepaidInvoicesPayables PendingGR.png

Once processed Openbravo informs about the Goods Receipt number just registered.

Next step is to enter the vendor invoice. There are several ways of entering a vendor invoice.
The company in this example uses for instance the process "Create Lines From" which can be found in the Purchase Invoice window. This process can be used once the purchase invoice header information has been properly entered. It retrieves either order or goods receipt information to be copied to the being entered invoice.

HowToManagePrepaidInvoicesPayables PI.png

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

In this example:

HowToManagePrepaidInvoicesPayables PIPayment.png

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

Account Debit Credit
Product Expense 825.00
Vendor Liability 618.75
Vendor Prepayment 206.25

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:


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


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

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


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 made, create a purchase invoice for the goods required 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 made, therefore the "Withdrawn Payment Account" can be specified in the field 'Upon Payment Use'.


Note that the checkbox "Automatic Withdrawn" is also selected. That means that the payment will be automatically withdrawn from the financial account.

Purchase invoice creation

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


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.


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

The payment can be post from the "Payment Out" window.

Payment posting looks like:


Above posting reflects the moment in which the vendor liability is cancelled by the prepayment, which is also cancelled by the recognition of the payment withdrawn.

Purchase Invoice posting

Last step is to post the purchase invoice to the ledger.
Invoice posting looks like:


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


This completes the creation and processing of

Retrieved from ""

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