Friday, March 28, 2014

Dynamics GP - PSTL Error: Invalid length parameter passed to the Right function

  • Error
    • Invalid Length parameter passed to the right function
  • Solution
    • This database has jLan and replication enabled against it
    • Uninstall jLan, Disable database replication in SQL


Monday, March 24, 2014

Zebra TLP2844 - Pauses between printing each label. Does not print continuously. Stops at each label.

Problem:
We were trying to print labels from dynamics NAV. We would enter a qty of 10, and click print within NAV. 
The printer would then print 1 label. 
Pause. 
Print 1 label. 
Pause. 
for all 10 labels.

Attempted Solutions:
In our attempts to figure out a solution, we discovered a few things
Sending ZPL commands to the printer using passthrough codes worked
Sending EPL commands proved to be a challenge, as the passthrough commands did not work for EPL.
We used a slightly different model, an LP 2844, and we did not experience the issue at all, so it seems like a specific problem with this model. 


Eventual Solution:
What we eventually ended up doing was coding the NAV window so that it would generate a barcode and send it to the report as an image to a blob object.
We also coded it to kick open the print window so the user could enter the number of labels required in the "copies" field for the printer itself.
As long as we put the number into the "copies" field, it printed with no pauses.
It looked like the way NAV was coded to print, it would loop and send each label as a single separate job, causing this specific printer to pause after each label.

It had nothing to do with image size, or print speed, or usb speed, or firmware.


Dynamics GP - Integration Manager - ERROR: Unknown Great Plains field subtype '10016'.

This occurs if the currently logged in user does not have access to the window required for integration.

This can also happen if the client loses connection to the server.

Solution:
Restart GP

Sunday, March 23, 2014

SSRS - Export a summarized version of report to excel without all details on another sheet


  • Copy the existing report tablix, and paste it into the report after the existing tablix.
  • You should have two identical tablixes on the same report.
  • Right click on the second one and set a page break before, and set the visibility to baseo n an expression.
  • enter this as the formula
  • [&RenderFormat.IsInteractive]
  • This will hide the second tablix as long as the report is interactive, meaning it will not show on screen but it will export to excel
  • The page break will cause it to export on a new sheet
  • On the second tablix, hide the details row, and it will only export the visible totals


Tuesday, March 18, 2014

Dynamics NAV - Send Raw ZPL to a barcode printer to print a barcode from a report


Under normal circumstances, you can just send a text file containing ZPL commands to a zebra barcode printer, and it will interpret the commands, and print the barcode.

However, NAV 's 2013 report format forces the commands to be displayed in a table, which prevents the printer from parsing the ZPL contained within the table, resulting in the printer printing the actual commands instead of interpreting them.

To get around this,
  • Right click on printer
  • Properties>Advanced>Miscellaneous>Enable Passthrough Mode
The default passthrough notation is ${ and }$
Any text placed within that notation will be parsed as ZPL commands.

You can now format your text strings in the report to begin and end with the passthrough notation, and the barcode printer will interpret them correctly.

Original Post

Wednesday, March 12, 2014

Dynamics GP - SeeHITB - sp to view the Historical Inventory Trial Balance

Use this script to generate the HITB
----------------------------------------------------------------------------
exec seeHITB @I_nSortBy=2,@I_nReceiptOptions=2,@I_sStartItemNumber=N'',@I_sEndItemNumber=N'þþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþ',@I_sStartAccountNumber=N'   -    -  ',@I_sEndAccountNumber=N'ÿÿÿ-ÿÿÿÿ-ÿÿ',@I_sStartLocationCode=N'',@I_sEndLocationCode=N'þþþþþþþþþþþ',@I_nStartQTYType=1,@I_nEndQTYType=5,@I_dtStart='1900-01-01 00:00:00',@I_dtEnd='2014-03-12 00:00:00',@sStartClass=N'',@sEndClass=N'þþþþþþþþþþþ',@sStartGenericDesc=N'',@sEndGenericDesc=N'þþþþþþþþþþþ',@I_fUseGLPostDate=0,@I_fIncludeZeroQtyItems=1,@O_SQL_Error_State=NULL
-----------------------------------------------------------------------

To build the output table schema from the stored procedure, use
------------------------------------------------------------------------
sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO


SELECT * INTO BI_Temp FROM OPENROWSET('SQLNCLI', 'Server=sql\gp;Database=TWO;Uid=sa;Pwd=mypassword','SET FMTONLY OFF;SET NOCOUNT ON;EXEC seeHITB')
--------------------------------------------------------------------------

To update the tabl ewith values from the stored procedure, use
------------------------------------------------------------------------
insert into BI_Temp
exec seeHITB


The output includes all transactions up to the "to" date.
You have to use the sum of all the transactions before the "from" date to get an opening stock balance

Dynamics GP - This Transaction Contains Multicurrency Errors

Under the posting setups, tick "Include Multicurrency Info" to get better error reporting for multicurrency errors.

Solution Here
http://support.microsoft.com/kb/852031

Tuesday, March 11, 2014

Dynamics NAV - Update a form field based on another field


//DAV
IF "Transfer-from Code" = 'CSU' THEN
Store.GET('WH')
ELSE BEGIN
Store.GET("Transfer-from Code")         ;
END;

IF "Shortcut Dimension 1 Code" = '' THEN
"Shortcut Dimension 1 Code" := Store."Global Dimension 1 Code";
end;
CurrForm.UPDATE
//DAV

Monday, March 10, 2014

Dynamics GP - You are not allowed to have negative Actual Quantity - Project Accounting, Timesheets, eConnect, Smartconnect

Cause:
When you integrate or enter a timesheet into GP, and then delete it, the PAUNPOSTEDQTY and PAUNPOSTACCRREVN go into negative.
When you attempt to integrate the transactions gaain, you get the error about negative actual quantity.

To resolve this error, you must set the PAUNPOSTEDQTY and PAUNPOSTACCRREVN to 0 wherever they are < 0

Solution:
I have set the following script to run prior to my timesheet integratoins to ensure timesheets will always integrate

---------------------------------------------------------------------------------------------
update  pa01301 set
PAUnpostAccrRevN=0
,PAUnpostedQty=0
where patu=1 and PAUnpostedQty < 0 and paprojnumber='myproject '
-------------------------------------------------------------------------------------------------

Original Post that pointed us in the right direction
http://www.brianwilliams.pro/great-plains-you-are-not-allowed-to-have-negative-actual-quantity/

Friday, March 7, 2014

Dynamics GP - Upgrade Paths

Each service packed version of 2010 requires a specific service packed version of 2013 to upgrade to
Check the list here
https://mbs.microsoft.com/customersource/northamerica/GP/support/hot-topics/HOT_TOPIC_MDGP2013Upgrade

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/04/23/microsoft-dynamics-gp-2013-upgrade-paths-_2d00_-gp_2c00_-windows_2c00_-sql-server.aspx



  • Current State:
    • Dynamics GP 10/SQL 2005/Windows 2003
  • Upgrade Path
    • On Current Server: Upgrade GP 10 to Final SP (YE2012 10.0.1868) 
      • MicrosoftDynamicsGP-KB2769063-v10-ENU.exe
    • On Windows Server 2016 destination: Install SQL 2012
      • Install GP 2013R2
      • Import Databases
      • Upgrade GP 10 (10.0.1868) to GP 2013 R2 12.00.1745
      • Change Database Version
    • On Windows Server 2016 destination: Install SQL 2016
      • Install GP 2016R2
      • Upgrade GP 2013 R2 12.00.1745 to GP 2016 R2 16.00.0552
      • Change Database Version
  • Additional Notes
    • For any upgrade path, upgrade to the above versions to jump to the next step
    • If you are unable to install SQL 2012, you can also use SQL2008R2, but this will only be allowed from Windows Server 2003 SP2 up to Windows Server 2012

Wednesday, March 5, 2014

Dynamics GP - You can't choose this document because it is part of a recovered batch or is still in the process of posting.

I came across this error when a user had entered a credit card payment for a vendor as a manual payment, and for some reason the process did not complete properly.

The end result was a payment on the vendor that could not be pulled up in the list to be applied, but would be displayed in the vendor document inquiry.

The transaction existed in the PM10400, PM10100 table and the PM00400 table only, and was not available in the other tables for application.

The record was deleted from these 3 tables and re-entered.