Customer Hitorical Aged Trial Balance Tables
About the historical aged trial balance reoprt for customers..
I can generate it from excel by connecting to the related tables in
SQL. But the problem is: I don't know what those tables are!
Can any specialist in Dynamics GP DB tell me what are the tables that
related to H A T B report plz?
IT & GP Application Specialist
Mail to: Yassir.firstname.lastname@example.org
Mobile: +966 50 499 7475
Tel. No: +966 2 635 5523 Ext: 127
Fax No: +966 2 635 5223
The HATB rep...You a 7-Day FREE Trial
We Are Offering You a 7-Day FREE Trial to the internet's Hottest New
If you missed out on the DOT COM boom, now is your chance to cash in
on the massive and growing global demand in our $20 BILLION PER YEAR
market. We'll show you how to create an income that will come to you
for years and grow with each passing month.
A SIMPLE, Fully-Automated, REJECTION-FREE Internet Marketing System!
Finally, an EASY, proven, FREE system that will truly help anyone
willing to follow our guidance succeed!
Average People Are Making Money! Average people are putting their
home...URGENT: Mail access issues
I am having a problem logging into my Outlook mail
account on my laptop. I get the following error:
"Your logon information was incorrect. Check your
username and domain, then type your password again. If
your account is new or if your administrator requested a
password change you need to click Change Password then
logon with your new password."
Seems like a straight-forward message, but here is the
problem. I can access my mail account when logging on to
the client's desktop computer. I should be able to logon
to this account from my laptop, just like my co...odd issue with word help file
i am programming word through access i have access 97 and word 2000
when i press f1 on the word code in msaccess i get this error
cannot find c:\program files\microsoft office\office\VBAWRD9.CHM would
you like to fine it yourself
the file is located in c:\program files\microsoft office\office\1033
when i try to find it it only shows .HLP files i am guessing there is
jack all i can do as office 97 uses hlp and office 2000 uses chm.
so i am merely confirming that this is true or is there a solution.
I would like to create a macro which can be used on
several worksheets. I'm having to cut/paste info into
these worksheets from another worksheet. I need this
macro to highlight all cells and autosize them and then
(here's the problem I can't figure out...) go to the
first empty cell on column A. When I do a Cntr+End and
then down arrow and Home, it will keep that row's number
in the macro..In other words, it won't go to the first
empty cell in all the worksheets.This probably makes no
sense at all...but if you can understand what I'm trying
to say-Please help...Issue with ADP form bound to Stored Procedure
I have an application that I support that is a Microsoft Access Database Project. It uses Access as a front end to a SQL Server database (SQL Server 2000). The current version of Access used in production is Access 2000 (Office 2000). My application site will be receiving new workstations next week that run Access 2002 (Office 2002/XP). When testing with the new version of Access we discovered an issue with one of the Access forms being bound to a Stored Procedure as its data source. It uses the following code to do this
Me.RecordSource = "dbo.proc_frm_Input
Me.UniqueTable = "d...OK any ideas on this issue
OK, on the computer and I am doing some clean up of drive C(with windows
tools,disk cleanup and check)
I then reboot and notice that my background on the desktop is wrong, so I go
into the properties and go to set the correct background and it tells me the
directory that i am looking for is not available etc etc.
So I go into my computer and low and behold, no photo drive. nada, nothing.
OK, so now the sweat breaks out(I do have back ups anyway)because I am
wondering what the hay?
Disk management does not show it(second hard drive).
I open the case and switch SATA cables ...free dot interview questions information
..NET database dev questions
Some general quickies
..NET WebDev interview questions - Part 1
..NET WebDev interview questions - Part 3
Electronic engineer interview questions
http://freedownloadablebooks.blogspot.com/2008/03/electronic-engineer-interview-...Exporting to Excel Issue
When exporting from CRM 3.0 to Excel 2003, dates and numbers in CRM 3.0 are
exporting as text in Excel 2003. Is there a way to correct this so that
dates and numbers export correctly?
A simple way to do this:
1) Select the cells that have dates as text and you want to convert.
2) Go to menu Data - Text in columns...
3) On first step of the wizard select "Delimited"
4) On second step click next
5) On third step select format "Date" and click "Finish"
"Kathy" escribió...freeing up space
If you delete an attachment or an image from a message, then save the
changes, does that free up space in the store?
On Wed, 22 Dec 2004 13:27:04 -0800, dlv
>If you delete an attachment or an image from a message, then save the
>changes, does that free up space in the store?
Not enough to care about I would think. Unless you have a 10 GB
Can anyone tell me where to get a trial version of publisher?
I have tried http://office.microsoft.com/en-ca/publisher/default.aspx but it
does not complete the download.
> Can anyone tell me where to get a trial version of publisher?
> I have tried http://office.microsoft.com/en-ca/publisher/default.aspx
> but it does not complete the download.
> Thank you
You are using the correct link.
I'm guessing you were trying to install directly
from the net, it may be best if you download
the file to your hard driv...Missing Free/Busy Folder #2
I have read the other postings regarding the fix to the missing Free/Busy.
When you follow the recommendations from the following KB articles:
There is only one Administrative Group folder. Also the client has several
folders created under the public folder. Will I need to reset their
published folders under public? Also will there be any other information
that I will need to rest after coping the new GUID ?
When we put in a new GUID we will dest...Free books on Excel; Free Add-In
You may download the free books and software from
http://www.vgupta.com (offer good till Dec 31 2003)
Excel For Beginners
Charting in Excel
Excel- Beyond the Basics
Managing & Tabulating Data in Excel
Financial Analysis Using Excel
Statistics Using Excel
Software: "Excel Usability Enhancer"
> You may download the free books and software from
> http://www.vgupta.com (offer good till Dec 31 2003)
> Software: "Excel Usability Enhancer"
I note that the only significant installation instructions were:-
"Double click to launch the add-in &q...Excel Compatibility Issues
Our office is having an issue exchangint Excel files between the Mac
and PC users.
Recently an issue has developed where the PC users can open and use
Excel files, but the Mac users cannot open them at all. They get this
"The file might have been damaged or modified from its original
We have tried:
Saving it as .xls
Moving it via flash drive instead of email.
Moving it via a network location.
We also tried copying and pasting the contents into a new document,
and removing all the links. That worked... for a while. Today, when
trying t...Any Links to Free Manuals for Word 2007?
Does anyone seem to know links to Free Good Quality manuals fro Office
I did downlaod one from http://www.mousetraining.co.uk/ms-office-training-manuals.html
but it doesn't include all the topics that I want to learn!
Any help will be much appreciated!
"Rajeev Rawat" <email@example.com> wrote in message
> Does anyone seem to know links to Free Good Quality manuals fro...Site missing in System Folder
I have 7 sites in my Exchange 2000 organization. 4 of them was
migrated from Exchange 5.5 to Exchange 2000, the other 3 are new.
In system folders - schedule+ free busy of the 3 new sites I can only
see the local site. On the other 4 sites I see only them selfs and
none of the new sites.
I think this is related to the problem that I have that people can't
see each other's calendar when they make an appointment.
Can someone help me solve this problem?
...Are there known issues with Vista and Acc2003
I have a rather complex commercial Acc2003 application (tab controls,
50K+ lines of VBA code, etc.) that will not run well at all on Windows
Vista Ultimate. I have seen posts indicating that Acc2003 MDBs should
work on Vista. However, our particular file has too many problems to
be viable on a Vista platform. Even converting it to an Acc2007 accdb
file has no positive effect.
I realize that Vista is new and should be avoided like the plague, but
we have few choices if some of our clients go to Vista.
We have been all over the MS knowledgebase and these groups without
much luck. Are there any...Possible Replication issues
I am using an Exchange 5.5 environment, with NT4 based servers.
I have three servers in one site in addition to several worldwide. One acting as a bridgehead and the other two with an equal share of mailboxes on them.
I have noticed that whenever I delete mailboxes off one of the servers in the site, the entry does not get deleted from the Address List on the other server. If a user whose mailbox resides on that one server checks the Global Address List from within Outlook, it still appears, even though on the other server and all worldwide servers, it have been removed.
It just se...Credit / ATM Issues???
Just wondering what happens if your network connection goes down, but you do
not loose internet access...and you opperate in offline mode, where employees
still except Credit / ATM Cards? When you sink back up does everything sort
out, does everything work fine because you processed the transaction
anyhow??? Not exactly sure what happens in this regard, can anyone explain?
If they don't lose Internet access AND you are using the Offline database
mode, everything will sync back when the server comes back on-line.
I know you didn't ask, but for ...Extend Published free/busy time, consequences.
I am thinking of extending the published Free/Busy time in Outlook to a year
or two into the future.
But how about the consequences in doing so, as seen from the Exchange
perspective. Before Exch 2007 this information was stored in a public
folder, now in Exch 2007 the check is made directly in the calendar using
OWA, so I guess that there should be no problem in doing so? Anyone got any
info or best practice I can lean up against.
Free-busy data is pretty small so I doubt think you'll have any trouble.
But, seriously, who...Couple of issues with contracts after upgrade
We have a couple of "why's" after upgrading to 4.0.
In 3.0 we had a contract template using time allotment. When creating
contracts based on it, the initial allotments field was recommended, not
required. In 4.0 the field is required in both templates.
Is there some new setting on the template to decide whether the field is
Another thing is that in 3.0 the customers mailing and visiting address was
possible to select and map to the contract, now it seems only "more
addresses" are possible to automatically insert in the contract.
Seems a bit weird ...Problem for generating Trial balance report (GP10 sp3- upgrded frm
When I am printing a Trial Balance report (Report > Financial>Trial Balance),
getting an error “[Microsoft][ODBC SQL Server Drover] [SQL Server] An
explicit value for the identity column in table '##0185624' can only be
specified when a column list is used and IDENTITY_INSERT is ON.”
Please help me to solve this prob.
Stop and start your SQL Server service, then attempt to run the report again.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogs...Default Free/Busy Calendar time
I put a GPO in a few months ago to change the default free/busy time in
outlook so that some of the Administrative Assistants could schedule things
on their boss's calendars up to 4 months in advance.
Since the time change/DST this gpo has stopped working.
Has anyone seen this?
The users haven't moved OU's, they haven't been upgraded, the GPO hasn't
If I'm posting this in the wrong group can someone point me the right way?
Hello all, I have update my e-books..
Please take a look: http://freebooks2007.blogspot.com
Oh By the way I downloaded the free Excel VBA manual from http://www.mousetraining.co.uk/training-manuals/Excel2003VBA.pdf but it doens't seem to provide me any answer for my specific query
cheers Download Excel VBA Language Reference from Microsoft
> Oh By the way I downloaded the free Excel VBA manual from http://www.mousetraining.co.uk/training-manuals/Excel2003VBA.pdf but it doens't seem to provide me any answer for ...