Taxable, Tax Exempt, Non-Taxable Report

Our shop's accountant  wants us to give him a monthly  report showing each 
day's total sales, taxable sales, non-taxable sales and tax exempt sales.  
Does anyone know how I can generate it?  The Sales Tax Analysis report will 
give totals one day at a time or summary totals for the entire month.
0
Stitcher (8)
2/9/2006 11:40:26 PM
pos 14173 articles. 0 followers. Follow

0 Replies
501 Views

Similar Articles

[PageSpeed] 1

Reply:

Similar Artilces:

Fomatting amount fields w/ proper currency symbol using SQL Report
Entered in a transaction using currency id Z-EURO. Standard GP report pulls the correct currency symbol. When creating this report using SQL Reporting Services the Currency Symbol for the Amounts are pulling in '$' and not the EURO symbol. How would I accomplish formatting amount fields with the proper currency i.e (EURO, YEN or USD)? ...

Taxable Benefit
Customer has already printed all of their checks for 2008 but now need to record a taxable benefit for 3 employees. They need their wages and tax liablity updated. The employee will be liable for the taxes to be paid with their tax returns. HELP...they need to do this today so i can install year end updates so they can do their first checks for 2009 tomorrow ...

Calculating Taxes in CRM
Hi all, I am putting together some new reports for printing out quotes, etc for clients rather than exporting the data to excel, formatting and then sending out. I've got the reports from the Sandbox running, and I've modified them to our standards, but now I need to calculate taxes on the quotes for clients. In CRM, this is simply for show and tell, it doesn't mean anything to the bottom line since taxes have no bearing on the revenue of a company. GP sorts this out and accounts for it correctly on our back-end. Problem #1: We do business in more than one country (why...

Crystal Reports #2
We are using GP 7.50 and new to Crystal Reports and are having problems finding any type of direction. Does anyone have a sample of a simple report that might help us get started. It is hard to identify the physical names...is there a manual that lists all this information without me having to go under Tools>Resources>fields to figure it out...that is time consuming. Any input would be helpful!! Yes, there is a manual. It's on CD2 of the Great Plains set. It's the SDK. You can find it on CD2 under Tools. Run the setup program. It's not comprehensive but will get yo...

gal showing non mail enabled users
I have just finished doing a migration from e2k to e2k3. I have several users that do not have mailbox's, but show up in the GAL. That's right! example: user jdoe does NOT have a mailbox, but shows up in the GAL. There is not a "hide from address list" option as there is no mailbox to set this on. I have no contacts in AD. There is a recipient policy named "no internet access", and this policy will stamp @local.domain.com to specific users, and this is supposed to keep those users from sending mail to the internet. This is pointless because the us...

One or more rows contain values violating non-null, unique, or foreign-key constraints
Populating a typed dataset from xml document: I created an xml schema (attached below), generated a typed dataset from it, and then programatically I tried to populate the typed dataset by calling its ReadXml method. I keep getting a constraint exception. I have validated that my xml matches the schema using xmlspy. I've included the schema, xml, code and exception information below. I can't figure out why I would get the exception if my xml validates against the schema, and the dataset was generated from the same schema. Exception--------------------------------------------...

taxable/non taxable dividends
using ms money 2005. I am trying to get a report on my stocks showing the total taxable dividends and the total non taxable divinends in two seperate reports. I have my investment to show taxable and non taxable and i have showen the correct tax form. the only report i can get is a report showing total dividends (this shows all dividends taxable and not taxable togeather). In microsoft.public.money, qazwsx wrote: >using ms money 2005. I am trying to get a report on my stocks showing the >total taxable dividends and the total non taxable divinends in two seperate >reports...

how to put this in report header?
I have a table with more than 30,000 records. I want to put Sem and Rundate fields to the report header. These two fields looks like this: Sem RunDate 0 20070214 1 20070316 2 20061013 3 20070103 Sem is for semester. 0=Winter, 1=Spring, 2=Summer, 3=Fall and there are no other posibilities. 30,000 records just repeat same above. I don't want to put RunDate in the detail band of report. Since there are only 4 possibilities, I want to put in report header something like: Semester Update Winter 02/14/07 Spring 0...

$4,000 DST patches from Microsoft for non-mainstream support systems
I presume Exchange 2000 would fall into this category. Perhaps someone with Exchange 2000 could post back with what they find out. http://blogs.technet.com/james/archive/2007/01/24/dst-support-update.aspx "To help customers through this change and in response to their feedback, Microsoft has decided to amend the regular Extended Hotfix Support program to add a new pricing category for extended non-security hotfixes with a wide customer demand. The new pricing category will be applied to the daylight saving time hotfixes (DST 2007). � DST 2007 hotfixes for products in Mainstream S...

taxable wages
When processing bonus checks I do not withhold the Federal and State taxes but they are still subject to taxable wages. I think there should be an option to replace the withholding $ amount to 0 for the taxes that I don't want to withhold on the check but still show up on the employee's taxable wages. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion ...

Completely Blank Report...no title, data, etc.
I am using Access 2002. I have created five reports that list totals in the footer of each for January through December. They are then all on a report so there is only one report instead of five. They are not linked to each other. All of them show up except one. One of the reports shows nothing at all, not even the title of the report just a huge blank area where the report should be. I'm assuming this is because there isn't any data pulled when the query runs. If I run the report by itself I receive rows of #Errors where all the calculations are but nothing but ...

How to: Send non-registered user e-mail to trash
Example: @mail.com users are a, b, c Psuedo code: If TO: field does not contain a OR b OR c; send to trash. This would eliminate 95% of my spam. Thank you, Dennis D., http://www.dennisys.com/ Dennis D. <tech@dennisys.com> wrote: > Example: > @mail.com users are a, b, c > > Psuedo code: If TO: field does not contain a OR b OR c; send to trash. > > This would eliminate 95% of my spam. Create a rule that deletes messages with "mail.com" in the sender address, except if sender address contains "a", "b", or "c", or create a r...

'temp' folder as work area for non-administrator
First apologies, as this is slightly off topic, although I am using MFC. If anyone can suggest a group where I'm more likely to get an answer I would be grateful for that too. I have had a report on our application that it fails under circumstances where is is running in non-administrator mode, and cannot create temporary files in the ..\Program Files\Manufacturer\ProgramName\ folder. I realise that there is a whole area of expertise that I am in the dark about, and I'm looking for a starting point. What I visualise is creating a '\temp\' subfolder and allowing full access to...

Problem with subsets for multiple Report Filters in 2007 PivotTabl
I have 2 fields in my PivotTable's Report Filter section - 'Country' and 'City'. When I filter by 'Country' it doesn't automatically restrict the possible values in the 'City' filter to cities within the selected country - any ideas how to do this? I'm sure 2003 used to do this sort of subsetting :( Any help would be appreciated! Gordon. Hi Gordon No, I'm afraid there is no change between Xl2003 and XL2007 as far as this is concerned. There is no dependency between the two fields when both are selected as Page fields. ...

Bug report for VBA on Office 2004 for Mac
As I don't want to use MS Passport, I hope that this will suffice as a bug report for Office 2004 for the Mac. I hope that someone will pass this along to the proper person. Anyway, if you have even one Cyrillic character (or probably one from any other non-Mac Roman script) in your hard drive volume name, VBA will not launch from within Word. I haven't tested the same from within Excel or other apps, or launching VBA by itself. This applies to the creation and recording of macros as well as the Visual Basic Editor itself. Here's hoping that someone reports this and that MS fi...

How to Associate Capital Gains Category with Tax Line?
I want to associate the category ("Capital Gains") with the appropriate tax line. In practice, this is IRS form 1040 line 13a or IRS Schedule D line 1, for example. However, the "Tax Line Manager" doesn't give me the option of associating this category with any of those tax form lines. The only options are highly specialized lines on Schedule D, but none of them are the generic short term gains. Has anyone encountered this? Thanks for your help! ...

Timer Question
Hai All, For a NonWindows application looking Set a Timer for 5 Secs and once the timer expires i need to print some text, i looked at SetTimer and it required handle and a CallBackFunction and for nowwindows applciation the handle i passed is Null as i dont know the handle,when the handle is null the application is not going to the callback fuction and is there any other API to handle this situation,any help is greatly appreciated Thanks and Regards Suresh For non-windows applications you need to supply a callback function. ...

report
Access 2007, I am making a report with several fields. If a field is null (contains no information), I want that field removed so that only fields containing information are displayed/printed. What is the easiest way to do this? Thanks I am curious how a control that is bound to a Null value displays? How are you seeing nothing? -- Duane Hookom MS Access MVP Help me support UCP http://www.access.hookom.net/UCP/Default.htm "Flash" <Flash@discussions.microsoft.com> wrote in message news:1E588CFE-B8C4-4653-B0B0-998E21270532@microsoft.com... > Access 2007, > I am ma...

In a Report, how do I display the text not the ID value?
I am trying to generate a report from table#1 that looks up organization names from table#2. When I include the organization field from table#1 in my report, the report displays the numerical value stored in table #1 not the actual text of the organization name stored in table#2. How do I get the report to display the text value from table #2? I'm just getting started with access and tried finding this in a book I have and on the help topics but to no avail. Any help would be greatly appreciated. Thanks. Sounds like you've used that misguided misfeature known as the Lookup ...

Non-technical specialist with perplexing outlook address book problem
I am writing in hopes that someone out there can help me out -- I am using Outlook 2002 with XP. I am not a specialist or "techie," only a guy who wants his outlook contacts to display properly. Here's the problem as best I can describe it: *When I type in the first letters of a contact's name, outlook faithfully autocompletes the entry no problem. Cheers to Microsoft. *I can then assume that these entries, which are "autocompleted," are stored somewhere deep in the recesses of my computer. *However, when I go to both the "outlook address book" and "...

Problem with loading report
Here is my code for loading report: DataSet ds = new DataSet(); DataAdapter da = new FbDataAdapter("SELECT * FROM TABLE", myConnStr); DataSet customers = new DataSet(); da.Fill(customers, "Customer"); string path = @"C:\Report2.rpt"; ReportDocument docRep = new ReportDocument(); docRep.SetDataSource(customers); docRep.Load(path); crystalReportViewer1.ReportSource = docRep; I get error message: "Invalid report file path." and it breaks on docRep.SetDataSource(customers); line. If I comment that line the report is showed but witho...

Solver Reports
I am using Solver and looking at the reports it produces. Can anyone explain the following terms to me: Reduced Gradient and LagRange Multiplier (Sensitivity Report) -- Thanks Cath Cath - The reduced gradient for a nonlinear optimization problem is similar to reduced cost for a linear problem. At the optimal solution of a linear problem, for a variable not in the solution, i.e., for a changing cell equal to zero, the reduced cost measures how much the target cell would change if the currently-zero changing cell is forced to be one instead of zero. For a nonlinear problem, at the st...

Taxable, Tax Exempt, Non-Taxable Report
Our shop's accountant wants us to give him a monthly report showing each day's total sales, taxable sales, non-taxable sales and tax exempt sales. Does anyone know how I can generate it? The Sales Tax Analysis report will give totals one day at a time or summary totals for the entire month. ...

Invoice showing sales tax only
We sell prepaid gift cards (points value only) to customers who give them out to be redeemed by employees. At the time the gift cards are sold no sales tax is collected only the value of the points. When the gift cards are redeemed we then know the ship to address so that we can collect the correct sales tax. We want to have the invoice only show the amount of sales due and not the item sell price on it as the customer has already paid for the item and now only owes the sales tax. Does anyone know of a way to only show the sales tax due on the invoice? -- Rodger Enter the amount redee...

Report code not recognizing a report control
Hi All - I am sure this is a case of overlooking the obvious. I am trying to adjust a form's header when the report is generated to more accurately reflect the report's content. Until now, I have never had a problem. The report is opened from a form VB module with: DoCmd.OpenReport "Diagram CORCAS Prtvar", acViewPreview In the On Format event of the report header, I have this code (for debugging purposes): Debug.Print "List of controls" Debug.Print "================" Dim ctl As Control For Each ctl In Me.Controls Debug.Print ctl.Nam...