Using the Invoice Consolidation Wizard

Invoice Consolidation wizard automatically applies credit memos (that is, orders with credit balances, typically from cancellation) to invoices with open or outstanding balances. It ensures that when using an order credit to pay off a balance, both the credit and balance are adjusted appropriately and automatically in the system.

Note that the Invoice Consolidation wizard does not control which Credit Memos are automatically matched with outstanding balances, it only allocated dollar amounts. To control how credit orders and balances match up, you can manually create payments that use specific credit memos to pay specific balances. Also, the wizard can only apply a credit memo to an order that is in the same currency. To apply a credit memo in one currency to an order in another currency, follow the procedure described in Recording a Payment in a Different Currency than the Order.


The following steps describe how to use the Invoice Consolidation wizard, broken down by interface.

Support for running the Invoice Consolidation wizard in the web interface is added in Aptify 5.5.5.

Aptify Web Interface

  1. In the Orders service, create or open a view of the records within the service that needs to be consolidated. Note that the wizard also supports prompted views.
  2. Launch the Invoice Consolidation wizard by selecting the Invoice Consolidation Wizard option from the More menu in the view's toolbar.
  3. In the Person field, enter the customer's name.
    • The related company displays automatically in the Company field.
    • If you are consolidating invoices on behalf of the Person only (that is, consolidating the balances from individual orders that do not have a Bill To Company specified), then clear the Company field.
    • The Person/Company (or the Person, for individual orders) you enter should have a set of orders with an outstanding balance and a set of orders with credit balances (credit memos) that you want to consolidate.
  4. By default, your name appears in the Employee field. Modify this information, if necessary.

  5. Click Next to continue.
  6. If the selected person has open invoices or credit memos in more than one currency, the wizard prompts you to select which of the Person's currencies to use in the process.
    • The wizard can only process one currency at a time. It cannot apply a credit memo in one currency to an order in another currency.

      Invoice Consolidation Wizard - Select Currency
    • If this step appears, select a value from the Currency field and click Next.
  7. The wizard displays the customer's orders that have an outstanding balance in the Order grid. It also shows the total credit dollars that the customer has available in the Credit available field. Enter amounts in the Amount Allocated column to allocate the available credit to the orders with outstanding balances.
    • Click the amount in the Amount Allocated column to edit the amount of credit to be used for the selected order.
    • As the allocated amounts for each order line are edited, the Credit allocated amount adjusts automatically to reflect the total amount allocated.
    • If the available credit is not enough to cover all outstanding balances, follow the customer's instructions regarding allocating credits to pay off balances partially or in full. For example, allocate an equal amount of credit toward each of ten -outstanding balances. Alternatively, allocate all the credit toward a single outstanding balance and pay it off completely.
    • The Credit allocated cannot exceed the Credit available.

  8. Click Next to continue.
    • The wizard displays a proposed list of payments that it will create based on your credit allocation.
    • The wizard displays information about the payments it created to cover the outstanding balances.
      • ID:  The ID of the payment that the wizard generated.
      • Order: The ID of the order with an outstanding balance to which the credit was applied.
      • Credit Order: The ID of the order that had a credit balance.
      • Amount: The payment amount that was applied to the Order with the outstanding balance. This amount need not equal the entire amount of the original outstanding balance or the entire amount of the original credit. It is the amount of the payment.

  9. The wizard provides a final opportunity to go back and make any necessary changes. If needed, select the Back button and change the information before creating the consolidating payments. Otherwise, click Finish to create the payments.
  10. After using the Invoice Consolidation wizard, review the new payments that the wizard generated, as necessary.
    • For example, open the record of an order that previously had an outstanding balance. One or more new Credit Memo payments should now appear on the Payment > Payments for Order tab.

Aptify Desktop Client

  1. Create or open a view of the Orders service.
  2. Click the Invoice Consolidation Wizard icon on the view toolbar to launch the wizard.

    Invoice Consolidation Wizard Icon
  3. Review the introductory information and click Next to continue.
  4. Enter the customer's name in the Person field.
    • The related company displays automatically in the Company field.
    • If you are consolidating invoices on behalf of the Person only (that is, consolidating the balances from individual orders that do not have a Bill To Company specified), then clear the Company field.
    • The Person/Company (or the Person, for individual orders) you enter should have a set of orders with an outstanding balance and a set of orders with credit balances ("credit memos") that you want to consolidate.
  5. By default, your name appears in the Employee field. Modify this information, if necessary.

    Select Person and Company
  6. Click Next to continue.
  7. If the selected person has open invoices or credit memos in more than one currency, the wizard prompts you to select which of the Person's currencies to use in the process.
    • The wizard can only process one currency at a time. It cannot apply a credit memo in one currency to an order in another currency.

      Select a Currency
    • If prompted, select a currency from the list and click OK.
  8. The wizard displays the customer's orders that have an outstanding balance in the Order grid. It also shows the total credit dollars that the customer has available in the Credit available field. Enter amounts in the Amt. Alloc. column to allocate the available credit to the orders with outstanding balances.
    • As the allocated amounts for each order line are edited, the Credit allocated amount adjusts automatically to reflect the total amount allocated.
    • If the available credit is not enough to cover all outstanding balances, follow the customer's instructions regarding allocating credits to pay off balances partially or in full. For example, allocate an equal amount of credit toward each of ten -outstanding balances. Alternatively, allocate all the credit toward a single outstanding balance and pay it off completely.
    • The Credit allocated cannot exceed the Credit available.

      Credit Available and Allocated
  9. Click Next to continue.
    • The wizard displays a proposed list of payments that it will create based on your credit allocation.
  10. Select an OrderID line item in the grid to display information about payment or payments that the wizard will create to cover all or part of the order's outstanding balance, including the ID or IDs of the credit orders from which funds will be applied.
    • To edit the dollar amounts allocated, click Back to return to the previous page.

      Selecting an Order
  11. Click Next to continue.
  12. The wizard provides a final opportunity to go back and make any necessary changes. If needed, select the Back button and change the information before creating the consolidating payments. Otherwise, click Next to create the payments.
  13. When finished, the wizard displays information about the payments it created to cover the outstanding balances.
    • ID = The ID of the payment that the wizard generated.
    • Order = The ID of the order with an outstanding balance to which the credit was applied.
    • Credit Order = The ID of the order that had a credit balance.
    • Amount = The payment amount that was applied to the Order with the outstanding balance. This amount need not equal the entire amount of the original outstanding balance or the entire amount of the original credit. It is the amount of the payment.

      Information on Payments Created
  14. Click Next to continue.
  15. Complete the wizard.
    • To process more consolidations, select Yes on the screen and click Finish.
    • To finish consolidating invoices, select No and click Finish.
  16. After using the Invoice Consolidation wizard, review the new payments that the wizard generated, as necessary.
    • For example, open the record of an order that previously had an outstanding balance. One or more new Credit Memo payments should now appear on the Payment > Payments for Order tab.
 
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.