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

Dynamics GP - AR Invoice shows as HIST* but is not voided, and has no applications against it

This transaction has been voided. Confirm all parts have been voided correctly.

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

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

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

http://stackoverflow.com/questions/4442122/send-raw-zpl-to-zebra-printer-via-usb

Dynamics GP - Cost of Goods Sold Distribution Amount Incorrect

http://support.microsoft.com/kb/871854