How do I display the open balance on a PO? (2025.02)

Issue

I want to view the open balance on a PO on the printed purchase order. 

 

Explanation

In accounts payable, the open balance on a purchase order (PO) refers to the amount of money still unpaid or outstanding on that specific purchase order. It's the difference between the total value of the PO and any payments, credits, or adjustments that have already been applied to it. 

Open Balance = Total PO Amount - Payments Made - Credits/Adjustments

 

Solution

You need to be running version 2025.02 or later. To view the open balance on a printed PO, add the variable to show the open balance to the PO form definition. From the Print Purchase Orders report, click the Forms tab, and then use the Form menu to select Edit This Form. 

 

In the Forms editor, click Variables . A variable will be added to the editing window.

 

Click Settings . Start typing in Open Amount, and then select Purchase Order Open Amount. Click OK to add the variable to the form. 

 

Finally, drag and drop the variable to position it on the PO form definition. 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

• Related Articles

• How do I close open POs?

  An open purchase order is a document a business uses to request goods or services in return for payment, generally set for a later date. Use this routine to close an open purchase order or close a sequence when there's a partial shipment on an open ...

• How do I display a credit balance warning?

  A credit balance occurs when a customer has an account with an overpayment or credit. You can set up the options on the category code to display a warning message when a user enters a payment from a customer that has a credit balance on their ...

• How do I enter a PO?

  Use Enter Purchase Orders to record a purchase order that does not have a requisition. A purchase order is a document that lists item type, quantity, and price for products, services, or both products and services. Watch a video Learn about changes ...

• How do I change the column display order?

  You can build each section of the report to display the information in a specific order. If the column will not be displayed in the reporting section, then you don't need to worry about the column display order. But if the column will be displayed, ...

• How do I create a PO from a requisition?

  Use an existing requisition to create a new purchase order. This routine will transfer the information from the saved requisition to the purchase order form. Creating purchase orders from requisitions 1. Open Connect Accounts Payable > Purchases and ...