Computerized Bookkeeping Module 6
Computerized Bookkeeping Module 6
N
o
q
o
@
N
@
ts
N
@
N
o
157
:
Ensure that all the information on what your Customers terms aro
with your Company are recorded
conectly on their Master File (account)'
Learning example 6 A
158
Learning trlodule 6-
Practice exercise
Mr' Ungaretti would like the same Custom er categoriesto
be created as the customer price
list names.
1. Trade
2. Retail
3. Cash
Learning example 6 B
Ac rn u nt:
Supplieru Categorie r'
Te rm: )
lnventory f,ustomer Prices
t.j.B,!;r
hlanufactu ring
'l
) l
.,1
I
Prrjett: >
N;
oi
.!l Exchanqr F,atrs
5l Tax Type [Link]
5
@
N Time and Billinq )
6l
NI
Ni Scheduled lnuoicing )
@,-
N
o
159
and maintain custOmer accounts
-Create
1. The Edit Sa/es Analysis Codes screen displays:
SH Ll l-i l{{ i
,{r1tl Edit Drletr !a\ri FPiP+ !earrh (sde llarnt Firrt PreY
I I
0e:cription
Picture
{^ Sales
[Link]
0,00
J
0.00
0,00
0,00
t Descriptlon - Enter the name of the sales code in this field, which can contain up to
30 characters. lf codes are used to represent sales representatives, enter the sales person's
name here.
. Blocked - lf you do not want a specific sales code to be used, you could block it by ticking
this box.
160
Learning Module 6-
Pay Cammisrio"n Dn
0,0s
0.00
I
t Pay Commission On - lndicate here how commission should be calculated. Two options
exist relating to calculating commission, namely on Gross Profit or on total exclusive Sa/es
value.
' Commissian Structure Table - Specify target values and the commission percentages
relating to those targets reached.
When entering lhe Peiodic Target Amounts, always enter the the lowest amount in the
range. The system will automatically enter tne Range as the target values are entered.
' syo commission if they sell between R 1.00 and R 20 [Link]. ln the Periodic Target
Amaunt column an amount of 1 will be entered and 5%o in the Cornmrbsion column.
' 7Yo commission if they sell between R 20 001 .00 and R 50 000.00. An amount of
R 20 001 .00 will be entered in the Periodic Target Amounf column and 7Yo in the
Commission column.
The system will take the range of the first line and make it R 1.00 to R 20 O0O"0O and the second
line will be R 20 001 .00 onwards. As you continue to enter the target amounts, the system will
continue to adjust the range accordingly.
' Copy / Pasfe Cornmlssion Structure - This allows you to copy and paste commission tables
between from one cost codes to another.
N
o
c1
@
N
@
ts
N
6
N
o
161
and maintain customer accounts
-Create
Mr. Ungaretti would like you to create the following Sa/es Analysis Codes with the respective
commission structure. All reps will receive commission on Sales and they are all on the same
structure.
Tip: Before saving the first Sa/es Ana tysis Code, selecl the
then save the record.
After entering the code and description for the 2nd representative, Enfer ar Tab on the
keyboard which will activate the . Select this option and the
commission structure will automatically be copied to th6 sscond rcpresantatlve,
162
Learning Module 6-
Learning exampte 6 C
x
*fr,f,. nn it
;iJ Enll [Link]. :j.! [Link] !.drih Code llini Firji Fi., tii.r Lrjt
[Link] Code i
l__ I
(ash Sale,qcrount f- Etccled f
0e,cr ptron
aultanrer Cntegory C{ - None Ct rk the 5chrdr ed tnrorrE5 buhof te !Ee and,cr [Link] thE
- Lt cf S(hEdulE.J n.;cr(E! tor thr! cu![Link] 5cheduled lnvcices
Deta;ts procelsrng
Terms Additrona{ Optj.n! Ealances Noter
AJdrsses EntigJ Banking
Poilal AddrE!t
r,o rta d
Telephone
Fu
r- Access thse functicB naw
Delirenl hdrJrc: !-oad reooils
L{cbile phohE
Authorise pdyntent b6tches
Fayfieri balch rep+i1s
163
and maintain customer ac6ounts
-Create
2. The Detals tab;
Addresres
Telephone
Sa[* Code
r_--l I ,.,.,.,,':. I j
.i f ontact Details..,
This is the customer contact detail screen and should be completed with all the relevant information
as required on this screen. Remember these fields are optional.
. Sales Code - Enter a default sales code for the relating customer here. This is however, an
optional field. Sales codes can also be entered with the processing of each sales invoice
individually.
o Additional Delivery / Contact Detaits * By clicking this option, you could set up additional
delivery addresses and contact details for a customer. This option would typically be
selected if you sell to a customer with various branches. You would still invoice the head
office, but goods will be delivered to the various stores.
164
Learning Module 6-
An unlimited number of
Additional Delivery / Contact
Details can be created for
each customer account. The
Address Code identifies the
various delivery addresses. lt
can be a mixture of Alpha and
Addre:: f,ode Numeric characters and can
Dr ilEry l be up to three characters long
Dt iverl 2
Delilery l
DrliEry4
Delivery 5
ll
once all the contact detairs have been entered, go to the processrhg
tab.
uExails I pl.
Cursncy
Electrotric 0c(umentt
cde m
C
T Custonler [Link], [Link] Doruments
Froc*sing l,,lrthocl
Conta.t
Tax
Email
t. tX(lUst!E i" lnclusive
N
o Statements
c! ELl Cauntry
Prif,ting
USaUIt lax
l\,lEsigs
@ Trx Code
N Contad
@
N Tax Relerence
F Email
@
N
o
165
and maintain customer accounts
-Create
Let's look at the various sections of the processing screen:
o Currency - This option applies only when you are using the Multi Currency add-on module.
You could then select different currencies for ditferent customers.
Tax
Tu ****
li Exclusive f lnrluriye
ELI Couhtry
I rr, : _ -]
DeloultTax
Tax Code
Tsx Refe/ehre
Electronic Documents
Elertronic Docunrent:
If you intend to email customer documents, invoioes, credit notes and ddblt ndtds, EARS requir8s
that:
166
Learning Module 6-
Documents - By clicking on the drop down arrow, the method of printing customer
documents
can be seJected. Remember, should you wish to email documents; cJntact name
and email
address nLeds to be entered into the relevant fields.
CEntn.t
lfafemenfs - Select the printing options for customer statements, as well as which message
should print on each customer's statement. These messages were set up in the
Statements
tab of the Customer Control function as discussed in Leariing Module 3.
Should statements
be emailed a contact name and email address needs to be entered into
the relevant fields.
Staterrentr
Frintirrg Print Stattment
Conti (t
Email
re
Retail
Credit Limit
lnvo {r Di5cc!nt n;
J.i'J
L-
I
Note that default customer terms were previously discussed and set up in
the Auto Setup Customer
N
o Control function in Learning Module 3, but any customer specific changes
q can be set here.
c Monthly / Day Based Terms - Select the option for each customer. Terms
can be Monthty or Day
6 Basedfor open item processing, but for baiance forward processing customers,
@
N terms can only be
@
N
Monthly.
ts
@
N
o
' Normal Terms' This relates to the maximum period within which a customer
account' Select an option for Nonnal Monthly Terms trom the drop down box, or
should settle his
create specific
Normal Day Based rerms from the Add faciliff by clicking on the zoom facility.
167
and maintain customer accounts
-Create
Early Terms - Select or create early payment terms, which relate to specific settlument discounts
for a customer.
lnterest From - This relates to the charge of interest on overdue accounts and parameters for
interest have been set up in the Configuration tab in the Customer Control function.
Price List -You can select a price list that would apply to a specific customer. Frice lists have been
set up in the Configuration tab in the Setup lnventory function.
lnvoice Discount % -This relates to an overall invoice discount if applicable. Thi$ is a discount in
addition to any line discounts or inventory specific discounts you might enter on an invoice.
Freight / Ship / Deliver - Enter any specific freight or Shipping methods in these fields, if it is
applicable to a specific customer.
Credit Limit - lf a customer has a specific credit limit, this would be entered in this field. The sys-
tem will then warn you, if a customer exceeds this credit limit.
llser Defined 2
User I ]
These five fields could have been set up on the Customer Control function in the Setup option
from the menu bar. The names of these fields that were set up in the Customer Control function
will then appear on this tab. This is an optional function and you could use it to display additional
information you might require about customers.
lf you can recall, the fields as displaying above have been set up in Learning Module 3, Practice
exercise 3m.
168
Learning tr/odule 6-
Psiod Sals ThisYar Sals LBst YeB! Balance This Yea Brlance Last Yst
l
:
)
4
6
f
B
I I
4e-.q!ffi:
To open a notq [Link] on it. To creBte B new note. riEht,click uryrh"ru on th_-Iii
*__i
N
q
A note can be created or linked to the customer.
The Note Facilityhas been discussed in detail in
Learning Module 4.
o
@
N
@ once all the information on the supplier has
N
N
been completed, click on the ,,Y. Srr" i"on.
@
N
o
169
and maintain cuStOmer accounts
-Create
Practice exercise
The following Cusbmers need to be created. Remeniber to use the recomffibnddd way of
creating customer codes.
Account No:
Cusiomer: Runway Dealers Mr. Lebo Tathe
Category: Trade Retail
Postal Address: P O Box 596, Randburg P O Box 45, Bononi, 1601
7894
Physical Address: 48 Trent Park Lane, Randburg, 98 Fountain Avonue, Bencni,
7895 1 602
Contact Namo: William Calder Lebo Tathe
Tel. Number: 01 1 954-3625 011 876-3951
Fax. l{umber: 01 1 954-3626 011 876-4561
Mobile Numben 071 567 890'1 083 567-9012
Email Address: neil@[Link] lebo@[Link]
Sales Person: Tyrone Tyrone
VAf, Req, Number: 4568763456 36984752'19
Normal Terms: 30 Days 30 Days
Early Payment Terms: 1oo/o if paid within 15 days 10Vo il paid within I5 days
from date of invoice from date of invoico
lntercst One period after terms One period afier terfis
Gredit Limit: R 70 000.00 R 50 000.00
170
Learning Module 6_
Account No:
Customen Owens Enterprises Ms. Sunil Govender
Category: Trade Retail
Postal Address: P O Box 5498, Centurion, 87 Saffer Road, Randburg
4780 7895
Physical Address: 52 Finch Road, Centurion, 87 Saffer Road, Randburg
4781 7895
Contact Name: Owen Finch Sunil Govender
Tel. Number: 012 596-2345 011 596-4231
Fax. Number: 01 2 596-2346 011 596-4230
Mobile Numben 083 444-5555 074 555 8953
Email Address: Sales@[Link] sunil@[Link]
Sales Person: Wanen Warren
VAT Reg, Number: 9824635871 63521 98759
Normal Terms: 30 Days 30 Days
Early Payrnent Terms 10% it paid within 15 days 10% il paid within 15 days
from date of invoice. from date of invoice.
Interest 1596 per annum on 15% per annum on
outstanding amounVs outstanding amounVs
Credit Limit: R 75 000.00 R 40 000.00
Document Printing: Print and Email Print
Contact: Owen Finch Sunil Govender
Email Addressl sales@[Link] sunil@[Link]
Permission for electronic documents: Yes No
Statement Printing: Email Email
Contact: Jessica Sing Leoni Myburg
Email Address: cred itors@owens. [Link] creditors@[Link]
Cr. Clerk Name: Jessica Sing Leoni Myburg
Cr. Cle* Numben o12 596-2347 011 596-4235
!!
q
3
@
N
@
N
ts
6
N
o
Ecreate and maintain customer accounts
Learning example 6 D
General Ledger
*"1
Customers Ftint 0r:cument ii
L
Anrlyse Saks )
lnventory Detailed Ledger ,
Price Lists Outstanding 0uotes / Bac[ 0rders >
Man ufacturing
Balances
Projert: Irlonthly / Feriodic
Open Batches
6raphs
Financial Ratios
Notes
Categorirr
Tirre and Billing ,
Rprpintt ,
lntelligence Reporting l
172
Learnrng Mociute 6-
Print To
5creen
Sale: Analysi: Code Sequrnce
T fancel
5ale: Anal,vsis Code 5tart
End
t_
ryllu
Cu5tomer Category 5equence
T
fategory ltdrt
00 - None
fategory End
J - Cash
Show Details
lii
Print U:er Defined Fields
1{;;
Blorked r'Unblocked
Both
f ustomer Accepts Etectronic Do(ument!
6
@
N
@
N
N
@
ts
o
173
and maintain customer accounts
-Qpsate
The following Customer Listing report displays:
O.EWllr5g
&3 EI{TJEEI nesa d-gEi*
8fff {|[Link]{ F": f !I :.Hl::r: [Link] 4o-ffiin
tHr*t'A4tEr FctIAIEaa ::"}-il[ : - _] B6t 0
ElEkia E*
Ed,frstg [Link]] !S
f:
:4.'_. ?93! hE LEt HH*
,: -1:.?i ,, ; a&,@ tit&t
Te$re l*itE!*.
ttfsr lE
TakE *Iitl$rHt
:; ,: r.-: I SHprHlI:
hr*1r
oElr6{aAE: *t
&[Link].& ffi
fls* ilF*
trr" C[: Citrtr l,lF&s
Lffi F*IHS [11 9S42:{,
i.:. I /,i{ l:
* .':.: f
' '-'."-/
.:: ,a- -:' . :" ii-;ti,.i'
E -
174
Learning Module 6
-
lf you rerun the report and deselect the option to show details, the following report displays:
C!stomer Listing
P E96r6d by EducationEl Pack
End ofReport
Well done! You have now managed to complete the creating of Customer Master Files.
' When invoicing, the sales analysis code will automatically display on the invoice.
'
o
A,commissions report will become available for printing on tne sites analysis codes.
When receiving customer payments, the system will be able to calculate the
setflement
discount, as well as whether the customer has paid on time to receive the settlement
discount.
r lnterest will be charged on overdue accounts, as set up on the customer account.
N
q
6
@
N
@
N
N
@
N
175