You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

08-Credit Limit Worksheet and add field in Customer Card

A place for review all customers & apply all new C/L at the same time. 

i. New field in customer card

New field Credit Limit Tolerance added.  This field also related to then enhancement for Credit Approval

*User need to fill up Credit Limit Tolerance to existing customer card if any.

ii. Action Menu

Action menu for Credit Limit Worksheet added.  User can find in Departments => Financial Management => Tasks 

User can use the standard function Add to Actions on Role Center Ribbon if needs.

iii. How to use the Credit Limit Worksheet

StepsDescription
1Go to  Credit Limit Worksheet
2

Add Customer to credit limit worksheet

Select Action button Add Cust. to Credit Limit Wksh.

Remarks: user can fill up the Start Date, End Date, Customer, Calculation Value x, y manually


Fill up the criteria for adding customer to the worksheet for review the sales amount and credit limit in the worksheet.

Click OK to confirm the option

Field Description

(1) Start Date / End Date

Enter the Date Range for allow system calculate the Sales Amount for the customer during the period

(2) x / y - calculation figure for the calculate the suggested credit limit.

(3) Filter criteria for Customer

The screen capture show the sample as below; 

  • Review the customer with Nature of Business - RTL-MEDCO
  • Sales Data from 1/1/2020 to 6/30/2020 use for review the credit limit
  • Formula for calculate Suggest Credit Limit = Sales Data / 6 * 3

Remarks:

  • Blocked - Default value is "Blank",  No need to change this option if user only need to review the customer which is not blocked any sales transaction
3

Calculate Suggested Credit Limit...

  • Rows for selected customer to be populated to Credit Limit Worksheet
Field Description
  • Start Date / End Date / x / y are populated according to the filter options
  • Sales (LCY) - system calculate the sales amount of the customer during the period between start date and end date
  • Credit Limit - show the existing credit limit for the customer
  • Credit Limit Tolerance - show the existing credit limit for the customer
  • User can add/delete customer or change the x / y value before calculate the suggested credit limit. 
  • Click the action button Calculate Suggested Credit Limit..

4

Apply Suggested Credit Limit

Suggested credit limit to be calculated according to the formula Sales (LCY) / x * y.  User can edit the suggested credit limit or apply the suggested limit to the customer.


Click Apply Suggested Credit Limt. if ready to update the credit limit to customer card

5

Credit Limit Updated to Customer Card

System update the credit limit to customer.  The credit limit change information to be added to Comment Sheet by system.

  • No labels