Accounts Payable Data Exports

 

Export Description

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