LOADING STORED PROCEDURES - Create_Requester_Procs_cursor

Technorati Tags: gp 2013,upgrade,cursor error

Recently I did an upgrade from GP2010 to GP 2013 R2 (build 1745) and ran into a variety of problems.

I thought I’d share them here, in the event someone else is faced with the same issues.

Some background on the upgrade, we switched about everything you could:

 

1. Switched SQL Server physical machines.
2. Moved from a physical machine to a virtual server.
3. The names of the servers, and the SQL server changed.
4. Moved from Server 2008 to Server 2012.
5. Moved from SQL 2008 R2 to SQL 2014.
6. Moved from GP 2010 to GP 2013.
7. Moved an eConnect web commerce application.
8. Moved AVALARA’s web service.
9. Several 3rd party products were involved.

After several attempts to do things that did not solve the problem, the following DID solve the problem. My thanks goes out to fellow MVP Richard Wheeler who gave me the tip to shrink the transaction log.

1. Restore the databases to the new server
2. Execute the Upgrade scripts suggested by Microsoft
1. Account_Framework_Validation.sql
2. Check_Workflow_Status.sql
3. eConnect_Out_Setup.sql (this is really not necessary)
4. Invalid_Records_POTables.sql
5. Payroll_Work_Tables.sql
3. Truncate the eConnect_Out_Setup table
4. Shrink the transaction log of the target databases:
1. DBCC SHRINKFILE ('DB_Log.ldf', 1), etc;
5. Install Dynamics 2013 on the new Server
6. Update the tables using DynUtils
7. Import the eConnect_Out_Setup table records that were previously removed in step 3.

You most likely do not have to complete all of the above steps. But it worked for me, so I stopped.

I had done several upgrades before this one and never had a problem. I guess I just got lucky this time .

Until next time,

Leslie

Modified SOP Entry window

The SOP Entry window pictured above has been modified to bring the Description up to the first line. This made the window quite wide, but my goal was to get as much of the description visible as possible. The expanded view looks almost the same as the original, except I added the Item Code field as can be seen below:

If you would like a copy of this modified window for yourself, you can download the package file containing this window here: https://app.box.com/s/z2sujz9pu62jbybhxb4b

This is a GP2013 R2 window.

I welcome any suggestions you all may have to spiffy this up.

Until next post,

Leslie

Technorati Tags: Modifier,Modified Window,SOP Entry Window

Record the Bar Code in the Item Code field in Inventory

 

We’re all looking for fields we can use for something else without bringing the system down. Inventory is a popular area where we never seem to have enough fields. How many times have you looked through that Item Maintenance window looking for a field you can ‘re-purpose’. I always use the Item Code field. It’s a 15 character string field, but it’s not visible on the window. It’s been in the table for eons, but the powers that be never exposed it on the window. Well, we all have Modifier now, so that’s a quick and easy way to reveal the field .

Here’s my window - I’ve got Item Code in a field above Item Class, but you can put it anywhere you like.

That’s my tip for today!

Until next time,

Leslie

Technorati Tags: Inventory,Modifier,Bar Code

Modified RM Aged Trial Balance–Summary

The RM summary aged trial balance is too busy. Too many lines per customer. If you just want one line per customer, this is the report for you.

The modified AGED TRIAL BALANCE WITH OPTIONS – SUMMARY:

The original AGED TRIAL BALANCE WITH OPTIONS – SUMMARY:

I know it’s hard (perhaps impossible) to read the images, but you can clearly see how much cleaner the modified report looks.

You can download the modified version of this report here:
Modified RM Summary ATB-1 line per customer

Until next post

Leslie

Modified Payables Transaction Entry Distribution

I modified the Payables Transaction Entry Distribution window so the Account Number appears on the first line of the scrolling window. I also added the Currency ID field to the second line of the scrolling window because the second line looked pretty desolate and  needed something else. There were no other fields in the distribution table (PM10100) that looked interesting.

This modification was done on GP 2013 R2. You can download a package file for this modified form here: Modified Payables Transaction Entry Distribution

Enjoy!

Leslie