Accounts Payable Data Exports

 

Export

Purpose


Accounts Payable
Inventory Purchases by Supplier

(formally called Supplier Purchases)
Supplier purchases based on inventory receipts. All inventory receipts are included (billed and unbilled). Returns can be included.Option to Group By: Company or Location.

All quantities are displayed in main unit type.

Matches the Inventory Received report.
Inventory Purchases with Levy Supplier purchases based on inventory receipts and the levy (tax) charged; used for government remittance.

Levy per line is calculated as:
(Total * TaxAmount) / (PITotal - NonInvTotal – PILevyTotal)

Payment Summary

Summary of AP Payments and to which Purchase Invoices applied.

Purchase Order Summary

Summary of purchase orders. Details of purchase orders associated to work orders. 

Suggested Payment Details

List of outstanding payments for suppliers.

Supplier Aged Balances

Aged balance for all suppliers based on the Due Date.

Supplier Balances

Current balance for all suppliers.

Supplier List

All suppliers.

Audit/Admin

Deleted AP Payments \ Prepayments

 

Deleted Purchase Invoice Details

 

Deleted Purchase Invoices

 

Deleted Purchase Order Details

 

Deleted Purchase Orders

 
Supplier EFT Changes to all supplier EFT details (includes inactive).

CAUTION: Sensitive Supplier security is ignored - results will be visible for ALL suppliers