Financial Trial Balance Detail Restrictions
I would like to put in a suggestion that when you run a Trial Balance Detail
and you enter in your ranges for the restriction (example, by account, by
date, etc), that it be flexible enough to run multiple non-continuous
accounts (for example, GL 01-6500,GL 01-6502....and not GL 01-6501) on the
My options now are either: 1. Run two seperate TB Detail reports or 2. Run
GL 01-6500 to 01-6502.
We are on GP 9.0. Would this be something that I can look forward to in
future GP versions?
Who''s Calling, Inc
Financial Reporting Manager
---------------...ways to separate totals for tax and non-tax items at tender time ?
I am using Microsoft POS 1.0 and a new user. I want to be able to show two
separate totals for tax and non-tax items at tender time. Is there a way to
do so within POS or do I need to write an add-in ?
I am also surprised that I can't even sort per selected column which is
often implemented in similar design by clicking on the column's title. At
least that way, I can sort tax and non-tax by clicking on the tax column.
Thanks in advance for the help,
...Keep all forms maximized
I have a number of forms that are displayed one at a time. I need to display
them all maximized. I can do this fine, but there's an annoying problem
When I close one form to open the other, the next form first appears NOT
maximized and ONLY THEN gets maximized. This causes a glitch in the user
So, how can I make forms change smoothly between each other?
Thank you in advance
Hope this helps. I build a macro that has, open form, maximize for each form
and also a close form line for each form. In the properties of each form I
refer to the correct macro in the ...How to create new Contacts form and have it apply to current conta
I can create a custom contact form by following
But how do I apply the new form to my current contacts ? For example, if I
want a Car Phone field in my new form I want to be able to go back to my
current names I have in my Contacts folder and see the Car Phone field.
Thanks for any help.
See http://www.outlook-tips.net/beginner/publish_form.htm - end of page.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com...booking form
I have a spreadshhet showing booking fields, name, address etc & have
created a webpage booking form which sends the booking info by email.
Is there an easier way of putting the data into the fields other than
having to "scrub" the data thats on the email, then use csv?
Message posted from http://www.ExcelForum.com/
...Tax Exempt and tax display
I am new to POS 2009 so this may be a simple question, but it escaped me.
1) We have 2 tax types. How do you setup customers so they are exempt for
only one. If you use the exempt feild in customer setup then they are exempt
2) We have each tax seperate on the receipt, but is their a way to display
both taxes seperatley on the pos screen?
I am having the same issue but with RMS 2.0..when i set it up to exempt
certain part of the tax it gives no tax..plz help
"Prairie Computers SK Canada" wrote:
> I am new to POS 2009 so this may be a si...Skip blank or N/A in data analysis
I try to do data analysis (such as regression) to two
data columns X ~ Y. Under some condition, some of the Y
values are blank or (#N/A). When I do X-Y chart, those
points are ignored. However, when I select the same
columns to do regress or any other data analysis, I got
the error saying "Input range containing non-numeric
data". I don't want to put any number like 0 for those to
distort my result. I just want to ignore or skip those
N/A data. Is there a way I can do it without removing
those data? Because the N/A location depends on a
variable (a condition). I ...Posting from a form to a table
A have a db that is used to keep track of members that talk and when. the
process is that I have a form that pulls in several names from a table
"MemberName". each record is associated with a date. I would like to have
the date of the record post to each of the names from the "MemberName" table.
I imagine that you would need one table for the member names and another
table for the talks.
One member can give many talks, so the relationship is 1 to many between
MemberName table and the Talk table.
In the talk table, you would have the MemberID from the memb...Sub-Form Properties Changed...
I have a data entry form with a sub-form. Somehow on ocassions, which I
can't track, the sub-form properties: Allow Edits, Alllow Deletions and Allow
Additions, gets changed. I've been trying to observe users and their habits
for the past few months, in the hope of trying to figure out the reason for
these changes. Somehow I can't figure out what would cause these changes.
There is nothing in the form coding that even addresses these properites. Is
there someone out there who can explain this so that I can fix this problem
for good? Right now, I have to go and ch...Sequential numbering of invoices
I have recently downloaded an Excel template for invoices from
Microsoft's website. Is there any way to fix it so that every time I
create a new document based on this template, it automatically gives
it an invoice number one greater than the previous invoice (eg,
starting at 100 and then the next one I open would be 101, then 102
and so on)?
"Nick Xylas" <email@example.com> wrote in message
>I have recently download...Money 2003 Deluxe
When I go to Reports/Taxes/Tax Software Report I get a summary of what
should be included in the various Federal Tax Forms. Everything looks
reasonable except for the Capital Gains and Losses Money generated when I
bought or sold a stock. It looks like some of the transactions ended up
under Schedule C! Can someone give me a hint on where I have to go to tell
Money how to handle the generated gains and losses? I have been to all the
obvious places like "Catagories" and "Taxes" but I must be missing
something. Thanks in advance.
In microsoft.public.money, Ken wrote:...enter / match invoice
I posted a transaction in enter / match invoice, i want to void that
i used the option void open status but i only voided the payable transaction
but i want to void the invoice receip. how to do that, beacau i need to
invoice that receip again
You can't void a shipment receipt. You must do a return transaction,
then re-receive the item.
MCP-GP, MCT, MVP
East Coast Dynamics
but i posted by enter / match invoice for that receips, then after i void
that transaction by void open transactions
...VALUE appearing (referencing blank cell)
Hi Guys, sorry for again posting on here but this reoprt will be the death of
I have 2 cells that have the following formlas
IN C45 =IF(ISBLANK(AG149),"",AG149)
IN D45 =IF(B45=1,'Base Data'!$H$52,IF(B45=2,'Base
Data'!$K$52,IF(B45=5,'Base Data'!$L$52,IF(B45="pd",'Base Data'!$M$52,""))))))
Both C45 and D45 have no data in and are therefore blank - GREAT
Then in cell AF45 I have the following formula which is...Work Breakdown Structure details
Is there any way to increase the level of detail
displayed in a work breakdown structure diagram created
I am using the WBS wizard you can add to the Project 2002
(prof) toolbar but the final diagram in VISIO only has
the duration of the task. Is it possible to expand the
level of detail transfered from Project to include things
like resources in the final VISIO WBS diagram.
Many thanks in anticipation
...start a non microsoft program via a macro in excel
I was wondering if it is possible to have a macro in excell that would
start another program, ie. QuickBooks. Currently I know that if you
double click on a QuickBooks file, as long as that extension is
associatied as a QuickBooks file, QuickBooks will automatically start
up. So what I am trying to do is have a macro that will in a sense
allow me to double click on my QuickBooks data file and in turn start
up QuickBooks via my macro in Excel.
Thanks for any help at all on this!
Try the Shell function.
Not sure about the program name for Q...Copy from form & paste into a blank document
Operating System: Mac OS X 10.4 (Tiger)
I am looking for a different strategy for the following (since the macro below does not work: A user fills out a form. A macro is needed to step through each of the form fields and then copy or paste the user-supplied content of each into a separate Word document. The idea is to "autogenerate" a letter from the contents of the form fields. <br><br>The following test macro did not work; got a compiler error: "invalid use of property". <br><br>Sub CopyText...Working with a seperate invoice system
Is it possible to import and export invoice batches in Microsoft Money
Business & Personal Edition 2003 (or 2004? I'll upgrade if that adds this
The reason I ask is because I'm using a custom written in-house online
billing system. But, it ONLY does invoices and nothing else. It does not
track expenses or generate any sort of reports that would indicate if I'm
actually making any money or just shoveling it around from one corner of the
sandbox to the other all quarter.
I can export invoice data to CSV files, and probably write some code if
necessary to move ...Tax Invoice automated Tax number
I used Office 97 for a long while. In this Office Software Excell had the best Tax Invoice program or sheet. This sheet had a automated numbering system.
Who knows of this and can tell me why in the Office 2003 Software this is not available any more ... this is very disturbing
How can I use this Tax numbering system in the new Office 2003 - the numbers should automate themselves
...Price Includes Tax
We have a very simple store that sells 4 sizes of ice cream.
Size A is 2.75
Size B is 3.50
Size C is 4.25
Size D is 5.00
These prices include tax which is 7.8%. So what I did was entered item
pricing of the following to account for the tax.
Size A is 2.55
Size B is 3.25
Size C is 3.94
Size D is 4.64
This works great except for when the customer orders multiple quantities.
Because I have rounded up the pricing it eventually rounds up making the
total sale value a penny or two higher. For example:
If the customer gets 3 Size D's the final price should be $15.00. However,
the POS...Blank page at the end of document
We are currently generating a word document with the business details based
on the input from a CRM tool(CCM). The issue currently we are facing is a
blank page gets attached at the end of the file. When we tried deleting the
page the document gets corrupted, we are generating the document using
You would have to show us the VBScript to give you a specific answer, but I
imagine that your code is inserting Section Breaks and what you probably
need to do is include code the change the last one from a Next Page Section
Break to a Continuous Section Break.
Hope thi...Outlook custom form error
I made some changes to the Account and Contact forms, published them and all
works fine via the web however now when I try to open a CRM linked Contact
form I receive an error stating that Outlook cannot find the custom form and
will use the standard form. I've gone Offline and back Online but no joy.
Has anyone experienced this problem before?
...pivot table data v detail
I would love to know the difference between the data area and the detail
area in a pivot table in Access 2003.
Excel doesn't have both of these fields and I cannot find any help
references for Access 2003.
...Print Invoice for customer
How do I print an invoice for a customer
This is a multi-part message in MIME format.
If you are looking for the word "Invoice" on the receipt, you need to =
add or change your receipt template and/or printer setup. =20
Here is an example on CustomerSource http://tinyurl.com/4gdbu of a Full =
Page receipt that says Invoice rather than Sales Receipt.
Check Point Software
Search this newsgroup...Paycode & Taxes
Not to go into details on this particular matter, but for background purposes
we have some employees who due to a classification as "ministers" they have a
set amount dresignated to come out as withholding from their monthly paycheck
rather than being calculated off of the tax tables. We have no technical
problems w/ the system handling these situations, but it causing an different
issue for which I am trying to find a solution.
There are times that these employees get a special pay distribution later in
the month. Since they have set their monthly withholding, there is not ...Customized forms for Outlook
I am trying to design and customize my own form in
Outlook 2003. Can anyone tell me what I need to do to
publish this form? Any other information on these forms
would be greatly appreciated.
Start at http://www.slipstick.com/dev/forms.htm ...lots of help there.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> I am trying to design and customize my own form in
> Outlook 2003. Can anyone tell me...