Create Customer Account

Menu Path: Customer > Maintenance > Create Account

  • To prevent the creation of duplicate accounts, 'click here to search first'.
  • The 'Account PKID' will be self-generated by the system.
  • Enter the Company or Customer Name → Tick 'Disable Name Checking for Corporate Account' if user does not system to check the existence
  • Key in Account Code Prefix → the code from previous account software or leave it blank to let system auto generate the prefix code
  • Select Gender
  • Select the Tax Configuration for the customer → make sure the Tax Code is exist
  • Select the Type of the customer → personal or corporate
  • Key in additional information on email, address, tax id, registration number and contact number → check Customer Configuration to setup the compulsory fields 

  • Key in Secondary Address and Contact Number if any
  • Select Status → OK or Black Listed to proceed to buy any stock. 
  • Select Customer Type, Salesman and Categoryif any configuration on drop down list
  • Select Tax Option → customer tax will overwrite Item Tax Configuration or leave it blank to follow back Item Tax Configuration
Scenario 1Scenario 2Scenario 3Scenario 4
Item : Tax Exclusive Eg 100
Customer : Tax Exclusive 
In Invoice : Item - RM 100 
Tax 10% - RM 10
Total RM 100

Item : Tax Exclusive Eg 100

Customer : Tax Inclusive 
In Invoice : Item - RM 110 
Total RM 100
Tax Include 10% - RM 10

Item : Tax Inclusive Eg 100
Customer : Tax Inclusive 
In Invoice : Item - RM 100
Total RM 100
Tax Include 10% - RM 9.09

Item : Tax Inclusive Eg 100

Customer : Tax Exclusive 
In Invoice : Item - RM 90.91
Tax 10% -RM 9.09
Total RM 100


  • Key in the Credit Term and Credit Limit 
    • Credit Terms 1 → the terms indicate when the payment will due from sales made on the account (or credit). This is just used for normal credit term and it calculates the number of days for the credit due

    • Credit Terms 2 ~ 5 → This can be user as grace period controlling and some terms that count both on day and month and etc

Set Date & Add Date: 

Set Date (yy,mm,dd)
  • This is used to reset the date of the create invoice to a certain date.
Add Date (yy,mm,dd)
  • This is used as the number of dates to be added on the reset date.

Eg. Sample usage of SET DATE and ADD DATE :

eg1. EOM + 7days


SET DATE: 0-0-1
ADD DATE: 0-1-7

eg2: 30 days

SET DATE: 0-0-0
ADD DATE: 0-0-30

eg3: next month before last 7th day

SET DATE: 0-0-1
ADD DATE: 0-2-(-7)

  • Please check the Configuration for the default Credit Limit and Terms or Naming of Credit Terms 


The algorithm to calculate the new dates for the invoice credit terms consist of 2 simple functions:
a) setDate(YY1,MM1,DD1)
b) addDate(YY2,MM2,DD2)

Scenario 1:
The credit terms date is next month 7th day.
Assuming today 
d0 = 2013 Feb 8
d1 = setDate(d0, 0,0,1); this will return the results as 2013 Feb 1 (0 means don't modify the value)
d2 = addDate(0,1,7); this will return the results as 2013 March 7

Scenario 2:
The credit terms date is 15 days from the current invoice date:
d0 = 2013 Feb 8
d1 = setDate(d0,0,0,0), as we don't need to modify the day value, it will return 2013 Feb 8 (same as d0)
d2 = addDate(d1,0,0,15), we just add 15 days from the current date, results will be 2013 Feb 23

Scenario 3:
The credit date is last day of the same month
d0 = 2013 Feb 8
d1 = setDate(d0, 0,0,1); this will return the results as 2013 Feb 1 (0 means don't modify the value)
d2 = addDate(0,1,-1); this will return the results as 2013 Feb 28 or 29 (depends on which year, basically, adding one month to 1st of March, and minus one day to get the day before)

So, basically, the settings for this column would be :
YY1, MM1,DD1,YY2,MM2,DD2


Related Wiki Pages:


Private & Confidential