RM-Statement

Is it possible to get the originating currency on a Statement?
-- 
Toni
0
Toni1 (87)
9/28/2009 1:08:01 PM
greatplains 29623 articles. 3 followers. Follow

2 Replies
609 Views

Similar Articles

[PageSpeed] 38

Toni

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.

Regards
Reddu

On Sep 28, 6:08=A0pm, Toni <T...@discussions.microsoft.com> wrote:
> Is it possible to get the originating currency on a Statement?
> --
> Toni

0
9/29/2009 5:17:45 AM
Print Receivables Statements.
-- 
Toni


"reddy" wrote:

> Toni
> 
> 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.
> 
> Regards
> Reddu
> 
> On Sep 28, 6:08 pm, Toni <T...@discussions.microsoft.com> wrote:
> > Is it possible to get the originating currency on a Statement?
> > --
> > Toni
> 
> 
0
Toni1 (87)
9/29/2009 5:39:03 PM
Reply:

Similar Artilces:

Integration Manager
Hello 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 amounts. 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
Hello - 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? TIA --- Phil >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: =IF(A1=A2,0,A1-A2) =IF(A1=A2,0,A2-A1) -- Biff Microsoft Excel MVP "sloman" <pmwslo@yahoo.com> wrote in message news:jQiIm.2022$Zu5.442@newsfe24.iad... >...

RM-Statement
Is it possible to get the originating currency on a Statement? -- Toni Toni 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. Regards Reddu On Sep 28, 6:08=A0pm, Toni <T...@discussions.microsoft.com> wrote: > Is it possible to get the originating currency on a Statement? > -- > Toni Print Receivables Statements. -- Toni "reddy" wrote: > Toni > > 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 Access? 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 [7] But you seem to be missing the "false" value so I've used Null above. Tony. "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.. -- alexm99 ----------------------------------------------------------------------- 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. alexm999 Wrote: > 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? Thanks. -- Message posted via http://www.officekb.com Hi =AND(A1>x,B1>y,A1+B1>z) -- Arvi Laanemets ( My real mail address: arvil<at>tarkon.ee ) "Patty via OfficeKB.com" <forum@OfficeKB.com> wrote in message news:524A720A47687@OfficeKB.com... >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 History. 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.... Array 1: Example 1 Bill Art John Array 2: Example 2 Mike Bill Gary {if('sheet1'!$A$1<10,example1,example2)} 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? Thanks "Gun_Maddie" <gun_maddie@excite.co...

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. >-----Original Message----- >Would microsoft retail manger be suitable for running a resaurant (one-site, >3-floors, 2 kitchens) or is it really designed for shops? >. > Try www.dinerware.com "bwillia" <bwillia@discussions.microsoft.com> wrote in message news:4279711C-3D36-4FB9-932C-312A716FB877@microsoft.com... > Would microsoft retail manger be suitable for running a resaurant (o...

Excel
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 Lyle they are called Backoffice tools or the Professional Tools Library. Unfortunately they are not available for Pervasive. HS <someone@nowhere.zz> wrote in message news:cg3fr092hp57t1918qtq9nm4nrk5rh00of@4ax.com... >I have used RM Tools, and its cousins, on systems with the Pervasive >database. > 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! Tara wrote: > I could really use some help with this ...

IF statement help #2
Hi 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 worksheet This is what I tried, IF((E22*0.5)>0), (E22*0.5), Thank -- RudeYut ----------------------------------------------------------------------- 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 advise. 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. Frank Hamelly 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 together seemlessly. This counters against a total ERP system... the modules should be integrated thus that each module knows what's happened in the other. -- Steve Laurenzano K-Rain Mfg ---------------- 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 FROM Table1; Can I write an iff statement that can do this? new to acces can anyone help. thank octet 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 task until 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 this field. IIf([tblOrders].[FreightOnly]=False,[tblOrders].[Price]-DLookUp("Price","tblProductCost","EffectiveDate <=#" & [qryNetRevenue].![Loadeddate] & "#"),[tblOrders].[Price]) Thanks! Walter Walter, there is a typo here: [qryNetRevenue].![Loadeddate] you have both a . and a ! Maybe you need to remove the ! from [qryNetRevenue].![Loadeddate] 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! Thanks VJ You could change Control Panel settings before you import and put it back after! -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;...

RM Keys
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. Thank you! Susan, 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? ...

Income Statement
Hi, 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 Hi Saad, 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! Cheers, 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 "Saad&...