QAD 2017 Enterprise Edition > User Guides > Periodic Costing > Using Checklists > Period End Checklist Using Advanced Repetitive
  
Period End Checklist Using Advanced Repetitive
This section contains the following checklists for closing to use with advanced repetitive work orders.
WIP Advanced Repetitive Orders
Inventory and Accruals
Accounts Receivable
Accounts Payable
Value-Added Tax
General Ledger

WIP Advanced Repetitive Orders
 
Your Closing Activity
Menu
Frequency (weekly, monthly, or quarterly)
Complete all transaction activity:
Standard cost revisions (rollup) for new period
14.13.14, 13.12.13,
1.4.18, 1.4.20, 1.4.21
 
Backflush transaction
18.22.13
 
PO Subcontract activities*
18.22.5 +
 
Repetitive Scrap*
18.22.18
 
Repetitive Reject*
18.22.16
 
Repetitive Rework*
18.22.15
 
Repetitive Setup Labor*
18.22.15
 
Repetitive Move
18.22.19
 
WIP Adjustments
18.22.21
 
Downtime
18.22.20
 
Non Productive Labor
18.22.22
 
*Can be completed as part of
backflush transaction
 
 
Cum Order Close
Note: Cumulative orders must have an effective end date on or before the effective end value you enter.
18.22.10
 
Print WIP Valuation Report (use cum order std)
18.22.4.13
 
Print other cost reports as required, for example, WIP Status Report
18.22.4.11
 
Review unposted GL transactions
25.13.13 or 25.13.14
 
Post repetitive order transactions to GL
25.13.7
 
Analyze unposted repetitive transactions:
Correct
Re-post
25.13.13 or 25.13.14
 
25.13.7
 

Inventory and Accruals
 
Your Close Activity
Menu
Frequency (Weekly, Monthly or Quarter)
Check all transaction activity up to date:
Verify all transfers up are to date
3.4.1 or 3.4.2
 
Verify all issues (unplanned/returns) are up to date
3.9 and 3.7
 
See all PO receipts/returns completed
5.13.1 and 5.13.5
 
See all SO shipments completed
7.9.15
 
See all SO shipments completed
7.9.5
 
Print Inventory Valuation Report.
3.6.15
 
Identify remaining sales invoices from Pending Invoice Register
7.13.2
 
Print and post remaining sales invoices or accrue using Pending Invoice Register (7.13.2).
7.13.3 and 7.13.4
 
Print PO Receipts Report GRNI (unvouchered)
5.13.5
 
Print PO Receipts for Memo vouchers (unvouchered)
5.13.5
 
Review unposted GL transactions
25.13.13 or 25.13.14
 
Post IC and SO transactions to GL
25.13.7
 
Analyze unposted IC and SO transactions
Correct
Re-post
25.13.13 or 25.13.14 3.21.16
25.13.7
 
Close sub-module in GL (WO/IC, SO)
25.3.4
 
Using GL Account Balance or Transaction by Account Inquiry or Account Balance and Detail Reports, reconcile with:
Inventory Valuation
WIP Valuation
GRNIs - PO Receipts
GRNIs - PO Receipts Memos
25.13.17, 25.13.18
25.15.1 and 25.15.2
3.6.15
18.22.4.13
5.13.5
5.13.5
 

Accounts Receivable
 
Your Close Activity
Menu
Frequency (Weekly, Monthly or Quarter)
Complete all transaction activity
Run AR to GL Transactions Report (all posted?)
27.21
 
Run AR Age Report as of Effective Date
27.18
 
Run DR/CR Memo Register
27.3
 
Run AR Payment Register
27.6.6
 
Reconcile opening Age balance plus DR/CR Memo Register Report total less AR Payment Register total with closing AR Age balance total
 
 
Review GL Unposted Transactions Register/Inquiry
25.13.13 or 25.13.14
 
Post AR transactions to GL
25.13.7
 
Analyze unposted AR transactions
Correct
Re-post
25.13.14
 
25.13.7
 
Reconcile AR Closing balance with GL balance
25.15.1 or 27.18
 
Close sub-module in GL
25.3.4
 

Accounts Payable
 
Your Close Activity
Menu
Frequency (Weekly, Monthly or Quarter)
Check all transaction activity
Run AP to GL transactions report (all posted?)
28.21
 
Run AP Age Report as of effective date
28.18
 
Run voucher register for: confirmed/unconfirmed/all
28.3.1
 
Run AP Payment Register (GL detail to Yes)
28.9.12
 
Reconcile opening Age balance plus Confirmed Voucher Register Report total less AP Payment Register total with closing AP Age balance total
 
 
Review GL Unposted Transactions Register/Inquiry
25.13.13 or 25.13.14
 
Post AP Transactions to GL
25.13.7
 
Analyze unposted AP transactions
Correct
Re-post
25.13.14
 
25.13.7
 
Reconcile AP Closing balance with GL balance
25.15.1 and 28.17
 
25.15.1/28.17
25.3.4
 

Value-Added Tax
 
Your Closing Activity
Menu
Frequency (Weekly, Monthly or Quarter)
Reconcile AR and AP Vat Reports to GL
2.15.2.13 or 2.15.2.14 and
2.15.2.16 or 2.15.2.17
with
25.15.1
 

General Ledger
 
Your Closing Activity
Menu
Frequency (Weekly, Monthly or Quarter)
Other modules: Fixed Assets
Reconcile/post
 
Other modules: Payroll and Deductions
Reconcile/post
 
Other modules?
Reconcile/post
 
Accrue for unconfirmed vouchers
28.3
 
Calculate manual accruals and prepayments
 
 
Input Standard Transaction Maint. journals
25.13.1
 
Input Reversing Transaction Maint journals
25.13.3
 
Foreign Exchange Revaluation
25.13.9
 
Review/correct unposted transactions
25.13.13 or 25.13.14
 
Post JL, RV, FX and other GL transactions
25.13.7
 
Print and review as required:
Trial balance
Balance sheet
Income statement
Custom reports
Cost center or project reports
GL Report Writer reports

25.15.4
25.15.8
25.15.13
25.17.13
25.15.18 to 25.15.23
25.21.17
 
Review, correct, post and reprint until satisfactory
25.3.4
 
Close GL module for period