|
Stored Procedures - Using Sql to automatically
create the following:
Journal Entries - Ideal for Allocations
(Similar to Oracle's "Mass Allocation")
1. Calculations to allocate costs by profit center.
2. Create journals to post STATS from Info Center Tables.
3. Calculations for DSO, Backlog Burn Rates etc.
Mass Allocations: A journal entry formula
that allocates revenues or expenses across a
group of cost centers, profit centers, departments, divisions
or Companies (Orgs).
Use a Mass Allocation formula to automatically create journals, instead
of manually calculating in a spreadsheet and then keying in or importing the journal for posting. A single
formula can perform multiple allocations. These allocations are done via a SQL
Stored Procedure. These are system shortcuts that can simplify your life, automate closing
entries and take you out of spreadsheet calculations improving your monthly close time and reporting process.
There is no limit for uses of a SQL Stored Procedure, Allocations of Corporate Overhead, Professional Liability Insurance,
Fringe Benefit Costs, Rent, Other Expenses, WIP Adjustments and even Overtime Premium Costs not posted in timesheets just
to name a few.
Mass Allocations versus Recurring Journals
Accounts Payable Batch - Ideal
for Multi-Office 1. AP Imported from Spreadsheets. 2. AP Batch's Validated with Sql for duplicate invoices. 3. AP Validation for "lowest level" verification.
Accounts Payable ACH Payment Processing
1. ACH/Direct Deposits for Vendor Invoices & Expense Reports.
2. ACH/Direct Deposit Automated E-mails.
Cash Receipt Processing
1. Cash Receipt posting by Spreadsheet.
2. Electronically "linked" Spreadsheet to Data Base records.
Publication of Reports to "Intranet" WEB
1. Publishing to Intranet using Special Windows Applications.
Areas of Expertise in DELTEK VISION
AP 1099 Processing AP ACH to Vendors, AP Electronic Payments BILLING Billing
Refresh BILLING Billing Terms BILLING Invoice Templates BILLING Labor Categories BILLING Labor Codes BILLING Pre-Bills without Revenue Recognition BILLING Retainage BILLING Retainers CONFIGURATION Auto Accounting
Rules, Time Analysis CONFIGURATION Dashboard Setup CONFIGURATION Org Setup, Auto Accounting Rules, Time Analysis CONFIGURATION Time Analysis EMPLOYEE Direct Deposit for Employees EMPLOYEE Expense Categories GL Cash Basis
Accounting Mapping & Configuration (see my blog: http://www.deltekvisionconsultant.com/deltekvisionblog/2011/11/cash-basis-accounting-reporting/ ) GL GL Calendars, Standard or 4-4-5 GL GL Periods, 12 or 13 GL Tax Setup and Reporting HR Benefit
Accruals and Setup PAYROLL Job Cost Variance PAYROLL Payroll Cycle vs. Timesheet Calendars PAYROLL Withholding
Codes, Contribution Codes for automated Accruals. REPORTING Accounting REPORTING Balance Sheets REPORTING Employee REPORTING Income Statements REPORTING Project Reports REPORTING Report Configuration REPORTING Tax REV
GEN reports to support the Balance Sheet (see my blog: http://www.deltekvisionconsultant.com/deltekvisionblog/2011/12/revenue-recognition-generation-rev-gen/ ) REV GEN Revenue Methods as required for Project needs. SECURITY Roles, Security SECURITY Setup with
Security, Required, Hidden and Locked Fields TS Adjusted Salary Job Costing (see my blog: http://www.deltekvisionconsultant.com/deltekvisionblog/2011/11/adjusted-salary-job-costing/ ) TS Labor Cross Charge, Reports Configured to support the Income Statement. TS Timesheet Categories
with Automated Assignment by Employee Org
Month
End Close - Automated Journal Entries can be created from a calculation. Ideas
for use are: Calculations
for Allocations across departments. As an example, if you allocate Liability Insurance
by Department based on their share of Revenue, Corporate Overhead by Department based on Wages or Headcount, WIP Adjustment
by Department, or anything else a stored procedure can perform the calculation and Create the journal entry. You simply click “Post”. Look at all your closing entries, if there is a Spreadsheet involved followed by you creating a journal entry,
a Stored Procedure could do that with one click of your mouse. Former users of Oracle may recognize this as the General Ledger Mass Allocation process, however this
is NOT limited to Journal Entries. Another common need is Calculating and Posting the Overtime Premium if Overtime
Hours NOT entered in timesheets.
|
