Customer Hierarchy

This Cashbook module solves a common problem whereby customers receive payment for an invoice that relates to another customer on their ERP system. In many companies the standard child-parent relationship within the ERP system does not cater to the way people pay their invoices.

This solution evolved from a customer requirement. A cashbook 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 pay King UK for all Whitbread pubs that have been supplied by King over the last month. These pubs are supplied to as an individual customer. These pubs are then regionally located so the invoice is sent to the regional hub. Whitbread have a Shared Service Center that then pays invoices for all the regional hubs. Three or it some cases 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.
Caters for discount and credit/debit notes as always.
Integrated with standard Cashbook and EDI/Excel uploads.
Ability to join customer masters with unlimited additional levels.

Ability to name customer groups with an alphanumeric name (e.g. “Whitbread”, “DHL”)
Regular uploads from the ERP system customer master feed into Cashbook Customer Hierarchy solution.
Makes all necessary updates to your ERP’s A/R and G/L
Auditable display of all customer relationships.
Original customer numbers are displayed in cash allocation screen.

Benefits

Hugely reduces A/R processing time for large corporate customers.
Eliminates time wasting for A/R users who are attempting to compare remittance information with multiple, different customer accounts.
High-volume receipts applied to customer accounts faster as A/R staff focus on exception handling instead of data entry
Reduces reporting time devoted to large customer accounts during closing periods
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.
Elimination of manual effort allows companies to allocate more staff time to other higher-value activities

King UK is the UK's leading supplier of all non food products ....[»]