Tag: sterling-adventures

Using Derived Tables to Create SRS Reports for Dynamics GP

| 09/07/2011 | 0 Comments

People often want to create reports in SRS with data from multiple periods. For example, you may want a report with year-to-date (YTD) numbers in one column and month-to-date (MTD) numbers in another column. Or you might want budget data in one column and actuals in a second column.

Continue Reading

Scheduling, Scheduling, Scheduling Payments in Dynamics GP

Scheduled payments are not used extensively in Microsoft Dynamics GP , but they can be quite helpful if you need to record scheduled invoices to post over time. If you want to pay off an invoice in installments, in payables management, or if you have negotiated with a customer to allow them to pay a large bill over time, scheduled payments can be helpful.

Continue Reading

Simplifying Payroll Liability Payments

The process of running payroll creates numerous liabilities, paying a variety of vendors for garnishments, medical insurance premiums and taxes. And, as many folks have over the years, you may have developed a manual process to ensure these get paid: Giving the posting journals to payables, who rekey the information as an invoice Possibly having someone review the general ledger after posting to pull the liability amounts Making the payments yourself to ensure there is no mixup Wouldn’t it be nice if you could simply post your payroll and the vendor invoices would be created automatically for inclusion in the next check or electronic funds transfer (EFT) run? Payroll Integration to Payables (PIP) allows just that.

Continue Reading

Payroll Manual Check – Fields to Watch

Occasionally, you may have to re-enter a payroll check using the Manual Check window in Payroll. Transactions | Payroll | Manual Checks Payroll Manual Check Adjustment Entry Window This window can be used to enter three transaction types: Beginning Balances – Recorded as checks with a gross and net amounts, but do not post to the general ledger or bank reconciliation Manual Check – Recorded as checks with a gross and net amounts, do update general ledger and bank reconciliation Adjustment – The gross and net must be zero; this type is used to move amounts between codes

Continue Reading

Take Self-Service Reporting to New Heights with Report Builder 3

| 08/19/2011 | 0 Comments
Take Self-Service Reporting to New Heights with Report Builder 3

Date: August 18, 2011 SQL Server Reporting Services (SSRS) gives your users a powerful and flexible solution for creating and deploying reports.

Continue Reading

Creating Budgets That Span Multiple Periods

| 08/15/2011 | 0 Comments

Are you using budgets on your financial statements? Are you tired of going into FRx or Management Reporter every year and reselecting the new budget for each year? With the new functionality of Dynamics GP 2010 , you can create a budget that spans multiple periods.

Continue Reading