Kreye yon Fakti Preparasyon pou

Invoices in OpenBoxes (Purchase VS Prepayment)

In a traditional accounting system, there are many different types of invoices: Regular Invoices, Purchase Invoices, Accounts Receivable Invoices, Prepayment Invoices, and more.

As an LMIS (Logistics Management Information System) with limited accounting functionality, OpenBoxes only supports two types of invoices: Purchase Invoices and Prepayment Invoices.

Purchase Invoices

Purchase invoices are the standard invoice - this is the type of invoice to make a final payment on any good or service, and to mark that line as paid in the system. But purchase invoices can only be processed after an item has been shipped in the system. To learn more about creating Purchase Invoices, see this document: Create a Purchase Invoice.

Prepayment Invoices

For vendors that require prepayment, there needs to be a way to process a payment before the items have been delivered. That is where the prepayment invoice comes in. For purchase orders that require prepayment, users can process a special prepayment invoice that will show the payment made before they were delivered. After the items are delivered, a purchase invoice must be created to reconcile the prepayment against the final receipt (more details in the instructions below).

Indicating Prepayment on a Purchase Order

Fakti peman ka sèlman trete kont lòd acha ki gen yon tèm peman ki gen ladan peman. Si ou pa wè opsyon pou jenere yon fakti peman, edite tèm peman yo sou PO a pou reflete peman pousantaj la. Si ou pa gen tèm peman ki disponib, yo pral bezwen ajoute pa administratè ou lè l sèvi avèk enstriksyon yo isit la.

Create a Prepayment Invoice for ALL items

  1. To create a prepayment invoice, first open the Purchase Order (PO) that you need to prepay.

    Go to Purchasing > List Purchase Orders. Find the PO that you need to invoice and open the order by clicking on the order name.


  2. On the order view page, click on Generate Prepayment Invoice.
Generate Prepayment Invoice option on PO View Page

If you do not see this option, check the prepayment terms. The payment terms must be prepayment and the PO must be Placed for the Generate Prepayment Invoice option to appear.

Also check the Invoices tab to see if a prepayment invoice was already generated.

  1. Clicking on Generate Prepayment Invoice will automatically generate an invoice based on the PO lines and the prepayment percent in the PO terms:
Prepayment Invoice
  1. The invoice will show all lines on the purchase order, with the quantity to invoice and final cost applied based on the prepayment percentage.

    For 100% prepayment, the invoice will exactly match the PO. For 50% prepayment, the total value for each line will be 50% of the value of the PO, For 25% it will be 25% of the PO value, etc.


  2. Ensure that the invoice matches the proforma you received from the vendor, and press Post Invoice to register the prepayment.


  3. Kontrèman ak fakti acha, liy nan yon fakti ki afiche pa parèt tankou fakti sou PO la. Se peman an anrejistre, men liy yo pa montre kòm fakti ak konplè paske atik yo toujou bezwen resevwa ak peman an rekonsilye. Gade seksyon ki anba a pou ki jan yo rekonsilye yon fakti pri peman.

Edit oswa rollback yon fakti pri peman

Prepayment invoices cannot be edited because they are generated based on the information in the PO. If after generating an invoice, you notice an error, you will need to delete the invoice and recreate it after editing the PO to reflect the proforma.

  1. From the invoice edit page, press Save and Exit to go to the invoice view page.

  1. From the view page, press Delete to delete the invoice:

  1. Once you have deleted the invoice, go back to the PO and edit it, using the instructions for editing POs after posting in Edit a purchase order.
  2. Once the PO is correct, press the Generate Prepayment Invoice button again to restart the process.
  3. If the invoice is already posted, you must first roll it back and then delete it.

    On the invoice view page for a posted invoice, you will see a Rollback button. Select that button to move the invoice back to pending status.

    Once the invoice is pending, you will see the delete button.

You can find the invoice by going to Invoicing > List Invoices or by opening the associated PO and clicking on the Invoices tab.

If you have an integration with another system for invoices, check when the transfer of invoices occur. Updating the invoice in OpenBoxes might not update the invoice already transferred into the other system!

Reconcile a Prepayment Invoice - ALL Items

To completely close the invoices for Prepayment POs, you must reconcile the Prepayment Invoice and create a final Purchase Invoice. For Prepayment PO lines to be officially invoiced, they must be shipped and added to the purchase invoice. This process verifies that we received what we paid for, and addresses any discrepancies.

This section shows you how to create the final invoice for ALL the items in a Prepayment PO.

  1. After the prepayment is completed, the purchase order goes through the normal shipping and receiving process. If at any point an item needs to be changed or cancelled, make those changes to the PO.
  2. Once all items on the PO are received or cancelled, Click on Generate Invoice button in the PO view page.

  1. Fakti a pral pwodwi pou PO a plen, ak prepare anvan an retire nan pati anba a:

  1. Pou yon 100% ranbousman PO ak tout atik yo te resevwa, valè total fakti final la pral 0. Pou yon peman pasyèl oswa yon PO kote chanjman yo te fè apre yo fin peye, pral gen yon balans kite pou peye. Verifye ke fakti a alimèt pwofòm final la ak peze "Post Fakti" pou finalize.
  2. Liy sa yo pral make kounye a kòm fakti nan PO a ak nan tout rapò po louvri.

Reconcile a Prepayment - Partial Items (Only available for versions 0.9.2 - hotfix1 and newer)

OpenBoxes also allows invoice users to finalize invoice for only some items in a Prepayment Purchase Order (PO). This is important if only some items in a PO have been shipped and the team needs to pay for those shipped items. Vendors can take a long time to ship all the items in a PO, sometimes even months, which keeps the items incorrectly encumbered (i.e. they are an outstanding financial risk to the organization) and can cause audit issues and confusions.

For example, let's say there is a 50% prepaid PO with 10 items. The vendor delivers 3 of the 10 lab items for now. When they deliver the items, they also issue an invoice that matches the shipment with those 3 items. The team can then process the invoice for the 3 items against the Prepayment PO and pay the remaining 50% for those 3 items only, instead of waiting for the rest of 7 lab items to also be shipped, which might be a a month or more away.

When can you generate final invoice for partial items in a Prepayment PO?

  • The PO has adjustment(s) item that has not already been invoiced.
  • An item's shipment has been cancelled and that cancellation has not been invoiced.
  • At least one item in the PO has been shipped and has not yet been invoiced.


Generate Final Invoice for Partial Items in a Prepayment PO

  1. On the PO View page, click on Generate Invoice.


  2. You will see a message stating that not all lines on the PO are available to invoice. Click OK if you want to proceed with invoicing only the lines available to invoice.


  3. In the following Invoice page, you will only see the lines that are ready to be invoiced. You can see the inverse prepay lines (red lines) for only the available line items.

    You can click on the three dots on the right-hand side to perform the following actions to finalize your invoice:

    a. Edit the quantity to be invoiced for the item. The edited qty can be less than the original qty in the purchase order. This will also show the prepaid amount corresponding to the edited quantity.

    After you edit the qty, click on Save to see the qty changes! Do not hit ENTER on you keyboard!! This will submit your invoice instead of saving the changes.

    b. Remove items from the invoice. Removing the invoice line will also remove the associated prepayment line.

  4. After you check that the numbers look good and match the final invoice provided by the supplier, click on Submit for Approval.
Èske repons kesyon sa a? Mèsi pou fidbak la Te gen yon pwoblèm soumèt fidbak ou. Tanpri eseye ankò pita.

Toujou bezwen èd? Kontakte nou