From the Microsoft Dynamics GP Blogs: A save operation; Advanced lookups; Recurring batches; Canadian payroll tax update

In this review of the Microsoft Dynamics GP blogs:

• A save operation on table 'XXXX' (45)
• How to use advanced lookups to find information faster
• Automate monthly entries with recurring batches
• Canadian payroll tax update

A save operation on table 'XXXX' (45)

Writing on his blog, David Musgrave stated that a customer recently ran into an issue on their system, and today another customer reported a similar problem. As such, Musgrave thought it would be helpful to write about it on the blog in case others experience the same issue.

He noted that the problem involves an error that appears when trying to save data in Microsoft Dynamics GP, which triggers a dialog box.

Musgrave wrote that the table name may be different in each case, but it's important for fixing the problem. He stated that you'll need to find the table's SQL name using the technical table name shown in the error message. He then explained that you can use the resource Information window in GP Power Tools, set to tables and fields mode, to find the table and its SQL name. You can also use the built-in resource descriptions using the tables lookup to find the SQL table name.

How to use Dynamics GP advanced lookups to find information faster

An author writing on the CAL Business Solutions blog asked if you've ever been in this situation: you're entering a transaction in Dynamics GP and click the lookup button to find a customer, vendor, or item. The list opens, but it's sorted in a way that doesn't help you. The columns you need aren't displayed, so you end up scrolling through the list or typing part of a name to find what you're looking for. You eventually find it, but it takes much longer than it should.

The author stated that advanced lookups in Dynamics GP are designed to make finding information easier. They let you choose which columns appear in lookup windows and how the data is sorted, so the information you need is easier to find. 

In the blog post, the author explained what advanced lookups are and how to set them up.

Automate monthly entries with GP recurring batches

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access

or login