AP Over 30 Days Dashpart

The AP Over 30 Days dashpart is a stacked bar chart that displays the outstanding accounts payable (AP) vouchers by vendor for a given aging range. The data on this dashpart comes from Costpoint.

Each vendor is represented by a bar, and each segment of a bar represents the amount of outstanding AP vouchers for the vendor in one of four aging ranges (in days): 31-60, 61-90, 91-120, and 120+. The amounts that display are based on the company's functional currency, as set up on the Costpoint database being accessed. The functional currency is also displayed on the chart legend, along with (000) to reflect that the data is presented in thousands.

The AP balance amount comes from the Open AP (OPEN_AP) table, which contains outstanding vouchers. The age of open accounts payables is based on payment due dates (Current Date - Due Date).

Drill-Through

Hover over a bar segment to display a tooltip containing the vendor name and AP balance amount represented by that segment. Click a segment to open the View Voucher History Inquiry screen, where you can view the outstanding AP vouchers for a particular vendor in a given aging range. For example, when you click a 91-120 segment in a bar/vendor, the View Voucher History Inquiry screen displays AP vouchers for that vendor that are 91-120 days outstanding.

Security

The data that displays on this dashpart depends on whether or not your company uses the organization security feature in Costpoint. If your company does not have organization security applied, you can view data for all organizations in your company, but the data displayed will be limited by the organization selected in Global Settings and the dashpart settings specified.

If your company has set up organization security, the security applied to the dashpart will be based on the organization security settings of the View Voucher History Inquiry screen. The security will be applied to the organization on AP transactions (performing organization) instead of the owning organization.

If the security profile with which you are associated does not have rights to the View Voucher History Inquiry screen, you can still view the AP Over 30 Days dashpart but you will not be able to drill through the View Voucher History Inquiry screen.