Business Alert #4

Is there a way to have a business alert set so that if a sales item has a 
profit of less than 5% or greater than 100% we can have an alert sent? 
ls (21)
8/11/2009 2:19:02 PM
greatplains 29623 articles. 5 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 3


Yes You can set it up that way. You can create an Alert on Sales Transaction 
History Table using a formula that looks like this (you might want to change 
it a little if you want it for each sales line item, you need to capture the 
same from Sales Transaction Amounts History). However the question is against 
5% or 100% of what you'd like that to be compared? Put that field in place of 

(SOP30200_T1.DOCAMNT - SOP30200_T1.EXTDCOST )  <0.05*X  OR  
(SOP30200_T1.DOCAMNT - SOP30200_T1.EXTDCOST ) > 1*X
Janakiram M.P.

"LS" wrote:

> Is there a way to have a business alert set so that if a sales item has a 
> profit of less than 5% or greater than 100% we can have an alert sent? 
janakirammp (688)
8/11/2009 4:01:01 PM
you can create an alert against the Sales Open Work Table (SOP10200) 
comparing the item selling cost to the projected sales cost.  (note that the 
final cost will be adjusted when the item is posted as new items may be 
received/sold changing the layer that the next posted invoice consumes).   
Doing this against the open table allows "bad sales" to be stopped/corrected 
before posting.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at

"LS" wrote:

> Is there a way to have a business alert set so that if a sales item has a 
> profit of less than 5% or greater than 100% we can have an alert sent? 
info4071 (3004)
8/13/2009 1:56:01 AM

Similar Artilces:

Business Cards with my own clip art?
I would like to creat my own business card, with my own clip art. What's stopping you? "business card with clip art" <business card with clip> wrote in message :I would like to creat my own business card, with my own clip art. See -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site Word MVP...

Business manager
What is business manager component doing for Outlook? Thanks, Ray Which version of Outlook? There are various addins that use the words business and manager. The newest is the Business Contact Manager for Outlook 2003. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: Outlook & Exchange Solutions Center: Join OneNote Tips mailing list: http://www.onenote-...

Business club, Business leads, New business opportunities
Title: Business club, Business leads, New business opportunities Welcome to Biz-Club the UK's first truly independent internet based networking group established in 2006 for SME's, that allows you the member to choose how it can best work for you. Operate locally, regionally or nationally with all the advantages of a business networking group but almost none of the disadvantages. Enjoy membership of Biz-Club alongside your existing affiliations plus a host of other valuable benefits all at a cost far lower than that normally provided by traditional business networking groups. Be treat...

View Free/Busy Data
I have an Exchange Org that consists of three admin groups with a total of 1 server per admin group. Currently as it stands, users not able to view free/busy information from one exchange server to another. I am aware that you can accomplish this by creating replicas of your publics folders, however do not know exactly where to enable this. I do not want to replicate actual public folders, but only want users to be able to view free/busy data from users on a different exchange server. Under the system folders in the public folder, there is a folder called Schedule + Free Busy...Do I...

CRM 4.0 Customizations
Hi, I haev customized the LeadSourceCode pick list in the Lead entity adding new items to the list. I've published it OK and when I first go into a Lead record it loads the screen up OK. But when you go back into this record the system crashes with a Null value exception. I can't remember if this only happens after a save of the Lead record or not. Anybody else experienced anything like this. Also, how can you set up the system to provide better error logging (like you can do in sharepoint) thanks Hi Chris, I am having the same problem editing the paymenttermscode pick list....

How can I use a different layout on a business card template?
I want to use the design on one of the business card templates (Colors), but I like the text layout on another one. Is there a simple way to remove the formatting on the Colors template, and replace it with another? I have already designed a card I like on another template, and want to copy that so I have the colors in the Color template. I am using Publisher 2003. Thank you. Copy and paste? -- JoAnn Paules MVP Microsoft [Publisher] "emichel" <> wrote in message >I ...

Outlook 2000 in Office 2000 Small Business
I have done several clean installs w/several different versions of Outlook from discs and I cannot get Outlook to open w/out crashing upon loading. All other components of Office work great. I began having problems w/Outlook when I began using Outlook Express.... Maybe they are related. Please help. ...

Schedule free/busy
Hi there, I have one problem, All users can see others calendar. Example, when user a send a meeting invitation to user b, at the same time is sending a exchangelegacydn atribute so user b receives all calendar information about user a. I need to know how to do to every user only see availability calendar but information about the meeting. Thank you a lot for your help, I made a lot of tests but nothing worked -- Mark ...

Installing Business Portal, done, but issues
I've just installed BP 2.0...install went clean. However now when I try to access the site for the first time, I get an Invalid User error (Server Error in '/' Application. Invalid user.) I did change the bp accont to use as per the installation instructions to the "Network Service" account. Do I need to setup or add the actual users somewhere else first? I did not install the sample users. I was able to sort of login with the local server account, which is what I used to install the product. But most of the web parts show errors like the above. Chris, Wh...

CRM 4 Outlook Client
Hi, Although it runs sometimes the majority of the time the CRM client is causing Outlook to hang. It either prevents outlook from opening, prevents messages from being dispayed or Outlook freezes when try and send a message. As soon as the CRM client is removed all is okay. Is anyone using it for real?! What might be making it so unrelieable for us? Marcus -- MR ICT Ltd - a) Delete (disabling is not sufficient!!!) every Anti Virus software on this computer. b) Disable all further addins inside Outlook. Does it work now? If not, open a service request with M...

intel, OSX 10.5.4, Endnote X1, Word 2004, NOT WORKING
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel hihi, I just installed an Endnote X1 licensed to my Univ to my new macbook running OSX 10.5.4 and Word 2004. and every time i try to input a reference to my word doc, it just says there is a Microsoft visual basic error "run-time 5"-invalid procedure call and argument. can anyone help me with that? i really need to that working on my thesis. thks a lot, Gareth <> wrote: > hihi, Hi, > I just installed an Endnote X1 licensed to my Univ to my new macbook > ru...

World Wide Calling! Unlimited Incoming Calls. #4
New virtual access anywhere technology lets you call anyone, anywhere in the world, from any phone! Access: ...

Scatterplot with 4 quadrants
I would like to set a scatterplot that has a crosshairs grid view. When you set major grid lines, it populates several vertical and horizontal lines; i would like to have one vertical and one horizontal lines. thanks - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - _______ "dhill" <> wrote in message >I would like to set a scatterplot that has...

how to change business address
I can't seem to figure out for the life of me WHERE OR HOW to change my business address so my NEW address prints on my invoices now that I have moved. Can anyone help me with this? PLEASE????? LGLEIM In, LGleim wrote: > can't seem to figure out for the life of me WHERE OR HOW to change my >business address so my NEW address prints on my invoices now that I have >moved. Can anyone help me with this? PLEASE????? Is there a Tools->Settings->BusinessInformation place? YES!!! You did it! Thank you so much! "Cal Learner-- MVP" wrote: ...

Changing the Sales Stage in CRM 4.0
Hi, In CRM 3.0 it is possible to change sales stage (skip one or more) without finishing task(s) from the previous stages (by "change stage" option). Is it also possible in CRM 4.0 ? Thanks, Pawel Whether or not your finish or complete the task to move the next sales stage is controlled via workflow. I don't see the action in 4.0 to change the sales stage process. You could overcome this with a custom workflow that will set the sales stage to a specific stage or advance it by 1. Then you will be able to run the workflow on the opportunity to advance it. -- Christopher Co...

Business Portal for GP 9.0 and WSS/MOSS 2007?
Hi, I think I know the answer to this but need something official. If we are running Dynamics GP 9.0 and therefore BusinessPortal 3.0 (is that right?) we have to be running WSS 2.0 or SPS 2003. Correct? Can GP 9.0/BP 3.0 run under WSS 3.0 or MOSS 2007? Will it run? Is it a supported configuration? Alan Alan, Thanks for using the newsgroups. You are correct. GP 9.0/BP 3.0 is only compatible with WSS 2.0 and SPS 2003. GP 10.0/BP 4.0 is compatible with MOSS 2007 and WSS 3.0. In terms of SharePoint, these are our only supported configurations. Thanks Rob -- Rob Bernhardt Softwa...

Home Business -- Whatever the Mind can Conceive & Believe the Mind will Achieve Start your own home Business : ...

how do I get rid of microsift office small business 2007?
how do I get rid of microsift office small business 2007? Throw it in the garbage or the incinator. Describe exactly what ,how and why in detail -- Peter Please Reply to Newsgroup for the benefit of others Requests for assistance by email can not and will not be acknowledged. "waltond" <> wrote in message > how do I get rid of microsift office small business 2007? Uninstall it. -- JoAnn Paules MVP Microsoft [Publisher]...

Look up #4
In column A, I have different languages, such as English, Spanish etc... These languages appear several times. In column B, I have another list of languages. Now what I want to be able to do is, create a dropdown menu in a new worksheet with all the languages in column A listed in this menu. Now, when I choose a language from the dropdown menu, such as English, I want a list of all the languages which appear in column B next to English. I'd like these two appear in a dropdown menu too. Does that make sense? It's kinda like two interactive dropdown menus, with what is selected in the f...

Outlook 2003 Signature #4
WHen I go to send a new email, reply or forward and email the paragraph characters are showing up in my signature. How do I change it so that these do not show up? It just started yesterday. Thanks Cntr+shift+* --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, asked: | WHen I go to send a new email, reply or forward and email the | paragraph characters are showing up in my signature. How do I change | it so th...

Deposits in Money Small Business.
Currently I select payment received for all invoices I bill which creates a deposit entry in my register. The problem is when I download my banks transaction only one entry is specified for the Deposit entry from the bank. How do I combine multiple deposits to match the banks download deposit entry? How do I tell money which deposit transactions to add to match the deposit? I have tried to use "Change" during the matching but that doesn't give me any help and doesn't list the deposit entries? I'm currently using delete to get rid of the deposit entry but the transact...

How do I set the form # for business cards in publisher 2000
I have created a business card in Publisher 2000. when I go to print it the only option I get is to select is 2"x 3 1/2" business card. That is the correct size but it does not print properly on Avery 8873 template. I cannot find where it will let me select Avery 8873 template. All business cards are created equal in Publisher 2000 if you are creating 10 per sheet. Page setup, Special Size, Business Cards. When you are ready to print, File, Print, Page Options, Click custom options, Side Margin .75 Top Margin .5 Zero Gaps. -- Mary Sauer "ChuckP...

issues with giving wrong IP address for DNS
I have been plagued by a single server in the west that has had trouble sending email to an external client. The telnet tests worked fine, the connections from everywhere else work fine, but, it appears that the public DNS server of was giving bad IP address information. The domain name we were sending to (MX record) has not changed in 11 months, but the DNS query was pointing at the wrong IP address. I removed all FORWARDERS in SBS 08, restarted the transport services, and email works fine now... I've never had problems with before. Just thought I ...

business portal tables
Howdy there kind folks. I need to track down the tables in the Dynamics database that hold all the purchase order information. Particularly the bits that deal with transferring a purchase request to a purchase order. i started looking but theres just too many. I know all the requisition ones start with reqmgmt. Sadly the purchase order ones dont seem to follow this idea. many thanks. they are not in the Dynamics database, the purchase order tables are contained in the company database (like TWO) and they begin with POP the POP10xxx series are the work tables you should be looking at. ...

How do I change my business name in Money 2007?
I installed Money 2007 and initially put in a business name that I'm trying to change now. I click on Business, and I go to Account settings and I change the name there. This changes it everywhere except for on the invoices that I print. The template's placeholder for <<company name>> is still putting what I had originally put in there. Where do I change this!? Any information would be greatly appreciated. Thanks! How about in the Invoice Designer that gets installed along with M2007? -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http...