Home

Finance Module Capital USER MANUAL

1. it Capital AR Analysis Master AR0230 The ten analysis header fields in the AR Control Definition AROO10 can be further subdivided using the AR Analysis Master Thus if defined the User will be able to generate more detailed analysis reports R ecord 1 1 List of Values lt OSC gt lt DBG gt 1 Click on the LOV button next to the Serial No field to get the list of the Analysis heads defined in the AR Control definition Page 17 of 191 Capital 2 Select one from the list and hit Enter or click OK This Analysis Head will get displayed in the AR Analysis Master screen 3 Then Enter the Analysis Codes and Names that is required in the rows provided 4 Click on Save button to save the details specified Ar Analysis Master Bs Action Edit Block Field Record Query Window Help AR0230 CAPITAL SUPER USER Serial Ma hi J CORPORATE Analysis Code Analysis Mame Aon CUSTOMER A 8001 CUSTOMER B coo CUSTOMER C Enter value for amp nalysis Code Record 4 4 lt OSC gt DBG Page 18 of 191 Capital AR Master AR0060 To record the details of the Accounts Receivable Customers the AR Master AROO60 is used This screen will also help in setting up the limits and other details for that particular AR customer Ex Receivable Master Ex Action Edit Block Field Record Query Window Help ARUUSU Information Dynamics SUPER
2. AP0090 Whenever an Accounts Payable Supplier makes cash payment a cash payment needs to be generated For this purpose the Cash Payment APOO90 is used As a pre requisite the document type must be pre defined in the Document Type Master C00050 Ex Cash Payment Ex Action Edit Block Field Record Query Window Help x F X 3 i AR z ARUM CAPITAL SUPER USER Reference Details Docente DocmerNamer Bank Code SA Other Reference Currency Details Currency cde gE 0 5 1 Date Details Exchange Rate Foreign Amount Document Date our Base Amount 1 G L Date 27 AUG 2007 ada ian Narration PRdTO 000000000 l Send For Approval Difference Allocation Total Allocation Details _ Allocation Code Currency Exchage Rate Foreign Amount Local Amount Marratian Allocation Details Enter value for Document Type list of values available Record 171 ListofValues lt C gt lt DBG gt Fields those were not explained earlier will only be explained The User can take a look at the table in the section Voucher Entry APOO70 for some information Page 96 of 191 Capital Bank Payment AP0100 Whenever an Accounts Payable Supplier makes Cheque payment a Bank payment needs to be generated For this purpose the Bank Payment APO100 is used As a pre requisite the document type must be pre defined in the Document Type Master C00050 Bi Bank Pay
3. Process Page 45 of 1091 Capital Multi Bank Receipts AR0330 Sometimes it is possible that an Accounts Receivable Customer makes cash and Cheque payment together For this purpose the Multi Bank Receipts ARO330 is used to generate receipts As a pre requisite the document type must be pre defined in the Document Type Master C00050 EX Multi Bank Receipts eles Ex Action Edit Block Field Record Query Window Help a LE ia E RU al E f ES EE We 4 Al n AR0330 Information Dynamics SUPER USER Document Type J Other Reference Dates Amount Details Document Date i 6 DEC 2007 we Cash Total Local Amount GI Date 16 DEC 2007 zl Cheque total Allocation Total N aration Notes Cash Bank Details Bank Code HA 7 i Allocation Details Allocation Code i e Exchage Rate Foreign Amount Local Amount l p ll Allocation Details NENNEN s Allocation Details Record 141 JlistofValues USC lt DBG gt The fields and parameters have been explained in earlier sections The User can take a look at the table in the section Voucher Entry AROO70 for some information Page 46 of 191 Capital To generate a cash receipt for the payment made by the AR Customer 1 First select the document Type by clicking on the LOV button Usually the document type selected is the Multi Receipt Voucher which must be pre defined in the Document Type Master
4. ld Document Type Master Document Name BANK RECEIPT VOUCHER CASH RECEIPT PDC RECEIPT MULTI RECEIPT VOUCHER BANK DEPOSIT VOUCHER Cancel 2 The User can then enter any additional reference details if required 3 Specify the date details 4 Enter the narration for that particular AR transaction 5 Enter the Cash Bank details This is where the User can add multiple bank or cash payment details of the AR customer Cash Bank Details Allazatian Pirntaile 6 Finally enter the allocation details required Page 47 of 191 Capital Allocation Details Allocation Code Currency p Rate Foreign Amount Local Amount Narration AR amp J AED 750 Allocation Details De Li 2 2 sj Allocation Details ER 1 3 E Enter value for Allocation listof values available lt o lt o AAA Record 2 2 List of Values KOSE lt DBG gt 7 Click on Allocation Details button if the User wish to specify the GL Account code and other related details This screen will have fields that were defined in the corresponding masters Once the User have completed entering details Click on Go Back button to go to the main screen or simply hit Enter 8 Now click on the Save button to generate the Multi bank Receipt A message box appears asking whether the User want to match the document or not Click Ok if the User wish
5. y AP0130 Information Dynamics SUPER USER Party a J Total Doc value pO Doc Type Pl 0 Doc No otal Match Value fi Original Balance Matched Date Local amp maunt Local Amount Local Amount Other Reference The screen has got two sections The first section is where the criteria are set and the second section is where the details get displayed Also scroll to the right to see more columns Page 107 of 191 Capital AP Document Unmatching AP0190 This screen is used to unmatch any AP documents matched improperly For example suppose that two vendors A and B have sold goods worth AED 700 with references AP SI A 0001 and AP SI B 0002 respectively Sometime later a payment of 700 AED is made for Supplier A for the AP Invoice AP SI A 0001 generating a cash payment voucher with reference number CPV A 0001 Similarly another cash payment voucher is generated when the Supplier B receives a payment of 7O0AED with a reference number CPV B 0002 Now suppose AP Matching was then done and mistakenly the cash payment CPV A 0001 was matched with Supplier B s AP Invoice AP SI B 0002 and likewise CPV B 0002 was matched with AP SI A 0001 This kind of matching is improper and will lead to inaccurate information In such cases the AP Unmatching tool can be used to unmatch these documents These unmatched documents can be re matched using the AP Matching form EJ Ar UnMatched Transactions ole S Action Edit Block
6. TIT LL PO Boe 30448 Duba UAE Rei D 38987 DZ42 Fac 04 397 1877 The 46142 amp GROLIP EM BANK RECEIPT Received With thanks From Receipt Ho BRCT 2004 00001 Date 25 FEB 04 Mode CHEQUE Cheque No 76376565676 Date 25 FEB 04 0652000145 Doc Type BANK RECT Bank 00150D Branch BANK OF DUBAI DERA Cust Alc No 001 001 001 User Code ID Currency DIRHAMS Amount in Figures 1106000 Amount In Words ELEVEN THOUSAND SIXTY ONLY In Settlement of Confirmed By Received By Page 132 of 191 Capital File View Help amp 2 EX A p Pee f CASH RECEIPT Received With thanks From D i CRCT 2005 00001 02 NOV 05 CASH CASH RCT CASHMEMO ID Currency Amount in Figures Amount In Words Page 133 of 191 Capital PDC Listing by Bank E e md REPO ng Bal Action Edit Block Field Record Query Window Help AAA Bejsan mpi SFR A CON Information Dynamics SUPE POC By Bank AF Y j 01011990 R ecord 1 1 List of Values 050 gt lt DBG gt 23 3 ax DA m s vi Page JT Wd PageNo 1 ofl RunDate 26 DEC 2007 Information Dynamics att us seas PDC LIST BY BANK RefNo ARROIS User D PO hor 9548 Duel UAE Set DANS GAT Pan 04 390 INNT Tw 6142 DONTE A From Date 01 01 1998 To Date 01 01 2007 Page 134 of 191 Capital DC Listing by Customer POC LIST BY CUSTOMER J From Tale
7. 05 301 W01 060415 000 05 53501 W01 060416 000X 05 301 W01 060416 000 06 SOL WOL 06041 6 0001 06 501 W01 060416 000 06 CUSTOMER SALES FOR LOCATION W01 301 W01 060416 0000 3 CUSTOMER SALES FOR LOCATION 401 301 W01 060416 0000 5 CUSTOMER SALES FOR LOCATION W0 3501 W01 060416 0000 CREDII CUSTOMER SALES FOR LOCATION W01 501 N01 060416 00040 6 CREDIT CUSTOMER SALES FOR LOCATION W01 301401 060416 0000 6 CREDIT CUSTOMER SALES FOR LOCATION W01 501 V01 060416 0004X 6 Total Transactions Total Transactions With Opening Balance Closing Balance Due To You Due TO Us TAFF The 46 14 SUP EPA Page No Ref No 22337 01 01 1998 6 12 2007 Outstand Debit 0 00 10 00 1 of APROTO Uzer Kun Date 26 DEC 2007 ID Payment Terms 0 DAYS Credit Limit 0 00 Currency DIRHAMS Outstand Credit Foreign Amt 0 06 1198 00 1198 00 1198 00 3594 00 3594 00 3564 00 Page 189 of 191 0 00 10 00 DHS 1198 00 DHS 1198 00 DHS 1198 00 DES Capital Age Analysis as on date 4 JAPROOSA As on date Be Lc bee 30 ax pa Toon snper iE XMF ANIT VAN MAY 1 HM CREE WO ALARTE Im GMOMORTI 6 Daya THLE n MOSATC TASENMONT PLC 20 Daya THSG 50 GHARD PALS JESETISGR Ja Page 190 of 191 Information Dynamics
8. 3 Add any notes if required and then click on Process to do the reversal Page 33 of 191 Capital RINO7OZ0003 ca RECEIVABLE INVOICE Bea SI VOICE 23 FEB 2007 23 FEB 2007 INV NO 345 23 FEB 2007 23 FEB 200 For the sake of demonstration eae ele Page 34 of 191 Capital AR Voucher Cancellation AR0050 Use this screen to cancel any AR Voucher entry created earlier o Record 1 1 List of Values Sc DBG gt Enter or select the document number of the required AR voucher and enter the cancellation remarks Then click OK to cancel the AR Voucher Entry Page 35 of 191 Capital Cash Receipt AR0091 Whenever an Accounts Receivable Customer makes cash payment a cash receipt needs to be generated For this purpose the Cash Receipt AROO91 is used As a pre requisite the document type must be pre defined in the Document Type Master C00050 gi Cash Receipt oles m x Ex Action Edit Block Field Record Query Window Help SUPER USER Reference Details Document Type ae Document Number os Bank Cade Other Resines Currency Details Currency code Date Details Exchange Rate Foreign Amount Document Date 16 DEC 2007 Base Amount G L Date i b DEC 2007 3 Additional Information Narration Allocation Total Motes Allocation Details uio dee RIEN Exchage Rate Foreign Amount Local Amount Narration
9. Date Details Currency AED J ARAB EMIRATE DIRHAMS Document Date 224UG 2007 wj Exchange Rate Foreign Amount 10000 G L Date 22 amp LIG 2007 Base Amount Age Date 30 AUG 2007 e Narration Mothin special Due Date 29 AUG 2007 es Allocation Total More Details Total Entry Completed Kore Details Allncatinn Details Page 25 of 191 Capital 7 Click on Send for Approval or Entry Completed The User can see the display against the check box as either Send for approval or Entry Completed While creating the document type master if the User specify that this document requires approval then once the User complete this document the User have to click the check box so that it will be received by the person who is suppose to approve it If it is Send for Approval it means that the voucher requires approval and Entry Completed means it does not require any approval In both the cases the User will have to click the check box so that the voucher can get created If the User don t click the check box then it will still be available for modification 8 Finally enter the allocation details required Allocation Details Allocation Cade Mieten Code Beene Rate Foreign Amt Local Amt Narration 10000 Allocation Details Mothin Special Enter value for Document Type Record 3 3 List of Values 05C gt lt DBG gt 9 Click on Allocation Details button if the User
10. 1 000 00 User Code ID Amount In Words ONE THOUSAND AND 00 100 ONLY In Settlement of E amp OE Page 98 of 191 Capital BANK PAYMENT JV Other Reference Doc Number BPY07080001 Doc Type BPY Doc Date 27 AUG 07 Gl Date 27 AUG 07 Currency AFD ARAR EMIRATE DIRHAMS Exchange Rate 1 00 Foreign Amount 1 000 00 Status Normal Local Amount 1 000 00 Allocation Description Debit Details Harration Amount AED 60011103 HSBC CURRENT ACCOUNT Demo Demo In Words ONE THOUSAND AND 00 100 ONLY Prepared By ID Approved By Page 99 of 191 Capital Payment Confirmation AP0240 All approved payments are shown here Select documents which are to be confirmed and save settings BPVO7080001 DTAUG PDU ae EE et Payments will appear in this screen only if the setting for confirmation was opted in the Document Type definition master The Payment confirmation screen helps double check transaction details Page 100 of 191 Capital The Payment Reversal APO290 screen is used to record reversal transactions on an earlier payable transaction The Payment reversal document must be defined using the Document Type Master C00050 and linked to the Payment documents using the Voucher Reversal Link C00120 The User can do a Cash Bank PDC Payment reversal only for existing Cash Bank PDC Payments Page 101 of 191 Capital Payment Cancellation AP0420 Use this screen to cancel
11. 13 INT wr 200700340 33314 DR esos oNTH END13 INT NT 2007 00340 iNroU Re esn MONTHEND13 INT wr2007 00340 Baie R eg MONTH END13 INT wr2007 00340 Nro fR sos JwowreEND 130 INT INT 2007 00342 naris DR esos MONTH END13 INT wNT 200700342 Into DR O pon MONTH END 13 INT wr 2007 00343 i1 n3 pR ose MONTH END 13 INT wr2007003433 wr DR psn MONTHENDIS INT Nr z00700344 aasa p poss IMONTH END13 25093 INTO INT 2007 00344 INTOOT DR MONTH END 13 NT NT 2007 00345 183737 DR 25094 MONTH END 13 i E INT INT 2007 00345 INTOOT DR 25094 MONTH END 13 4 Debit Local Amt Credit Lacal Amt 468809311 2054964 Enter value for Document Type Re ecord 27323 27323 lt OSE gt DBG gt Click the Query button once enter the AR Code required and then click the query button once again to retrieve all transactions related to that particular AR Code Same can be done with other fields also Place the cursor in the AR Code field and then double click the query button or press F8 to list all the AR transactions Page 71 of 191 Capital AR GL Query AR0320 This query form is used to query for the AR transactions that have been posted in to the General Ledger Ej AR GL Query Ex Action Edit Block Fiel
12. 25 FEB 2004 Drawer Branch BANK OF DUBAI DEIRA Drawe Bank 001 001 001 Narrati Wwersers Allocation otal arratinn T4 RET Status Posted Notes jersere Allocation Details Exchage Rate Foreign Amount Local Amount Narration i R JI 11060 usn Allocation Details Enter value for Document Type list of values available Record 177 l l lt OSC gt kDBG To query for an AR receipt click the query button once and select the criteria Document Type Bank Code or Document Number required and then click the query button again The system will populate the details of the receipt based on the query Double clicking the query button will fetch all the AR receipts The User can navigate through the receipts by using the up and down arrows Page 68 of 191 Capital Multi Bank Receipt Query AR0340 The Multi Bank Receipt Query ARO340 is used to query for the AR multi bank receipts generated during various AR multi bank transactions Ex Multi Bank Receipts Ex Action fs 2 ARO340 Information Dynamics SUPER USER Document Type A Document Number Other Reference Dates Amount Details Stats Document Date s Cash Total Local Amount Gl Date Cheque total Allocation Total Narration Notes r Cash Bank Details Bank Code Currency Code Exchange Rate Foreign Amount Local Amount Cheque Number A _ Allocation Details Allocation Currency Exchage Rate
13. ES c c 149 BUS Colec Hons REPOTI entities 150 o AAA E A AE re 151 Lu DESDE oe E EEE EAN EE 152 Du TIAM ANSE OEE IAEN apap EAA A A 153 B o AI AS NNI NE 154 O ar di Bo Iri T T 155 Not Approoed Vouchers AR ista 156 ve a NS E E A 157 A a E co EN O A A 199 4 3 ACCOUNTS PAYABLE REPORTS ssssssssesossorosossossesossesosocecsossosossosoesosossssosossosossesossosossosossssssoeses 160 B NETUS eee Ce ee reo er eee P 161 AN AS A rr is 162 AAA TT 164 E E A RUD GPS INNER RU NU evens 165 Taek ENTM T m 166 PL IESU UU DU cose uo DEN Erbe mM M RE 167 ee CENT 168 ad veo Rr AMA MNT 169 a Miu T m 170 Document reparen nud Cancelled on E SOME UN ecien usi rtatuv tu petu s 171 a de a CaN as AAA rio O EE errr tet 172 DIEGO o DEDE DE Paneer reer Ped ore A prb reser 173 Pond idis ri o RM 174 Payment Date lt Due Date of th Matched Documents AP satan isos 175 Payment Date gt Due Date of the Matened Documents AP Dunst apo 176 E A e A NN OO Ncc 177 Capital MM D c Eo A UU A A A 178 ata O UH E C o y T 179 FT a rears soonest PI AE A A A A A A 180 Pom AO a a r r teen ae 181 AA OEI EEA O EPOE M R 182 INE I E E ii 183 O COS Eme 184 O TOMOS DP a idos 185 Ea ET O PE OO M NIMM M DUE MED 186 EXA II AA 186 DAL A ee eT o oo ere E 187 COn en o memen O ACES ar OS 189 o E COTON TU 190 Page Capital 1 Introduction CAPITAL is a comprehensive Fi
14. Enter value for Document Type list of values available Record 171 List of Vales DSC lt DBb gt Fields those were not explained earlier will only be explained The User can take a look at the table in the section Voucher Entry AR0070 for some information Page 36 of 191 Capital To generate a cash receipt for the payment made by the AR Customer 1 First select the document Type by clicking on the LOV button Usually the document type selected is the Cash Receipt Voucher which must be pre defined in the Document Type Master Id Document Type Master Document Name CASH RECEIPT Cancel 2 Next select the Bank Code using the LOV button 3 The User can then enter any additional reference details if required 4 Next specify the current transaction s currency details 5 Specify the date details 6 Enter the narration for that particular receivable transaction and also specify the name of the person from whom the cash was received 7 Click on Send for Approval or Entry Completed Page 37 of 191 Capital The User can see the display against the check box as either Send for approval or Entry Completed While creating the document type master if the User specify that this document requires approval then once the User complete this document the User have to click the check box so that it will be received by the person who is suppose to approve it If it is Send f
15. Field Record Query Window Help Page 108 of 191 Capital AP Document Static Change AP0360 22 DEC 2007 11 52 57 Use this screen to modify the narration and other references for any AP document in the corresponding GL All GL Header Cash Book Page 109 of 191 Capital AP Opening Balance Entry GL0310 An opening balance is automatically created when the User enter the first transaction for a supplier However there may be situations wherein it may be required to enter the opening balance for a supplier At such times the AP Opening Balance Entry GLO300 form proves to be handy 2DEC 2007 Jl jee DEC 2007 J Page 110 of 191 Capital AP Opening Balance Confirmation GL0320 Whenever an AP opening balance is created either in the form of a transaction or using the AP opening balance entry GL0300 form it needs to be confirmed For confirming these opening balance entries use the AP opening balance confirmation GLO320 form Total Number of Transactions to be Posted Document Number Local Amount Status Enter value for Status Record 1 3 lt OSC gt kDBG The screen will display all AP opening balance entries that haven t been confirmed Enter the GL Date for the transaction to be posted place a check mark next to the entries that the User wish to confirm and the click the Save button Page 111 of 191 Capital Payable Voucher Query AP0220 The Payable Vou
16. Foreign Amount Local Amount Allocation Details FAM 40301 Quer caused no records to be retrieved Re enter Pecord 12 Eniter Guery List of values DSC lt DBG gt To query for an AR multi bank receipt click the query button once and select the criteria required and then click the query button again The system will populate the details of the multi bank receipt based on the query Double clicking the query button will fetch all the AR multi bank receipts The User can navigate through the receipts fetched by using the up and down arrows Page 69 of 191 Capital AR Matched Transaction Query AR0260 This query tool is used to retrieve details of all the AR matched documents of a balanced transaction Ex Ar Matched Transactions Query Ex Action Edit Block Field Record Query Window Help EJ s ela B EE JE 33 4 zt z ARO260 Information Dynamics SUPER USER From Doc Fram en To Dd OsLoon02 OSLODOD E OSL0000 OSLOD0O pOSLUOOUE OSLODOO jo sL gude pOSLUOUUS pOSLUOUUS pOSLUOUUS pOSLUOOUS OSLOD00S pOSLUOOUS OSL00004 Seral Amount Doc Date q pe O IS sesperes omar nannan peas s 993f6FeB2o06000000 22254 fT 1 6P0 FEB2oosc00000 22254 E iheFEe 2008oo0000 2254 Moo s t003e0 FEB eoosco0000 22254 fm 1 ve PEB 2006 000000 22254 fm PA e PEB 2006 000000 22254 fm i s83f6FEB 20060000 00 22254 oo 1 34420
17. P007 60040901 ID PCR PcRD7030001 f D1 MAR 07 D1 MAR 07 2007 60041501 PAY PCVLA POYLAD 040001 f O7 APRO l z APR 07 2007 60042200 CPV CPv07030001 2 D1 MAR 07 D1 MAR 07 je an 50042200 PCVAD PCVADO O40001 2 T2 APR 07 iz APR 07 2007 60042200 PCVAD POvADO7040002 f 1 amp APR 07 6 APPR 07 R007 0042401 BPV BPv07040001 f Oe APR O 02 AFR 07 2007 DebitLocal Art Credit Local Amt 39320 38320 The User can query by entering the required GL Account Code Scroll to the right to view more details Page 116 of 191 Capital AP Matching Transactions Query AP0330 This query form is used to query for the AP transactions that can be matched Document Document Document Exchange Des Number Seral Code Date ney Rate INDP00001 fi 00 08 MAR 05 ps p2 INDP00002 f 00 2 ALIG 05 USD 3 6E p2 INDP00003 f 00 24 ALIG 05 USD 3 66 132 INDP00004 f 00 25 AUG 05 USD 4 66 p2 INDP00005 f 00 25 AUG 05 AED 1 132 INDP00006 f 00 25 AUG 05 USD 4 66 32 POP00004 Mo f g MAn D 7 UKP 7 25 BANK PAY BPAY 2004 00001 5001 f JANM 04 AED 1 BANK PAY BPAY 2004 00002 Fei 23 FEB 04 AED 1 PUR CN PURCN 2005 00001 f 00 25 JUN 05 AED 1 PUR DN PURDN 2005 00001 f 00 25 JUN 05 AED 1 PUR INV PURIN 2004 00001 5001 f JANM 04 AED T m JPUFLINV PURIN 2004 00002 roo 02 APR 05 AED T DebitLocalAmt Credit Local Amt 6093 69 2341075 25 DS
18. PERFORMANCE FOR THE MONTH Currency DIRHAMS 149872 19 Page 177 of 191 Capital AP Master Listing al ea EN xx rz E EI ETE APR300 AP Master Listing AP Master Listing IA fil 320 ax 98 uusumeP Run Date 26 DEC 2007 SCRI RENE AP MASTER LISTING Uzer ID Supplier Code Supplier Name P O Box No Address Line 1 Address Line 2 Y 0 00 Address Line 3 00 2261376 06 Page 178 of 191 Capital Page No 1 of 1 Run Date 26 DEC 2007 RefNo APR390 Uzer SUBSEQUENT COLLECTION REPORT AP Year 2000 Page 179 of 191 Capital AP Transaction Listing A AER l Page No ofl Run Date 26 DEC 2007 pn ae ON MN SCA TRANSACTION LISTS AP Ref No APRO30 User ID NN OOTP RRL Oe eT TY Oe tee i From Date 01 01 1998 To Date 26 12 2007 Base Currency DIRHAMS oplier Code amp Name Doc Date Reference No Other Ref No Allocation A c Code Foreign Local Balance Amount Amount Amount GOODSWORTH 01 AUG 05 NDP00002 E03493 7785 00 USD 28493 10 28493 10 GOODSWORTH 01 AUG 05 NDP00003 E03600 test 11770 50 USD 43080 03 43080 03 GOODSWORTH 01 AUG 05 NDP00004 E03600 1537 80 USD 5628 34 3628 34 GOODSWORTH 01 AUG 05 NDP00005 VMITEST Tested by Vannessa in presence o 140 00 AED 140 00 140 00 Gavin GOODSWORTH 01 AUG 05 NDP00006 F50001 Tested DSD invoice by vanessa 20 28 USD 74 22 74 22 supervised by Gavin MOSAIC FASHIONS 19 MAY 07 PDP00004 EYEO01 9994 00
19. Tested by Vannessa in presence 140 00 AED 140 00 of Gavin Tested DSD invoice by vanessa 74 22 supervised by Gavin 01 AUG 05 77415 69 Page 169 of 191 Capital Currency wise Transactions Report Mame Currency Wise Transactions AP No f1 Inftomation Diysamibca im v5 CURRENCY WISE TRANSACTION LISTS AP E i ess deme mam mune 3 AQ CA he Om aE shiv a tho me From Date 01 01 1998 To Date 26 12 2007 Supplier Code amp Name 100 GOODSWORTH Date BaseDoc Type Reference No 32 Tested by Vannessa in presence of Gavin Page 170 of 191 Capital Document Prepared and Cancelled on the same day formation Dar E EE RE DOCUMENTS PREPARED AND CANCELLED SAME DAY sy fame BEES Au Hm OS m a l Irem Dee LOLI Tee Tinte i 51 SSG Document Humber Bate ot Doc tye oe tine CeherBefereno Maroc Foreign cer Page 171 of 191 Capital Number of Reversals AP EA PageNo of 1 RefNo APROS0 AAA inaa idi dd ID MIX lE Iul o NUMBER OF REVERSALS IN AP From Date 01 01 1998 To Date 26 12 2007 Base Document Document Type TOTAL Page 172 of 191 Capital Number of Cancelled Documents AP AA A A E gee tess UM y 7 f y a f zi 1 i eee A ree AO eost rm eae ne H A CE E m Y N A55 X po ES Name EX Number af Cancelle PageNo 1 ofl Run Date 26 DEC 2007 Enformation Dynamics e dale iae y pm Ref No Hihi APR100 Uz
20. USER Customer Code Al Telex Customer Name L Hn E MAIL P O Box AN Receivable Type Cash v Address Line 1 Status Normal Address Line 2 ll Limit Type No Lirnit Address Lom 3 y _ OQO 1n Limit Amount 0 Telephone Add Up FAX 1 Final Limit i Credit Days 8 Additional Currency Group Details Analysis Detals Lh 1 End User Account Description Enter value for Customer Code Record 171 x List of Values sBsC DBL gt This screen also stores the additional currency details the AR group details Analysis details and also the license details of the AR customer Page 19 of 191 Capital AROO60 AR Master A code entered by the User to identify the AR customer It must be unique Name of the AR Customer Contact details of the AR customer Name of a person to contact when the customer is not reachable The type of receivable expected from the customer Cash Cheque Both Telex Transfer Draft The status of the AR Customer Account Normal Receipts only Black Listed The type of limit imposed Fixed limit No Limit The maximum amount above which the receivable is not supposed to exceed for that particular customer The tolerance percentage above the set limit that the system can allow This is calculated by the system based on the limit amount and the add up percentage set The number of days given to the custome
21. and down arrows Page 113 of 191 Capital AP Matched Transaction Query AP0280 Use this query tool to retrieve details of all the AP matched documents of a balanced transaction Matched From From AR 12 Dac Amount Doc Date Code Type 100 01 MAR 200 icon 3 EPYO7030007 500 D1 MAR 200 coo PIN PINOY Oso IPCROFO30001 f 200 01 MAR 200 coo BPV IBPYO7030 PINO 0530002 f 300 f 4 MAP 200 coo BPV IBFD 030 IPIND 040001 f 100 07 APPR 2007 con RPIN IRPIND 04 PINO 040002 f 550 07 APR 2007 coo PIN RPING O8 IPIND7 040003 f 456 f12 APR 2007 coo PIN IRPIND 04 PIND 040003 2 456 12 APR 2007 cam RPIN RPINO O4 Enter value for From Doc Type 000 000000000000 00 0 00 Record 1 8 DSE lt DBG gt Scroll to the right to view more fields To query for a matched transaction enter the document number and hit enter Place the cursor in the AP Code field and then double click the query button or press F8 to list all the matched transactions Page 114 of 191 Capital AP Transaction Query AP0250 Use this query tool to retrieve details of an AP transaction By clicking the Match Details button the system will allow the User to view the matching details of the particular transaction also Ap Transaction Query ES Action Edit Block Field Record Query Window Help area Wim wx 21412 Document Document u Base Document Internal Other Type Number Serial
22. any Payment vouchers created earlier Record 1 1 List af Values kosc DBG gt Enter or select the document number of the required Payment voucher and enter the cancellation remarks Then click OK to cancel the payment Page 102 of 191 Capital PDC Payments AP0110 If the User make a Post Dated Cheque payment to a creditor PDC Payments APO110 is used to generate payments As a pre requisite the document type must be pre defined in the Document Type Master C00050 dj PDC Payment Cua Ex Action Edit Block Field Record Query Window Help fiw CE 8l e B RFR i Al de AP0110 Information Dynamics SUPER USER Reference Details Document Type A Document Number pan k Code Al Other Reference Currency Details Currency code 83 Date Details Exchange Rate Foreign Amount Document Date 22 DEC 2007 e Base Amount G L Date 22 DEC 2007 sr Cheque Details e Cheque Number Cheque Date 22 DEC 2007 z Clearance 22 DEC 2007 Beneficiary Account Beneficiary Branch Send For Approval M Pisanan Pe Allocation Total Notes o Allocation Details Allocation Code Currency Exchage Rate Foreign Amount Local Amount Narration Allocation Details Enter value for Document Type list of values available Record 1 1 List of Vales DSC lt DBG gt The fields and parameters have been explained in earlier sections The User can take a look at the table in
23. dl Final Limit 0 00 Credit Days 0 Balance 00 Address Line 3 Telephone Fax Analysis Details Description DEBTOR Addition Currency Currency Code Page 146 of 191 Capital Unposted Transactions A MEM wo n VPape e pool Bun ceca LNPOSELD TRANSACTIONS AR nana ar ate Page 147 of 191 Capital AR Summary Report lolas ACCOUNIS RECEIVABLE Page No 30 of30 Run Date 26 DEC 2007 30448 Dubai UAE SUMMARY REPORT RefNo ARR280 User ID From Date 26 12 2003 To Date 26 12 2007 Invoice Receipts Debit Note Credit Note Closing Balance Credit Limit 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 12575 35 13175 35 0 00 433110 28 433110 28 0 00 433110 28 433110 28 0 00 6741 24 6741 24 0 00 6741 24 6741 24 0 00 714 00 8658 40 6340 40 0 00 714 00 8658 40 6340 40 12054 48 861479 11 Page 148 of 191 Capital Daily Collections DAILY COLLECTION Page No ofl Run Date 26 DEC 2007 RefNo ARR400 User ID aR Ne Las TEAL sos eT Ret PH From Date 26 12 2002 To Date 26 12 2007 Branch Location Doc Number Cash Bank Code Cheque Date Cheque No Branch Currency Foreign Amount BRCT 2004 00005 001BOD 03 MAR 04 WERWERERE 1000 00 BRCT 2004 00001 001B0D 76576565676 BANK OF DUBAI DERA 11060 00 BRCT 2004 00002 001B0D 2323232 BANK OF DUBAI DEIRA 25 69 BRCT 2004 00003 001BOD 123344 BANK OF DUBAI DEIRA 7446 00 BRCT 2004 0
24. done as per the existing layouts in Capital or as per the user provided layouts Page 11 of 191 Capital GL Master GL0030 Existing COA Chart of Accounts of the company will be interfaced using the below entry screen Once the GL master is created then the corresponding GLs will be linked for the invoice receipt positngs Enter value for G L Code Record 1 1 lt OSC gt DBG gt Page 12 of 191 Capital 3 2 Accounts Receivable Module Setting Up the Accounts Receivable Package In order to perform any transaction on the AR customers it is necessary that the AR package be set up by defining the masters and other configurations in accordance with the company s business processes Page 13 of 191 Capital Group Master AR0020 This form is used to define the various AR Debtor groups the User will be dealing with in business By defining group level settings the system will retrieve those details whenever a transaction is done on the customer belonging to that group ARO020 Information Dynamics Group Description Account Code aa CA RD CREDIT CARED 10010601 a TR Enter value for Group CEA PSB The screenshot shown above is that of the AR Group Master AROO20 This form makes it possible to categorize the Debtors or AR Customers by location purchasing power loyalty or by any other user defined classification Page 14 of 191 Capital AR Control de
25. the AP Group Master APOO20 This form makes it possible to categorize the Debtors or AP Vendors by location supplying power loyalty or by any other user defined classification Page 80 of 191 Capital AP Control definition AP0010 Once the AP Groups are created in the AP Group Master APOO20 the User has to define the controls that ought to be levied upon the groups The form AP Control Definition APOO10 facilitates this Below is the screen sample of the AP Control Definition form This screen allows the User to state whether discounts and tax are allowed or not for a group which will be set as the default group It also helps configure the parameters that will be displayed while generating analysis reports Page 81 of 191 Capital Take a look at the table in the next page to get a better understanding on the purpose of the different fields in the form APOO10 AP Control Definition A group selected from the LOV and set as default This will be updated by the system and hence no user interaction is necessary Basically it displays the date on which the most recent posting was done on for the group Document Type Document Date Other Reference No These different options help the User set Amt Descending the matching screen that will appear Order while doing the AP matching Amt Ascending Order A flag indicator to specify if discounts are applicable or not A flag indicator to s
26. the User wish to do a document matching Proceed as required Page 51 of 191 Capital PDC Confirmation and Cancellation ARO120 Use this screen to confirm or cancel the PDC received Scroll to the right to view more details The User can also specify the PDC transfer details here The Post Dated Cheques will get displayed automatically when the Bank Code is selected Page 52 of 191 Capital AR Document Matching AR0130 This tool is used to match AR documents when the transaction is complete AR Document Matching is one of the most important features of the Accounts Receivable module The document matching plays an important role in reducing the work load of the system by just ignoring any receivable transaction that has been balanced since no further transaction will occur on it Whenever a complete recovery full or in parts of the receivable amount is made the corresponding sale transaction document s and its receipt transaction document s has to be matched This will prevent the system from spending its valuable resources and time for it along with other incomplete transactions For example an AR sales invoice has to be matched with its corresponding Cash Bank Receipts Another important point to be noted is that for successful document matching the documents must be previously linked using the Allocation Master during the implementation Only if this is done will the User be able to match these
27. to match the document Forms 9 A message box appears showing the system generated voucher number Forms Page 48 of 191 Capital PDC Receipts AR0110 If an Accounts Receivable Customer makes a Post Dated Cheque payment PDC Receipts ARO110 is used to generate receipts As a pre requisite the document type must be pre defined in the Document Type Master C00050 El PDC Receipt oles fr Ex Action Edit Block Field Record Query Window Help ARO 10 Information Dynamics SUPER USER Document Details Document Type sal o et EA Other Reference gt Currency Details Currency code 3 Date Details Exchange Rate Foreign Amount Document Date b LEC 2007 9 BaseAmount G L Date 16 DEO 2007 Cheque Details Cheque Number Cheque Date b DEC 2007 2 Clearance B DEC 200 7 J Branch pal Drawer Account Narration Allocation Total Notes Allocation Details Allocation Code rency Exchage Rate Foreign Amount Local Amount Narration Allocation Details Enter value for Document e list of values available Record 11 List of Values siS DBa The fields and parameters have been explained in earlier sections The User can take a look at the table in the section Voucher Entry AROO70 for some information Page 49 of 191 Capital To generate a cash receipt for the payment made by the AR Customer 1 First select
28. 0004 001BOD 878978 BANK OF DUBAI DERA 100 00 4324324324 BANK OF DUBAI DERA Page 149 of 191 Capital Subsequent Collections Report in Subsequent Collectio jg Preview Page No 1 ofl RefNo ARR410 SUBSEQUENT COLLECTION REPORT AR Year 2000 Page 150 of 191 Capital AR Transaction Listing m Information Dynamics PA oigo adi TRANSACTION LIST AR Pta BO Oda UAE CA FE EO Fus OCT TET Dae did MICA iw PageNo 1 ofl Run Date 26 DEC 2007 RefNo ARRO30 Uzer ID From Date 01 01 1998 To Date 26 12 2007 Base Currency DIRHAMS Customer Code amp Name DocDate Reference No Other Ref Nc Narration i Foreign Local 22336 i 16 APR 06 OCNO00039 501 W01 060416 00000 CREDIT CUSTOMER SALES 200 00 DHS 4 FOR LOCATION W01 501 W01 060416 0000004 22336 E 16 APR 06 OCNO00040 501 W01 060416 00000 CREDIT CUSTOMER SALES 200 00 DHS 4 FORLOCATION W01 501 W01 060416 0000004 16 APR 06 0OCN00041 501 W01 060416 00000 CREDIT CUSTOMER SALES 200 00 DHS 4 FOR LOCATION W01 501 W01 060416 0000004 16 APR 06 OSLOO009 501 W01 060416 00000 CUSTOMER SALES FOR 224 00 DHS 3 LOCATION W01 501 W01 060416 0000003 16 APR 06 501 W01 060416 00000 CUSTOMER SALES FOR 224 00 DHS 3 LOCATION W01 501 W01 060416 0000003 16 APR 06 301 W01 060416 00000 CUSTOMER SALES FOR 224 00 DHS 3 LOCATION W0i 501 W01 060416 0000003 TOTAL TRANSACTION SUMMARY Customer Code Type 22336 INV Page 151 of 191 Cap
29. 007 NOT APPROVED VOUCHERS RefNo APRI110 User From Date 01 01 1998 Page 185 of 191 Capital Payable Cheque Printing Repo ating ES Action Edit Block Field Record Query Window Help K kwn pi de GM Geni Dey Ws Eb 0000000000000 eB UK Bajsa BMI IFRR A 5 cono itomation Dnanies suren ust Payable Cheque Print A Preview pd Record 1 71 List of Values D5C lt DBG Limit Base Master Listing Es JARA BAAR TER TISTIH HU Bil UA EA A Le Page No 1 ofl Run Date 26 DEC 07 RefNo APROOL Uzer ID A A O LIMIT BASE MASTER LISTING AP Page 186 of 191 Capital Duplicate Printing KOSC gt DBG gt Page 187 of 191 Capital Kal Tcr320 Previewer File View Help El XX DEBIT NOTE DOCUMENT DETAILS Document Number SDNR 2006 00002 Document Date 5 00 APR 06 Due Date 1 09 APR 06 Other Ref VPEWOL4O0157 User Code 501 Page No 1 of 1 1 00 rand Total DIRHAMS FIVE ONLY Page 188 of 191 Capital Consolidated Statement of Accounts File View Help amp 3 5 ax amp 1 E n Pase IET STATEMENT OF ACCOUNT From AR Post Box No Type 16 APR 06 INV 16 APR 06 INV 16 APR 06 INV 16 APR 06 INV 16 APR 06 INV 16 APR 06 INV Reference Ho OSro0010 OCNO0O038 OCNOOUAD PO Bae SIGAN Dial UR E Tel 8 307 CUL Fax Cy Other Ref Ho Harration Opening Balance 501 V01 060416 000
30. 0101 1998 Lo Date LES Page 135 of 191 Capital Transaction based on Details tenor AARROSO t Transactions Based on Detail 1 to 10 AR ransactians Based on Details Information Dynamics sm etnies o5 DETAIL WISE TRANSACTION LIST AR ELS From Date 01 01 1998 To Date 26 12 2007 Base Currency Customer Code amp Name 22336 Doc Date Base Doc Doc Type Other Ref Nc Narration 17 301 W01 060416 00000 CREDIT CUSTOMER SALES 4 FOR LOCATION W01 501 W01 060416 0000004 17 301 W01 060416 00000 CREDIT CUSTOMER SALES 4 FOR LOCATION W01 301 W01 060416 0000004 17 501 W01 060416 00000 CREDIT CUSTOMER SALES 4 FOR LOCATION W01 301 W01 060416 0000004 11 501 W01 060416 00000 CUSTOMER SALES FOR 3 LOCATION W01 301 W01 060416 0000003 11 501 W01 060416 00000 CUSTOMER SALES FOR 3 LOCATION W01 501 W01 060416 0000005 501 W01 060416 00000 CUSTOMER SALES FOR 3 LOCATION W01 501 W01 060416 0000003 Page 136 of 191 Capital Currency wise Transactions dpi 998 e 28 12 2007 y JUSDAED PageNo 1 of Information Dynamics cia ieas CURRENCY WISE TRANSACTION LIST AR Reno ARRO60 Fm e AA w EUNT AL ee A Customer Code 8 Name 32643 BAILEY D Doc Date Base Doc Type Reference No Narration Allocation A c Code Foreign Amount 04 DEC 05 DR INT 2005 01903 Interest for the month 001001020133002 04 12 2005 DR INT 2006 02246 Interest for the month 001001020133002 15 01 2006 DR INT 2006 02444 Int
31. 2 38 WS enar ERU A ee Freeze Enter value for Document Number Record 1 1 List of Values lt 05C gt lt DBG gt This form is used to freeze a document in a transaction cycle This document once frozen will not be available for any sort of transactions Page 120 of 191 Capital Document Unfreeze AP o A ee Enter value for Document Number Record 1 1 List of Values asc DBG This form is used to unfreeze a payable document that had been frozen from transactions earlier Page 121 of 191 Capital 4 Informational Requirements 4 1 General Ledger Reports Sample Reports and their calling forms are pasted in the following pages Page 122 of 191 Capital Cash Book Detail This item will get you a summary on the Cash Book TH FE Ele View Hep 32 8 ax 92 00201 rol Poe 644 Our GAE OA IN BOAT Far OUT TA Mo A142 GO dd m Doc Date Deposit Slip No Ref No BANK CASHMEMO CASH MEMO COLLECTIONS 16 APR 06 OSL00011 wol 15 AUG 06 OCN00043 wol 15 AUG 06 OCN00043 wol 15 AUG 06 OSL00012 wol 11 MAR 07 PSL00001 GS BANK CR CARD CREDIT CARD COLLECTIONS CASH BANK BOOK DETAILS Pg Noa uf Run Date 22 DEC 2007 Ref No GLR030 User E 1D From Date 01 01 1998 ToDate 2242 2007 23 59 59 Chq No Chq Date DebitAmount CreditAmount Run Balance Currency AED CASH COLLECTION FOR LOCATION Wol CASH LAYBYE RETURN FOR LOCATI
32. 2 OCT 05 0 00 611 00 611 00 23 OCT 05 0 00 100 00 100 00 25 OCT 05 0 00 1 00 1 00 Page 124 of 191 Capital 4 2 Accounts Receivable Reports E papi ff n r E pe Payable Repats ES y Prepared Cancelled Same Black Listed Mail Attachment Sample Reports and their calling forms are pasted in the forthcoming pages Page 125 of 191 Capital Detailed Ledger 2 2 x 9 0 Ho wl Poel m Information Dynamics als ii y ga DETAILED LEDGER AR PULMO AMA AA EDS Bot S DA IS A Tac A IA A From Date 01 01 1998 To Date 26 12 2007 Customer Code 22337 Customer Name Payment Terms 0 Days Credit Limit Doc Doc Ref No Narration i Credit Balance Foreign Due Date Other Type Date Amount Amount Amount Clearance Date Ref No Opening Balance 1 0 00 0 00 CUSTOMER SALES FOR 10 00 DHS 301 W01 060416 00000C 16 APR 06 LOCATION W01 301 W01 060416 0000005 1198 00 DHS 501 W01 060416 00000C 16 APR 06 501 W01 060416 0000006 CUSTOMER SALES FOR 10 00 DHS 501 W01 060416 00000 16 APR 06 LOCATION W01 501 W01 060416 0000005 CREDIT CUSTOMER 1198 00 DHS 501 W01 060416 00000 16 APR 06 SALES FOR LOCATION wol 501 W01 060416 0000006 CUSTOMER SALES FOR j 10 00 DHS 501 W01 060416 00000C 16 APR 06 LOCATION W01 501 W01 060416 0000005 CREDIT CUSTOMER 1198 00 DHS 501 W01 060416 00000 16 APR 06 SALES FOR LOCATION wo
33. AP Code Type Humber Referenc 62 NDPOOD2 LL v SST B2 oro fi e628 JE03600 B2 NDPoom4 2629 En3600 B2 wore 2630 MITES B2 wore fi P631 Foon e654 EYEDO1 es A Debit Local Amt Credit Local Amt 0 143872 13 Enter value for Document Type E Record 676 SC DBG gt Click the Query button once enter the AP Code required and then click the query button once again to retrieve all transactions related to that particular AP Code Same can be done with other fields also Place the cursor in the AP Code field and then double click the query button or press F8 to list al the AP transactions Page 115 of 191 Capital AP GL Query AP0320 This query form is used to query for the AP transactions that have been posted in to the General Ledger ES AP Gl Query SE Action Edit Block Field Record Query Window Help Allocation Base Document Document serial Document G L Code Document Type Number Number Date Date Sear an 60040210 NV PIN PIND7040002 2 07 APR 07 0 APR O7 2007 50040210 Pas BPV BPvo7030002 2 p MAR O D1 MAR 07 2007 50040210 Pas PCVSH PCVSHO7040001 2 1 amp APR 07 Te APR OF 2007 50040210 PAY PDCP PDCPO 040001 2 m MAR 07 3D APR 07 P007 50040210 Par REW PREV PREVO 030001 2 p MAR O p1 MAR OF 2007 60040805 ICR PIN RPIND7040001 2 11 APR O f11 APR 07 2007 50040805 HIN PIN PIND O40001 f T APR 07 l z APR 07
34. CARD SALES FOR y 08 JAN 06 LOCATION 592 Page 142 of 191 Capital Receipt Date lt Due Date of the Matched Documents AR aer annA xx 1141 2 a Bitmap E af File View Help B28 ax 928 M00 2 Pafe Page No 16 of 16 Run Date 26 DEC 2007 Dynamics E A UR OUTEONETOUIM Elis Que quA NIS ROBA Bel UR KL W IO ONE A O WEL e MRE DONI UM From Date 01 01 1998 To Date 26 112 2007 Narration Match Doc No OSL00007 OSL00007 OSL00007 Page 143 of 191 Capital Average Performance l acon Eat mod Fe Reo Quy Wider HEP aja LYS IERT 4 5 0030 Information Drmamics suren USER A a Average AR Performance Preview IA fll LEN Cg R ecord 1 1 List of values lt OSC gt D BG Page No 1 ofl Run Date 26 DEC 2007 RefNo ARRISO User ID BIME A B A A m T E 63207249 1895306 43 15715 81 6741 24 152916 33 Page 144 of 191 Capital AR Master Listing Biss Feld Record Query Window Help zm Hijam RN AA A joo Record 1 1 Listof Values DISC DBG Page 145 of 191 Capital File View Help 83 23 Ax 8 9 m H P n Page 4 Page No 45 of Run Date 26 DEC 2007 AR MASTER LISTING Ref No ARR260 Usar ID Customer Code 22306 Telex Customer Name LETSOSA KGATLHEGO E Mail P O Box No ol Receivable Type Cash Address Line 1 er Status Normal Address Line 2 tl Limit Type No Limit Limit Amount 000 Add Up
35. Completed Allocation Total More Details Total Status Posted l i Approval FHistany hore Details Allocation Details Allocation Code Currency Code Exchange Rate Foreign Amt Local Amt Narration 19 Allocation Details k Enter value for Document Type Record 142 DSC gt DEG To query for an AR voucher click the query button once and select the criteria Document Type AR Code AR Group or Document Number required and then click the query button again The system will populate the details of the voucher based on the query Double clicking the query button will fetch all the AR vouchers The User can navigate through the vouchers by using the up and down arrows Page 67 of 191 Capital Receivable Receipt Query AR0240 The Receivable Receipt Query ARO240 is used to query for the different AR receipts generated during various AR transactions B Receipt Query uE AX Ex Action Edit Block Field Record Query Window Help A El sje a DFR E z AROZA0 Information Dynamics SUPER USER Document Details Document Type BANK RCT JaGANE RECEIPT Document Number Bl T uuu l Bank Code 001BOD amp JIesr OF DUBA Other Reference 149 Currency Details NC Currency O AA 00 Date Details Exchange Rate Foreign Amount 11080 Document Date 25 FEB 2004 2 Base Amount 11067 G L Date 25 FEB 2004 Cheque Details Cheque Number 75576565676 Cheque Date
36. E lt DBG gt The User can query by entering the required Document type or number Scroll to the right to view more details Page 117 of 191 Capital Year Closing AP DE aleja nip eee 11412 O SE open 01 44 2005 31 DEC 2005 Enter value for Tear R Record 1 1 k 5c k DEG Particular accounts payable year can be closed from this program This has to be used once Periods are closed Year Enter the financial year to be closed Once entering the year if any period is open for that particular year it will display the user which period is open Status From here user can close the year by selecting the option as Close If any period is not closed for the entered year will be displayed in these fields Page 118 of 191 Capital Period Closing AP A Enter a query press F8 to execute Ctrl g to cancel Record 1 1 Enter Query lt OSC gt DBR Particular accounts payable period can be closed from this program The system will display the currently activated year amp month Year The current financial year will be displayed Period Number The activating month will be displayed Status From here user can close the period by selecting the option as Close Description Any user specific description can be given for this period None of the fields except Status can be modified Page 119 of 191 Capital Document Freeze AP EEE am ipd ele 9
37. EX Action Edit Block Field Record Query Window Help 0 lt gjeja El E 4 EFE ARO190 CAPITAL SUPER USER Party Code A001 JICUSTOMERA Document Value Document Type CRV Document Number CR V07040003 amp j UnMetched Value UnMatch Transactions Matched Doc Number Matched Amount Balance Now Doc Date Status AR007010001 200 3791 01 JAN 2007 00 00 00 Posted D a ARO mmm A 4 Enter value for Status i a pe Record 1 1 lt OSC gt DBG Page 60 of 191 Capital The status field will show whether the document was posted or not 3 Click on the button Unmatch to do the Unmatching Then click Save and Exit Page 61 of 191 Capital AR Document Static Change AR0360 Use this screen to modify the narration and other references for any AP document in the corresponding GL All GL Header Cash Book Page 62 of 191 Capital AR Opening Balance Entry GL0300 An opening balance is automatically created when the User enter the first transaction for a customer However there may be situations wherein it may be required to enter the opening balance for a customer At such times the AR Opening Balance Entry GLO300 form proves to be handy Ej Receivable Opening Balance ES Action Edit Block Field Record Query Window Help GLOJ00 Information Dynamics SUPER USER AR Code A Group Cade A Doc Type e Base Type Doc N
38. FEB 2oosco0000 22254 fm 1 s3ferEBzusUuno00 e2254 1 1 ss3 e EB 2uD6 000000 22254 fm a feo PEB 2006 000000 e254 1 0 a fieresz00 ooo feezsa fm jac nuua 186 g FEB z s 00 00 00 22254 i Enter value for From Doc Type Record 147 s05C gt lt DBG gt Scroll to the right to view more fields To query for a matched transaction enter the document number and hit enter B Ar Matched Transactions Query Ex Action Edit Block Field Record Query Window Help Xx AROZ6O CAPITAL SUPER USER Document Number BRVO O20001 Ar Code From Doc From Diac Ma Serial From DocAmt ToDoc To Documento Serial Bal Before ug Z BRV BRvO7020001 1 80000 RIN RINO7020004 1 80000 SEIT I 4 4 1 1 1T Q 1 1 Place the cursor in the AR Code field and then double click the query button or press F8 to list all the matched transactions Page 70 of 191 Capital AR Transaction Query AR0250 Use this query tool to retrieve details of an AR transaction By clicking the Match Details button the system will allow the User to view the matching details of the particular transaction also a Ar Transaction Query Ex Action Edit Block Field Record Query Window Help za R0250 Information Dynamics Document Document Base Document Internal Other Type Number serial amp R Code Type Humber Reference INT j wr 200700333 O INTO pR X fsos8 MONTH END
39. Finance Module Capital a AFW S SHIPPING SOLUTION USER MANUAL Version 1 0 1 Copyright Information Dynamics LLC www infodynamic net Capital DISCLAIMER The contents of this document are subject to change from time to time Although Information Dynamics uses its best endeavors to ensure accuracy of the contents we assume no responsibility for any inadvertent error or omission that may appear in this document Page 2 Capital Table of Contents L INTRODUCTION ci as 8 Z HIGH LEVELARCHITECTURE coo 10 d PROCESSES A a a 11 3 1 GENERAL LEDGER INTERFACE ee eee e eee ooo tonto etta ta tto trabe te beoe ene a te bee tn sesta aseo ee eene beoe 11 fo sp CI 12 3 2 ACCOUNTS RECEIVABLE MODULE ssessssessosesessossososoesososessocsososcososessosoesosossesossesossorosocsosesssssseesos 13 E AA TA 14 AR COMO E Un AUTO sp aa 15 ANDE MED UD AM RO uU SEDEM D Nm NUN MD 17 A AO ho teme PUE NM MU MAMMA M DEMNM 19 a a FAT 0 6 A N A Tm 23 AA o NE T E sed 28 Recoge Voucher conj makon e F080 in 31 AR NEO TOT A o EE AEE E EE A E TE 2 O O o I AMANDO no PA po BILL no MESH OD UU Rc e 36 lcu dis RU Do MQ 40 a a GET 10 A0 NNNM PM m ABU Rap EU oidor tasas 46 JB SA ica 49 PDC tom omae and Cancelation ROO via 52 Ak Document Machia ARQ IA EE E EE MAP EM 22 A A dtd UM EU ME ao AR DEE BE RE etapa cid 62 pat a op EPA 63 AR pemn Baldo COR irm
40. HILLARY BUSIE EUNICE 43 76 MAKHUBU M 3 0 30 ZANDILE E DLAMINI 25 00 MNGOMEZULU FIKILE 142 SIBANDZE PINKIE 373 SANDILE KHAMANGA 9 65 MUIR CAROL 17 95 REEVE JACQUELINE MARY 0 29 SIHLONGONYANE ABIGAIL 29 96 ARMSTRONG J C 0 20 THANDIE F SHONGWE 360 25 LAYBYE RETURNS FROM RSC 13733 80 ME 4570 20 MR 35454 75 7643 15 462 30 4390 34 Page 141 of 191 Capital Receipt Date gt Due Date of the Matched Documents AR FE iZ pr A J sje m m xi is ARR 60 Receipt Date gt Due Date of the Matched Docs AR Receipt Date gt Due Date of matched AR Page No 16 of 16 Run Date 26 DEC 2007 Information Dynamics eras RECEIPT DATE gt DUE DATE OF THE MATCHED eoram ie iJ DOCS AR FOIS KORR Bde LOL TE ANI MG Rh RET e ms Rn n From Date 01 01 1998 To Date Narration Local Amt Receipt Date Due Date LOCATION 592 NOM 592 060106 0000087 06 JAN 06 CUSTOMER SALES FOR z 06 JAN 06 03 JAN 06 LOCATION 592 NOM 592 060106 0000087 06 JAN 06 CREDIT CARD SALES FOR 06 JAN 06 03 JAN 06 LOCATION 592 06 JAN 06 06 JAN 06 03 JAN 06 06 JAN 06 06 JAN 06 03 JAN 06 08 JAN 06 08 JAN 06 03 JAN 06 SPH 392 060108 0000004 08 JAN 06 CUSTOMER SALES FOR i 08 JAN 06 03 JAN 06 LOCATION 592 PH 592 060108 0000003 08 JAN 06 CUSTOMER SALES FOR 08 JAN 06 03 JAN 06 LOCATION 392 SPH 592 060108 0000002 08 JAN 06 CUSTOMER SALES FOR 72 is 08 JAN 06 03 JAN 06 LOCATION 592 SAN 3592 060108 0000001 08 JAN 06 CREDIT
41. K RECEIPT CASH COLLECTION STATEMENT Cancel 2 Next select the Bank Code using the LOV button 3 The User can then enter any additional reference details if required 4 Next specify the current transaction s currency and amount details 5 Specify the date details 6 Enter the Cheque details 7 Enter the narration for that particular AR transaction Page 41 of 191 Capital ES Bank Receipt Em x ES E e 4 ll n EE AR0100 Test USer SUPER USER E a 2 a e Heference Details Document Type BAN RECEI E DocumemNumber OOOO o Bank Code cm s In OtherReference Currency Details Currency ende al Date Details Exchange Rate 1 Foreign Amount 1000 Document Date 22 AUG 2007 es Base Amount G L Date 22 AUG 2007 Cheque Details Cheque Mumber 09276490870 Cheque Date 30 AUG 2007 El Clearance 3 1 AUG 2007 JI Drawer Branch NED BANK CAPETUONWIN 9 Drawer Account 564566576756667 Maranam Dema 0 Allocation Total Motes Demo 0207 00000 1000 8 Click on Send for Approval or Entry Completed The User can see the display against the check box as either Send for approval or Entry Completed While creating the document type master if the User specify that this document requires approval then once the User complete this document the User have to click the check box so that it will be received by the person who is suppose to approve it I
42. ON W01 CASH LAYBYE RETURN FOR LOCATION W01 CASH COLLECTION FOR LOCATION Wol CASH COLLECTION FOR LOCATION GS BANK TOTAL Currency AED BANK TOTAL 60 00 83 00 83 00 249 00 23 00 16702 00 6668 00 Closing Balance Opening Balance Page 123 9928 00 9845 00 9762 00 10011 00 10034 00 10034 00 0 00 of 191 Capital Cash book Summary EIE i las e Ep RER t A E 000190 Information Dynamics SUPER USEF General Ledger Cash Book Summary Report el amp zm mxiseas msumH n PageNo 1 of Run Date 22 DEC 2007 n ee Soe CASH BANK BOOK SUMMARY RefNo GLROSO User ID From Date 01 01 1998 Currency DIRHAMS ToDate 22 12 2007 Bank Code amp Name Currency lt Reconciled Op Bal gt lt Unreconciled Amount gt Unreconciled Balance Upto Amount Receipts Payments PDC 001BOD BANK OF DUBAI DIRHAMS 21 AUG 05 0 00 575 00 575 00 22 AUG 05 0 00 115 00 115 00 23 AUG 05 0 00 118 00 118 00 13 OCT 05 0 00 200 00 200 00 14 OCT 05 0 00 400 00 400 00 13 OCT 05 0 00 450 00 450 00 18 OCT 05 0 00 466 00 466 00 22 OCT 05 0 00 600 00 600 00 24 OCT 05 0 00 1158 00 1158 00 25 OCT 05 0 00 1020 00 1020 00 30 OCT 05 0 00 331 00 331 00 02 NOV 05 0 00 1500 00 1500 00 CASHMEMO CASH MEMO COLLECTIONS DIRHAM 21 AUG 05 0 00 90 00 90 00 22 AUG 05 0 00 49 00 49 00 23 AUG 05 0 00 8012 00 4353 00 3659 00 24 AUG 05 0 00 7008 00 1722 00 5286 00 13 OCT 05 0 00 175 00 175 00 18 OCT 05 0 00 30 00 30 00 2
43. Payable Payment Query APO240 is used to query for the different AP payments generated during various AP transactions E Cash Bank PDC Payment Query Cua m Ex Action Edit Block Field Record Query Window Help AP0260 Information Dynamics SUPER USER Reference Details Document Type BANK PAY BAME PAYMENT Document Number BP4Y 2004 0000 Bank Code on Bap EA BAN JEA Other Reference PMT FOR J4M2004 Currency Details Currency code L JCIRIHAMS Exchange Rate Foreign Amount 5000 Document Date ene enon e Base Amount 000 G L Date 1 JAN 2004 J Date Details Cheque Details Cheque Number 500 Cheque Date APA JAN 2004 Clearance 18 JAN 2004 j Beneficiary Account LAHE amp SULTAN PoC Cheque Beneficiary Branch Narration MAINT FOR JAM Bus Allocation Total Motes MAINT FOR JAN Po sted Approval History Allocation Details Allocation Code 2 Exchage Rate Foreign Amount Local Amount Narration 1 5000 5000 Allocation Details Error This Account Code does not exist Record 1 7 KOSC DBB To query for an AP payment click the query button once and select the criteria Document Type Bank Code or Document Number required and then click the query button again The system will populate the details of the payment based on the query Double clicking the query button will fetch all the AP payments The User can navigate through the payments by using the up
44. UKP 72456 50 72456 50 PLC 149872 19 149872 19 Page 180 of 191 Capital Document Matching List AP ste 01 01 1998 PageNo 1 of 1 Run Date 26 DEC 2007 RefNo APRO4O User ID DOCUMENT MAICHING LIST AP Page 181 of 191 Capital Black Listed AP El Acton Edt Bok Edd Record Query Window Heb 5 x Ejea 1AA FRR 4 COO Information Dynamics SUPFRUSFR EJ HS Ey J Record 171 List of values lt OSC gt DBG Ele View Help Ex gem Mw reef 12 Page No 1 of Run Date 26 DEC 2007 RefNo APRI70 User ID Page 182 of 191 Capital Document Approval Details 01 01 1998 x 28 12 2007 PageNo 1 ofl Run Date 26 DEC 2007 RefNo APRI90 User ID DOCUMENT APPROVAL DETAILS AP From Date 01 01 1998 To Date 26 12 2007 ment Number Local Amount Created By Created On Rejected By Received Date Time Approved Date Time Status Page 183 of 191 Capital AP Opening Balance EGET E AA AP Opening Balance Details PageNo 1 of 1 Run Date 26 DEC 2007 RefNo APR400 User ID From date 26 12 2003 Todate 26 12 2007 AP Code AP Name Document Type Document Number 100 GOODSWORTH BANK PAY BPAY 2005 00001 PUR_INV PURIN 2005 00001 Page 184 of 191 Capital ot Approved Vouchers AP 4 dst 2 EA g A esin Dd conne eee M i A EN OA A Fh gt gt Mame EX Not Approved Vouchers AP PageNo of RunDate 26 DEC 2
45. acdatesbiasssasneupsusesymeseeseaniasiiesate 111 gv Aui ERU A 112 AU APA rosa ode 113 APO Bii UPRO TR 114 a RO Prov P Nt 115 AP OLGE c PIU T e o A 116 AP Matching Transactions Query AP0330 ri ita anio 117 E a a E E A A E in EE ye 118 Lon COR hia Ol a E OO E O Eo A 119 Ba Proce AP Gud nE nein NNI TIED MM NM RUE 120 DM LEER AA En 121 4 INFORMATIONAL REQUIREMENTS ocio 122 4 1 GENERAL LEDGER REPORTS sscosonssiorsicerosanosrocirnnancnrnccreroncnrocicononccoococanonccrncoccnnceroccncirnccrccincss 122 E IO ET E AA A NE A A AAE 123 Bd o i I T 124 4 2 ACCOUNTS RECEIVABLE REPORTS eee ee eese eaae eaae seta atento etae Pee Poen sero Ie tense Pepe ern eee aaO 125 A Dr T ett 126 as DEED DETUR A E EE mann EPUM CiU 127 O e 129 A E N E E E A A 130 T C MIEL E AEE E 130 T A E neater ees 131 DIO o po AAA E A A E E A rte 134 EE TE E N E A N UEM 135 Tr ns chon based AA o UE A 136 E Mii A Eo O e 137 Ex Document Prepared qud Concelleg on Te SOME dansa 138 ds a o A A o eee 139 Ateo CONDERE pana ia ias 140 EA e 141 Receipt Date gt Due Date of the Matched Documents AR eee 142 Capital Receipt Date lt Due Date of the Matched Documents QR ues tritt protesta reete iei 143 P c cu nu 7 1 TM 144 T Mu CUN n E 145 arose eters eda 147 Pa p Ao o AA ni 146 Bv
46. and AR SI B 0002 respectively Sometime later a collection of 700 AED is made from Customer A for the AR sales Invoice AR SI A 0001 generating a cash receipt with reference number CRV A 0001 Similarly another cash receipt is generated when the Customer B makes a payment of 700AED with a reference number CRV B 0002 Now suppose AR Matching was then done and mistakenly the cash receipt CRV A 0001 was matched with Customer B s AR Invoice AR SI B 0002 and likewise CRV B 0002 was matched with AR SI A 0001 This kind of matching is improper and will lead to inaccurate information In such cases the AR Unmatching tool can be used to unmatch these documents These unmatched documents can be re matched using the AR Matching form Ar UnMatched Transactions A4R0190 Information Dynamics SUPER USER Party Code zal Document salue Document Type Ey Document Number J UnMatched Value Linkiatch Transactions Matched Doc Type Status Page 59 of 191 Capital To do a Document Unmatching operation 1 Select the Party Doc Type and the Document Number Once these are selected the Total Document Value and Unmatched Value are displayed The Document Type LOV button will retrieve only those documents which are unmatched ERVO7040003 UmMa DOCume CRVO7O40003 2 Select the Matched Documents which are displayed in the grid that the User wish to unmatch E Ar UnMatched Transactions USB
47. ano L a errean e aE nod amtnmseesotes 66 Recelonble Voucher Query ARUZ 20 PEN NEEE REE a N 67 Capital Recetoable Receipt Query A sasstanisitenbuseditiaiatmsa chispa rn Eron eT ninnan 68 Mult Bank Kecoipt Query ARUSI AAA RO PP eii E 69 Akane Trn on QUE A einni R 70 ER TTO a AA E E CER reer ret Teer er 71 E A AA EE mA o TI fa AR Mon Pree Ome Gery EDO arar ca 3 b AOI Vie ARR rH T 74 a a MEA nen RU EUM Med tol ccn bu MUN PIN at ccna herrea 75 DONDE PUEDE Cate E ENE E E EET 76 Des E I UTE NM A O Ir 3 3 ACCOUNTS PAYABLE MODULE ssesseseesesossosesossossesosoesoscescsossssoscosoesososoesosessosossessssorssscssssesossssoses 78 Payong Croup Master e EDU A E E OUR EEE EEN TI Uds 79 P T O ML QU III e E A 81 No T Rar PR 65 Fo c E Mu prog D o oo 67 poule E a 0046 mE 69 AP Vonder USO er DD densities ete inopi EEE 21 Pre Voucher COD TENEO es PU BD otitis 22 DP TOUGH e Pt BE etc ibas 93 AP VOT an A AE 94 ra e AAA E E E ere E E E A ee vie a AAN t o REO ene Mere er Ma CMM E 96 pu DIM esu DU A a ROS OO EE Pei DIM INN ers 97 Payment Confirmation E Wig OC WP 100 Ia Io EA a P Wing 0 0 0 EN PPP A 101 EEC PIOS U aa MNT m 102 AU A amd uou MN NEUE 103 PDC Com mp ana CON HO APUL ZU ass Leasecipbsunisiqo dus vii id seir ted aora EA eR 105 HD APO y RN 106 O Uc MEI Uc AUT AAA o on 108 e UND Ped PUB MM 5 E er et Teer er ere 109 Paw age cele DIC misc C LOS rip ao 110 Capital AP Opening Balance Confirmation LGU ss iusasmscssnatsdomv
48. ation Details Allocation Cade Currency Code Exchange Rate Foreign Amt Local Amt Narration Allocation Details Enter value for Document Type NADIE Record 14 List of Values lt OSC gt BBB On successful voucher creation a payable voucher reference is automatically generated by the system Page 89 of 191 Capital The Voucher Entry form has a number of parameters and controls that can be specified Look at the table in the next page to understand these parameters and controls AP0070 Voucher Entry The document type required for the current AP transaction Accounts Payable Code The group the creditor belongs to Additional details for reference to this voucher Currency in which the transaction is done The exchange rate of the currency selected Foreign currency Amount Local currency Amount Voucher Creation Date GL Posting date Date on which the payment amount begins to age Date on which the amount gets due for payment Area used for adding up comments or remarks Either of the two may appear on the screen based on the document type setting for the particular JV type Allocation details for the amount are specified here Page 90 of 191 Capital AP Voucher Approval AP0200 If the payable voucher was set to get an approval it will get listed here in this AP Voucher Approval APO200 form Page 91 of 191 Capital Payable Voucher Confirmation AP0080 All approved documen
49. ble to buy items not more than a fixed limit set by the User 7 If the User had selected the limit type as fixed the User will have to specify the Limit amount 8 Next specify the Add up which is nothing but the tolerance percentage of the limit set wherein the AR customer can Page 21 of 191 Capital purchase above the specified limit For e g if the defined is 5 and the limit specified was AED10000 then the system would allow up to AED10500 Based on this the final limit will be automatically calculated 9 Next enter the credit days allowed For e g if the AR customer is given a period of 30 days to payback the amount owed then the ageing would start calculating from the 31 Day as due 10 If the AR customer pays in different currencies click the Additional Currency button to specify the additional currency details in the grid that gets displayed 11 The User can also specify the group details for the AR customer by clicking on the Group Details button The LOV button will fetch a list of groups already defined in the AR Group Master 12 Click on the Analysis Details button to add analysis details specific for that AR customer NOTE AR master will be interfaced with the Customer master in the CMS module once the customer is created then the same details can be captured to the AR master This can be done from the financial updation program which is available in the CMS module Page 22 o
50. ble voucher confirmation screen helps double check transaction details Page 31 of 191 Capital AR Voucher Reversal AR0180 The AR Voucher Reversal ARO180 screen is used to record reversal transactions on an earlier receivable transaction The AR voucher reversal document must be defined using the Document Type Master C00050 and linked to the AR Voucher document using the Voucher Reversal Link C00120 sra ENS s xx tu WW ean Opens LO Process Enter value for Document Number R ecord 1 1 List of Values asc DBG gt The User can do an AR Voucher reversal only for existing AR Vouchers Page 32 of 191 Capital To do an AR Voucher reversal 1 Enter or select the AR voucher document by clicking on the LOV button found next to the Document Number field When selected the details get populated automatically Other Reference D Document Number RCRO7040001 E RDRO7020001 TOWARDS CO M RDRO7030001 DEBIT NOTE TEST RDRO7040001 2 RDRO7040002 RDR 34567 RINO7020003 23 3 07 23 07 400 5 INY NO 345 RINO 7020004 RIN BEING INV 345 RINO7030001 TEST INVOICE RAISING RINO7040003 RINO7040004 RINO7040006 RINO7070001 2 Enter the reversal Document Date and GL posting date These dates must be equal to the voucher document and GL dates respectively or else an error message will get displayed as shown below Forms E e Reversal Document Date Should be equal to Document Date
51. cher Query APO220 is used to query for the different AP vouchers created during various transactions El Payable Voucher Query aA of X Ex Action Edit Block Field Record Query Window Help El se B ES ala 4 2 PO220 informati Document Type PUR INV amp J PURCHASEINVOICE ils AP Code 100 GOODEWORTH System PURIN 2004 00002 APGrmup TRCRS jJ TRADE CREDITORS Other 12 Amount Details 4 7 Date Details Currency AED J DIRHAMS Document Date 02MAP 2005 4 Exchange Rate Foreign Amount 100 G L Date 02 MAR 2005 A o Base Amount CL Age Date 02 MAR 2005 sj Narration MM Pay Date 02 MAR 2005 Allocation Total More Details Total status Posted p m 100 a i Approwal_History Mare Details Allocation Details Allocation Code Currency Code Exchange Rate ForeignAmt Local Amt Marration Es p GL AED el 100 Allocation Details Enter value for Document Type Record 4 4 QS lt DBG gt To query for an AP voucher click the query button once and select the criteria Document Type AP Code AP Group or Document Number required and then click the query button again The system will populate the details of the voucher based on the query Double clicking the query button will fetch all the AP vouchers Navigate through the vouchers by using the up and down arrows Page 112 of 191 Capital Payable Payment Query AP0260 The
52. cluding PDC Total PDC Closing Balance Amount Due Excluding PDC lt 30 days Page No 61 of18lKun Date 6 DEC 2007 RefNo ARE340 Uzer ID Code 32713 PaymentTerms g DAYS Credit Limit To Date 26 12 2007 Currency DIRHAMS Outstand Debit Outstand Credit Foreign Amt 0 00 0 00 2 62 68 47 Page 128 of 191 Capital Age Analysis AR ge Analysis AGE ANALYSIS AR Cid A AA Cl AUI iia Date 26 12 2007 CUSOMER CODE AND NAME PAY TERM CURRENT BALANCE o 30 72 00 72 00 3564 00 3564 00 13175 35 13175 35 433110 28 433110 28 6741 24 6741 24 Page 129 of 191 Capital Limit Base Master Listing File View Help 838 Bx OS m me reef Page No 1 of Kun Date 26 DEC 07 RefNo ID User ID n i l a r J LIMIT BASE MASTER LISTING AR a28 ax 920009 e Page No 1 of Kun Date 26 DEC 07 Ref No ARROO User ID ee GROUP MASTER LISTING AR Group Code Account Code Description CCOO01 001001020132003 CREDIT CARD COLL DEBTOR 001001020132003 Debtor INT 001001020132003 INT LABYE1 001001020132006 LAYBYE1 GROUP LAYBYE 001001020132006 layby Account CARD 10010601 CREDIT CARED Page 130 of 191 Capital Printing lese pa ger pu ed Bey qam c List Of Values Available Record 1 1 Listof Values DSC DB Page 131 of 191 Capital 2828 ax oa mau ref J mi Information Dynamics ya io lt pds 5 gis
53. configurations in accordance with the company s business processes This section will help the User with the requirements and procedures imperative to the setup of the AP package Each form s fields and parameters and the corresponding steps required will be explained wherever necessary To understand complex procedures illustrative examples will also be shown wherever applicable Page 78 of 191 Capital Payable Group Master AP0020 This will be the first form the User will have to work with to begin the setup process for the Accounts Payable This form is used to define the various AP groups the User will be dealing with in different business situations It is always recommended that the User create groups of vendors with similar properties Obviously it will also help the User transact with the AP vendors with utmost ease as the User can define group level settings By defining group level settings the system will retrieve those details whenever a transaction is done on the supplier belonging to that group iy Payable Group Definition SUPER USER Group Description AccountCode Description TRCRS TRADE CREDITORS OTHERS 0020502 TRADE CREDITORS OTHE n RORSGR fl RADE CREDITORS GROUP 60020501 i CREDITORS GROLIF ar E urs SI TRADE CREDITORS OTHERS p ug E de i a I po E OS DB Page 79 of 191 Capital The screenshot shown above is that of
54. cument Type All Documents 28493 10 7785 00 USD 31 AUG 05 01 AUG 05 43080 03 11770 50 USD 31 AUG 05 01 AUG 05 5628 34 1537 80 USD 31 AUG 05 01 AUG 05 140 00 140 00 AED 31 AUG 05 01 AUG 05 74 22 20 28 USD 31 AUG 05 01 AUG 05 77415 69 77415 69 77415 69 77415 69 Page 161 of 191 Capital Statement of Accounts AP Page 162 of 191 Capital File Mew Help 828 ax 98 HM bbl Pal information Dynamics Pow 3008 Duba UAE Tel 04 397 0202 Far 05 387 TRY Toc 46142 SOGOU EM TM Page No 1 off Run Date 26 DEC 2007 STATEMENT OF ACCOUNT M n EXAMS Eur asd COODSWORIH Code 100 Payment Terms amp DAYS Post Box No From Date 01 01 1998 Credit Limit 0 00 To Date 26 12 2007 23 2 Currency DIRHAMS Tel Fax Type Reference No Other Ref No Narration Qutstand Debit OQOutstand Credit Foreign Amt Opening Balance 0 00 0 00 0 00 USD 01 AUG 05 INV NDPO00002 E03493 28493 10 7785 00 USD 01 AUG 05 INV NDP00003 E03600 test 43080 03 11770 50 USD 01 AUG 05 INV NDP00004 E03600 5628 34 1537 80 USD 101 AUG 05 7 NDP00005 VMITEST Tested by Vannessa 140 00 140 00 AED in presence of Gavin 01 AUG 05 INV NDP00006 F50001 Tested DSD invoice 74 22 20 28 USD by vanessa Supervisar by Gavin Total Excluding PDC 00 77415 69 Closing Balance Excluding PDC 77415 69 Total PDC Closing Balance Page 163 of 191 Capital Age Analysis AP Porat APROOS z 7 y Acco
55. d Record Query Window Help AR0320 Information Dynamics Document Document Serial Document fal Document Type Number Number Date Date 001001020133002 DR INT INT 2007 00286 fo OS MARO 05 MAR 07 0101020132003 DA INT INT 2007 0n287 0S MAROF 05 MAR 07 p01001020133002 DR INT wr2007000805 2S MAR O O5 MAR0 001001020132003 DR INT wr20070028 f e M P 05 MAR 07 001001020133002 DR INT NT 2007 00288 2 JO MAR O7 D5 MAP 07 001001020132003 DA INT wrzo0700289 5 MAR OF O5 MAR07 0001020133002 DR INT wr200700089 P e Mar 05 MAR 07 001001020132003 DR INT wr200700980 5 MAR O7 e MAR 07 0101020133002 DR INT wr2007009080 P MAR O 05 MAR 07 01001020132003 DR INT wrzo7 0099 D DMARD MAR 7 00001020133002 DR INT wr 2007 002803 P JO MAREO 5 MAP 07 E MAP O 07 001001020132003 DA INT INT 2007 00292 i D5 MAP 07 E por 0010201 35002 DF INT INT 2007 00292 E D5 MAP 07 05 MAR 4 DebitLocal Amt CreditLocal Amt 53146 3445 54007 1445 Record 2760 2780 I KOST DBE The User can query by entering the required GL Account Code Scroll to the right to view more details Page 72 of 191 Capital AR Matching Transactions Query AR0310 This query form is u
56. documents The Capital Finance s Accounts Receivable also allows matching multiple documents Suppose a customer A has bought an item XYZ on credit from the store which is worth AED 1000 An AR Sales Invoice is generated with code AR SI A 00001 Now suppose that the customer A pays back AED 500 in cash and then the other AED 500 as a PDC Post Dated Cheque after a week Two receipts will be generated Page 53 of 191 Capital CRV A 00001 and PDC A 00001 The customer has paid all the money for his purchase and the transaction is complete This will involve multiple documents to be matched as illustrated Illustration Multiple Document Matching Cash Receipt 500 AED Credit Sale Invoice 1000 AED PDC Receipt 500 AED Like wise multiple combinations of both debit and credit documents are possible depending on how the balances are cleared Page 54 of 191 Capital The screen has got two sections The first section is where the criteria are set and the second section is where the details get displayed Also scroll to the right to see more columns Page 55 of 191 Capital Total Doc Value A Total Match Value Approval Pending Original Balance Approval PendingMatched Local Amount Foreign Amount Foreign Amount Foreign Amount Foreign Amount ll 1 T A 55 1 es ee l D 71 T 1 Enter the value for Par
57. e corresponding purchase transaction document s and its payment transaction document s has to be matched This will prevent the system from spending its valuable resources and time for it along with other incomplete transactions For example a Creditors invoice has to be matched with the corresponding Cash Bank Payments Another important point to be noted is that for successful document matching the documents must be previously linked using the Allocation Master during the implementation Only if this is done will the User be able to match these documents The Capital Finance s Accounts Payable also allows matching multiple documents Suppose a supplier A has sold an item XYZ on credit to the store which is worth AED 1000 The creditor will send over the invoice with code AP SI A 00001 Now suppose that the supplier A is paid back AED 500 in cash and then the other AED 500 as a PDC Post Dated Cheque after a week Two payments will be generated Page 106 of 191 Capital CPV A 00001 and AP PDC A 00001 The supplier is paid all the money for his sale and the transaction is complete This will involve multiple documents to be matched as illustrated Illustration Multiple Document Matching Cash Payment 500 AED Supplier s Invoice 1000 AED PDC Payment 500 AED Like wise multiple combinations of both debit and credit documents are possible depending on how the balances are cleared 3 x K 4 A
58. equired for the current AP transaction Accounts Receivable Code The receivable group the customer belongs to Additional details for reference to this voucher Currency in which the transaction is done The exchange rate of the currency selected Foreign currency Amount Local currency Amount Voucher Creation Date GL Posting date Date on which the payment amount begins to age Date on which the amount gets due for payment Area used for adding up comments or remarks Either of the two may appear on the screen based on the document type setting for the particular JV type Allocation details for the amount are specified here Capital To record a receivable voucher entry 1 First select the document Type by clicking on the LOV button Doc Mame SAMA MOTE RECEIVABLE DEBIT NOTE RECEIVABLE INVOICE Cancel 2 Next select the AR Customer Code and group using the LOV buttons 3 The User can then enter any additional reference details if required 4 Next specify the current transaction s currency details 5 Specify the date details 6 Enter the narration for that particular receivable transaction Ex Receivable Voucher Entry QuE Em x Ex Action Edit Block Field Record Query Window Help Be xi 4 Ea ARODOFO CAPITAL SUPER USER RECEIVABLE INVOICE Reference Details CUSTOMER A System RINOZ080001 AR Group TRDRSLOC J TRADE DEBTORS Other Null Amount Details
59. er ID NUMBER OF CANCELLED DOCUMENTS IN AP From Date 01 01 1998 To Date 26 12 2007 Page 173 of 191 Capital AP with Credit Balance ma ER ES Action Edit Block Field Record Query Window Help 15 x wise py ww x x 1 14 72 ton mmeen Dynamis euren USER IA m EDERIM DuEm A T De AHE T pia DEBIT BALANCE IN AP Page 174 of 191 Capital Payment Date lt Due Date of the Matched Documents AP PageNo 1 ofl Information Dynamis a e PAYMENT DATE lt DUE DATE OF THE MATCHED RefNo APRI60 User Ss ID FOREN MAA UA AL OT ORE tae ONY WET he 00 DA UM AP From Date 01 01 1998 To Date 26 12 2007 Doc Date Narration Local Amt Match Doc No Page 175 of 191 Capital Payment Date gt Due Date of the Matched Documents AP a80 ax 99 00020 ref PageNo 1 ofl Information Dynamica grapa uda guia PAYMENT DATE DUE DATE OF THE MATCHED RefNo APRI50 From Date 01 01 1998 To Date 26 12 2007 Doc Date Narration Local Amt Match Doc No Page 176 of 191 Capital Average Performance Ek Action Edit Block Field Record Query Window Help A ajaja 2NA SERR A con i omeionDmenics suren USER pangemane 0000000 Average Performance AF Preview PS TRETEN 2828 ax 98 0000 roof ci Page No of Run Date 26 DEC 2007 Information Dynamics E ells es pa Ref No APRITO Uzer ID A A I A NR RU 1 Ut A Unum m p AVERAGE
60. erest for the month 001001020133002 28 02 2006 DR INT 2006 02635 Interest for the month 001001020133002 26 03 2006 INT 2007 00214 Interest for the month 001001020133002 05 03 2007 Page 137 of 191 Capital nti in Document Prepared and Cancelled onthe Same Day 01 01 1398 ei 2 2007 PageNo of DOCUMENIS PREPARED AND CANCELLED SAME DAY ma Aaii From Date 01 01 1998 Document Number Base Doc Doc Type Doc Date Other Reference Page 138 of 191 Capital umber of Reversals AR PageNo of RunDate 26 DEC 2007 RefNo ARROOO User ID From Date 01 01 1998 To Date 26 12 2007 Hae Base Document Document Type Page 139 of 191 Capital Number of Cancelled Documents AR PageNo 1 ofl Run Date 26 DEC 2007 RefNo ARRIOO User ID NUMBER OF CANCELLED DOCUMENTS IN AR From Date 01 01 1998 To Date 26 12 2007 Base Document Document Type Page 140 of 191 Capital AR with Credit Balance aker mp BEN HET RI SWR dessin A Credit Balance gt n Days Preview o Bl 1 a2 ml ax DA e a Paf Page No 4 of 4 Run Date 26 DEC 2007 Information Dynamics alas ei y gil Ref No ARRI30 User ID AA GR E XM Ga ee A AS CREDIT BALANCE IN AR Hame CR Balance Without PDC SYLVESTER ANGIE 58 94 MATSENIWA GUGU 1 00 THWALA BONISIWE 0 02 HLOPE NOMATHEMBA 0 01 LUKHELE ALBERT A 0 08 MARGARET SEMPUMA 55 1 KUNENE FIKILE IJ 35 10 NOMSA HLOPHE 102 92
61. f 191 Capital Voucher Entry AR0070 Whenever an Accounts Receivable Transaction is done a voucher needs to be generated To record an Accounts receivable entry the Voucher Entry AROO70 is used As a pre requisite the Receivable Voucher document type must be defined in the Document Type Master C00050 El Receivable Voucher Entry Quay ER Ex Action Edit Block Field Record Query Window Help E E RI al A El ES FIX 4 Al dy E AR0070 Information Dynamics SUPER USER Document Type Reference Details AR Cade sj system AR Group e Other Amount Details gt Bate Details Currency w qd Document Date i b DEC 200 s Exchange Rate Foreign Amount G L Date i B DIEC 2007 Base Amount Age Date i b DEC 2007 Narration oO Due Date f B DIEC 200 7 kot Allocation Total More Details Total A Send For Approval More Details Allocation Details Allocation Code Currency Code Exchange Rate Foreign Amt Local Amt Narration Allocation Details Enter value for Document Type Record 141 ListofValues USC DBG On successful voucher creation a receivable voucher reference is automatically generated by the system Page 23 of 191 Capital The Voucher Entry form has a number of parameters and controls that can be specified Look at the table in the next page to understand these parameters and controls AROO70 Voucher Entry The document type r
62. f it is Send for Approval it means that the voucher requires approval and Entry Completed means it does not require any approval In both the cases the User will have to click the check box so that the voucher can get created If the User don t click the check box then it will still be available for modification 9 Finally enter the allocation details required Page 42 of 191 Capital Narration 00 Allacatian Details Demo Allocation Details LIED TA AA i i il remm eme I i J 1 LARA Enter value for Allocation list of values available Record 2 2 ListofWalues USE DB 10 Click on Allocation Details button if the User wish to specify the GL Account code and other related details This screen will have fields that were defined in the corresponding masters Once the User have completed entering details Click on Go Back button to go to the main screen or simply hit Enter 11 Now click on Save button to generate the Bank Receipt A Bank Receipt reference code is also created by the system Page 43 of 191 Capital Receipt Reversal AR0270 The Receipt Reversal ARO270 screen is used to record reversal transactions on an earlier receivable transaction The Receipt reversal document must be defined using the Document Type Master C00050 and linked to the Receipt documents using the Voucher Reversal Link C00120 The User can do a Cash Bank PDC Receipt rever
63. finition AR0010 Once the AR Groups are created in the AR Group Master AROO20 the User has to define the controls that ought to be levied upon the groups The form AR Control Definition AROO1O facilitates this Below is the screen sample of the AR Control Definition form This screen not only sets the limits and clearance accounts for a group which will be set as the default group but also helps configure the parameters that will be displayed while generating analysis reports Page 15 of 191 Capital Take a look at the table in the next page to get a better understanding on the purpose of the different fields in the form AROO10 AR Control Definition A group selected from the LOV set as default which is retrieved from the AR Group Master This will be updated by the system and hence no user interaction is necessary Basically it displays the date on which the most recent posting was done on for the group Document Type Document Date Other Reference These different options help the No User set the matching screen Amt Descending that will appear while doing the Order AR matching Amt Ascending Order This will also be updated by the system simultaneously and always indicates the year period which is currently open for transactions A set of 10 parameters used as criteria for analysis and label headers on the report generated thereby um H 242
64. i 501 W01 060416 0000006 Total Without PDC Closing Balance Without PDC Total PDC Amount Closing Balance PDC Amount TYPE SALES SALES RETURN INVOICE TOTAL FOR THE PERIOD 0101 1998 TO 26 12 2007 Page 126 of 191 Capital Statement of Accounts AR UL I HH i o o E 1 5 a O ETE CIS XLI A AR E Te PER A x AL xt Y E ra hard tint AA e Ld AA A A A rires ee eg Uc raf Tti Tr ITI iT t Zw T m 5 LA EM Fe b Ne A EE EL a E i Name Statement of Acco 01 01 1998 25 12 2007 Page 127 of 191 Capital A Tl Statement Of Account Accounts Receivable File View Help 828 EX A MA P l Pee BENNETT SYBIL Post Box No Type U4 DEC 05 DE 31 DEC 05 INV 15 JAN 06 DE 18 MAR 06 INV q25 MAR 06 DR 05 MAR D7 DE STATEMENT OF ACCOUNT Tel Fax Reference Ho INT 2005 01931 NSL0U886 INT 2006 02236 03L01573 INT 2006 02514 INT 2007 00155 From Date 01 01 1998 Other Ref No Narration Opening Balance MONTH END 8 Interest for the moni 04122005 THA 151 051231 04HH CUSTOMER SALES 025 FOR LOCATION 131 THA 151 051231 0 0026 Interest for the moni 15 01 2005 THA 151 060318 00 4 CUSTOMER SALES 025 FOR LOCATION 131 THA 151 060318 04 0025 Interest for the moni 2603 7006 Interest for th moni 05 03 2007 MONTH END 9 MONTH END 11 MONTH END 13 Total Excluding PDC Closing Balance Ex
65. ics SUPER USER Creditar Code lo Tl AR Cole e Creditor Name Fayment Type Cash y ROBox 00 SSS Status Normal AddUp 0 Address Line 1 Invoice Limit Type No Limit y Our Final Limit ji Address Line 2 Invoice Limit Amount 0 Credit Days Address Line 3 Bank Marne Telephone BankAccount Fax Group Details Cheque To Telex NNNM Additional oS Ei Bl o End User Description Enter value for Customer Code R ecord 1 2 List of Values KOSEC lt DBG gt This screen also stores the additional currency details the AP group details and also the Analysis details of the AP supplier The AP Master is one of the most important masters as it contains important information on Vendors required for the different AP transactions Page 87 of 191 Capital APOO60 AP Master A code entered by the User to identify the AP supplier It must be unique Name of the AP Supplier Contact details of the AP supplier AR Code of the supplier if available The type of payment through which the supplier will be paid for Cash Cheque Both Telex Transfer Draft The status of the AP Supplier Account Normal Black Listed The type of limit imposed Fixed limit No Limit The maximum amount above which the payable is not supposed to exceed for that particular supplier The tolerance percentage above the set limit that the system can allow This is calculated by the system based on the lim
66. iod can be closed from this program The system will display the currently activated year amp month Year The current financial year will be displayed Period Number The activating month will be displayed Status From here user can close the period by selecting the option as Close Description Any user specific description can be given for this period None of the fields except Status can be modified Page 75 of 191 Capital Document Freeze AR ER Action Edit Block Field Record Query Window Help en DN py FRR A meme iie Denans SUPERUSER o PT EM NENNEN IO A A Freeze Enter value for Document Number R ecord 1 1 List of Values OSC DEG This form is used to freeze a document in a transaction cycle This document once frozen will not be available for any sort of transactions Page 76 of 191 Capital Document Unfreeze AR ik Ex ei Pad ted Qe thn Eeo ea ipd akn ale E A E ooo o BJ O seas WE E eee rr IE eee NENNEN A LinFreeze FAM 40202 Field must be entered Record 1 1 List of Values a5c DBG gt This form is used to unfreeze a receivable document that had been frozen from transactions earlier Page 77 of 191 Capital 3 3 Accounts Payable Module Setting Up the Accounts Payable Package In order to perform any transaction on the AP vendors it is necessary that the AP package be set up by defining the masters and other
67. it amount and the add up percentage set Cheque to Bank name Bank Account number that will be used for the particular creditor Depends on the AP transactions and will get displayed automatically Initially it will be zero This button will show the fields required to record additional currency details for the AP supplier This button will show the fields required to record Group details of the AP supplier This button will show the fields required to record analysis details for the AP supplier This button will show the fields required to record credit application details of the AP supplier Page 88 of 191 Capital Voucher Entry AP0070 Whenever an Accounts Payable Transaction is done a voucher needs to be generated To record an Accounts payable entry the Voucher Entry APOO70 is used As a pre requisite the Payable Voucher document type must be defined in the Document Type Master C00050 Ed Payable Voucher Entry QuE B8 x Ex Action Edit Block Field Record Query Window Help APUUZ0 CAPITAL SUPER USER Reference Details 2 Sysem AP Group sJ Other Amount Details Bate Details Currency AED EE Document Date 27AUG 2007 A Exchange Rate Foreign Amount i G L Date PI AUG 2007 5 Base Amount FI Age Date P AUG 2007 __ eee Pay Date 27 AUG 2007 Al Difference Allocation Total More Details Total l Send For Approval More Details Alloc
68. ital Document Matching List AR Name Document Matching List AR Page No 1 of 1 Run Date 26 DEC 2007 RefNo ARRO40 User ID DOCUMENT MATCHING LIST AR Page 152 of 191 Capital Black Listed AR l Acton Edt Bok Ed Record Query Window Heb 5 x ajo ELIS FRR 4 COO IMomaconbmamies SUPFRUSFR exe s ES Run Ej 2 R ecord 1 1 List of values lt OSC gt D BG File View Help Axl ea maA M r Page 153 of 191 Capital Document Approval Details Bi LIE acl fx pal Toon e T Vane Mac of mnia DDEC el 7 AE la y TE RU ae y I E Ml zik i TE RAA Em n Fa L DOCUMENT APPROVAL DETAILS AR TRMEENE con eco DorumentHimber ForeignA mour Loza Amount aejectec Dy Receed DaieTlme ApprowedQate Time Sianas Reason Of Rejected Page 154 of 191 Capital R Opening Balance A E AR Opening Balance Details PageNo 1 of 1 Run Date 26 DEC 2007 j v ES coto ee mL RefNo ARR440 User ID Met m hee AU SORA Her m HR m ht tm From date 26 12 2001 Todate 26 12 2007 AR Code AR Name Page 155 of 191 Capital ot Approved Vouchers AR Bi LIE acl i icem OEE curs i i E Mame EX Mot Approved Vouchers AR E File View Help amp zt mx fgaj mispmm re Information Dynamics NOT APPROVED VOUCHERS PageNo of 1 RefNo ARR110 From Date 01 01 1998 T
69. ment Ja Ex Action Edit Block Field Record Query Window Help m x Olla Fal i 8 El APO100 CAPITAL SUPER USER Reference Details Document Type __ Becument Number Bank Code Other tran Currency Currency code i Date Details Exchange Rate Foreign Amount Document Date 2 AUG 2007 J Base Amount G L Date 27 AUG 2007 Cheque Details PDC Cheque Auto Cheque Number Cheque ar Cheque Date 2 7 ALIG 2007 Clearance 27 AUG 2007 J Beneficiany Account Beneficiary Branch M Send For Approval Narration D O Difference Allocation Total A 000 Allocation Details Allocation Code Currency Exchage Rate Foreign Amount Local Amount Marratian Allocation Details Enter value for Document Type list of values available Record 1 1 ListofWalues lt C gt lt DBG gt Fields those were not explained earlier will only be explained The User can take a look at the table in the section Voucher Entry APOO70 for some information Page 97 of 191 Capital Take a look at a sample Bank Payment BPVO7080001 generated for the AP supplier COO1 SAMPLE gt BANK PAYMENT BRVO7080001 BANK PAYMENT Payment to Ref No BPV070S0001 Address Date 27 AUG 07 Bank Code H3BC Cheque No 1234 Tel Fax Date 27 AUG 07 Code Bank HSBC Branch dubai Eee ARAB EMIRATE DIRHAMS Cust Alc No 6546873651365436 Amount in Figures
70. nancial Management solution built to offer a cost effective solution for managing and integrating every financial and accounting aspects of the company The primary objective of the package is to provide concrete accounting information for making sound business decisions for the shareholders creditors and various other business associates It provides detailed financial management options that range from general ledger interfacing accounts payable and accounts receivable modules to reporting and easy reconciliation The CAPITAL Financial and Accounting system has got three basic modules General Leger interface CAPITAL Accounts Payables Accounts Receivables Page 8 Capital The CAPITAL system provides a broad range of flexible customizable analytics reporting and budgeting options to meet the company s needs from advanced consolidation analysis to the simplest reporting requests Its applications tap into one of the most powerful reporting and analysis tools available providing real time insight into the critical information needed for smarter faster business decisions Page 9 Capital 2 High Level Architecture Financials Page 10 Capital 3 Processes 3 1 General Ledger Interface This is the interfacing module of the Capital the local system Which ever is available with the user s company This module will provide the required details to the local system This interface can be
71. ntry GLO300 form it needs to be confirmed For confirming these opening balance entries use the AR opening balance confirmation GLO320 form ER Ar Opening Updation Ex Action Edit Block Field Record Query Window Help Exile nn xiwxwi rl SUPER USER GL Date Total Number of Transactions to be Posted Document Number Local Amount Status SELECT EE EE EE 120 teed 120 ee eb Tels BEES teed 120 EE EE teed EE Enter value for Status LR MN dd Lc The screen will display all AR opening balance entries that haven t been confirmed Enter the GL Date for the transaction to be posted place a check mark next to the entries that the User wish to confirm and the click the Save button Page 66 of 191 Capital Receivable Voucher Query AR0220 The Receivable Voucher Query ARO220 is used to query for the different AR vouchers created during various transactions Ex Receivable Voucher Query E Action Edit Block Field Record Query Window Help 0 Information Dynamics SUPER USER Document Type t SALES RETURN Reference Details AR Code Lar JI SALR 2006 i AR Group LABYET J LAYEYEI GROUP Other Een Amount Details Date Details Currency AED c Document Date 16 APP 2006 Exchange Rate l Foreign Amount G L Date 16 4PP 2006 Base Amount oc Age Date amp APP 20DB or J Marratian ME S Due Date 16 APR 2006 oe E Entry
72. o Date 26 12 2007 Page 156 of 191 Capital Duplicate Printing at a E E x c se E aq um COGIG0 Information Dynamics SUPER USER mE es Record 171 istefValus DSC kDBG Page 157 of 191 Capital fal Tcr320 Previewer Ele View Help B25 ax 98 DEBIT NOTE DOCUMENT DETAILS Document Number SDNR 2006 00003 Document Date 08 APR 06 Due Date 08 APR 06 Other Ref VPW01000167 User Code 501 Code gt 22353 22336 Page No 1 of 1 zz om 4 00 4 00 rand Total DIRHAMS FOUR ONLY For INFORMATION DYNAMICS Page 158 of 191 Capital Age Analysis as on date Page 159 of 191 Capital 4 3 Accounts Payable Reports Payment Printing AP Opening Balanace AP Op AF Transaction Listing Age Inventory Repot oc Prepared Cancld Same D Limit Base Master AP Sample Reports and their calling forms APe pasted in the forthcoming pages Page 160 of 191 Capital Detailed Ledger Accounts Payable Detailed L amp sm mx sa uuu me er lino Ht Hates AL bi DAR QU fec Use flt WO Ihe a 1d ABLA He From Date 01 01 1998 Type Date 32 32 32 32 32 01 AUG 05 01 AUG 05 01 AUG 05 01 AUG 05 01 AUG 05 Credit Amount 0 00 28493 10 43080 03 5628 34 140 00 74 22 77415 69 77415 69 DETAILED LEDGER AP of2 Run Date 26 DEC 2007 Ref No APROO3 To Date 26 12 2007 Transaction All Transactions Do
73. of 191 Capital AP Analysis Master AP0230 Recall that there were ten analysis header fields in the AP Control Definition APOO10 These fields can be further subdivided using the AP Analysis Master Thus if defined the User will be able to generate more detailed analysis reports ES Ap Analysis Master Serial No al Analysis Code Analysis Name Record 11 List of Values DSC DBG 1 Click on the LOV button next to the Serial No field to get the list of the Analysis heads defined in the AP Control definition 2 Select one from the list and hit Enter or click OK This Analysis Head will get displayed in the AP Analysis Master screen Page 85 of 191 Capital 3 Then Enter the Analysis Codes and Names that is required in the rows provided 4 Click on Save button to save the details specified BR Action Edit Block Field Record Query Window Help a x neer nhao ex ae e O pens S I b DAYS 21D 30D Enter value for Analysis Code Record 1 2 lt OSC gt DBG gt Page 86 of 191 Capital AP Master AP0060 To record the details of the Accounts Payable Creditors the AP Master APOO60 is used This screen will also help in setting up the limits and other details for that particular AP supplier El Creditor Master Cua B x Ex Action Edit Block Field Record Query Window Help Els erm E E M E E AP0060 Information Dynam
74. or Approval it means that the voucher requires approval and Entry Completed means it does not require any approval In both the cases the User will have to click the check box so that the voucher can get created If the User don t click the check box then it will still be available for modification 8 Finally enter the allocation details required Allocation Details Allocation Code Currency Exchage Rate Foreign Amount Local Amount Narration ser en em ee ell AR amp JJAED l e 751 Allocation Details Demo amp J AED 2 Allocation Details Demo J 5 Bl Z OX ill I A Enter value for Allocation list of values available MARTEL NITE Record 2 2 List of Values lt O5C gt DBG gt 9 Click on Allocation Details button if the User wish to specify the GL Account code and other related details This screen will have fields that were defined in the corresponding masters Once the User have completed entering details Click on Go Back button to go to the main screen or simply hit Enter 10 Now click on Save button to generate the Cash Receipt A Cash Receipt reference code is also created by the system Page 38 of 191 Capital Take a look at a sample Cash Receipt CRVO7080001 generated for the AR customer AROO1 Page 39 of 191 Capital Bank Receipt AR0092 Whenever an Accounts Receivable Customer makes Cheque payment a Bank receipt needs to be generated For this purpose
75. pecify if tax is applicable or not This will also be updated by the system simultaneously and always indicates the year period which is currently open for transactions A set of 10 parameters used as criteria for analysis and label headers on the report generated thereby DEl To define the controls 1 Select a group from the list of values retrieved from the AP group master to set it as the default group Page 82 of 191 Capital Group Description TRADE CREDITORS OTHERS TRADE CREDITORS GROUP IMPORTED TRADE CREDITORS Cancel 2 Select a matching order This is to set the type of matching screen the User would like to see during AP matching operations tet Poste TN e Discount Allowed Het App cable Tex Allower AHlatchinc Order Document Dale Carem Open Year Document Type 858 Document Data Other Reference Hc Amount Oescenting Order htGpen Fero Amount Ascentn Order alvsis Head I CORPORATE 6 2 BRAND 3 Specify whether discounts and tax are applicable or not 4 Select the matching order that will be taken into consideration during an AP match activity Page 83 of 191 Capital ction Edt Blok B TRCHS S TRADE CREDITORS OTHERS Posted D1 JAN 2007 F 5 Enter the analysis headers required which can be up to ten in total This will be used during AP analysis 6 Click on Save button to save when the User are finished with it Page 84
76. r to payback This is a grace period set for the customer to payback when the credit days are over Depends on the AR transactions and will get displayed automatically Initially it will be zero This button will show the fields required to record additional currency details for the AR customer This button will show the fields required to record Group details of the AR customer This button will show the fields required to record analysis details for the AR customer Page 20 of 191 Capital The AR Master is one of the most important masters as it contains important information on Customers required for the different AR transactions A new AR customercan be created by following these steps 1 Click on the Insert button to enable the fields for editing to add the new customer details 2 Enter a unique customer code that will help identify the customer If the User enters an already existing customer code the system will alert the User 3 Enter the name and contact details of the new AR customer in the fields provided 4 Enter the name of a person who could be contacted when the AR customer is not reachable 5 Select the Receivable payment type from the list available 6 Select the Limit type to be imposed on the AR customer If the User selects No Limit the AR customer will be free to make purchases for an unlimited amount Instead if Fixed Limit is selected the AR customer will be a
77. sal only for existing Cash Bank PDC Receipts To do a Cash Bank PDC Receipt reversal Page 44 of 191 Capital 1 Enter or select the AR voucher document by clicking on the LOV button found next to the Document Number field When selected the details get populated automatically Document Number Document Date Gl Date Other Referena BDV BDVO 70200071 17 FEB 07 16 FEB 07 35000 SALES COLLECT BOVO 77040001 15 AFR 07 15 AFR 07 BR VO 7020001 4 23 FEB 07 TOWARDS ADV BR VO 030001 d MAR O3 MAR OF CEVOFOZ0001 CEW 23 FEB 07 23 FEB 07 ea TOARODS CAAS CRVO 7020002 Y A 23 FEB 07 TEST RWO7030001 i 19 MAR 07 13 CASH RECEIPT CRV 7040003 t APRA 12 APR O 55 PRO 7020001 E 23 FEB 07 PDC1 PRVO 7020002 E Uin 24FEB 07 PRVOFO40001 1 E 15 AFR 07 4 2 Enter the reversal Document Date and GL posting date These dates must be equal 3 Add any notes if required and then click on Process to do the reversal ES Cash Bank PDC Receipt Reversals Ex Action Edit Block Field Record Query Window Help A xX RFR 4 I ARU27U CAPITAL SUPER USER Document Number cRvovosoo01 Bele Orre PETTY Document Type CRY ICASHRECEIPT 00 0000000 Base Document Type RECEIPT 0 0 Old G L Date 19 14 2007 Doc Local Amount 1 Old Document Date M19 MAR 2007 Other Reference CASH RECEIPT Document Date 22 AUG 2007 J Reversal Type PBR O G L Date 22 4UG 2007 3 Notes For Demonstration 000
78. sed to query for the AR transactions that can be matched Document Document Type Number El oe SALON SALON 2006 0013 SALDN_RISDNR 2006 00001 SAL_DN_A SDNP 2006 00002 kl SAL_DN_ SDNP 2006 00003 The User can query by entering the required Document type or Document Exchange Foreign Date Currency Rate Amount prew peo Ooo 3 e Ere pe oo ET a a 039 4PR 0b 09 APR 06 ED 09 APR 06 ED 09 4PR 0b l f cl t L mm i i a D L DebitLocal Amt CreditLocal Amt 5769 069 5312 664 AA number Scroll to the right to view more details Page 73 of 191 Capital Year Closing AR al as E NIS Enter value for Year Record 141 OSC DEG Particular accounts receivable year can be closed from this program This has to be used once Periods are closed Year Enter the financial year to be closed Once entering the year if any period is open for that particular year it will display the user which period is open Status From here user can close the year by selecting the option as Close If any period is not closed for the entered year will be displayed in these fields Page 74 of 191 Capital Period Closing AR Gh son Es Bed End Ged Ge o ES AE alejo jp lp SEER A 5 Ao Infomation Domamice suren USER Record 141 OSC DEG gt Particular accounts receivable per
79. the Bank Receipt AR0092 is used As a pre requisite the document type must be pre defined in the Document Type Master C00050 EE Bank Receipt ole Ex Action Edit Block Field Record Query Window Help m x AR0100 Information Dynamics SUPER USER Reference Details Document Type 2 as Document Number A Ban k Code eil Other Reference RR Currency Details Currency cada BAO Date Details Exchange Rate Foreign Amount Document Date o DEC U07 J Base Amount 1 G L Date 16 DEC 2007 2 Cheque Details Cheque Number Cheque Date 16 DEC2007 jJ Clearance 6 DEO 2007 J Drawer Branch E Drawer Account Narration Fe Allocation Total Pt f l lj mE zm Allocation Details Allocation Code Currency Exchage Bate Foreign Amount Local Amount Narration Allocation Details Enter value for Document Type list of values available Record 171 ListoPvalues DsC lt DBG gt Fields those were not explained earlier will only be explained The User can take a look at the table in the section Voucher Entry AROO70 for some information Page 40 of 191 Capital To generate a Bank receipt for the Cheque payment made by the AR Customer 1 First select the document Type by clicking on the LOV button Usually the document type selected is the Bank Receipt Voucher which must be pre defined in the Document Type Master Id Document Type Master Document Mame BAN
80. the document Type by clicking on the LOV button Usually the document type selected is the PDC Receipt Voucher which must be pre defined in the Document Type Master Id Document Type Master Document Mame PO RECEIPT Cancel 2 Next select the Bank Code using the LOV button 3 The User can then enter any additional reference details if required 4 Next specify the current transaction s currency and amount details 5 Specify the date details 6 Enter the Cheque details 7 Enter the narration for that particular AR transaction 8 Finally enter the allocation details required Page 50 of 191 Capital Allocation Details Allocation Code Currency Exchage Rate Foreign Amount Local Amount Narration i A pa ED vj 1000 Allocation Details L ema E wy amp a 9 a 2j Enter value for Allocation list of values available Record 2 2 List of Values D5C gt lt DBG gt 9 Click on Allocation Details button if the User wish to specify the GL Account code and other related details This screen will have fields that were defined in the corresponding masters Once the User have completed entering details Click on Go Back button to go to the main screen or simply hit Enter 10 Now click on Save button to generate the PDC Receipt A PDC Receipt reference code is also created by the system 11 The PDC Receipt will get generated and then the system may ask the User whether
81. the section Voucher Entry APOO070 for some information Page 103 of 191 Capital SAMPLE PDC Payment PDC PAYMENT JV Other Reference Doc Number PPAY 0002 0708 Doc Type PDC_PAY Doc Date 27 AUG 07 Gl Date 27 AUG 07 Currency E AFRICAN RANDS Exchange Rate 1 00 Foreign Amount 1 000 00 Local Amount 1 000 00 Allocation Description Debit Credi Debit Details Narration Foreign Foreigr Amount Amoun Credit Amount 0063924 TRADE CREDITORS CONTROL DEMO In Words AFRICAN RANDS ONE THOUSAND ONLY Created By ID Page 104 of 191 Capital PDC Confirmation and Cancellation AP0120 Use this screen to confirm or cancel the PDC payment Scroll to the right to view more details The User can also specify the PDC transfer details here _ gt The Post Dated Cheques paid will get displayed automatically when the Bank Code is selected Page 105 of 191 Capital AP Document Matching AP0130 This tool is used to match AP documents when the transaction is complete AP Document Matching is one of the most important features of the Accounts Payable module The document matching plays an important role in reducing the work load of the system by just ignoring any payable transaction that has been balanced since no further transaction will occur on it Whenever a complete recovery full or in parts of the payable amount is made th
82. ts are shown here Select documents which are to be confirmed and save settings AAA The Payable voucher confirmation screen helps double check transaction details Page 92 of 191 Capital The AP Voucher Reversal AP0180 screen is used to record reversal transactions on an earlier payable transaction The AP voucher reversal document must be defined using the Document Type Master C00050 and linked to the AP Voucher document using the Voucher Reversal Link C00120 Process Enter value for Document Number R ecord 1 1 List of Values lt OSC gt l DBG gt The User can do an AP Voucher reversal only for existing AP Vouchers Page 93 of 191 Capital AP Voucher Cancellation AP0050 Use this screen to cancel any AP Voucher entry created earlier Record 1 1 List af Values kosc DBG gt Enter or select the document number of the required AP voucher and enter the cancellation remarks Then click OK to cancel the AP Voucher Entry Page 94 of 191 Capital This utility is used to view matching debit and credit AP documents This is of great help to find out imbalances in the postings Whenever a payable is recovered it is said to be matched Non recovered payables will create a balance The screen has got two sections The first section is where the criteria are set and the second section is where the details get displayed Page 95 of 191 Capital Cash Payment
83. ty List of value available Record 171 L List of values lt O5C gt lt DBG gt To do a Document Matching 1 Select the Party Doc Type and the Document Number Once these are selected the Total Document Value is displayed 2 Click on Normal Match if the User wish to do the matching manually but populate matching documents automatically 3 Click on Auto Match to allow the system to do the matching automatically Page 56 of 191 Capital 4 If there was a match a message box informs the User as shown above Click Ok and the documents will get populated The matching amount is also shown See below 5 Click on Document Match if the User wish to manually enter the document number to do the matching and hit enter The details will get populated and then the User can do the matching 6 If the User enter a matching value that exceeds the document value an error message as shown below occurs 7 If the User haven t matched the document properly the User will get this message Page 57 of 191 Capital 8 Click on OK to continue or Cancel to go back and change the matching 9 After completion of required activities click on Save button and exit Page 58 of 191 Capital AR Document Unmatching AR0190 This screen is used to unmatch any AR documents matched improperly For example suppose that two customers A and B have made purchases worth AED 700 with references AR SI A 0001
84. umber Other Reference Currency Details Date Details Currency T Document Date 16 DEC 2007 E Ex Rate Foreign Amount 0 Aqe Date amp DEC 2007 pal Local Amount J Due Pay Date fi b DEC 200 e Other Information Description Notes Enter value for AR Code list of values available Record 171 List of Values DSC lt DBG gt To make an AR opening balance entry 1 Select the AR Code of the required customer 2 Select the group which the AR customer belongs to Page 63 of 191 Capital 3 Select the document type usually AR Opening Balance Document 4 Enter any reference if available 5 Enter the date details 6 Select the currency and enter the opening balance amount 7 Enter any description and notes if required 8 Click on Save button Upon completion of these steps a message box gets displayed showing the AR opening balance entry s reference code as shown above A sample AR Opening balance Entry screen is shown below The Document number appears only after the Entry is completed Page 64 of 191 Capital F a cen ra z ee CMS P A Pees TO EJcUsTOMERA C EM TRADE DEBTORS MARA EMIRATE DIRHAMS Eu P3 AUG OD7 AUG 2 07 y 29 ALIG 2007 Page 65 of 191 Capital AR Opening Balance Confirmation GL0320 Whenever an AR opening balance is created either in the form of a transaction or using the AR opening balance e
85. unts Payable A ype Preview Laax eA M mA e m Information Dynamics AA A AGE ANALYSIS AP PD MOLAR Deke d AR EOE INS CET Aem BO OU CAD Y The ALAS NETA IM Page No ofl Date 26 12 2007 From Supplier 100 To Supplier 100 Currency DIRHAMS SUPPLIER CODE AND NAME PAY TERM CURRENT BALANC ES 91 180 181 999 AP BALANCE 100 GOODSWORTH 77415 69 77415 69 GRAND TOTALS 77415 69 77415 69 Page 164 of 191 Capital Page No of Kun Date 26 DEC 07 malas ll y ga Ref No APROO Uzer ID A AA A A AS GROUP MASTER LISTING AP Description Account Code 001001020113001 steig 001001020115001 ACCESSORIES 001001020115001 LEATHER BAGS 001001020115001 LEATHER BAGI 10020502 Page 165 of 191 Capital Payment Printing El Acton Edit Block Field Record Query Window Help XA List OF Values Available Record 1 1 List of Values OSC lt DBG gt Page 166 of 191 Capital PDC Listing by Bank Page No 1 ofl Run Date 26 DEC 2007 Ref No APRO17 Uzer ID Page 167 of 191 Capital PDC Listing by Supplier Page 168 of 191 Capital Transaction based on Details 262 2007 DETAIL WISE TRANSACTION LIST AR From Date 01 01 1998 To Date 26 12 2007 Customer Code 8 Name 100 Foreign Balance Doc Date Amount Amount 7785 00 USD 28493 10 01 AUG 05 11770 50 USD Y 43080 03 01 AUG 05 7 1537 80 USD 5628 34 01 AUG 05
86. wish to specify the GL Account code and other related details Page 26 of 191 Capital SCRAP SALES a 10 The More Details will help the User add more specific allocation details Quantity Currency Exchange Rate Foreign A Enter value for Description Record 1 1 lt OSC gt DBG Page 27 of 191 Capital AR Voucher Approval AR0200 If the receivable voucher was set to get an approval it will get listed here in this AR Voucher Approval ARO200 form Document Number Enter value for Status Record 1 1 ASA To change the approval status of the voucher 1 Select the status required from Pending Approved or Not Approved Page 28 of 191 Capital jm le r E rad ios i ma Sai deor Ger dde d 2 Add notes if necessary 3 Scroll to the right and enter the received date 22 AUG 2007 4 If the User wish to view the details of the voucher click the Details button which will take the User to the Voucher Entry screen with all details displayed for viewing Page 29 of 191 Capital Acan Det Allocation Details The User can click exit to go back to the AR Voucher Approval screen 5 Click on Save button to confirm the approval setting Page 30 of 191 Capital Receivable Voucher Confirmation AR0080 All approved documents are shown here Select documents which are to be confirmed and save settings a T The Receiva

Finance Module Capital USER MANUAL

Contents

Download Pdf Manuals

Related Search

Related Contents