Recent content by RobertC22

Even if this doesn't give you the answer you seek, hopefully it might give you the techniques you can use select StartDate , EndDate , mm , sum ( case when daccepted < StartDate and ( dcleared >= StartDate or dcleared = '1900-01-01') then 1 else 0 end ) as Brought_forward , sum ( case when...

Does this give you what you desire? select ServerName ,db as DatabaseName, max ( (select description from applicationinformation a1 where a1.dbname = dbs.db and a1.Application='MS_Application') ) as Application, max ( (select description from applicationinformation a1 where a1.dbname = dbs.db...

You would need to enter into the description on each individual document that you have created for the reversal. If you are not entering these reversal documents within DynamicsGP, then I cannot offer a way forward that would allow a mechanism to match the pair of debit and credit documents...

To achieve this reliably you would need to put some indication on the reversing document that it is such a document. You might use the Description field with 'REVERSAL XXXXXX' where XXXXX is the document ID that you are reversing. Just using the Apply details available would not be reliable. A...

NJNorma, You do not say what version of GP you are using. For Wennsoft, there are four possible modules - Service, Job Cost, Equipment and Timesheet which can each have their own user profile/ security. To check which module you are licensed, use the About Wennsoft window accessible from the...

I will assume you have at least two sources defined. When you preview the source data for the details, does this show the records you expect? I have found that it is better to have the common (linking) field between the header source and the detail source to be sorted. ------ Robert

To identify what Tasks have the "Accounts" smartlist object, use the following script in SQL Management Studio. use DYNAMICS select * from SY10700 where DICTID = 1493 and SECURITYID = 1 and SECRESTYPE = 1000 From that use the SECURITYTASKID to amend the tasks. I do not know what the...

Yes, you will need to split the CMMTTEXT into four parts. DynamicsGP will not do so, unless the user at some point makes a change to the comment from within the application. Even though it sounds like you have your own report outside of DynamicsGP, I would suggest that the CMMTTEXT be split for...

The SOP Documents have two varieties of comments - an overall comment field that applies to the document and a comment field that applies to each line on the SOP document. For the former, this is stored in the SOP10106 table for the latter, this is stored in the SOP10202 table. the CMMTTEXT...

You do not mention whether the existing companies reside in the same or separate databases within DynamicsGP. If currently in separate databases, it would be just a matter of creating a new company database for the Holding Company and adding that company into your FRX Reporter tree. If these...

Given that you say that the triggers are only recognising the 'developer' id as the user making the change, leads me to the question. The third party form been used to enter the Contract Details ; Is this a Dexterity form, or a VB/VBA Form? If the latter, then the data is likely to be sent to...

As a workaround - move all the unposted invoices that have been printed to a different Batched. That is, open each SOP invoice, amend the Batch number and save. Once you have done this for all the printed invoices, you will at least be able to delete the origianl batch ( having only un printed...

For the server on which you have installed the named instance of SQL Server, ensure the SQL Browser service is running. This is necessary to allow a client request to be pointed to the correct port that the named instance is using. If this service is not running, the ODBC connection will...

Here is a query that will show the Account Group ID that the asset may have originally been based on. It will only show an Account Group ID if the combination of account numbers is unique to an Account Group ID. That is, you cannot have more than one Account Group Id with the exact same set of...

Does this occur for any UserID you try at the 'problem' workstation? If so, delete and re build the ODBC DSN that is used. Ensure it uses the same SERVER name as other workstations DSN entry. ------ Robert