N - Tiered Customer Hierarchy

Meet the challenges of customers that do not pay according to the
standard child-parent relationships in your ERP systems.

This solution evolved from a customer requirement. A Cforia customer
was receiving a single customer payment that paid for 1000’s of invoices
from over 100 different parent customers. The sales ledger department
needed a way of adding an additional level to the traditional child-parent
customer relationship. We enabled the customer to create a relationship
between customer numbers which we store at a higher level than the
customer master. This customer relationship can be updated to reflect
new changes in the business process.

An example will illustrate the point. King UK receives a payment from
Whitbread. Whitbread pays King UK for all Whitbread pubs that have
been supplied by King over the last month. These pubs are supplied to
as individual customers. These pubs are then regionally located so the
invoice is sent to the regional hub. Whitbread has a Financial Shared
Service Center that then pays invoices for all the regional hubs. Three
or  four payment levels are required. The ERP system holds two levels.

Features
  • Single view of all invoices for a grouping of customers.
  • Enables users to choose primary customers so that unallocated
    cash can be attributed to specific corporate customers.
  • Handles discount and credit/debit notes.
  • Integrated with EDI/Excel uploads.
  • Join customer masters with unlimited additional levels.
  • Name customer groups with an alphanumeric name (e.g. “Whitbread”, “ABC”).
  • Regular uploads from the ERP system customer master feed into the Customer Hierarchy.
  • Makes all necessary updates to your ERP’s A/R and G/L.
  • Provides auditable display of all customer relationships.
  • Original customer numbers are displayed in cash allocation screen.

Benefits
  • Greatly reduces A/R processing time for large corporate customers.
  • Eliminates time wasting manual comparisons of remittance information across multiple, different customer accounts.
  • High-volume receipts applied to customer accounts faster. Allows A/R staff focus on exception handling instead of data
    comparison and entry.
  • Reduces end of reporting period closing time and manual effort.
  • Single view of customer payment data reduces likelihood of manual entry errors.
  • Extensive search and find capabilities across multiple corporate customer numbers.
  • Improves customer account management by ensuring everybody is looking at the same data and information.
  • Allows redeployment of staff from low skill manual work to higher value activities.

Click on this link to view Lockbox Auto Cash Application Webinar replay.  Presented by a 20 year veteran.

Click to view cash application background for Greg Coulter.
Cforia
ZeroCapital