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,
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
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 Terms
BILLING Invoice Templates
BILLING Labor Categories
BILLING Labor Codes
BILLING Pre-Bills without Revenue Recognition
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
Accruals and Setup
PAYROLL Job Cost Variance
PAYROLL Payroll Cycle vs. Timesheet Calendars
Codes, Contribution Codes for automated Accruals.
REPORTING Balance Sheets
REPORTING Income Statements
REPORTING Project Reports
REPORTING Report Configuration
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
End Close - Automated Journal Entries can be created from a calculation. Ideas
for use are:
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.