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 Fields: REGION
Statistics: Leave only
View
Activity: Leave 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
|