Processing a Period End Close in MFG/PRO

1
Processing a Period End Close in MFG/PRO

• Midwest User Group
• September 27 28, 2004
• Carol Cvitkovich and Maureen Hunt
• QAD Global Services

2
Period End

• General Ledger Calendar
• Security Settings (Entity, Site, Account, Menu
  Options)
• Transaction Posting
• Balancing Sub Ledgers to General Ledger
• Financial Statements

3
Common Issues at Period End

• Processes and Procedures
• Customer Expectations
• Processing Cutoff Time
• Reporting Requirements
• MFG/PRO Configuration

4
Control Files

• System Account Control File
• General Ledger Control File
• Account Maintenance
• Inventory Control File
• Sales Order Control File
• Work Order/Repetitive Control File
• Accounts Payable Control File
• Accounts Receivable Control File

5
General Ledger Control File
6
Account Maintenance
7
GL Account Flow
TransactionsPO, SO, WO, etc.(Can override
default accounts)
PL Sales Accts 1.2.17Default per channel, site,
cust type, PL
PL Inv Accts 1.2.13Default per site/location

• Customer Accts, 2.1.1
• Supplier Accts, 2.3.1
• Site Accts, 1.1.13

Dept. Accts. 14.1Work Center Defaults
Product Line (PL) Accts1.2.1Item Defaults
System/Account Control File 36.1General Defaults
8
Inventory Flow
Purchase Order Receipts
Inspection
Raw Materials Service Items
Work-in- Process
Finished Goods
Shipments to Customer
9
GL Consequences of Unplanned Inventory
Transactions
Inventory Transaction Debit Account Credit
Account Unplanned Receipt Inventory Purchase
Expense Unplanned Issue Cost of
Production Inventory Sales Return Inventory Sales
Returns Return to Supplier Purchase
Expense Inventory Return to Stock Inventory Cost
of Production Receipts-Backward Inventory Work In
Process Work in Process Inventory Work in
Process Labor Work in Process Burden Work in
Process WO Variance Cycle Count
Adjustment Inventory Inv Discrepancy
10
Purchasing Life Cycle
Purchasing
Record PO Return
Blanket Order
MRP
Receive Purchased Items
Maintain Purchase Order (5.7)
Requisition
Scheduled Order
11
Sales Order Life Cycle
Enter the Sales Order
Process the Sales Order
Process the Shipment and Invoice
12
Work Order Life Cycle
Create work order or approve MRP planned order
Issue work order components (optionally record
labor in SFC)
Modify work order bill and routing
Receive work order
Release and print work order
Perform work order accounting close
Check for work order components
Delete/archive obsolete work orders
optional
13
16.3.4 Work Order Cost Report
14
16.21 Work Order Accounting Close
wowocl.p
16.21 Work Order Accounting Close
Date 01/18/99 Page 1
MFG/PRO Training DB -
V90 Time
112754 Work Order ID Item Number
Site Qty Ordered Qty Completed Qty
Reject SO/Job Project Eff Date ----------------
-- -------- ------------------ --------
------------ ------------- ------------ --------
-------- -------- 1000 1000
03-0030 train 2.0
2.0 0.0 DESIGN 01/18/99
DISPLAY RACK
GL Reference Type Dr
Acct CC Description Cr Acct CC
Description
Amount -------------- --------------- --------
---- ------------------------ -------- ----
------------------------ ------------- WO990118000
001 WO-CLOSE 1600 WORK IN PROCESS
6500 5040 LABOR ABSORBED
10.00 WO990118000002 WO-CLOSE 1600
WORK IN PROCESS 6400 5040
BURDEN ABSORBED
20.00 WO990118000003 WO-CLOSE 1600
WORK IN PROCESS 6500 5040 LABOR
ABSORBED 10.00 WO990118000004
WO-CLOSE 1600 WORK IN PROCESS
6400 5040 BURDEN ABSORBED
20.00 WO990118000005 WO-CLOSE
1600 WORK IN
PROCESS -20.00 IC990118000002
WO-CLOSE
1600 WORK IN PROCESS
-9.20 IC990118000003 WO-CLOSE
1600 WORK IN
PROCESS -52.80 IC990118000004
WO-CLOSE
1600 WORK IN PROCESS
-2.30 IC990118000005 Method Change 6200
0500 METHOD CHANGE VARIANCE 1600 WORK
IN PROCESS 18.15 --- End of
Report ---
15
16.3.5 Work Order WIP Cost Report
16
Advanced Repetitive Variances
17
18.22.4.9 Repetitive Operations Accounting
Report
18
18.22.4.13 Wip Valuation Report
19
AR Period End Preparations
20
27.18 AR Aging as of Effective Date
AR-PR-140
21
27.3 DR/CR Memo Register
AR-PR-170
22
27.6.6 Payment Register
AR-PR-190
23
Accounts Payable Period End Preparations

• Supplier Invoices Processed
• Credit Vouchers Processed
• Bank Statements Reconciled
• AP Transactions Completed

AP-PR-080
24
AP GL Transactions
25
Purchasing Variances
26
28.11 Voucher/Std Cost Variance Report
AP-PR-110
27
25.13.14 Unposted Transaction Register
28
25.13.1 Standard Transaction Maintenance
29
Review Posted Transactions
30
GL Transaction Processing Flow Overview
31
GL Period End Processing
32
General Ledger Calendar
33
Reversing Entries
34
Recurring Journal Entry Transaction Copy
35
Consolidation Database Processing
36
Translation Exchange Rate Maintenance
37
Transaction Import
38
25.19.15 Transaction Import
39
Exchange Rate Maintenance
40
Imported Transaction Revaluation
41
Transaction Post
Post Transaction Types XX and XY
42
General Ledger Calendar Maintenance
43
GL Year End Close Processing
44
Transaction Year End Close
45
Tips to help Month End Processing

• General Ledger Control File -Do not allow
  changes to module transactions
• In Multiple Entity Database, set Balanced
  Entities to Yes
• In Account Code Maintenance consider using
  Sub-Module only entry
• Validate the Translation Index in Account Code
  Maintenance
• Ensure that the System Account Control File is
  set to verify GL Accounts
• Ensure that the default Chart of Accounts defined
  in System Account Control File is accurate
• Verify General Ledger Accounts/Sub-Account/Cost
  Center in Product Line

46
Tips Continued

• Utilize Inventory Account Maintenance, Work Order
  Account Maintenance, Sales Account Maintenance,
  Purchase Account Maintenance
• Establish Cut Off times for Processing
  transactions
• Post transactions during the month
• Balance General Ledger to Sub-Ledgers
  periodically during fiscal period