Low Value Pool assets
Asked By jane jane
08-Feb-10 01:17 AM
Just wondering if any is able to manage low value cost pool items in GP.
From what I know of GP, FA will not be able to manage these items.
You maybe able to set up the low value cost pool but I'm not sure how you
arbitrarily change the depreciation rate from year to year and how you manage
assets that might have been depreciating on a declining/ stright line basis
but then needs to be moved into the cost pool?
Low value cost pool items are a huge requirement for all australian GP
users...
but I'm not sure how you arbitrarily change the depreciation rate from year to year and how you manage assets that
No 123 980 3 Email ID abcdefg ghijklm 4 Product Rate 1 Rate 2 Rate 3 Rate 1 Rate 2 Rate 3 5 Pro 1 1 2 3 10 20 30 Name ABC 2 Contact No 3 Email ID 4 Product Rate 1 Rate 2 Rate 3 5 Pro 1 6 Pro 2 7 Pro 3 XYZ Contact No 123 980 Email ID abcdefg ghijklm Product Rate 1 Rate 2 Rate 3 Rate 1 Rate 2 Rate
when dbo.fgetstcode( sy.stid ) = 'CNV' then isnull(isnull(max(rate.rate), 0) * 0.01 * 0.1 * isnull(max(sy.facevalue), 0 openev.syid and UDCOLID = '10000018') IS NULL begin select max(rate.rate) end else (select convert(decimal(15, 12), (udf.value)) from when dbo.fgetstcode( sy.stid ) = 'STO' then isnull(isnull(max(rate.rate), 0) * 0.1 * 0.01 * isnull(max(sy.facevalue), 0 when dbo.fgetstcode( sy.stid ) = 'CVF' then isnull(isnull(max(rate.rate), 0) * 0.1 * 0.01 * isnull(max(sy.facevalue), 0
is my query its nt working prop. select sum((btea*rate +bsandwitch*rate)) from diet, menu where item_name = 'btea' and item_name = 'sandwitch'; my prob. is oracle cant decide wat rate it shud take. . . . . we r nt gettting th ans dere we multiply in sum function please tel If you have rate as one of the column and if its type is the query Try this query and check ; select sum(btea*rate) + sum(bsandwitch*rate) from diet, menu where item_name = 'btea' and item_name = 'sandwitch'; You same row in the column item_name You should have a rate column separately or from some other table, then try the following query select sum((item_name*rate)) from diet, menu where item_name = 'btea' or item_name = 'sandwitch'; select sum((btea*rate +bsandwitch*rate)) actually what are btea and bsandwitch, i hope this are
update currency price I want to update the currency rate frequently.how to update currecy value.how to update pls op = xServiceFAQ U can use RSS feeds for update currency rate frequently in your site. u can get RSS feed from root element writer.WriteStartElement("Rates"); / / Start an element writer.WriteStartElement("Rate"); / / add sub-elements writer.WriteElementString("Currency", "British Pound"); writer.WriteElementString Exchange", "0.635243"); / / End the item element writer.WriteEndElement(); / / end Rate / / end the root element writer.WriteFullEndElement(); / / Write the XML to ModuleError.ToString()); } } Here is the some site, from which exchange rate data can be extracted. Here is the some site, from which exchange rate data can be extracted. PACIFIC Exchange Rate Service for 242 countries http: / / pacific.commerce.ubc.ca / xr cfm Rates.xml file: "Rates.xml" contains 242 countries exchange rate. But if you look at the countries names they are NET page. <?xml version = "1.0" encoding = "utf-8"?> <Rates> <Rate> <Currency> Andorran Peseta< / Currency> <Exchange> 154.763< / Exchange> < / Rate> <Rate> <Currency> U.A.E. Dirham< / Currency> <Exchange> 3.673
Hi, I have a table of data : affiliate, lenders, pub rate, sales rate, and leads. I want to find top 5 from each want to use SQL language. for example: Affilate Lenders Pub rate sale rate leads Chima A1 2 3 4 Chima A2 3 2 fine. suppose the Tablename is Table1 SELECT affiliate, lenders, [pub rate], [sale rate], leads FROM Table1 WHERE [Pub rate] IN ( SELECT TOP 5 [pub rate] FROM Table1 as S WHERE S.affiliate = Table1.affiliate ORDER
Hi, I have a table of data : affiliate, lenders, pub rate, sales rate, and leads. I want to find top 5 from each want to use SQL language. for example: Affilate Lenders Pub rate sale rate leads Chima A1 2 3 4 Chima A2 3 2 fine. suppose the Tablename is Table1 SELECT affiliate, lenders, [pub rate], [sale rate], leads FROM Table1 WHERE [Pub rate] IN ( SELECT TOP 5 [pub rate] FROM Table1 as S WHERE S.affiliate = Table1.affiliate ORDER
s) that could fetch me these things • The current dollar rate. • The current gold rate. • The current silver rate. I wants to show in asp.net web application Goldy all three functionalities visit the respective sites. The current dollar rate. Simple Currency Converter http: / / www.exchangerate-api.com / asp-net The current gold rate.The current silver rate. Try below links to get Gold and Silver prices : http rates for free http: / / www.ashishblog.com / blog / currency-exchange-rate-in-webpage-using-c-asp-net / Helo suchit I am