Release Name
Track:
Thread:
QA Lead:
1095 -11.5.9 Upgrade
Finance
Thread 27 -Month End Close
Suresh Venkat
Number
27-1
27-2
27-3
27-4
Component
General Ledger
Accounts Receivables
Accounts payable
Fixed Asset
27-5
Project Accounting
27-6
27-7
27-8
Royalties
Purchasing
Inventory
27-9
Cost Management
323052819.xls
Description
Month Close Process for General Ledger
Month Close Process for Accounts Receivables
Month Close Process for Accounts payable
Month Close Process for Fixed Asset
Month Close Process for Project Accounting
Month Close Process for Royalties
Month Close Process for Purchasing
Month Close Process for Inventory
Month Close Process for Cost Management
07/05/2016
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
27-1-01
Tracker
27-1-General Ledger
<Tester>
<dd-mmm-yyyy>
Sym US GL Super User,Sym Ireland GL Super User,Sym Ireland Pac GL
Test Case
Process
Import Jounal Entries
Navigator=>Journals=>
Import=>Run
Enter the Source from which you
want Journal Import to create
journal entries. (Symantec will
manually import from the Inventory
and Purchasing subledgers, but the
AP and AR subledgers should also
be swept.)
Select each Group ID that exists for
all of the Subledger
Define the Journal Import Run
Options: Post Errors to Suspense
and Create Summary Journals
should always be selected.
Click Import Button.
27-1-02
Correct Errors and Reconcile Navigator=>Journals=>
Posted Journals
Import=>Correct
Select your search criteria and click
on Find button.
Correct the errors and Rerun
Journal Import on the corrected
data.
Run the standard Oracle Month-End
reports.
27-1-03
Close Current Period
Navigator=>Setup=>
Open/Close
Place the cursor in the status
column of the period to be closed
and select Closed from the list of
values on Period Open/Close Form
Click Ok Button.
27-1-04
Open Next Period
Navigator=>Setup=>
Open/Close
Select the Period to be opened and
Click the Open Next Period button.
Sym Ireland GL Super User,Sym Ireland Pac GL Super User
Expected Results
Comments
General Ledger names the
resulting batch as follows:
<REFERENCE1> <Source>
<Request ID>: <Actual Flag>
<Group ID>.
Check for errors on Check
Journal Import Data Screen
Ensure all recurring journals
and Reversing Journals have
been generated and ensure all
journals have been imported
and posted.
Reconcile the reports
Selected period should be
closed.
Once a period is closed, you
can no longer enter or post
journals for the period.
Pass/Fail Defect ID
DO NOT select Permanently
Closed. This would prevent
you from ever re-opening the
period.
A concurrent request will be
generated to open the next
period; once the concurrent
request has completed, the
period status for the next
period will be 'Open'.
When the first period of a
new fiscal year is opened,
the net income/loss for each
Company segment value for
the year will be calculated
and closed to retained
earnings.
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
27-2-01
Tracker
Test Case
27-2-Accounts Receivables
<Tester>
<dd-mmm-yyyy>
Sym US AR Super User,Sym Ireland AR Super User,Sym Ireland Pac AR
Process
Complete all Manual Receipt Navigator=>Reports=>
Batches for the Month
Other
Run Deposited Cash Report -Open
Detail
These can be left as Unapplied, but
you should place the payment OnAccount
27-2-02
Enter and Complete all
manual invoices, credit
memos for the month.
Navigator=>Reports=>Other
Run Symantec Uninvoiced
Shippment Report
Navigator=>
Transactions=>Transactions
Enter and Complete Invoices and
Credit Memos.
27-2-03
Run Auto Invoice Process
Navigator=>Interfaces
=>AutoInvoice
Enter the parameters and Click
Submit.Verify Auto Invoice
Processing Report.
27-2-04
Approve Open Adjustments
Navigator=>Reports=>
Accounting
Run Adjustment Approval Report
Navigator=>Control=>
Adjustments=>Approve Adjustments
Approve Adjustments
27-2-05
Check Incomplete
Transactions
Navigator=>Reports=>
Listing
Run Incomplete Invoices Report
Navigator=>Transactions=>Transact
ion Summary
Complete or Delete all Incomplete
Transactions
27-2-06
General Ledger Transfer
Enter the Parameters and Run
General Ledger Transfer Job.
Navigator=>Interfaces=>
General Ledger
27-2-07
Close Receivables Periods
Navigator=>Control=>
Accounting=>Open/Close
Periods.
Place the cursor in the status
column of the period to be closed
and select Closed from the list of
values on Period Open/Close Form
27-2-08
Open Receivables Period
Navigator=>Control=>
Accounting=>Open/Close
Periods
Select the Period to be opened and
Click the Open Next Period button.
27-2-09
Run Period End reports
Navigator=>Control=>
Requests=>Run
1) Aged Trial Balance 4 or 7 bucket
by Account
2) Transaction Register
3) Unapplied Receipts Register
4) Applied Receipts Register
5) Adjustment Register
6) Invoice Exceptions
7) Transaction Reconciliation
les
Sym Ireland AR Super User,Sym Ireland Pac AR Super User
Expected Results
Un Applied Payments Batches
will be displayed.
Uninvoiced Shippments
should be displayed without
errors.
Invoices and Credit Memos
should be created without
errors.
Invoices should be imported
without Errors.
Adjustments yet to be
approved will be displayed.
Adjustments should be
approved without errors.
Incomplete Invoices should be
displayed without errors.
Invoices should be completed
or deleted without errors.
Journal entries should be
transferred to GL.
Comments
Pass/Fail Defect ID
Period should be closed
without errors.
A concurrent request will be
generated to open the next
period; once the concurrent
request has completed, the
period status for the next
period will be 'Open'.
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
27-3-01
Tracker
27-3-Accounts Payables
<Tester>
<dd-mmm-yyyy>
Sym US AP Super User,INT Payables Super User
Test Case
Process
Approve Invoice to be
Posted In the Current
Period.
Navigator=>Other=>
Requests=>Run
1.Run Payables Approval
Concurrent Request and Check the
report for any holds placed.
2.Run Invoice on Hold Report .
Navigator=>Invoices=>Entry=>
Invoices.
Review & Resolve distribution
account invalid holds.
Navigator=>Other=>
Requests=>Run
1.Run Invoice on Hold Report to
make sure holds are removed.
2.Re-Run Payables Approval
Concurrent Request.
27-3-02
Create Accounting Events
Navigator=>Other=>
Requests=>Run
1. Run Payables Accounting
Process to create invoice
distribution and payment accounting
events for review.
2. Review Payables Accounting
Process Report to review invoice
distribution and payment accounting
entries and make any changes
necessary before transfer to the GL.
3. Run Unaccounted Transactions
Report.
27-3-03
Payables Transfer
Navigator=>Other=>
Requests=>Run
1.Run Payables Transfer to GL to
transfer approved invoice
distributions and payments to GL for
posting
2. Review the Accounts Payable
Journal Entry Audit & Exceptions
Reports to ensure all invoices were
transferred.
3. Review Journal Import Execution
Report and ensure that Status =
SUCCESS.
27-3-04
Create Mass Additions
Navigator=>Other=>
Requests=>Run
1. Run Mass Additions Create to
transfer asset-related invoices to
Oracle Assets
2. Forward Reports to FA
Accountant.
27-3-05
Close Current Period
Navigator=>Accounting=>Control
Payable Periods
Select the Current Period and
Change Status to Closed and Save.
27-3-06
Sweep Unposted Invoices
Navigator=>Other=>
Requests=>Run
1. Run Unposted Invoice Sweep
with Sweep Now parameter set to
No for Preliminary report.
2. Confirm that invoices to be swept
do not have to be posted to current
period.
3. Review Sweep report against
Unaccounted Transactions report.
4.If no corrections are required, ReRun the Unposted Invoice Sweep
with the parameter set to Sweep
for Actual sweep.
5.Close the Accounting Period.
27-3-07
Reconcile Payables Activity
for the Period
Navigator=>Other=>
Requests=>Run
1. Accounts Payable Trial Balance
Report
2. Posted Invoice Register
3.
Posted Payment Register
27-3-08
Open Accounting Period
Navigator=>Accounting=>Control
Payable Periods
Select the period to be opened and
change status to "Open"
27-3-09
Run Month end Reports
Navigator=>Other=>
Requests=>Run
1. Accounts Payable Trial Balance
2. Posted Invoice Register
3. Posted Payments Register
4 Invoice Aging Report
5 Invoice Audit Report
NT Payables Super User
Expected Results
Invoices should be Approved
without Errors.
Process should go through
without any errors.
Comments
Pass/Fail Defect ID
Payables information should
be transferred to GL without
Errors.
Asset related invoices should
be transferred without error.
Status should change to
closed unless Unaccounted
transactions exist.
Accounting Period Should be
Closed and Records Sweeped
to Next Period.
The Oracle Payables roll-forward
reconciliation formula is:
Accounts Payable liability
beginning balance (from the
Accounts Payable Trial Balance
report run for the previous period)
Plus: current period
Invoices (from the Posted Invoice
Register)
Less:
current period Payments (from the
Posted Payment Register)
Equals: Accounts Payable liability
ending balance (this calculated
amount should equal the balance
from the Accounts Payable Trial
Balance report run for the current
period)
Period should be opened
without errors.
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
27-4-01
Tracker
27-4-Fixed Assets
<Tester>
<dd-mmm-yyyy>
Sym US FA Super User,Sym Ireland FA Super User
Test Case
Process
Prerequisites:
1.Verify Oracle Payables month-end
processing has been performed and
the Mass Additons Create process
has been run from AP.
2.Prepare and Post Mass Additions
from AP (Refer 27-3-04)
27-4-02
Post Mass Additions
Navigator=>
Mass Additions=>Post Mass
Additions.
Enter the Parameters and Click
Submit.
27-4-03
Create Journal Entries
Navigator=>Journal
Entries=>Standard
Select Book and Period in the
Parameter Form and Click Submit
button.
27-4-04
Run Depreciation
Navigator=>Depreciation=>Run
Depreciation
Select the Book and Period for
which Depreciation to be run and
Select Close Period Check box.
27-4-05
Data Validation
Click Submit.
Navigator=>Other=>
Requests=>Run
Reconcile Cost Summary Report
and Reserve Summary Report to
GL.
Sym Ireland FA Super User
Expected Results
Comments
Assets should be Added
without errors.
Journal Enteries for the
selected period should be
created without errors.
Depreciation ,Generate
Accounts,Calculate Gain and
Loss,Journal Entry Reserve
Ledger Report should be
processed without error.
Note: Once an
assets period is
closed, it cannot be
reopened.
Pass/Fail Defect ID
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
21-5-01
Tracker
27-5-Project Accounting
<Tester>
<dd-mmm-yyyy>
Sym US PA Super User,Sym US AP Super User,Sym US AR Super User,S
Test Case
Process
PA Imports Time
Navigator=>Other=>Request=>
Run
Select Single Request and From
the LOV select " PRC:
Transaction Import" and Click
Submit.
Click Yes to Submit Another
request.
From the LOV
select " PRC: Distribute Labor
Costs"
and Click Submit.
Click Yes to Submit Another
request.
From the LOV
select " PRC: Create and
Distribute Burden Transaction"
and Click Submit.
Click Yes to Submit Another
request.
From the LOV
select " PRC: Interface Labor
Costs to General Ledger"
and Click Submit.
Click Yes to Submit Another
request.
From the LOV
select " PRC: Interface Usage
and Miscellaneous Costs To
General Ledger"
and Click Submit.
27-5-02
AP Imports Expense Reports Responsibility:
Sym US AP Super User.
Navigator=>Invoices=>Entry=>E
xpense Reports
Query For the Expenses
Created and Approve Them.
Navigator=>Others=>Request
=>Run
Select Single Request and From
the LOV select " Payables
Invoice Import".
Enter the Below Parameters.
1.Source=Oracle Internet
Expense.
2.Summary Report=NO
Click Yes to Submit Another
request.
From the LOV
select " payables Accounting
Process"and Click Submit.
Click Yes to Submit Another
request.
From the LOV
select " Payables Transfer To
GL"
And Click submit.
27-5-03
PA Imports Expense Reports Navigator=>Others=>Request
=>Run
Select Single Request and From
the LOV select "PRC:Interface
Expense Reports From
Payables ".
And Click Submit.
27-5-04
PA Creates Revenue,
Invoice and Transfer to AR.
Navigator=>Others=>Request
=>Run
Select Single Request and From
the LOV select "PRC:Generate
Draft Revenue for Range of
Projects".
And Click Submit
Click Yes to Submit Another
request.
From the LOV
select " PRC:Generate Draft
Invoice for Range of Projects"
Navigator=>Billing=>Invoice
Review
Approve and Release Invoices
Click Yes to Submit Another
request.
From the LOV
select " PRC:Interface Invoices
To Receivables".
And Click submit.
27-5-05
Create Transaction in AR
Responsibility:
Sym US AR Super User
Navigator=>Interfaces=>Auto
Invoice
Enter Parameter as below
1.Source=Projects Invoices
27-5-06
Tie Back to PA
Responsibility:
Sym US PA Super User
Navigator=>Others=>Request
=>Run
Select Single Request and From
the LOV select "PRC:Tieback
Invoices from Receivables"
And Click Submit
27-5-07
GL Transactions
Responsibility:
Sym US PA Super User
Navigator=>Others=>Request
=>Run
Select Single Request and From
the LOV select
"PRC:Interface Labor Costs to
GL ".
And Click Submit.
Click Yes to Submit Another
request.
From the LOV
select "Interface Usage and
Miscellaneous Cost to GL"
Responsibility:
Sym US GL Super User
Navigator=>Journal=>Import
Enter Source as Projects and
Select All Group ID's
Responsibility:
Sym US GL Super User
Navigator=>Journal=>Post
Enter Source as Projects and
Click Find on Find Journal Form
Select all Records and Click
Post
Responsibility:
Sym US PA Super User
Navigator=>Others=>Request
=>Run
Select Single Request and From
the LOV select
"PRC:TieBack Revenue from GL
".
And Click Submit.
27-5-08
PA Period Close
Responsibility:
"Sym US PA Super User"
Navigator=>Setup=>System=>P
A Periods.
Change Status of the Period to
be closed from Open to Close.
ser,Sym US AP Super User,Sym US AR Super User,Sym US GL Super User
Expected Results
Process Should Import
TimeCards into PA.
Labour Cost Should Be
Distributed without Errors.
Burden Cost Should be
distributed without Errors.
Process Should Run Without
errors
Costs Should be Transferred to
GL no Errors.
Expense Should Be Approved.
Comments
Pass/Fail Defect ID
Expense Reports Should be
Imported to AP.
Invoices Should be Accounted
Invoices Transactions should
be Transferred to GL.
Expenses should be imported
for the Selected Project.
Revenue Should be Generated
and Approved
Invoices Should be Created
Invoices Should be Approved.
Invoice Should be Interface to
AR.
Transaction Should be Created
without Errors.
Process should run without
Errors
Transactions should to
Transferred to GL Interface
Tables.
Transactions should to
Transferred to GL Interface
Tables.
Journal should be imported
without errors
Unposted Project Journals
Should be listed.
Project Journals Should be
posted.
Process's should be completed
without errors
Period should be Closed within
2 minutes.
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
Tracker
27-6-Royalty
<Tester>
<dd-mmm-yyyy>
Symantec Royalty Administrator
Test Case
Process
27-6-01
Claculate the Royalty for
the period to be closed.
Navigator -> Reports ->
Royalty Reports -> Run :
Submit Requests.
Select thpe of request and click
OK.
Get LOV for Name field and
select SYMROY Calculations.
Select the Fiscal Period to close
and click OK input other
optional info and click Submit.
27-6-02
Close Period
Navigator=>Process=>
Period Close(M,Q,Y)
Enter Period and Click Process
nistrator
Expected Results
Opens the "Submit a New
Request" window.
Opens "Submit Request"
form.
Opens the Parameters
window.
Process submitted without
errors.
Period Should be closed
without errors.
Comments
Pass/Fail Defect ID
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
Tracker
27-7-Purchasing
<Tester>
<dd-mmm-yyyy>
Sym US PO Super User,Sym US GL Super User
Test Case
Process
27-7-01
Run PO Reports
Navigator=>Reports=>Run
Run PO Transaction Reports:
Purchasing Activity
Printed
Purchase Order Report
Canceled Purchase Order
Report
27-7-02
Analyse uninvoiced
receipts that will be
accrued for the period
Navigator=>Reports=>Run
Run UnInvoiced Receipts Report
27-7-03
Create unvoiced receipt
accrual journal lines for
the period
Navigator=>Reports=>Run
Run Receipt Accruals - PeriodEnd
27-7-03
Import Jounals
Sym us gl Super user
Navigator=>Journals=>Import
Select Source as
"Purchasing"and No Goup ID.
Click Submit
27-7-04
Reverse Accruals
Responsibility : Sym us gl
Super user
Navigator=>Journals=>Enter.
Query for Journal Source as
Purchasing and Category as
Accural for Period to be closed.
Select Journals and Click
Reverse
27-7-05
Close Purchasing Period
Navigator=>Setup=>Financials
=>Accounting=>Control
Purchasing Period
Sym US GL Super User
Expected Results
Comments
Reports Should Complete
and display output
without errors.
Un Invoiced Receipts
Should be displayed.
This process creates
accounting Accrual entries
using the Journal Source
'Purchasing' and the
Journal Category 'Accrual'
Purchasing Journals
Should be imported
withour errors
Accural Journals Should be
displayed for Source
Purchasing.
Jounals Should be
Reversed without errors
Define the Journal Import
Run Options: Post Errors to
Suspense and Create
Summary Journals should
always be selected.
Pass/Fail Defect ID
Period Should be closed
without error.
(When the purchasing
Period is closed, Purchasing
automaticaly un-marks all
the receipts previously
accrued to allow these
receipts to be accrued again
if they are still un-invoiced
at the end of the next
period.)
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
27-8-01
Tracker
27-8-Inventory
<Tester>
<dd-mmm-yyyy>
Sym US INV super User,INT Inventory
Test Case
Process
Inv. Accounting Period
Navigator -> Sym Inv ->
Accounting Close Cycle ->
Inventory Accounting Periods
Maintain Inventory Periods
Select the period to change
status and click Change Status
button.
Close the Period and click Ok.
INT Inventory
Expected Results
Opens the Inventory
accounting Periods form
Opens the window
"Change Period status.
Closes the period and
changes the status of the
Period to close.
Comments
Pass/Fail Defect ID
Component
Tested By:
Date Tested:
Relevant Documents:
Responsibilities Required
TC No.
27-9-01
Tracker
27-9-Cost Management
<Tester>
<dd-mmm-yyyy>
Sym US CST Super User,Sym Ireland CST Super User
Test Case
Process
Expected Results
Costing periodic Close
Cycle
Navigator => Periodic Costing
=> Close Cycle => Periodic
Accounting Periods Period
Accounting Periods.
Select the period and close it
selecting the Process status
button.
Opens periodic accounting
period.
Status changes.
Comments
Pass/Fail Defect ID
