Tag Archives: Reports

SmartList Wildcards

The Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.

Then, a couple of days ago, Tim Cruickshank, on the Rose Business Solutions blog, posted a few tips and tricks he’d picked up at Convergence, one of which was SmartList Wildcards.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , | 1 Comment

Problem With SOP Word Templates

I’ve recently been working on a Microsoft Dynamics GP 2010 implementation project for a client.

We created custom Word templates (Reports >> Template Maintenance) for POP Purchase Order Blank Form, SOP Blank Quote Form, SOP Blank Order Form and SOP Blank Invoice Form without problems and granted access to the relevant companies.

To test the new Word templates we printed the documents to screen so we could quickly see the result. The POP Purchase Order Blank Form worked fine but when it came to the SOP documents we had a problem. When printing any of the SOP documents as Word Templates, instead GP printed the Standard Report Writer reports. Continue reading

Posted in Dynamics, GP, Microsoft, Report Writer | Tagged , , , , , , , , | 5 Comments

Changing Open-Year In Financial Statement Reports

If you’re using the Financial Statements (Reports >> Financial >> Financial Statements) in Microsoft Dynamics GP you may see a messagesililar to the following after doing a year end;

Cash Flows Screen Output: The year you

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , | 3 Comments

Feature Explained: Reporting Ledgers

In Microsoft Dynamics GP 2010, Microsoft introduced the Reporting Ledger functionality which allows journals to be posted to one of three reporting ledgers; base, local, or International Financial Reporting Standards (IFRS).

This functionality is controlled via the General Ledger Setup window (Microsoft Dynamics GP menu >> Tools >> Setup >> Financial >> General Ledger);

Reporting Ledgers: Enabling via General Ledger Setup

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 1 Comment

Aged Debtors Report Problem

Microsoft Dynamics GPI was on site today to do a sales demo of a couple of new modules to an existing client. At the end of the demo, the new Head of Finance had a word with me about the Aged Debtors report which was not working correctly.

He showed me a copy of the report and all invoices, regardless of the transaction date, were showing in the Current Period. My first thought was that the Aging process (Microsoft Dynamics GP menu >> Tools >> Routine >> Sales >> Aging) had not been run; a hurried think for other options drew a blank. Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , | 2 Comments