Home
Order to Cash Process
Manage all the activities related to the customer cycle: from the sales quotation to the receipt of payment.
Statistics and Reporting
Consulting Customer Open Transactions
Display all the open balance history from customers on an exact date.

Order to Cash Process
Manage all the activities related to the customer cycle: from the sales quotation to the receipt of payment.
- Sales Quotation
  The sales quotation is the first step to create external documents and send an offer to a customer.
- Customer Order
  You need to create a customer order: this process enables to group information and actions about your sales with your customer.
- Invoice
  After the delivery, you need to create an invoice for the customer. The invoice displays all the details about the product or service sold to the customer.
- Creating an Instant Invoice
- Credit Note
  The credit note is used to correct an error or change an element in an invoice already sent.
- Return Material Authorization
  Use this process when taking back defective products from the customers.
- Mixed Payment for Customer
  Once you receive a payment from a customer in your bank, you have to register it as a mixed payment in IFS Cloud.
- Creating a Customer Settlement
  If you have not matched your payment(s) with the corresponding invoice(s), through the process topics/t-MatchingMixedPaymentwithExistingTransactionsCustomer.html, you can do a settlement.
- Advance Invoice
  In case you need to get paid before the delivery of a customer order, you need to use the advance invoice functionality in IFS Cloud.
- Creating a Settlement for an Advance Invoice
  You need to settle your mixed payment with your advance invoice.
- Managing Product Rentals
  The following processes explain how to manage short-term or long-term product rentals.
- Credit Management
- Statistics and Reporting
  - Consulting a Customer Analysis
  - Consulting Customer Basic Data Analysis
    Consult information on one or multiple customers.
  - Printing a Customer Statement
    You can print a statement for your customer in PDF.
  - Consulting Customer Open Transactions
    Display all the open balance history from customers on an exact date.
  - Consulting Customer Transactions Report
    Create a PDF report to have all the transactions for a customer or a group of customers.
  - Consulting Customer Transaction List
    You can see reports with specific details about the historic of customer transactions.
  - Consulting Customer Trial Balance Report
    Create a PDF report to have the trial balance for a customer or a group of customers.
  - Consulting Customer Invoices
    You can display a list of your customer invoices.
  - Consulting Customer Account Analysis
    You can review the transactions and balances related to your customers.

Consulting Customer Open Transactions

Display all the open balance history from customers on an exact date.

This report is also useful to reconcile auxiliary ledger with general ledger, as the general ledger account linked to each customer transaction is into the grid.

Go to Financials > Accounts Receivable > AP Analysis > Customer Open Balance History.
Click New + to add a line.
Choose a Balance Date and click Save.

You can access the open transactions for the customers for the date chosen.
In this example, the customer open balance history includes transactions that occurred on May 30th, 2023. Select a line with the transactions date you want, click the three dots and then click Details.

The full list of the open transactions from the customers for the date selected is displayed.
Remember:
You can export this report in an Excel file. On your lines area, click > Export All Rows and choose if you want to see data from the columns displayed only or from all the columns.