|
|
| I need to be able to display a tool tip when I hover over a RadGridView cell |
|
|
|
I just copied my live server to my test server. This article will teach you what steps you need to take to keep it working.
As an aside, I just looked at the Red-Gate 'clone db' product, $8k.
For the rest of you... we'll help. Read on.
|
|
|
|
Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive
Ha!
I come across this error twice a year, and the standard Bing searches don't work, it's all 'technical this' and 'server setup' that.
No.
The real answer is way simpler. See below |
|
|
|
I'm implementing a RadGrid control, bound to SQL Server table, and which will be used by up to 12 people at a time. What's the best way to handle concurrency (to be clear, I mean when one person makes a change while others are working or viewing the same records and fields)?
My client likes the idea of having changes submit to the database on a per cell basis. If a User changes a cell, it gets saved to the DB as soon as the User leaves edit mode of that cell.
If we go that route, what's a good way to deal with the others who may be VIEWING data that's no longer current? |
|
|
|
| All - what's the best practice method for sending out a Mass Email communication to all Great Plains vendors? No purchasing or Sales document is being sent. |
|
|
|
I've been developing a Proof of Concept Winforms application for a client, at their request. I've been using Telerik because that's what I have and am most familiar with . Just discovered the client uses DevExpress on other projects (with which I'm not involved) and I'm anticipating pushback when they discover I'm using Telerik.
Any suggestions on how I can convince them to stick with Telerik? Or would I be better off going with the flow and switching to DevExpress if that's what they request?
Of course, on the other hand, if DevExpress has serious advantages over Telerik in Winforms and GridView, let me know. In such a case, I'd actually advocate for DevExpress with my client.
My project is heavily dependent on GridView bound to SQL Server and will have about 12 users, often running concurrently.
Thanks for your insights. |
|
|
|
Hello,
I'm working on a data migration from GP to NetSuite. I have 16 companies to migrate data from and I created a table in each company db with an account mapping master table called "dbo.GL00105ToNetSuite". I'm trying to build a cursor to backup these tables into a separate database called Finlyte, because I have to restore over the original databases to pull a second set of data for migration. So here is what I have:
DECLARE @db VARCHAR(50) --- Database Interid
DECLARE @S_TABLE VARCHAR(50) --- Source table
DECLARE @D_TABLE VARCHAR (50) ---- Backup table
DECLARE db_curser CURSOR FOR
SELECT INTERID FROM DYNAMICS.dbo.SY01500
WHERE DYNAMICS.dbo.SY01500.CMPANYID BETWEEN 1 AND 17
OPEN db_curser
FETCH NEXT FROM db_curser into @db
WHILE @@FETCH_STATUS = 0
BEGIN
SET @S_TABLE = @db + '.dbo.GL00105ToNetSuite' -- appends the source company database onto the table name
SET @D_TABLE = 'FINLYTE.dbo.' + @db + '_GL00105TONetSuite' -- adds the source company database to the table name in the Finlyte database.
EXEC('SELECT * INTO ' + @D_TABLE + ' FROM ' + @S_TABLE) --executes the Select * into backup_db_table from source_db_table
FETCH NEXT FROM db_cursor INTO @db
END
CLOSE db_cursor
DEALLOCATE db_cursor
When I run it, it backs up the first database table correctly and then it crashes. Below are the error messages that I get. Help would be greatly appreciated.
Msg 16915, Level 16, State 1, Line 12
A cursor with the name 'db_curser' already exists.
Msg 16905, Level 16, State 1, Line 16
The cursor is already open.
(15127 rows affected)
Msg 16916, Level 16, State 1, Line 24
A cursor with the name 'db_cursor' does not exist.
Msg 16916, Level 16, State 1, Line 31
A cursor with the name 'db_cursor' does not exist.
Msg 16916, Level 16, State 1, Line 32
A cursor with the name 'db_cursor' does not exist.
|
|
|
|
Hi
Advanced SQL server option is where you decide password policies in GP. I want to know where in SQL server can I see the settings.
Auditors want to know GP Password settings in SQL server.
Thanks
Paul |
|
|
|
I am attempting to modify the analytical accounting posting journal that prints both from the edit list and after posting (purchasing module - GP2016 R2). I have tried many things to no avail - not a single edit will come through. I tested with simply moving/editing text. I am using the SA account to ensure the highest credentials.
I've tried editing several/all AA posting reports in the event the report that is actually printing is not the one I'm editing - even though I select 'Modify Report' from the report itself. Nonetheless, aaDistributionJournal-Sub-Ledger title matches both on the report and the one i'm attempting to edit so it would seem i have the right one.
Your help is much appreciated!
My AA Entry:
My report writer changes: I've misaligned 'Document Type' just as a test. My real intention is to simply add the AA Distribution Reference,
How report prints: Doc Type is not misaligned as I'd expect and no AA Dist Reference.
|
|
|
|
I have a query that brings back all of the Purchase Order Distributions and gives me all of the data I need -- except I cannot join POP30390 to the POP10110 or POP30110 through tables like POP30390, etc. I have the PONUMBER field but cannot find how I get the LineNumber for the PO. Shouldn't I be able to? Thanks much.
select rcpt_ln_hist.PONUMBER, rcpt_hist.POPRCTNM, rcpt_ln_hist.RCPTLNNM, rcpt_ln_hist.VNDITNUM
, pm_dist_hist.DEBITAMT, pm_dist_hist.CRDTAMNT
from POP30390 pm_dist_hist -- 87734
inner join GL00100 mstr
on pm_dist_hist.ACTINDX = mstr.ACTINDX
inner join POP30310 rcpt_ln_hist -- 46265
on pm_dist_hist.POPRCTNM = rcpt_ln_hist.POPRCTNM -- there is a small cartesian here
inner join POP30300 rcpt_hist
on rcpt_ln_hist.POPRCTNM = rcpt_hist.POPRCTNM
|
|
|
|
Good afternoon,
We've noticed that when an amount on a distribution line is changed, any AA info associated with this distribution gets deleted. Obviously, the amounts on the AA codes would need to be updated to reflect the new distribution amount, but they could at least persist. In our case, AA distributions can be extensive, so this ends up becoming quite the burden. Has anyone else encountered this issue and thought of a potential solution?
Thank you. |
|
|
|
Good morning,
The system show me a notification that i don't have privileges for Employee Card Attachment (see below red circle and notification). I try in the System/Security option all check mark at all levels but don't work, only work with Power User. There will be a specific check mark for attachment access I don't see that?
Any suggestion is welcome,
|
|
|
|
Good evening,
I changed the Category from Sales To Revenues (see below #1) in the Account Category Setup but when print the profit and Loss still show Sales instead that Revenues, see below image #2
See below Image #1
Image #2
Any suggestions is welcome.
GP2018 Version |
|
|
|
Trying to use eConnect to bring in Payroll Transactions. Appears this can only be done through the Manual Checks? Confused about several things. I don't want to import a check. I am wanting to import a batch of transactions that can then be combined with benefits/deductions etc and have a check created. It looks like this must have a check written at same time. Is that, correct? Integration Manager imports into Payroll Transaction Entry and you can finish out your batch there. What is the proper way to do this with eConnect or can you? |
|
|
|
I am trying to learn how to generate XML to send to eConnect to create an invoice. I've already got working code to insert/update customer records, just trying to figure out how to do invoices. I've found several example XML docs, but they all seem to use items and qtys, where as I just want to create one with an amount, sort of like the one pictured here:
It seems like there is a field called SALESAMT which could be what I'm looking for, but I can't find any examples of how to use it. Can anyone post a sample XML file? I'm not using VB or .NET, so please don't post any code examples, just XML would be the most useful.
Or am I looking for the wrong thing entirely? Based on the header of that screenshot, should I be searching for information on Receivables Trxns? |
|
|
|
Saludos: necesito crear un Excel similar al trial balance del menú reportes Financiero. la diferencia radica en que solo debo mostrar los saldos de las cuentas.
la estructura seria [numero de Cuenta], [Nombre de la Cuenta], [saldo Año corriente], [saldo año anterior] [variación]
Alguien podría ayudarme ya sea que tenga un query para ello o que me indique las tablas de donde obtener la información..
Saludos |
|