170 likes | 345 Views
MFG/PRO Navigation: What Every Financial Person Needs to Know. Come Discover What Every Financials Person Needs to Know About MFG/PRO Navigation. Agenda . GL Analysis Daily Activities Transaction History in 3.21 Menu Closing Activities Reporting Standards and Purchase Price Variance
E N D
MFG/PRO Navigation: What Every Financial Person Needs to Know Come Discover What Every Financials Person Needs to Know About MFG/PRO Navigation.
Agenda • GL Analysis • Daily Activities • Transaction History in 3.21 Menu • Closing Activities • Reporting • Standards and Purchase Price Variance Using eB Demo Database
Analysis • What is the GL Reference? Is it Significant? • Can I drill down on transactions from the General Ledger? • How do you view the Unposted GL Transactions? • 25.13.13 - Unposted Transaction Inquiry • 25.13.14 - Unposted Transaction Register
What is a GL Reference? • A GL reference code identifies a specific GL transaction (journal entry). • References begin with a two-character code that identifies the transaction type, followed by a 12-digit sequence. The sequence format for JL, RV, RA, FX, and YA transactions is determined by the value of Daily/Continuous Reference Sequence in the General Ledger Control File. IC 020325 000001
Can I Drill Down on Transactions? • You can drill down on Posted transactions using GL Reference:
Can I Drill Down on Transactions? • You can also Drill down on transactions by account String:
How do you view the Unposted GL Transactions? • 25.13.13 - Unposted Transaction Inquiry • 25.13.14 - Unposted Transaction Register
Daily Activities • General Ledger Posting – (25.13.7) • Do you post your general ledger daily? • Variance Review.
25.13.7 GL POST • Posts Unposted Transactions to: • View Results in the 25.15 menu for GL Reporting. • Utilize 25.13. • 17 Account Balance Inquiry • 18 Transaction by Account Inquiry • 19 Transaction by Reference Inquiry • 20 Inquiry by Account With Drill Down (Nice Feature) • Reconcile to Sub Modules (AR, AP, Inventory)
Why is the 3.21 menu so important to me? • Looks At Transaction History for the Database • 3.21.13 - Transactions by Order Report • Inventory Transactions by SO, PO, WO • 3.21.14 - Transactions by Item Report • 3.21.16 - Transactions Accounting Report
Closing Activities • Transaction Copy • Reversing Entries • Journal Entries • Cutoff of the Sub Modules • Analyze, Adjust and Report
Reporting • Should I Use Standard GL Financial Reports or GL Report Writer for My Business? • Standard Reporting Focuses on Consolidated Reporting. • GL Report Writer Focuses on Multi-entity Reporting
PPV vs. Standard Cost Adjustments • Purchase Price Variance (PPV) = Standard Cost Vs PO Purchase Price • What Does It Measure? • Accounts Payable Rate Variance (APR) = PO Purchase Price Vs Supplier Invoice Price • What Does It Measure? • Classical PPV = PPV + APR, or Standard Cost Vs Supplier Invoice