cost of Inventory at a past date...? In RMS 2.0

Hi,

Does anyone figured out a way of knowing what the invntory was on Dec 31 
2009?

I can't find a report that would give me that info.

RMS 2.0

Thanks,

Sacha



0
Sacha
5/21/2010 2:41:40 PM
pos 14173 articles. 0 followers. Follow

1 Replies
913 Views

Similar Articles

[PageSpeed] 52

This is a multi-part message in MIME format.

------=_NextPart_000_0062_01CAF8F0.C2C6D310
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Sacha,

Check with Ryan @ RITE rsakry@rite.us as they have a custom report. =
www.rite.us

--=20

Jeff=20
Check Point Software

Search this newsgroup -- http://tinyurl.com/2lmk4w  (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D


  "Sacha Favelevic" <sacha@chiacgocashregister.com> wrote in message =
news:O0DCAPP%23KHA.5848@TK2MSFTNGP06.phx.gbl...
  Hi,

  Does anyone figured out a way of knowing what the invntory was on Dec =
31=20
  2009?

  I can't find a report that would give me that info.

  RMS 2.0

  Thanks,

  Sacha



------=_NextPart_000_0062_01CAF8F0.C2C6D310
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3DWindows-1252 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000>Sacha,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Check with Ryan @ RITE <A=20
title=3D"mailto:ryan@rite.us&#10;CTRL + Click to follow link"=20
href=3D"mailto:rsakry@rite.us">rsakry@rite.us</A> as they have a custom =
report. <A=20
href=3D"http://www.rite.us">www.rite.us</A></FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>Search this newsgroup -- <A=20
title=3D"http://tinyurl.com/2lmk4w&#10;CTRL + Click to follow link"=20
href=3D"http://tinyurl.com/2lmk4w">http://tinyurl.com/2lmk4w</A>&nbsp; =
(Stolen=20
from =
DRS)<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #008000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
  <DIV>"Sacha Favelevic" &lt;<A=20
  =
href=3D"mailto:sacha@chiacgocashregister.com">sacha@chiacgocashregister.c=
om</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:O0DCAPP%23KHA.5848@TK2MSFTNGP06.phx.gbl">news:O0DCAPP%23KHA.=
5848@TK2MSFTNGP06.phx.gbl</A>...</DIV>Hi,<BR><BR>Does=20
  anyone figured out a way of knowing what the invntory was on Dec 31=20
  <BR>2009?<BR><BR>I can't find a report that would give me that=20
  info.<BR><BR>RMS=20
2.0<BR><BR>Thanks,<BR><BR>Sacha<BR><BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0062_01CAF8F0.C2C6D310--

0
Jeff
5/21/2010 9:20:27 PM
Reply:

Similar Artilces:

Macro for Autofiltering certain dates
Code below: Summary per month is in column A, the month and year are in columns B and C respectively. in row 1 (columns H and I) I have the =DATE function to say what month it is. Using these variables I wish to autofilter the A:C column data for the latest month so I can present the latest column A number. I need the data criteria to check the latest A:C data has been imported for that month. Sub Macro3() ' Dim Retail Dim Retailtest Set Retail = Workbooks.Open("N:\mis\EXCEL\EoM\DW-Reports \Retailfigure.csv") Set Retailtest = Workbooks.Open("N:\mis\EX...

Bcc field #2
I've lost the email fanclublist of our site (http://www.conniekennie.nl). All I can do is look if I can read the bcc-field of a previous email. Is there a way to see the email addresses in this field (with a little tiny program perhaps)? Can someone help me? Please! Thank you in advance, Ed Rosman http://www.ed-rosman.nl http://www.conniekennie.nl are they messages you sent as BCC? If so, you can see the list on the message in the Sent folder. if someone BCCd you, you can't see the list of who was BCCd. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in ...

2 Workflows
I need to create a workflow that, when a field is populated in one entity, will create an Alert prompt to the user as a reminder that they need to edit a field on another entity. And I would also like to know how to create a workflow that will, when a field is populated in one entity, create a new record for another (related) entity. Is this possible? Thank you very much. On Aug 17, 6:49=A0am, Bernardina <d...@discussions.microsoft.com> wrote: > I need to create a workflow that, when a field is populated in one entity= , > will create an Alert prompt to the user as a reminde...

Formula for calculating # of days between dates minus a particular date if present
I'm trying to create a formula that will calculate the number of days between two dates automatically subtracting a day(s) from the equation if a specified date(s) falls in between the two dates. For example, I don't want 1/15/04 to register as a counted day. If I enter the dates 1/1/04 in one cell and 1/12/04 in another cell then it's a straight foward DATEDIF equation. But if I enter 1/1/04 and 1/28/04, then I want the formula to figure out the number of days between 1/1 and 1/28 automatically subtracting 1/15 from the equation. This gets trickier as I need some calucations th...

rounddown with date calc?
I'm trying to determine the number of years someone has on the job. I'm using this formula - =DATEDIF(B7,TODAY(),"m")/12. This gives me a result of 13.92, how can I round down this calculatio to 13.0? If I remove the decimals...it rounds up to 14 - which is an error. Thanx -- Ltat42 ----------------------------------------------------------------------- Ltat42a's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2473 View this thread: http://www.excelforum.com/showthread.php?threadid=49837 Ltat42a schreef: > I'm trying to determine the n...

Planning to Upgrade Great Plains eEnterprise 6.0 to version 9.0
Hi Planning to upgrade from version eenterprise 6.0 running on SQL7.0 to Dynamics 9.0 on SQL 2005 anyone has done it? if so please post. Thx We have done it several times already. We can do it for you. inquire@flogility.com "Plam-Admin" wrote: > Hi Planning to upgrade from version eenterprise 6.0 running on SQL7.0 to > Dynamics 9.0 on SQL 2005 anyone has done it? if so please post. > > Thx Plam, I have done upgrades from 6. to 9.0 Tips: Always print reports before and after each version upgraded and compare. Backup the Reports Dictionary. Create a package file...

Conditional Format Tracker by Date
I'm building a tracker to make sure paperwork is done on time. Headers: A:Name B:IDNum C:Phone D:StartDate E:Plan F:Paperwork G:30DAuth H:90DAuth I'd like to use conditional formatting to compare the dates and color the cells for easier tracking. The compare TO date is column D. In column E, we have 7 days to write the plan so if there is no date in that column, turn red. When a date is entered turn green if within 7 days but yellow if it's past 7 days. In column F, same as column E but only 3 days for that one. (I can figure that out if I get a w...

Date.
I notice that when I put a date and drag the little square in the bottom right of the cell to adjacent cells, the other cells will have a date increment by one day. However, how do I do this when the cell is not adjacent and far apart? Another question, If I have two cell that are not adjacent and I want to add the date (9-23-04) for the beginning of the week which is Monday and the date for the end of the week which is sunday, How do I do this with 7 days range but within only two 2 cells? Thanks Hi use a formula such as =A1+7 and copy this formula >-----Original Message----- ...

Graph With 2 Sources
Is there a way to create a graph which gets it's source data from 2+ worksheets? Each worksheet charts the same kind of data. The x-axis length does vary but I don't mind manually entering the cell references. Look at Charting Data From Different Sheets: http://peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html You can't put data from different sheets into the values for a single series. My question for you: if you don't mind manually entering cell references, why haven't you just linked cells in a third worksheet to the cells in the first two, and pl...

paste charts into powerpoint-misalignment
i have an excel program which pastes excel charts into powerpoint. on certain excel charts ( i paste the entire page) the page that i wish to paste into ppt, consists of graphs as well as pictures on the same sheet. When I paste it into powerpoint via vba code, the pictures (not the charts) seem to come misaligned. they shift to the left on the powerpoint slide. do you have an idea what might be causing this misalignment. ...

email recovery #2
i just recently reformated my computer to the extentent of no lossage of files on my computer. everything was retained except the files. my isp said they should be still on my computer but dont know the extension to the files. i was wondering how i could recover these files. my os is win xp,office 2000, outlook 2000. outlook 2000 email, contacts, calendar, .etc is stored in a file with *.pst extension. default location is in a hidden directory under one of the following locations. \documents and settings\<userid>\application data\microsoft\outlook \documents and settings\<u...

Exchange tabs missing on 2 other 2003 DC's
I have a simple question (I hope) I used to have a 2000 GC with exchange 2000 on it. I have now moved to a 2003 domain and have migrated to Exchange 2003. This is all on 1 server, and I know "now" that having the GC on the Exchange server is not a good idea (but we all make due on a limited budget). I have just recently added 2 DC in a hope to move the GC off of the exchange server. Here is my question: Why are the Exchange tabs missing from the 2 other DC’s? I was under the impression that I did not have to install the Exchange management tools on the other DC’s. If this...

Outlook Client Error #2
I have one user that is receiving the following error after installing the CRM 4.0 Outlook client. "Your server administrator has limited the number of items you can open simultaneously. Try closing messages or removing attachments and images from unsent messages you are composing." This happens after using Outlook for a few minutes. If I remove the client the error will stop appearing. She is using Outlook 2007 on windows XP. I have applied Hotfix kb970944 and all applicable updates to Outlook. The user dose have a large amount of emails in her inbox, but I have other u...

Outlook slow saving attachments to nt 4.0 server
After upgrading to Windows XP Professional, Outlook 2000 is extremely slow in saving attachments to a Windows nt 4.0 server with Service Pack 6.0a. All service packs and updates were installed in both Outlook and Windows XP. Any suggestions?? Ben Horwich ...

vba copyright protection #2
I have created a spreadsheet which utilizes many of my own custom built macros and formulas. Does anyone know whether or not my vba code and/or formulas can be copyrighted--ie legally protected? thanks, Bill --- Message posted from http://www.ExcelForum.com/ ...

2 copies of every new e-mail!
I asked my computer guru to make sure my e-mail goes to my desktop PC and my laptop. That seems to be working, but now I am getting 2 copies of every e-mail in my inbox Can somone tell me how to turn this off so I only receive one copy of each e-mail? On 30 Apr 2004 10:06, "Mark" <anonymous@discussions.microsoft.com> wrote: >I asked my computer guru to make sure my e-mail goes to my desktop PC >and my laptop. That seems to be working, but now I am getting 2 copies >of every e-mail in my inbox. > >Can somone tell me how to turn this off so I only receive one...

Calculating age from two date fields-Excel 2003
I'm not sure what section this question should go in. I need to find if a person was 40 years of age or older (= or >) at his Date of Hire. I have two columns, Birth Date and Date of Hire. How would I write a formula to give me this answer? Thanks in advance Try this: A1 = DOB B1 = DOH =DATEDIF(A1,B1,"y")>=40 That will return either TRUE or FALSE -- Biff Microsoft Excel MVP "Veteran of the Software Cycles" <VeteranoftheSoftwareCycles@discussions.microsoft.com> wrote in message news:97B155B5-68F0-49EB-910C-549B84737765@microsoft.com... > I...

Inventory issues in GP
Dear all, The following are some of my challenges in Great Plains. Some of the stocks received and posted into GP are not available for use. * Inventory enquiry for some stock is giving incorrect balances. * A stock item used for a kit and posted to an invoice is not reflecting on the inventory balance for some items. * At times no document description will be found for an item allocated even when an item enquiry indicates Allocated. * When stock transfer for project is posted it does not reflects on the item enquiry. * An item already transferred for proje...

Add buttons for Center Across and Paste Formula
It would be very helpful if the Customize Toolbars funtion gave access to buttons for Center Across and Paste Formulas so you don't have to a) traverse through menus or drop-downs, or b) create macros and custom buttons to accomplish these oft-used features. I get tired of always having to create macros on each system I work on in order to set up custom buttons that accomplish these simple tasks. ---------------- 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 i...

If Then Statements #2
Need help. Need to turn the following into a formula within Excel. If B19>45 then A19 If B19>=45 but <100 then B19*A20 If B19>=100 but <300 then B19*A21 Thanks, Hi try =IF(B19>=100,IF(B19<300,B19*A21,"not defined"),IF(B19>=45,B19*A20,A19)) I assumed that your first condition should read B19<45 -- Regards Frank Kabel Frankfurt, Germany mh4568 wrote: > Need help. Need to turn the following into a formula within Excel. > > If B19>45 then A19 > If B19>=45 but <100 then B19*A20 > If B19>=100 but <300 then B19*A21 > >...

Pivot Table percentages #2
I have created a pivot table that is running off some data that looks like this (simplified version): Name Accept Decline Joe 1 0 Mary 1 0 Fred 0 1 The pivot table then counts these columns to give the total number of accepts and declines (on 2 seperate lines). Is there a way within the pivot table to represent the declines as a percentage of the accepts? I've tried using the % of Row and % of Column, but I can't find a way of doing it as a percentage of a different column/row. I have...

Service STORE is falling #2
Hello to All, I need a help with the problem that is happening with our server of exchange 5.5 and windows NT 4.0. The problem that is happening is that suddenly the service of STORE falls, seeking the mistake that is happening found the following note of MS that I am enclosing, only that we already sought and we didn't get to find a program to be accessing some of the mentioned doors. Did this problem happen please already with you or you know what can be? Regards, Lincoln Rollin Backup and apply SP4 and post-SP hot-fixes. Lincoln Rollin wrote: > Hell...

CRM Sales for Outlook 1.2
Hi! We are using mscrm 1.2 successfully for a while now (no mail router, no outlook client). Now we tried to integrate it into our exchange environment using the outlook client. Online is working fine but the offline functionality isn't working. Obviously the local msde- database is not getting any data. The error message is: "Metadata-Cache error, No entity!" The log says: MSCRM Platform Error Report: ---------------------------------------------------------- ---------------------------------------------- Error: Exception from HRESULT: 0x80040E00. Error Message: Exception...

due dates #7
thanks again you've made my life easier now if I could only type -- canman ------------------------------------------------------------------------ canman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14596 View this thread: http://www.excelforum.com/showthread.php?threadid=262235 You're welcome ! > now if I could only type but why type ? <g> .. when you could always do a copy and paste direct from the posting to the target cell(s) / dialog box(es) (but you would need to watch out for any line breaks in the pasted formulas - especially l...

Dynamic Charting By Dates
This is in reference to Jon Peltier's article on dyamic charts. http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246 My question is the example given is using data that goes down a column. Column A is the dates, Column B is the data, ect... My data flows across rows, so all my dates are in row 1 and the data is in row2. I would like some help converting Mr. Peltiers technique to fit my need. This code needs to go across a row instead of down a column. =OFFSET(AllDates,MATCH(StartDate,AllDates,1)-1,0,MATCH(EndDate,AllDates,1)-MATCH(StartDate,AllDates,1)+1,1) As well as...