Posted by: istewart | September 18, 2013

Update to Clear Activity in Bank Management

Had a support query today from one of our clients in the UK. They were getting the error message where Bank Management figured a user was still accessing a batch of transactions. This was after a hard close [aka 'crash'!!]. Ran the clear Activity utility in Bank Management to no avail, and then queried the CBEU1020 table – but no records. Searching around I found the User ID and Batch ID in table CB10006. The CBEU1020 table tracks activity for Euro denominated transactions, so this is why the activity record was not in there…the batch was for a GBP denominated bank account.
Delete CB10006 where Dex_Row_ID = ‘the relevant record’…did the trick.

Related post here:

Posted by: istewart | September 9, 2013

Purchase Order Prepayments – Dynamics GP 2013

Another cool feature and one no doubt driven by customer requests. In GP 2013 you can enter prepayments against Purchase Orders. These can be manual payments – or can be picked up by automatic check/EFT runs. If using the Auto Checks/EFT process, the PO appears like any other Supplier invoice and the resultant payment references the PO Number as the Document number on the remittance. When it comes to entering the Invoice[s], until the PO is closed, the prepayment cannot be assigned to unrelated invoices which makes sense.

To set up POP Prepayments go to the Purchasing Setup Window. Down the bottom, there are new fields added where you can enable this feature, add a password if required and dictate the Prepayments GL account to be used.

When in use, on the Purchase Order window – you will see a Prepayments field at the bottom where you can record the prepayment. A red hash to the left of this field tells you the payment hasn’t been made yet – it will disappear when the payment is recorded. Additionally, the GL is updated once the payment is complete – not before, which again makes perfect sense.

One issue at the moment is that the maximum prepayment you can enter seems to be the total of the line amounts. I.e. footer amounts like Purchase Tax cannot be prepaid. I can only assume that this is an oversight? I will update this post when I know more.

Posted by: istewart | May 14, 2013

Business Portal for GP2013 – the skinny

RTM release now issued following the issue of GP2013 SP 1.

Its 64 Bit only and supported on Windows Server 2008 SP2 and 2oo8 R2 SP1 + Sharepoint Server and Foundation 2010.  (BP 6.1 will be supported on SharePoint 2013 when its released).

Not supported on Windows Server 2012 because Sharepoint is not currently supported – wait for Sharepoint SP2.

Upgrade paths direct to 6 from BP version 4 SP2. Moving from 4 and 5 will require upgrading SharePoint to 2010…first! If you’re dropping any Business Portal applications – uninstall them before upgrading. The sequence is:

….Upgrade to Sharepoint 2010, upgrade to GP 2013,  upgrade web services if in use, finally upgrade business portal.

Posted by: istewart | April 19, 2013

GP Manufacturing Order to Sales Order link

One of those days. Took me an age to find the relevant table. Eventually copped on to myself and reached out to a pal in the US who didn’t even have to look at Resource Descriptions to tell me. For those in the same boat – here’s the answer.

When you create a newDynamics GP Manufacturing Order based on a Sales Order the link information is stored in table IS010001 (ICONrol Sales Order Line). Remember that each sales item line on a sales order will create an individual manufacturing order to make that product. So this table also stores the sales order line item sequence number.

A quick query (where ???? is the manufacturing order number) would look something like:


Additionally table WO010032 (Manufacture Order Master) may contain the Sales Order number in the DSCRIPTN field – if users haven’t overwritten the Description field when the manufacturing order is created.

Hopefully save someone some time!

Web Client functionality for Dynamics GP Project Accounting module is planned for release with GP 2013 SP2. Just thought you should know!

Posted by: istewart | February 2, 2013

Dynamics GP Web Client

The GP web client. What functional areas are available now? Phase I concentrated on core Financials and Distribution.

General ledger, Accounts Receivable and Sales Order Processing, Accounts Payable and Purchase Order Processing, Inventory control. These modules were released as part of Phase I. Any changes you make using Modifier will render in the Web Client…but VBA code will not run. (Check out Rubal’s post about migrating VBA code). For Excel reports to run, you need to be connected to the domain.

Whats coming next and in what sequence? The latest news is:

  • Human Resources and Payroll, then
  • Field Service and Project Accounting, then
  • Manufacturing


Posted by: istewart | November 26, 2012

Sample XL Dashboards to download

The Dynamics GP team have provided Business Intelligence dashboard samples for download from their Blog. These are created in Microsoft Excel 2013 and show the real power of the XL refreshable reporting. The Financial Dashboard is free to download and use with your existing data, and the guys would welcome feed back.

Check out the free dashboards here.

Dynamics GP Financial Dashboard - Refreshable XL Report

Dynamics GP Financial Dashboard – Refreshable XL Report

Posted by: istewart | November 24, 2012

Year end – Receivables Management

When should you run the Receivables Management year end process in Dynamics GP? Right before you start entering transactions in Receivables Management for the next year! Why? because the RM Year End Close transfers the summary figures stored in ‘Current Year’ summary fields to the ‘Previous Year’ summary fields – to see this in action look at Cards >> Sales >> Summary. These summary figures get updated every time you add a transaction to RM (including anything that originates in SOP).

So – like anything else that is procedure driven – you need a plan. I suggest the following:

  1. Post everything in RM relating to the current year.
  2. Make a backup.
  3. Run the RM Year End close process.
  4. Close the Financial Periods for RM (Tools >> Setup >> Company >> Financial Periods).
  5. Close the Tax Year.
  6. Make a final back up.
  7. Get going on processing the next years transactions as per normal.

« Newer Posts - Older Posts »



Get every new post delivered to your Inbox.

Join 29 other followers