Core Bank Enhancements

Review of Core Billing Process and Enhancement for billing Overdue Cores Not Charged for at Time of Sale

Selling Cores

Selling products which carry a core charge. This is a value that is contained in the product master record at cost. By default, any item that has a core value will automatically add this to the price the item is being sold at. The system has the ability to sell cores at a price other than cost by the use of the Core Markup routine found under Customer Pricing. This works on the basis of a markup over the cost price carried in the inventory master and can be applied either by a percentage or a flat dollar amount. In addition, the markup can be applied by:

Customer Core Pricing setup

When a product with a core is sold the system determines if the customer selected is set to be charged the core at the time of sale or not. This is controlled by whether a specific type of entry exists in the core markup database. An example of where customer 123456 is not to be charged for cores at the time of sale would be a record in the database showing the following:


If a customer is not to be billed for cores at time of sale on any product category one entry in the database will accomplish this.  An important point to remember though is that while one entry in the database will create the global default for a customer exceptions can be handled by additional records that control specific exceptions. An example of this could be Customer 123456 is exempt from paying for cores at the time of purchase on all categories other than products contained under Category RAY. For this category the customer might be required to pay for cores at a 50% markup over cost. A second entry in the core markup file would look like this:

Core billing

If a customer is billed the core on an invoice the system creates a record in the Core Bank database. This allows future validation for returns as it contains the invoice detail, including the qty and price charged as well as core cost. For those customers that are set up as being exempt from core charges at time of sale, or where the core charge is set to zero at the time of sale, the system will still create an entry in the core bank but with a zero in the price charged field. This results in a margin impact as the core cost is still charged against the cost of the sale.

Example

Part # 5555 sells at $50.00 and no core is charged although has a core cost of $10.00. The cost of this transaction is Average cost of $30.00 plus the $10.00 core cost for a total cost of $40.00 on the $50.00 reported as the sale amount. Had the customer been charged the core the transaction would report a higher gross margin, Sell = $60.00, Cost = $40.00.

Core Returns

A core is processed through the POS as a C line type. The user is prompted to select the invoice the core was sold on in order that the system can credit the correct price. Irrespective of whether the core was charged or not the Qty of cores outstanding is still adjusted by the Qty returned. The return can be applied against any invoice containing the part number in question that has a core qty balance outstanding.

Unbilled Core Management - Enhancement

For those customers not charged cores the system has now been enhanced to support the automatic billing of cores where the customer has exceeded the return grace period. The number of days, from the original billing date, is customer specific assuming the maintenance has been done on the customer’s master record. In addition, there is a second new customer flag that controls whether the customer would fall into the Auto Bill process or not.

Electronic Statement Set up

The customer’s master record will also contain a new transaction type of C that will allow the direction of the core statement to a unique email address. This would be set under the EDI Info section. In addition, there will be a copy of the customers email sent to a pre-determined internal email, unique by branch.

Overdue Core Billing Menu

The overdue Core Billing menu options are found through Sales Desk > Administration > Overdue Core Billing.

Overdue Core Billing Parameters

Aging dates, Statement Message and Email Subject Line along with the internal email address for statements are all controlled in the Core Billing Parameters

Processing Flow

The system will automatically retire the entry in the core bank that is carrying a zero core value based on the invoice number shown on the billing screen. In addition, a second record will be added to the core bank carrying the new invoice number and the core value as calculated above.

Internal Reporting

In addition to the customers core statement there will also be a consolidated report available for branch use that is generated at the same time as the customer’s statements are produced.

Enhanced On-Demand Outstanding Core Report

The current routine has been enhanced to offer the following options:


Revision #1
Created 19 May 2022 17:03:13 by Jim
Updated 19 May 2022 17:26:28 by Jim