Search results for query: *

I am currently trying to send data to a barcode printer to print labels using DPL (Datamax Programming Language). I had the printer setup to one of the comm ports and my code sending the data out the comm port to the printer using the MSCOMM control. But now I have the printer setup to a print...

I am currentley trying to upgrade my version of crystal reports 8 to version 11 and am running into a few problems. When I am trying to reference crystal reports 11 in the VB code on a client machine without crystal reports, it gives me the error "ActiveX component can't create object". I have...

When in the sales serial number entry form, when assigning serial numbers to a sales order the following error occurs: A save operation on table 'IC_SOP_Serial_Lot_WORK_HIST' has created a duplicate key. [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint...

I am currently using VBA with great plains. I have VBA and VB 6.0 installed on my local machine. In VBA I have created program that prints barcodes and uses the MSCOMM addin feature to send code through the comm port. When I export this code as a package and try to install this on other...

I currently have business portal 2.0 installed onto a test server. What I would like to do now is setup users and roles to have other employees test out the functionality of business portal. Is there a generic role that is in BP or a role that I could create that would give the basic overview...

I'm trying to install Microsoft Business Portal 2.0 for GP v7.5. When I get half way through the install process, I receive the following error "Setup was unable to modify the web.config at C:/inetpub/wwwroot." Does anyone have any idea how to fix this or get rid of this error message. I'm...

I was wondering if someone could tell me what table the posted financial batches are stored in. In GP when you go to Transactions > Financial > Batches and select a batch to post, the batch is stored in the SY00500 table. After the posting goes through, the batch is moved to another table...

I currently am trying to modify the 'Select Purchase Order Items' (POP_Select_PO_Items) screen in GP with the form modifier. The problem that I am having is that I need the global field 'Item Number' placed on this form (A pink rectangle box below the bottom of the form). When I find the 'Item...

Just curious if anyone else had this issue or not, or may be able to provide a solution for me. One day I was using GP and coding some stuff in VBA. I saved my work, logged off my PC and went home. I came in the next morning, and now I am unable to open VBA, customization maintenance, or any...

Does anyone know why when you create a purchase order in GP (from PO Entry form), and you have multiple line items to order and you have a qty cancelled, it includes those qty's in the price. For example I have a purchase order that I am looking at and 500 pieces were ordered, and 500...

This is a pretty basic question, but I'm not sure how to get this to work properly. Basically I have an initialize button that when pressed will either give a true or false. When true, there is a textbox that displays the text "Ready" and if false the textbox displays "Not Ready". What I...

I'm currently using VBA (or possibly VB6) and an Intermec 3240 with Printset v2.2. What I would like to do is create a form in VB that when print is pressed, a barcode is created and printed out. Ex: ||||||||||||||| (barcode) 123456 (text) A very simple barcode that just has the...

Hello, currently I am working with an Intermec 3240 barcode printer. Whenever I try to print to this printer from either code or from the Printset software, the Alert light keeps on flashing. I know that this light means that an overheat condition has occured. However if I let the printer sit...

I have a form created that allows users to pull data up into a Janus gridex through the use of a query. I also allow the users to export the data from the query to a crystal report. My problem is as follows: there is an extra column that I have added in that appears after the query is run...

I'm currently working on implimenting Business Portal with our Great Plains setup. What I was wondering was if anyone has any feedback on it. There's a few questions that I have about it too: 1) Is a user using only business portal able to view Great Plains smartlists? 2) Can the same user...

I currently have a form that contains 3 text boxes and a Janus GridEx. When the 3 text boxes are filled with information, a run button is pressed and calls a stored procedure that will populate the grid. There are 7 columns in the grid. Only one of the columns is editable and left blank so...

Is there a way to remove the default smartlists in Great Plains? There are a few smartlists in GP that I would like to remove, however I cannot seem to find a way to do it. I've went into the advanced security > smartlist, however it doesn't seem to list all of the smartlists that appear in...

I am currently trying to pull data from a SQL table and the data that is stored in the table is listed as such: SOPNUMBE SOPTYPE Tracking Number ------------------------------------------------ ORDSTD000100 2 12345 ORDSTD000100 2 12346...

I currentley have a custom form created with VBA, that when 3 values are entered into textbox's on the form and "run" is pressed, the data populates a Janus GridEx grid. This is all fine and well, the grid is populated by a stored procedure. However in the grid, there is another column that...

I current have a SQL Query that I have written that contains variables (DECLARE @DATE003 datetime, etc.) When I try to place this query in the smartlist builder SQL Script, I get the error "Incorrect syntax near the keyword 'DECLARE'" ODBC error 37000. Any idea why this error displays? With...