Sunday, 9 November 2014

Lesson - 5 A/P Module -- Sage 300 ERP (ACCPAC) Revised

Lesson - 5
A/P Module -- Sage 300 ERP (ACCPAC)


Lesson - 5
A/P Module -- Sage 300 ERP (ACCPAC)
How to change Session Date
File Open Company – Change date there.
A/P Module Activation:
Make Sure A/P Module is Activated from
Administrative Services Data Activation.
What is Month End Procedures for Sage 300?
1.        Post all Sub-Ledgers open batches
2.       Post all G/L  open batches
3.       Back-up data files in separate folders
4.      Print all you want GL, TB, FS-IS,BS
What Sub-Ledgers are there for G/L besides A/P and A/R?
1.         Tax Services:
-Items, Vendors, Customers
2.       Bank Services:
3.       Payroll Services:
How to set up A/P Module in Sage 300  and why AP-Setup Option is necessary?
A/P Module – A/P Set up - Option
Company: Address/Name/Tel/Fax
Processing:
     Currency Options: CAD
     Processing Options: Leave Blank
     Aging Period: Leave, only View
     Vendors n Group Statistics: Keep Statistics
Transactions:
     Invoice Options: Leave, only View
     Payment Options: Tick Allow Remit
Numbering: Leave, only View
How and why AP-Account Set
Account Set Code: ECAN
Description:  Canadian Vendors – Elect. Div.
Payables Control: 3000
Purchase Discounts: 6000-100
Prepayments: 1103



How do I create a AP Distribution Code
Distribution Code: OFF100
Description: Off Exp – Electircal Divison
6050-100
Discountable
How do I create a AP Division Code
Account: 6025-100
Description: Advertising Expense – Elec. Div.
Tab.1 – Detail
     Structure Code: DIV
     Normal Balance: Debit
     Account Type: Income Statement
     Account Group: 13
Tab.2 – Optional Fields
Tab.3 – Trans.Optional
How to Set Up Distribution Sets for Expenses
A/P Set up Distribution Sets
Distribution Set: TEL100
Description: Telephone Bill – Elec. Division
Distribution Method: Fixed Percentage
Tab.1: Distribution Code:
Tab.2: Desc.: Telephone Expense - Machinery
Tab.3: G/L Account: 6020-200
Tab.4: Account Desc.: Telephone Exp
Tab.5: Distribution Percentage : 70

How to set up A/P terms 2/10 net 30 OR
Terms 30 2/10
Net 30
Net 15
Net 60
Instalment
Multiple
A/P Set up Terms
Term Code : 210 – Desc. 2% 10 days, Net 30
Tax : Excluded
Due Date Type: Days from Invoice Date
Discount Type: Days from Invoice Date
     Tab.1.  Payment Number:  1
     Tab.1.   Percent Due: 100
     Tab.1.   No. of Days: 30
     Tab.1.   Discount Percent: 2.000
     Tab.1.   No. of Days: 10

How do I setup Payment Codes:
A/P Set up Payment Codes
   Payment Codes: CASH / VISA / CHEQUE
   Description: Cash / Visa / Cheque
How do I setup Vendor Group:
A/P Vendors Vendors Group
Group Code: ECN
Description: Canadian Vendors – Elec. Divi.
     Group
        Account Set:  ECAN
        Terms Code:  30
        Bank Code:  TDCHQ
        Payment Code: CHECK
         Leave Generate Separate Payments …
     Invoicing:
        Distribute By : Distribution Code
        Distribution Code : INVELC
        Duplicate Invoice Checking:
           Vendor and Amount : Warning
           Vendor and Date : Warning
        Tax Group : ONT
     Optional Fields: REGION
     Statistics:  (Current Period)
          Year: 2015
          Period: 01              
    





How to set up Vendors in AP Module
AP Vendors-Vendors
Vendor Number: 1000
Vendor Name: Kaka Lam Tool n Die
     Address:
          Group Code: ECN
          Short Name:  Kaka         
     Contact:
     Processing:
          Account Set: ECAN
          Terms Code:  210  (2% 10 Net 30)       
          Bank Code:  TDCHQ         
          Account Set: CHECK
          Credit Limit:  1000   
     Invoicing
          Distribute By:   1.  Distribution Set
                                   2.  Distribution Code
                                   3.  G/L Account
                                   4.  None 
As you select 1 to 4 all other fields
will be automatically selected
     Optional FieldsREGION
     Statistics: Leave only View
     ActivityLeave only View
     Comments: Leave only View
What is AP Vendor Remit to Location and why, when and where it is necessary to fill in?
Remit to locations form needed to fill in if the Vendor have different address to remit payment:
A/P Vendors Remit to Location – Input Vendor No. 1000 – Insert or New – Fill in the desired Information in desired Tab.
What to see in AP Vendors Activity
A/P Vendor – Vendor Activity
   Activity:
       Credit Limit
       Outstanding Balance
       Prepayment Amount
       Last Invoice Amount
       Last Payment Amount
   Aging: 30/60/90/90 over
   Transactions: All details INV/CR/DN/RT
   Payments:  All details of Payments
A/P Invoice Entry
Batch Number:  1
Batch Date:  01/31/2013
   Document:
      Entry No.:  1  Kramden Tool n Die
      Vendor No.:  1000
      Remit-To Location: 1
      Document Type:  Invoice/
      Document Date:  12/15/2014
      Posting Date:  12/15/2014
      Document No.: 3658
      PO No.:  8005BS
      Order No.:
      Document Total:  16050.00
      Distribution Code:  INVELC
       Amount: 16050.00
   Taxes: Enter Amount 0 (zero)
   Terms:  210
   Optional Fields:  REGION
   Total:  Check the figure

What is a Batch Listing?
In Sage 300 ERP Accpac, entries are recorded in batches and those batches are called Batch Listing.
How do adjustment made:
A/P Transaction – Adjustment Batch List – Post Batches (for Adjustment).
How many batch listing are there in A/P.  is it necessary to post through the appropriate Batch?
Yes and there are 3 Batch Listing:
1.        Invoice Batch Listing
2.       Adjustment Batch Listing
3.       Payment Batch Listing
How many Transaction types are there in A/P Payment
There are four types of Transaction type and the fields change according to the type selected.
1.        Payment
2.       Prepayment
3.       Apply Document (Credit Note)
4.      Misc. Payment
Under the Apply Colum - Change the No to Yes to pay or apply as the case may be.
Cheque Form 11A
look Cheques then Post
When to Post the Payment Batch Listing:
System will see the cheques are printed, post
1.         First See all the Cheques are printed
2.       Now you can Post.
How to Control Payment
A/P Transaction – Control Payment
Three are three Option
1.         Normal: OK to print and post
2.       Forced: Ok to Pay
3.       On Hold: Wait for Manager Approval
Please explain A/P Vendor Reports
Vendor Group: for Vendor Group List
Vendors:   All Vendors Name,
                  Address,
                  Profile,
                  Comments,
                  Recurring Payables,
                  Optional Fields
Remit to Locations
Recurring Payables
Letters / Labels


Lesson - 4 G/L Module -- Sage 300 ERP (ACCPAC)

Lesson - 4
G/L Module -- Sage 300 ERP (ACCPAC)

Lesson - 4
G/L Module -- Sage 300 ERP (ACCPAC)

How and where to set up my GL
GL – GL Option
Company:
    
Account:
     Use A/c Group
     Default Closing A/c 1520 Retained Earning
Posting:
     7 Years of Fiscal Sets
     7 Years of Transaction Detail
     Current Fiscal year                            2015
     Oldest Year of Fiscal Sets                  2014
     Oldest Year of Transaction Details   2014
Segments:
     Account                            4
     Department                      3
     Account Segment             1
     Default Structure Code    ACC
How to set up Source Code for G/L Set up
G/L Set up - Source Code
     GL - JE
     GL - CR
     GL - CD
What is Source Code? And
How to Add Source Code?
Source Code is like the Sub-Ledger Code.  Like GL for General ledger and SA for Sales
How to set up Source Journal Profile in G/L Set up
G/L Set up - Source Journal Profile
     Bank Reconciliation
        GL - JE
        GL - CR
        GL - BC
What is Source Journal Profile? and
How to Create Source Journal?
It is a combination of sub-Ledgers that are inter-linked like Bank Reconciliation would have
CD-Cash Disbursement,
CR-Cash Receipts and
BC-Bank Charges
How to set up Segment Code in G/L Set up
G/L Set up – Segment Code
     Department
         100   Consulting
         200   Textbooks    
What is Department Segment? and
How to Define Department segment?
It is a segment of a GL Account act like department and it can be Define through GL Setup – Segment Code
How to set up Account Structure in G/L Set up?
G/L Set up – Account Structure
     Structure Code:
       ACC                        Account
                                       ACCOUNT
       Use as Company Default
       
       DEP                         Department
                                        ACCOUNT
                                        DEPARTMENT   
What is Account Structure? and
How to Define Account Structure?
Account Structure is composite of GL Account number plus Segment Code….
How to set up Account Groups in G/L Set up
G/L Set up – Account Groups
        01 Cash and Cash   
        02 Account R/A      
        03 Inventory
How to set up Recurring Entry in G/L Set up
-Common Services - Schedules (Reminder)
-G/L Set up – Recurring Entries
     Month :  Monthly Cleaning Fee
        1810-100                50
        1810-100                50
        1360 R/A               13
        1300                                  113
-G/L Periodic Processing – Create Recurring                              Entry Batch - Process
-G/L Transaction Batch List – to CHECK n      Post
Where to Post Batches in G/L?
-G/L Transaction - Post Batch (All)
-Make first all Ready to Post ‘Yes’
What for is the Optional Fields and How to set up in G/L Set up.
G/L Set up – Optional Fields
     REGION
How do I create a GL Account
GL Account Account
Account : 1000
Description : Bank - Checking
   Tab.1 – Detail
     Structure Code :  ACC
     Normal Balance : Debit
     Account Type: Balance Sheet
     Account Group: 01
     Status: Active
     Account Group: 01
     Control Account: Yes
     Auto Allocation: Yes – No
                Allocation Tab will appear
                Make Account selection
                Make Percentage selection
      Post to Account :
                 Details
                 Consolidated
                 Prohibited
   Tab.2 – Optional Fields
   Tab.3 – Trans. Optional Fields


How do I create New Year what is G/L Periodic Processing?
-Dump the Current Year files in the folder
-Create Default Retained Earning Account  under G/L Option Set up
-Click Create Recurring Entries Batch  I-con in G/L Periodic Processing
-Click Create Allocation Batch I-con in G/L Periodic Processing
-Press Create New Year I-con and Process under G/L Periodic Processing.
How and where to create new Fiscal Year
Common Services – Create New Fiscal Year and Check it from G/L Setup Option to see the current Year is change to 2015
And the old Year is 2014


Lesson - 3 Loading Database to Sage 300 ERP (ACCPAC)

Lesson - 3
Loading Database to Sage 300 ERP (ACCPAC)
Lesson - 3
Loading Database to Sage 300 ERP (ACCPAC)
How to Load the Data files?
Database Load Process
Start – All Program – Sage Sage ERP 2013 Tools right click Load –– Run as Admin. – Set Directory Browse Your Name Accpac Lesson? (database folder should have 2 files) OK – OK – (2 Files should pop up)
1.        XXXDAT (Select) – Next – Make sure Same XXXDAT is selected – Next Finish – Click Next (Nothing shows at the screen right now and after clicking next XXDAT and XXXSYS show)
2.       XXXSYS (Select) – Next – Make sure same XXXSYS is selected – Next Finish
3.       Start – All Program – Sage Sage ERP 2013 –  right click icom sage 300 ERP 2013 and Run as administrator.  
How to Backup or Dump Data files? OR
What is the Process of Dumping Databases files in Sage 300 ERP - ACCPAC?

Database Dump Process
1.         Create a folder in local disk c drive : Lesson ? page ?
2.       In sage AccPac, Click Admin. ServicesDatabase DumpBrowse – local disk c drive – Lesson ? page ? (folder – OK
3.       At the top, company should be XXX DAT – Dump and then one more time
4.      At the top , company should be XXX SYS – Dump
5.       In Local Disk (c drive) Do you see 2 Folders (xxxdat and xxxsys)? To confirm
What is Visual Process Workflow?  Can we open a form from VPW?
Yes we can access to various windows and forms by clicking the related i-con linking Ledger Transaction Visual Process Workflow.


Lesson - 2 Beginning with Sage 300 ERP (ACCPAC)

Lesson - 2
Beginning with Sage 300 ERP (ACCPAC)

Lesson - 2
Beginning with Sage 300 ERP (ACCPAC)

What is Session Date and its Importance
Session date should be the last of the month preferred and it must be updated each time log in.
From where can we change the Computer Date Format
Start - Control Panel

Sage 300 ERP ‘I-con’ and ‘key’ and their name:
Finder
Previous/Next Button
New
Drill down button
Go button (F7)
Zoom button (F9)
Insert key

Magnify Glass
Arrow key
Blank Page
Picture of Drill to know the original point
Enter the first number and then press F7
To enter entry in separate transaction form
To go the next line if no access
How to create System and Company Databases in Microsoft SQL Server 2008 MSE
By creating 2 folders in Window Explorer:
C:\data\omnsys for Omni System
C:\data\omndat for Omni Company Data
Where can I change Company Name?
Common Services – Address Tab
Where can I change my Currency
Common Services – Option Tab
How to start again if you make mistake?
Database Load C:\data\Sage 300 ERP..
How and where to Activate Module?
Administrative Services: Before making entry; the related module should be activated and there are following applications/modules:
1.        Accounts Payable
2.       Accounts Receivable
3.       Bank Services
4.      General ledger
5.       Intelligent Reporting
6.      Inventory Control
7.       Order Entry
8.      Purchase Order
9.      Tax Services
10.    Cdn PR Tax Update July 1 2012
11.     Canadian Payroll.
Can I change the Icon Size?
Yes, from Common Services - View
What the Schedule window does?
It creates Schedule for recurring entries.
What is a Reminder List job?
It reminds you when the schedule is due
What is there in Common Services Folder?
1.         Company Profile
2.       Fiscal Calendar
3.       Scheduling
4.      Currency
5.       Optional Fields
What is there in Administrative Services Folder?
1.         Users
2.       Security Group
3.       User Authorizations
4.      Customization Directories
5.       Data Activation
6.      UI Profile Maintenance
7.       Assign UI Profiles
8.      Assign Visual Process Flows
9.      Data Integrity
10.    Restart Maintenance
11.     Database Dump
12.    Database Load