Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu Path:Customer

...

> Maintenance

...

> Create Account

Image Added

  • Key in the compulsory field such as Customer name, Credit limit, credit term, Address and Contact Number;
  • Click the optional tab to choose the

...

  • Salesman;
  • If got any remark for the customer account can key in at the property Column;
  • Click

...

  • 'Create New Customer Now'

...

  • .

Image Added

Credit

...

Terms 1: 

...

...

...

...

Credit Terms 2

...

~ 5:

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)


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

Tax Option

...

...

...

...

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