Item 'Last Ordered' Field updates inappropriately

The 'Last Ordered' field updates when I transfer inventory out.  This is not 
good.  If I want to know the last time I bought an item, the date of the most 
recent transfer does not help - especially if it was an inter-store transfer 
out.

Ideally, separate fields for 'Last Transferred In' and Last Transferred Out' 
could be added as separate fields.  This would reserve the 'Last Ordered' 
field for the last time the item was actually ordered from a supplier.

Alternately, and better thant the present system, the field could simply 
update with purchase orders ONLY and not transfer orders.

Tom

----------------
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 this 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=66ab3c6a-68dc-4838-aeea-015a83fb0c63&dg=microsoft.public.pos
0
tomg2938 (389)
8/18/2006 8:20:02 PM
pos 14173 articles. 0 followers. Follow

0 Replies
391 Views

Similar Articles

[PageSpeed] 2

Reply:

Similar Artilces:

dictionary->(item, item, item); Can dictionary point to an array in VBA?
Is it possible to have a dictionary object point to an simple array? Can you do something like that in code? Dim oDict as new Scripting.Dictionary oDict.Add "key_value", Array("foo", "bar") Tim "cate" <catebekensail@yahoo.com> wrote in message news:9f4b847e-eba7-487c-ac86-749d217dcc7e@b30g2000yqd.googlegroups.com... > Is it possible to have a dictionary object point to an simple array? > > Can you do something like that in code? ...

rev level in item inquiry
We need to be able to see the rev level of the part in the item inquiry screen. It would just link to the revision level field in the item engineering data screen. Currently a user with only inquiry access can not see what revision a part is supposed to be. ---------------- 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 this link to open the suggestion in the Microsoft Web-based Newsreader and then click &...

Listbox Delete multiple items
Hello. I'm trying to create a vba routine to delete items from a listbox. This is a multiselect listbox and what is happening is that i select several items and the code only removes the first item. When the first item is deleted, all of the other selected items became unselected. I post the code i'm using bellow. Can anyone give me a hint on this issue? Thanks, Luis Private Sub RemoveItem_btn_Click() If Listbox_1.ListIndex = -1 Then Exit Sub For i = Listbox_1.ListCount - 1 To 0 Step -1 If Listbox_1.Selected(i) Then Listbox_1.Remove...

Field Format
I have a column of name data in the format of "First Name Last Name". Does anyone have a script that will change all the entries in this column to "Last Name, First Name" ? suggest copy name list to a blank workbook follow the steps then paste name list back into original list One option without using a macro is to parse the text to column using space as the delimiter then use a formula ro recombine them in the format required then copy formulas & special paste values example cell a1 entry equals LastName Firstname pased data becoms b1 entry Lastnmae c1 entry...

Sent Items issue
When i send an email they sit in the outbox instead of going to my sent items folder. The items that are in my sent items folder cannot be moved or deleted as it comes up with an error. Any help would be appreciated. Thank. T On Thu, 20 Jan 2005 06:41:04 -0800, ctdude wrote: > When i send an email they sit in the outbox instead of going to my sent items > folder. The items that are in my sent items folder cannot be moved or deleted > as it comes up with an error. Any help would be appreciated. Thank. What version of Outlook? What sort of mail account(s)? What is the error th...

Item
Item needs to have more customer fields. Some countries require both an Inc and Ex Cost of each item. Ib Ivan, What are Inc and Ex costs and are you asking for more custom fields or do you really mean customer fields? -- * "Ivan Brebner" <ibrebner@premiumretail.com.au> wrote in message news:Oo9hLB4%23FHA.2524@TK2MSFTNGP10.phx.gbl... Item needs to have more customer fields. Some countries require both an Inc and Ex Cost of each item. Ib In places like Australia retailers prefer to see the cost of an item including tax as well as Excluding. So that quoting ite...

Query
I have crated a parameter query where I have a last name field and a first name field from the same table, and want them strung together to be shown like this Doe, John. Does anyone know how to accomplish this? In query design view enter this is an empty field "block": FullName: [Last Name] & ", " & [First Name] In SQL view SELECT [Last Name] & ", " & [First Name] as FullName FROM SomeTable John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County OceanBreeze wrote...

item created date for copied items
We create 2 new product catalogs every year with hundreds of new items. To make data entry easier for our users, we use the Copy function. Unfortunately, the Created Date is not updated for the NEW item (it uses the copied item's created date). Also, this NEW item is not listed in Activity Tracking. It would be great if Created Date was the actual create date, even if the NEW item was copied off an old item. It is important for us to run reports off Created Date. It is also important for us to see who created the NEW item in case there are data entry errors. Thank you. -----...

Three items, column and line chart
I have data for the quarter that looks like this: PRODUCT LINE Jan Forecast Jan Actual Jan % of Fcst PERSONALIZED IMPACTCARDS 2,921,347 2,017,000 69% I would like a bar chart to show (in bars) the forecast and actual, and a secondary axes as the %. Is this possible? I've done a chart with Forecast and % forecast, but really need the actual bar. TIA, Carole O Hi Carole - Easier than you might think. Make a column chart using all three series of data. Select the % series, then choose Chart Type from the Chart menu, and select Line. Then double click on this line, ...

Act! Import Field Names
Howdy, This is quite possibly the wrong area but I'm working on a project involving Act! and need the field names it uses for importing and exporting data. The names such as "LastName", "Address01", etc... Would anyone be able to provide the full list? I'll apologize ahead of time if this is not the correct place to ask. Thanks! you might want to download the data migration tool, it comes with couple excel documents that have all the fields layout. I have the excel document, if you want, send me an email and I will email it to you. The name for the doc is: &...

Change size of field on dialog
I just forgot how to change the width of a CEdit on a dialog. Would somebody help me? If you mean changing it dynamically, you can use SetWindowPos on the control after subclassing it. The easier way is to do it in resource editor(just drag the corners to desired size). -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "JackRnl" <Hccnet@Runit.Scarlet.nl> wrote in message news:bh081l$35k$1@news.hccnet.nl... > I just forgot how to change the width of a CEdit on a dialog. > Would somebody help me? > > How to obtain the 'original' position? In fact I want ...

Getting rid of old updates
When microsoft installs a new update, why do they not take out the old ones and how do I know which updates I can delete from my computer? I have tons of them! -- freakydi Have a look at this article. It may be relevant to your prºblem. Save Space After Installing Updates <http://www3.telus.net/dandemar/spack.htm> Another link that may be of interest - <http://www.pctipsbox.com/clearing-out-space-on-your-parents-system-hard-drive> hope that helps! -=- "freakydi" wrote: > When microsoft installs a new update, why do th...

copy item cost to supplier cost field
I have customer that has an item cost in each item, but has no cost in supplier tab. Is there a sql statement that will copy the item cost into the supplier cost field? Thanks for the help Dave here it is ************************** UPDATE Supplierlist set SupplierList.Cost=Item.Cost FROM Item WHERE Item.ID=SupplierList.ItemID --AND Item.SupplierID=SupplierList.SupplierID ************************** if u execute it as it is, it will update the cost for primary suppliers only, if u remove the comment (--) from the last line, it will update the cost for all the item's suppliers (primary &...

Degault global address book not updating
We're having problems getting users to show up in the GAL on Exchange 2003. (Before going further, we're using Outlook 2003 but NOT in cached mode, so it shouldn't be a problem with the offline address book). The clues are few and far between: our default RUP is set to filter just on (mailnickname=*): this is the system generated RUP, so can't be edited. (This might be the wrong track, but is LDAP case sensitive ? Looking at ADSIedit, no-one has a "mailnickname" attribute- it's "mailNickname". Tiny difference, but is this a possibility ?). The ot...

item picture
Is there a way to get an items picture on a report? I use the item price list report and export it to HTML to get my items on my web page. This works fine, however I would like to include the items picture also but I don't see that as a field to include on the report. Is anyone doing this or know of a way to do this? Thanks, Craig You could add the Item.PictureName field to the report. Search the newsgroup and you should find several recent examples of adding a column to a report. This isn't going to be much help though as this is only going to include the Filename of the ...

Other Items Bought with a particular item
Hi all- Extensive heavy-duty user of RMS and regular custom-creator of reports, but can't seem to find a way to manage this one. I have item XYZ and I've identified it as not a highly profitable item, but possibly an item that my customers purchase alongside other higher margin products. The item has hundreds of movements in the Movement History report. How can I run a report to show either: a.) The total sales ticket value of all transactions which include XYZ item. -or- b.) A list of other items (along with cost and sold price) which were purchased over a set period along ...

if all items in listbox are the same
access 2003 On form f018ContrPerf is have a listbox called lstUnitType(multiselect=none). How can I determine if all items in listbox are the same? ie all ST or all IT... If they are the same then Me.f018ContrPerfDetails.Form.optHP.Visible = True Me.f018ContrPerfDetails.Form.FrameElem_Label.Visible = True -- deb On Fri, 23 Apr 2010 10:38:01 -0700, deb <deb@discussions.microsoft.com> wrote: >access 2003 > >On form f018ContrPerf is have a listbox called lstUnitType(multiselect=none). > >How can I determine if all items in listbox are the same? ...

Items not in sent items folder
I am running Outlook 2000 and when trying to email directly from Word using File --> Send --> as Attachment, the email goes through, but does not show up in my Sent Items folder. I checked the box in Options to save messages in sent items. Any ideas? ...

Item Serial Numbers for Matrixed Items
Hello all: I have a question regarding serial numbers for matrixed items. I would like to set up an item, and then include a matrix for size, color, length, and still maintain invenotry on each color/sytle combination, and have a serial number for each item. Can anyone provide details as to how to best accomplish this. Thanks Victor Example: Style:FANA01 this comes in: Red, Green, Yellow and each color has small, med, large. Each item has a serial number. Create the item using the New Item Wizard as a matrix item. At the end of the wizard select "Edit this item" On t...

Set policies for items archivation on Exchange
Hi, it's posibble to set policies for AutoArchive? Eg. where to save old items from outlook, which folders should be archived and the age of items? Or should can it be done using GPO? Thanks, Jozef Izso. On Tue, 28 Nov 2006 02:53:02 -0800, Jozef Izso <jozef.izso@nospam.postalias> wrote: >Hi, > >it's posibble to set policies for AutoArchive? Eg. where to save old items >from outlook, which folders should be archived and the age of items? > >Or should can it be done using GPO? Yes, I believe you can set this with the outlook adm using a GPO. > > &g...

Smartlist Builder-Calculated field
I am building a smartlist, using hte IV00102 table so I can get Order Policy, replenishment Method, etc. In the table of course it uses numbers to designate, for example the order policy: 1=not planned 2=Lotforlot etc. I would like a calculated field in smartlist builder to change the 1 into 'NotPlanned' and 2 into 'LotforLot' I create a calcualted field: If Orderpolicy=1 then 'NotPLanned' else if Orderpolicy=2 then 'LotForLot' But I get not results, how do I get smartlist builder to have a column (word) instead of a number for older policy? thanks! -...

Update Field with value from another Table
How to I update a description text field on a form with the description from another table based on an Item Number selected from a combo list? The two tables are joined on the Item Number. I tried to an update query in the after-update event on the combo box but it does not work. CurrentDb.Execute "UPDATE tblMetalUsage LEFT JOIN tblWireTubingSheet" _ & " ON tblMetalUsage.ItemNo = tblWireTubingSheet.ItemNo" _ & " SET tblMetalUsage.Description = [tblWireTubingSheet]![WireDesc]" _ & " WHERE '" & Me.cmbItemNo.Value & "'...

Embedded Barcode Items Receiving
Is there any way to do a physical inventory or receiving in Store Ops on embedded coded items? When scanning into either of the above, since it is reading the whole barcode - says item does not exist. Does anyone out there do this or have a suggestion of how to accomplish? ...

Trendlines
Does anyone know if there is a limit to Excel's capability to accurate portray a 6th order polynomial trend line? I have obtained a formulae for a series of noisy data and got a nice 6th order polynomial curve with an equation. I have then used this formulae and plugged in the same x values and the graph apprears to exponentially increase after some time and not come back down as the previous graph showed. Any help would be greatly appreciated. Regards Jonathan Civil Engineer. The most likely explanation is precision. How many decimal places are you showing in the Trendline equa...

Line Item comments in SOP Transaction in Sales Line Item Smartlist
The Sales Line Item smartlist, comment fields (Comment 1, Comment 2...) seems to be picking up comment from the transaction level comment text rather than line item comment text entered in Sales Item detail entry screen. Seems illogical to me. It should pick comment text from Line item details rather than transaction level comments. Any Ideas? What version? It seems fine in 8.0. VG "Samit" wrote: > The Sales Line Item smartlist, comment fields (Comment 1, Comment 2...) > seems to be picking up comment from the transaction level comment text > rather than line item com...