Supplier Analysis

Explanation

This activity is used to view detailed information about a selected supplier. This window contains detailed information about all invoices and due amounts, as well as invoice/pre-payment dates, etc. These details can be analyzed from a supplier's perspective as well as a payee's perspective. It is also possible to analyze or modify the proposed installment plan, enter and modify notes for both supplier or an item and payment references. You can also determine whether each supplier is subject to tax reporting and withholding. It is also possible to view the supplier details with any applicable interest and fine amounts and simulate interest and fine in order to view the interest and fine that needs to be paid for late payments. For items which were debited/paid by payment files, it is possible to trace electronic payment addresses.

Prerequisites

This activity requires that suppliers have been entered.

System Effects

As a result of this activity, if the payment reference is modified, the modified data will be attached to the corresponding ledger items.

Window

Supplier Analysis

Related Window Descriptions

Supplier Analysis
Supplier Installment Plan
Payment per Invoice/Prepayment Analysis (Supplier)
Payment Address per Payment

Procedure

To view supplier details:

  1. Open the Supplier Analysis window. 
  2. Search for the supplier ID for which you want to view details, or populate the header and then select the relevant supplier ID from the list for the Supplier ID field.
  3. Select the Auto Populate check box if you want to automatically populate and view the supplier details. Clear the check box if you want to query for one or more specific ledger items.
  4. Select the Show Open Items Only check box if you want to  populate only the open ledger items of the supplier.
  5. select the Exclude Not Cashed/Open Documents check box, If you do not want to view open payment documents (e.g. checks and bills of exchange) for the supplier.
  6. Select the Show Open Amount Before Preliminary Tax Withholding check box if you want to view the open amounts of ledger items before the preliminary tax withholding amount is deducted.
  7. Select the Enable check box if you want to view the invoices with installment details.
  8. Right-click and click Payments per Invoice/Prepayment Analysis to follow-up payment information.
  9. Right-click and click View Purchase Order(s) to access the connected purchase order(s) of the selected ledger item.
  10. Right-click and click Reprint Debit/Credit Note to reprint an invoice/note.
  11. Double click on the Latest Note field to enter or modify a note attached to a AP ledger Item. Alternatively Right-click and click Notes to access to Notes window in order to enter and modify.

To view payee details:

  1. Open the Supplier Analysis window.
  2. Search for the supplier ID for which you want to view the payee details, or populate the header and then select the relevant supplier ID from the list.
  3. Select the Payee Perspective check box in order to view the payee details.
  4. Select the Auto Populate check box if you want to automatically populate and view  the supplier details. Clear the check box if you want to query for one or more specific ledger items.
  5. Select the Show Open Items Only check box if you want to populate only the open ledger items of the selected payee.
  6. select the Exclude Not Cashed/Open Documents check box If you do not want to view open payment documents (e.g. checks and bills of exchange) for the payee.
  7. Select the Show Open Amount Before Preliminary Tax Withholding check box if you want to view the open amounts of ledger items before, the preliminary tax withholding amount is deducted.
  8. Select the Enable check box if you want to view the invoices with installment details.

To simulate interest and fine details:

  1. Open the Supplier Analysis window.
  2. Search for the supplier ID for which you want to view details, or populate the header and then select the relevant supplier ID using the List of Values.
  3. Select the Auto Populate check box if you want to automatically populate and view  the supplier details. Clear the check box if you want to query for one or more specific ledger items.
  4. Select the Show Open Items Only check box if you want to populate only the open ledger items of the selected supplier.
  5. Select the Enable check box if you want to view the invoices with installment details.
  6. select the Exclude Not Cashed/Open Documents check box If you do not want to view open payment documents (e.g. checks and bills of exchange) for the supplier.
  7. Select the Show Open Amount Before Preliminary Tax Withholding check box if you want to view the open amounts of ledger items before the preliminary tax withholding amount is deducted.  
  8. Select Simulate Interest and Fine until check box and enter a payment date. The details for the simulated interest and fine amounts, as well as the differences between the paid interest and fine amounts and the simulated interest and fine amounts will be displayed.

To enter or modify payment references:

  1. Open the Supplier Analysis window.
  2. Search for the supplier ID for which you want to view details, or populate the header and then select the relevant supplier ID from the list for the Supplier ID field.  
  3. Select the Auto Populate check box if you want to automatically populate and view  the supplier details. Clear the check box if you want to query for one or more specific ledger items.
  4. Select the ledger item that you want to enter or modify the payment reference.
  5. Right-click and click Modify Payment Reference to enter or modify payment reference for the selected ledger item.

Note: To use this option the Supplier Invoice Validation Method in company/invoice tab should have the value Not Used selected. This option is enable for invoice ledger items, payment on accounts, payment in advances but not applicable for check ledger items and bills of exchange. It is not possible to use this option if allowed ledger items are in Canceled or Fully Paid states.