Accounting Applications

Dec 11, 2001

Hi to all..
Does anyone know about some useful resources of programming Accounting and General Ledger applications..SQL scripts,books..etc.
Thanks to all..

View 7 Replies


ADVERTISEMENT

Accounting

Sep 27, 1999

Is there a way, in SQL Server 6.5, to collect information about number of transactions,
CPU and memory usage, number of users connected etc. in a certain period?

TIA

View 2 Replies View Related

BCM With Accounting 2007

Feb 1, 2007

I have bcm with outlook 2007 and accounting express. when i create an opportunity in bcm, everything is fine. when i click the convert to quote button, it dumps all of the item information (quantity, name, description, price, tax....) into the description field in accounting. Then I have to copy each piece out of the description field into it's appropriate field in accounting 2007 express. Where is the mapping for these fields, so that I can map each one correctly? Is there something else i should be doing?

View 1 Replies View Related

Accounting Format

Nov 18, 2007

Hello,
One of our requirements is to use accounting format for money. Samples can be found in Excel, just select "Accounting" from predefined format strings. With this format "$" is aligned to the left of the cell and amount itself to the right side.
Unfortunately, I was not able to find "normal" solutions for this.
Not "normal" solutions that I can imagine now.
1) Format string with hardcoded spaces. Actually this will not work with Excel export;
2) Add fake column before cell and add "$" here. Same issue, this will work with Excel export.
Is there any way to do this without hacks?

View 1 Replies View Related

MSSQL Server Accounting

Jul 20, 2005

Hello,How can I see which login make more traffic to MSSQL ? Not by IP andexternal firewall , but with binding to database login

View 2 Replies View Related

MS Office Accounting Trouble Due To SQL Server

Mar 18, 2007

Help!

I've been using MS Office Accounting 2007 (free version) and today the application says that the database cannot be connected to. Basically, the SQL service will not start or run. Could it be due to Symatec's firewall? Please help.

Thanks,

View 3 Replies View Related

MS Accounting Exp 2007 Coexisting With SQL Server 2005

Jan 23, 2007

I recently installed MS Accounting Express 2007 which also installed an instance of SQL Server 2005 but without the standard interface. But I want to install SQL Server Express 2005 as well. Can the two coexist? Is there a way to have both applications running on the same machine? I am asking before trying the standard SQL Express install. Thanks, Jim.



View 1 Replies View Related

Summing A Column, Using A Pivot Table, Accounting For NULL

Sep 13, 2006

hello, i'm using sql200 and i am attempting to create a table that has an hourly-incrementing 'Date_Time' column, with a corresponding 'Total' column (which keeps a running total of values off of another table) . The code I am using right now is...

declare @date as smalldatetime

set @date = dateadd(yy, -1, cast(convert(char(11), current_timestamp, 101) + '00:00:00' as smalldatetime))



select dateadd(hh, i, @date) as Date_Time, sum(Subtotal) as Total

into #POGtable

from Pivot, OrderGroup

where

i between 0 and 24 and

CreationDate between @date and dateadd(hh, i, @date)

group by i





select dateadd(hh, i, @date) as Date_Time, 0 as Total

into #Ptable

from Pivot

where i between 0 and 24

group by i



select *

from #POGtable

union

select * from #Ptable p

where not exists(

select * from #POGtable pog

where p.Date_Time >= pog.Date_Time)



the solution is ugly, but the problem i'm having is that values for 'SubTotal' don't usually appear before 8 or 9 am. what you see above is me getting all the times (hours) that a subtotal present, creating another table with every possible hour in it (and with a 'Total' column as just zero), and then combining the two tables to create one flowing table over a 24-hour period.



there has GOT to be a better way to do this; the main point being that i want the sum( ) function to start adding up values immediately so i don't have to union two tables

View 3 Replies View Related

Cannot Open Company File In Office Accounting - SQL Server Problem?

Jan 10, 2008

Hi guys,

I recently installed Office Accounting 2007 Professional on a Windows Server 2003 machine with SQL Server 2005 (installed on an existing instance) and updated Office Accounting with service pack 1. However, after I have created the company file, other users were unable to open it. The error message was "The company could not be opened. Please ensure the SQL Server exists, the service is running and access has been granted."

Below are some of the stuff I had done, but still cannot solve the problem:

- Under "Manage users and roles", I granted full control to all users in the AD.
- Made the company.sbc as well as the multiuser.sbc file available to everyone on the server's shared drive.
- Granted full control to all users in the AD for the above mentioned shared drive.
- Copied the company.sbc and multiuser.sbc files onto all client computers.
- Ensured that SQL Server is running.
- Checked the security options for the linked database to ensure all users have the necessary rights.
- Enabled TCP/IP and named pipes as well as the port 5356 and have restarted the services.
- Added port 5356 as an exception in Windows firewall on all client computers.
- I even switched off Windows Firewall on the server just to eliminate this possibility!
- Tried everything listed in http://support.microsoft.com/kb/910012

I still get that error message on all client computers!!! What else have I left out? God bless me...

View 5 Replies View Related

Generate Single Record That Shows Status Of Accounting Period For Multiple Groups?

Mar 26, 2015

I'm trying to generate a single record that shows the status of an accounting period for multiple groups. For a single accounting period they could all be the same, or all be different (open, closed, hold, etc)

What I want to do is select the accounting period with a group by that says if all the groups are in the same status, then that's the status. But if there are different status' for the period, I just want to have a single line that says 'Mixed' The query below returns 3 records, but I only want 2. I tried a CASE WHEN Having COUNT > 1 but it blew up with an aggregate subquery in a group by error.

DECLARE @AccountingPeriod Table
(AccountingPeriod varchar(10), Status char(1), GroupNum int)
Insert into @AccountingPeriod
Values('2015-03','O',1),
('2015-03','O',2),
('2015-03','O',3),
('2015-02','O',1),
('2015-02','O',2),
('2015-02','C',3)
Select AccountingPeriod, Status from @AccountingPeriod
GROUP BY AccountingPeriod, Status

View 3 Replies View Related

Install Fails On SQL Express (part Of Setup For Accounting Express 2007)

Apr 4, 2007

I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.

BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:





Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Apr 03 19:36:54 2007

(LAPTOP NAME HERE) : Unknown article Result.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time : Tue Apr 03 19:36:56 2007



(As you can see, there is nothing in the file)





Any ideas what could be wrong?



Thanks





Pedro






View 6 Replies View Related

Install Fails On SQL Express (part Of Setup For Accounting Express 2007)

Mar 4, 2007

Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Sun Mar 04 15:25:13 2007

Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error Number : 29513
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time : Sun Mar 04 15:27:03 2007


List of log files:
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core(Patched).log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Datastore.xml
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_.NET Framework 2.0.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Support.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SCC.log

View 8 Replies View Related

Synchronization Of Business Contacts In Outlook With Small Business Accounting

Jun 10, 2006

Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?

I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.

Has anyone tried this?

Can someone walk me through the process?

Thanks

Debbie

View 1 Replies View Related

How Can I Connect To .MDF Through 2 Applications?

Dec 2, 2006

Here is the big problem:

I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database.
I built another application using windows service, and this application also connects to ASPNET.MDF database.
problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed.
I am going on circles about this, and just don't know what to do.
Please please please. love me do.
 
 

View 1 Replies View Related

MSDE For Web Applications

Dec 10, 2003

Hi, I am needing help on which MSDE version support 25 concurrent users. Can anyone help?

Creating an intranet that I would like to run on msde. My problem is that it wont allow more than one person to access the intranet at a time.

MSDE is running on windows 2000 with IIS.

View 1 Replies View Related

SQL Express Db With Both Win / Web Applications

May 17, 2006

I have a SQLexpress db that i would like to be able to access from both a windows app and web app (both running on the same machine) at the same time.  Is this possible. I've been able to connect either one or the other, but not both at the same time.
Thanks   

View 1 Replies View Related

2 Web Applications To Same Sql Server

Nov 2, 2000

If there are 2 different web application connecting to a sql server database through ODBC connection, both of them have full privilege to update , create , add column etc. Would there any issues of SQL server impacts when actually on live.

View 2 Replies View Related

Find Out Applications

Aug 3, 2007

how do i find out what application is using certain DB?.


=============================
http://www.sqlserverstudy.com

View 3 Replies View Related

Web Applications And SQL Server

Jan 11, 2008

Hi all,

Can anyone tell about impact of SQL server in web applications


Thanks in advance

View 2 Replies View Related

Deployment Of Applications

May 23, 2007

Hi,



I have developed several PPC apps in VS2003, which i have deployed to other PPCs using sqlce.wce4.armv4.CAB for the database runtime.



Now I developed a new app. version in Visual Studio 2005, using the free SQL server express database that came with it.



I can create a .cab file for the app using a setup project, but it eludes me what to install on the PPC of the customer, database wise.



Is there some kind of installable runtime for sql server express ?

(Or what is it called today ?)



thx in advance,

Paul.

View 1 Replies View Related

Why Can't Applications See My SQL Server?

Jul 6, 2006

I am running SQL Server 2005 Dev x86 with SSRS SP1 on Windows2003 Svr SP1.

My SQL Server is running and SSRS is working. When I come to run certain installs though, my Server name is not present in the dropdowns or in the browse for installed server lists.

I entered the name of my SQL server manually, but when I ran the application, it gave me an error: 00250 unable to run dtabase locator service.

Any ideas?

View 2 Replies View Related

Restoring Db From Web Applications..

May 17, 2007



i am a computer sciences engineering student and and we have an assignment to create a web project with a database.



Our lecturers will store our submissions on a db server but they want our projects enable the restoring our own databases..



that is, they wanna be able to have a copy of our databases to a new db that they have just created.. and they want us to enable this feature in an install.aspx page in our project.. the new db is guaranteed that will have the same name as ours..

so now what i am supposed to include in install.aspx?

View 6 Replies View Related

Sql Transactions Tiers Applications

Aug 3, 2006

Hi All.. I have an 3 tier web applications and I want to use sql transactions but not in each class.
Example :
I have 3 clases who need to update each table in one transaction how I do use sql transactions. I try to do in this way but not work:
sub cmdupdate_click   dim a as new class1   dim b as new class2   dim c as new class3   dim cn as new sqlconnection......   cn.open   .....transactions.... scripts   a.cn =cn ...I pass the same connection via property to each class   a.update   b.cn=cn....   b.update   c.cn=cn.....   c.update
   Transaction...scripts to commit   cn.closeend sub
maybe that logic is incorrect.  I dont now is my explain is clear.
 
 
 
 

View 3 Replies View Related

Unique Database For Various Applications?

Oct 18, 2007

There is a possibility of a unique database for various applications. Example users of a table that has the name, email, registro.Uma application included in a user table and other application also included in this table.

View 2 Replies View Related

Do We Need Extra Server To Run Web Applications?

Feb 5, 2002

Our company wants to run web based application
in folowing way.

Browser --> WebServer -->Sql Server

Sql server is part part of corporation domain and has about 25 more databases

Should we dedicate extra SQL server to run Web apps , or it would be safe to run web apps on corporation Sql Server?
or
If any one can point on links on this subject?.
Thank you

View 1 Replies View Related

Correct Way To Move Applications

Dec 10, 2007

What is the correct way to move applications from one server (2000) to another server(SQL 2005). I have to move all the databases as well as applications from one server to another.Here is my procedure:
1) Backup all 65 databases in first server(600GB total)
2)copy all the backup files from one server to another(destination)
3)Make all database(single user)and take transaction Log backup
4) Restore all database to destination server in norecovery mode and restore all transaction log in Recovery mode)
5)stop server 1 and point the application to another server

So how much downtime i have to face since it is 24/7 production server. and
Can you please give the correct details so i can apply.

View 10 Replies View Related

SQL Server Backup Applications

Jul 23, 2005

Hi All,During the past couple of years I have been maintaining the company'sAccess databases, in the coming weeks I will be migrating data to SQLserver, I will be using the Access forms as a frontend to access datawhile we developed a new front end through VB.Net.I was wondering if anyone will recommend an application that makes anexact replica or backup of the SQL server in the case the SQL serverfails. With MS Access, if a record is corrupted we needed to go backto the previous day backup of the database, we cant afford to havethis issue any longer.Regards,John

View 3 Replies View Related

Monitoring Applications Querys

Feb 1, 2007

Hi there!I'm programming in delphi and new to querieng MS SQL Server. Is there a wayto monitor the queries sent to the server and something of the returns. Atleast execution time would be interesting ...Thx in advance,Fritz

View 2 Replies View Related

Looking For Tools To Monitor Sql And Applications

Jul 20, 2005

I am looking for the right tools to do application monitoring.I'm hoping to find one single tool that can do the entire job but ifit does not exist then a few monitoring apps would do as well.I need the ability to do the standard things like testing for ping,checking for windows services running and restarting them after somethreshold is met, and wmi.Some of the more tricky things I need it to do are:* Parse log files looking for specific error codes, and the ability toset an alert only if it sees that error X times over some period oftime.* Run custom slq queries like row counts and max values returned froma query and if that condition is met X times over some period oftime.* Run an external app that does its own custom testing and act on itsresults, which could be to parse the result file from the app.Keep in mind cost is not the isssue right now - so this can befreeware to some type of enterprise solution that our company can use.Does anyone know of any tools that you can point me towards?Thanks...

View 1 Replies View Related

Problem Conecting To The Same DB From Two Applications

Apr 7, 2006

Hello,

I'm new to VB and SQL server. I have a windows forms application and a Web application that need to connect to the same database (Named WebCenter). But when I try to connect to it from the Web app while running the windows forms app this error message apears:

Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWebCenter_Data.MDF". Operating system error 32: "32(The process has no access to the file because is being used by another process).
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWebCenter_Log.LDF". Operating system error 32: "32(The process has no access to the file because is being used by another process.)".
Cannot open database "WebCenter" requested by the login. The login failed.
Login failed for user 'CARLOS-PCASPNET'.
File activation failure. The physical file name "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataWebCenter_Log.LDF" may be incorrect.

Can anyone give me hand or point me in the right direction.

Thanks,

Carlos.

Pd. Please excuse my english.

View 9 Replies View Related

Improving Chatty Applications

Nov 4, 2006

All:

I am presently tasked with improving the performance of a chatty application. What I mean by a chatty application is that the application makes multiple calls to the database server for each user request. In many cases it appears that many of the windows are making multiple calls to the database for the population of dialog boxes. In a couple of cases there are more than 10 dialog boxes that are populated similar to this.

To me this is kind of an "old issue", but my response is (1) cache the dialog information as much as possible and (2) make one call to the database to return all of this data for the dialog boxes if it is not cached. For update calls again make a single call to the database rather than making a call for each individual row of a table that is updated.

I admit that some of this will complicate the code of the application; however, my perspective is that I am supposed to look at this from the database perspective and not from the perspective of "programmer convenience." There will be times in which something that would otherwise get to hairy for a programmer will dictate an additional trip to the server, but this should not normally be the case.

What else do I need to consider?




Dave

View 3 Replies View Related

Using SSRS In Mobile Applications

Apr 3, 2007

Hi All,

Will anybody tell me is there any way to use SSRS Reports in Mobile Applications and if yes how should I implement it in my mobile application.





Regards

Pankaj Parashar

View 1 Replies View Related

Deploying Dual Use Applications With SMO

Feb 20, 2008

I have created a C# Windows Forms application that can be run connected directly to SQL Server 2005 (publisher) for in-office users and to a SQL Express (subscriber) on a tablet PC for remote users. The server is set through configuration and the remote users sync using replication and it all works.

The issue I'm having is that I've found it necessary to install SQL Server management objects (SQLServer2005_XMO) on the clients who sit at desktops and never use replication or SMO. I believe this is because SMO has to be installed in the GAC and I can't just distribute the required dlls with my app.

Is there any way I can deploy this app to always connected users without installing SMO on their machines?

Thanks, Jamie Ide

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved