Hope someone can help me with this.
I am trying to create an integration into RM. The source file I have
contains the Goods and the Tax nominal accounts and values. These will
always be credits.
The system I am integrating from has no concept of Debtors Control, so
effectively the source file I have only has the Credit amounts, no Debit
The Debtors Control (Receivables) will always be the same account, and the
value will be the full invoice value that appears in my header record.
I can't see a way to use the source file I have to get the Credit amounts
in, and...IF statement #17
I want to have a formula in a cell A3 that looks at cells A1 and A2.
If the values in cells A1 and A2 are the same, then return a zero in cell A3
If the values are different, return that value (the difference) in cell A3.
Is that possible?
>If the values are different, return that
>value (the difference) in cell A3.
The difference of what? A1 minus A2 or A2 minus A1?
Take your pick:
Microsoft Excel MVP
"sloman" <email@example.com> wrote in message
Is it possible to get the originating currency on a Statement?
Can you give more info on which statement you want the originating
currency. To the best of my knowledge any report you print in GP will
be printed in functinal/originating currency only.
On Sep 28, 6:08=A0pm, Toni <T...@discussions.microsoft.com> wrote:
> Is it possible to get the originating currency on a Statement?
Print Receivables Statements.
> Can you give more info on which statement you want the originating...Count on Iif Statement in Access to Case Statement
What is the SQL Case Statement equivalent to the following SQL expression in
Thanks for any help.
Count(IIf([HourCreated]=7,0)) AS 7
>> Count(IIf([HourCreated]=7,0)) AS 7 <<
None; you cannot name a data element 7 without using quoted
identifiers. I think you might want:
COUNT(NULLIF(creation_hr, 7)) AS seven
case when HourCreated = 7 then 0 else null end AS 
But you seem to be missing the "false" value so I've used Null above.
"Qaspec" <Qaspec@discussions.microsoft.com> wrote in message
news:CAA1B9F8-87D...Excel Help with IF statements
I have 3 cells which i named
One, Two, Three & Four
They all have 7 IF functions.
I need a way to put all 7 together and output to cell S29 using
master IF statement... Any ideas..
alexm999's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=491
View this thread: http://www.excelforum.com/showthread.php?threadid=39031
Be more specific.
> I have 3 cells which i named
> One, Two, Three & Four
> They all have 7 IF functions.
>...if/then statement that results in Yes/No
I want either a Yes or No given this if/then statement:
If cell A1 is greater than x AND cell B1 is greater than Y, then YES
otherwise NO. AND, the sum of A1+B1 must be greater than z. All conditions
must be met. How do I do this?
Message posted via http://www.officekb.com
( My real mail address: arvil<at>tarkon.ee )
"Patty via OfficeKB.com" <forum@OfficeKB.com> wrote in message
>I want either a Yes or No given this if/then statement:
> If cell A1 is ...Smart List Builder
I am building a smart list query that needs to link my customtable to the RM
Open and RM History - how to you link that?
Right now I just have the RM Open linked to my main table and the RM Apply
Open linked to my RM Open. I need to have the RM History and RM Apply
When i first created the smart list, i just have the RM Open and RM Apply
Open. works grea. But then i added RM History linked to my table, then i get
nothing, so i took RM History off, so kind of back to square one.
The reason is, the transactions I am looking at are linked/related to the
cash receipts entry wind...Using an if statement to display an array
Is it possible to use an if statement to return an array? I have
named two arrays and would like to display either based on a value
from another sheet. Using a macro would not help me, just due to the
fact I was told not to use a macro by my boss for this spreadsheet.
Here is what I have....
So far the only thing that is displayed is the heading of the array.
Is there a way to display the heading and the contents?
"Gun_Maddie" <firstname.lastname@example.org...Averaging with and if statement
I'm trying to create an average from a table with multiple records in it that
I identified as "originated by". I only want my form to show the averages of
certain records (originated by = continuous improvements"). Right now ALL
the records are being averaged with the Control Source: =Avg(
[NumberofDaystoClose]). I'm trying to add the criteria that only those
records identified as "continuous improvement" records should be averaged. I
don't know Access very well at all. I assume I need to add some type of If,
or When statement to that expression...Sutiability of RM
Would microsoft retail manger be suitable for running a resaurant (one-site,
3-floors, 2 kitchens) or is it really designed for shops?
No it is not suitable for Restaurants.
>Would microsoft retail manger be suitable for running a
>3-floors, 2 kitchens) or is it really designed for shops?
"bwillia" <email@example.com> wrote in message
> Would microsoft retail manger be suitable for running a resaurant
Dont no if this will help - but here's goes.
I am doing an assignment at uni, which involves building a model o
excel and then doing a report.
What I am having difficulty with is that you have to convert currenc
into dollars - which is the only problem I having. You had to import
database with all the data on which I have done and then import
conversion table from the msn website - which I have also done. What
dont understand is that the book which we are using has the assignmen
more or less in but isnt good on the idea I need. Its says you creat
an IF statement to convert the curren...RM Tools
I have used RM Tools, and its cousins, on systems with the Pervasive database.
Is there an equivalent for use with Great Plains v 7.5 on SQL?
If I can get the name, I can probably find it on Customersource. (hopefully)
Thanks in advance
Lyle they are called Backoffice tools or the Professional Tools Library.
Unfortunately they are not available for Pervasive.
<firstname.lastname@example.org> wrote in message
>I have used RM Tools, and its cousins, on systems with the Pervasive
> Is there an equivalent for use with...Help with an SQL statement please!
I could really use some help with this one! I need an SQL statement that
will insert a second supplier into the item properties of over 16,000 items-
the entire contents of the Item table. This second supplier is to be the
primary supplier with a reorder number thats the same as the item lookup code
and a cost price of zero. I'm not too sure how to proceed as I think we're
talking the SupplierList table and the Item table. Any advice would be
appreciated! The exact statement would win the provider my eternal gratitude!
> I could really use some help with this ...IF statement help #2
What im trying to do is,
Calculate a Cell x say 0.5. If the result is a negative number, sho
0. If it is a positive number, work it out and show the answer. Jus
tried, and cant seem to get it right for some reason. I dont want t
have to use another cell for no reaon, as I need to present th
This is what I tried, IF((E22*0.5)>0), (E22*0.5),
RudeYute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3295
View this thread: http://www.excelforum.com/showthr...Statement Problem
On a few customers payments and returns have been applied to invoices and
paid in full but are not purging off their statements. Acctg personnel state
that there was a computer issue at the time ??? Anyway, I need to get these
items purged from these customers to give them accurate information. Please
Did their 'Print For' settings in the Print Receivables Statements
window change when they had the 'computer issue'? They should be
selecting 'Exclude Fully Applied Payments' to exclude those documents
from the statement.
MCP-GP, MCT...Link RM to SOP
The payments in RM will only update RM. It will not be able to go back to the
document in SOP.
A quick overview of the SOP cash receipt process looks like you cannot
easily apply payments to more than 1 invoice at a time. This is likely why we
are using the RM module. The 2 modules should easily bring the information
This counters against a total ERP system... the modules should be integrated
thus that each module knows what's happened in the other.
This post is a suggestion for Microsoft, and Microsoft responds...IFF statement
I have a query in the RT field there are records that = 1111111 and 9999999
In LOC_No file I have counted the record that match Zip_codes, Company,RT
If any records = 1111111 and 9999999 I need them to be change to the
..LOC_NO that has the highest number.
SELECT Zip_codes, Company,RT, .LOC_NO
Can I write an iff statement that can do this?
new to acces can anyone help.
I'm a bit confused ... are you saying you have a field ("RT") that can
contain two values at once? If so, be aware that this is frowned on in good
database ...RM Unapply
Ability to Unapply from history A/R transactions that have discounts attached
to them. We have been on GP for over 7 years and this has not been changed,
we utilize the Professional Service Tool RM Unapply and it will not allow
invoices with discounts to be unapplied. This does not make sense, to not
allow just because it has a cash discount.
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 t...Workflow
I am attempting to create Support stages in CRM similar to the Sales stages
that already exist. One issue that I have encountered is as follows:
1. I create a Task for a call to be completed
2. I need to check if this calls is completed
- If completed - Do nothing and leave this workflow rule
- If NOT completed - send an Email every 24 hours to the owner of the
the Task is completed
3. When I create an IF statements I can only check if ANY activities have
been created not specifically if the above Task is completed? This doesn’t
allow me to conditional check the...DLookup within Iif statement
I'm having trouble getting an Iif Statement that includes a Dlookup to work.
Here is what I have but the records where the Iif is true show nothing for
<=#" & [qryNetRevenue].![Loadeddate] & "#"),[tblOrders].[Price])
there is a typo here:
you have both a . and a !
Maybe you need to remove the ! from
If the above doesn't w...Importing bank statement that has a different date format :
Is there a way import a money format statement file that has a different date
format? I use mm-dd-yyyy format in my Money but i would like to import
statements that have the dd-mm-yyyy format! Curretnly i open the file in
notepad and manually change the dates and then import the file into money.
It would be nice to have an option to automate this during the import process!
You could change Control Panel settings before you import and put it back
Microsoft MVP - Money
For UK tips & fixes see
We have a customer that is trying to post an RM Batch. We removed all stuck
sessions and ran a select statement on the sy00500 and found that the status
was Table Updates Interrupted. The batch will not post and is returning an
error message in Batch Recovery - Batch failed to complete posting.
Get/Change Operation on table RM_Keys_Master could not find a record.
Would Checklinks resolve this issue or will it be necessary to rebuild the
RM Keys? If so, is there an automated solution for this? Can't seem to find
anything in Knowledgebase.
Take a good backup...Nested IF(OR(AND) Statement with Two AND Conditions
I am using Excel 2003 and could use some assistance with a complex Nested IF
statement. Here is the criteria:
IF Salesorg=NAW1 AND Salesdivision=N4 AND SalesOffice=NWSA, then Group=UB
except when CustomerNbr=90000000 OR 90000001 OR 90000002, then Group=BA.
I have tried several different variations of Nested IF statements, but to no
avail. I do not know VBA, so this is not an option. Any help you can provide
would be greatly appreciated. Thank you.
A B C D E
1 Salesorg Salesdivision SalesOffice CustomerNbr Group
2 NAW1 ...Stop Downloading Statements in Money 2004
I don't want to download statements in Money 2004. I've tried to find
somewhere to stop this, but everytime I stop the statement downloads, I stop
online bill pay. Is it possible to seperate the two?
I made an income statement using AFA when I print it all the amounts are
zeros any idea why it is showing like this?
thx in advance
Please check the open fiscal year in your Income Statement in AFA and when
generating the IS, make sure you change your user date in line with the
fiscal period you want the IS to cover.
Hope this helps!
Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM, AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator