Item Resource Planning and the IV00102 Table

Hello:

Even though the minimum order quantity field is in the IV00102 table, this 
field is not in GP 10.0's Item Resource Planning window like it was in GP 9.0.

Why is that, and where can this field be found in GP 10.0?

childofthe1980s
0
6/9/2009 8:05:02 PM
greatplains 29623 articles. 6 followers. Follow

3 Replies
1493 Views

Similar Articles

[PageSpeed] 30

Hello,

In GP10.0, Minimum Order QTY is stored in IV00103 which is Item Vendor 
Master table. IV00102 though has the field that looks to inherit from GP9.0, 
but doesnt look to be updating in GP10.0 for IV00102. The Minimu Order QTY 
field in IV00103 get updated from Vendors Screen in 
Cards=>Inventory=>Vendors=>Minimum Order


Thanks
Janakiram M.P.
MCP-GP



"childofthe1980s" wrote:

> Hello:
> 
> Even though the minimum order quantity field is in the IV00102 table, this 
> field is not in GP 10.0's Item Resource Planning window like it was in GP 9.0.
> 
> Why is that, and where can this field be found in GP 10.0?
> 
> childofthe1980s
0
janakirammp (688)
6/9/2009 9:29:01 PM
Thanks, Janakiram!!!

childofthe1980s

"Janakiram M.P." wrote:

> Hello,
> 
> In GP10.0, Minimum Order QTY is stored in IV00103 which is Item Vendor 
> Master table. IV00102 though has the field that looks to inherit from GP9.0, 
> but doesnt look to be updating in GP10.0 for IV00102. The Minimu Order QTY 
> field in IV00103 get updated from Vendors Screen in 
> Cards=>Inventory=>Vendors=>Minimum Order
> 
> 
> Thanks
> Janakiram M.P.
> MCP-GP
> 
> 
> 
> "childofthe1980s" wrote:
> 
> > Hello:
> > 
> > Even though the minimum order quantity field is in the IV00102 table, this 
> > field is not in GP 10.0's Item Resource Planning window like it was in GP 9.0.
> > 
> > Why is that, and where can this field be found in GP 10.0?
> > 
> > childofthe1980s
0
6/9/2009 11:47:01 PM
Im looking at the Item Resource Planning Maintenance window on V10 and the 
field you mention is in the bottom left in the box labeled Order Quantity 
Modifiers.  It is disabled ONLY if the Order Policy is Use PO Gen.

This is the company wide all vendor order minumum.  The order minimum in the 
vendor item record allows a minimum order to be set for that one vendor only. 
 For example, the firm may not want to order less than 12 normally.  However, 
one vendor may have lousy pricing if less than 24 pieces are ordered.  Thus 
that vendor's order minimum would be set to 24.
-- 
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at 
http://www.AccoladePublications.com



"childofthe1980s" wrote:

> Thanks, Janakiram!!!
> 
> childofthe1980s
> 
> "Janakiram M.P." wrote:
> 
> > Hello,
> > 
> > In GP10.0, Minimum Order QTY is stored in IV00103 which is Item Vendor 
> > Master table. IV00102 though has the field that looks to inherit from GP9.0, 
> > but doesnt look to be updating in GP10.0 for IV00102. The Minimu Order QTY 
> > field in IV00103 get updated from Vendors Screen in 
> > Cards=>Inventory=>Vendors=>Minimum Order
> > 
> > 
> > Thanks
> > Janakiram M.P.
> > MCP-GP
> > 
> > 
> > 
> > "childofthe1980s" wrote:
> > 
> > > Hello:
> > > 
> > > Even though the minimum order quantity field is in the IV00102 table, this 
> > > field is not in GP 10.0's Item Resource Planning window like it was in GP 9.0.
> > > 
> > > Why is that, and where can this field be found in GP 10.0?
> > > 
> > > childofthe1980s
0
info4071 (3004)
6/12/2009 4:41:01 AM
Reply:

Similar Artilces:

adding a new item to existing matrix in rms 2.0
how come when you add an item to an existhing matrix non of the information is being forward from the main matrix (ex. supplier, price, cost, reorder #, barcode format, etc.) even the size, color, and 3rd dimention that you entered to the new item is not being fowarded. what is going on with 2.0 thank jack I think the Matrix is still is a little buggy.. Get all hotfixed up and see if the helps. There have been 3 for 2.0 hotfixes already. "jack" <jack@discussions.microsoft.com> wrote in message news:45CB84DE-B9B1-4DAC-9043-D8120CB44472@microsoft.com... > how come...

Pivot Table Help #3
I have a lot of data that I am trying to analyze with a pivot table and am not sure how to go about it. Columns are (1) District (2) Store # (3) 2003 Score - these are #s or text ("incomplete") (4) 2004 Score - these are #s or text ("incomplete") For each district, I am trying to find out 3 things: (1) % of stores incomplete (2) Average score for 2003 & 2004 - I've got this one working properly (3) % change between 2003 & 2004 I can successfully analyze the data in a spreadsheet but there is too much to go through and thought a pivot table was the way to ...

item look up #3
a customer is having an issue. he scans an item in the pos screen and all details show up. but when he tries to look for it later he cant find it. hes tried it in manager too. he would usse name, or barcode, or anything and still nothing. do we know what the problem is? Thanks If the item is set as inactive (in the item properties) it will not show up in the Find screen, but will scan in at the POS. You can turn off the find option, but I think it is easier to use one of the SOM reports to find the item, such as the price report. The item will show up in any report that includes it as...

Using Matrix Items
Someone...want to tell me how or if I can default which item is first (selected) when a matrix item is scanned? Is there a way to set this up? -- Thank You Vince :) What are the dimensions you use? Rob "Vince" <Nagarra@yahoo.com.(donotspam)> wrote in message news:E001F1F0-3002-4E1B-8E75-8E62FC6EC01C@microsoft.com... > Someone...want to tell me how or if I can default which item is first > (selected) when a matrix item is scanned? Is there a way to set this up? > -- > Thank You > Vince :) Using Lot Matrix, what I have is a six pack of coke or a sin...

SBS 2008 Fax Sent Items Not showing all faxes sent
Hello, I need to allow sent faxes to be seen by all users. I have Windows XP and Windows 7 64bit client machines. Currently they can only see their sent faxes. In SBS 2003 they were able to see all sent faxes. Any suggestions? Could you create an Outlook rule based on the fax sent acknowledgement that copied the fax to a public folder? "RodSoh" <RodSoh@discussions.microsoft.com> wrote in message news:A4541A0E-18C2-4A83-A13D-8E7D045C29E8@microsoft.com... > Hello, > > I need to allow sent faxes to be seen by all users. I have Windows XP...

Subtract colums in pivot table
I have a pivot table that has the following characteristics (Excel 2007): -rows (down the left) are values: "# Employees", "Total Pay" -Columns (across top) are Dates I want to calculate the difference between different date columns. Example: I have: Date 5/23/2010 5/16/2010 5/24/2009 Total # Emp 10 15 5 30 Pay 1000 15000 500 16500 I'd like: Date 5/23/2010 5/16/2010 5/24/2009 Total Vs. Last Wk % Change Vs. Last Yr % Change # Emp 10 15 5 30 -5 -33% 5 33% Pay 1000 5000 250 6250 -4000 -80% 750 15% Can anyone tell me how to cre...

I don't have 'as items arrive' option
I have the 5 minute synch option, which works great. But I do not have the 'as items arrive' option. Yes, I am running a MSFP version, I checked the build. Man I am so close to gettting this to work. Please help. Thanks, On Mon, 2 Apr 2007 12:42:00 -0700, MidMOman <MidMOman@discussions.microsoft.com> wrote: >I have the 5 minute synch option, which works great. >But I do not have the 'as items arrive' option. >Yes, I am running a MSFP version, I checked the build. >Man I am so close to gettting this to work. > >Please help. Thanks, You are either mist...

How to substitute for a non-existing column in a joined table
Hi, Is there a simpler way than a UNION to return a default value of a joined table for which a corresponding row does not exist? The following example (not a working one, of course) illustrates what I'm after. I'd like to return 'N/A' as c2name if there is no matching row in t2 SELECT t1.c1 (CASE t2.t1pk WHEN NULL THEN 'N/A' ELSE t2.name END) AS c2name, FROM t1 LEFT JOIN t2 ON t2.t1pk = t1.pk Thanks. On 2010-04-21 21:05, bob wrote: > Is there a simpler way than a UNION to return a default value of a joined > table for which a ...

entering multiple costs for an item
I am very new to Retail Management, and am trying to enter inventory, and create a purchase order. I can't figure out how to enter various costs for the same item from the same supplier. For example, when we purchase in lots of 50 pcs., the item cost is .50 per item (total cost of 25.00). However, if we purchase in lots of 100 pcs, the item cost is .47 per item (total cost of 47.00). We can also purchase the item in boxes of 10 (5.50 per box for a cost of .55 per item). How can I enter these costs so when I place a purchase order, the cost will be correct according to the quant...

Resource = rcreport. Error = 2109
I am using MS Money 2007 Deluxe on Windows XP Professional. All patches and updates are current on the machine. My MS Money file is 57,800KB. I have 5 customized reports, until just recently all custom reports worked, now the account balances (customized) and the account balances (standard) report will not load and the custom report returns the error in the subject line. I have made back up copies and done a standard repair to the file and reset all report to default settings and the account balances still will not load. Any suggestions? v/r Dave I am having the same problem. I...

Pull Data From Multiple Tables ????
Hi I will have 4 tables name "TblCostomers","TblVendors","TblAccounts", TblExpenses" Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers" in source. This form has two TxtBox Control name "TxtAccountNo" and "TxtAccountName" If User enters a Account No., It pulls the Account Name from Any One of these Table. I can do this if I have only one table. But tell me how can i do it while I have 4 tables for One Field of a table Thank you.. -- Message posted via AccessMonster.com http://...

Renaming table in a dB
Is there a short way in which i can modify all references to a table after i rename it? Or would i have to open every query and form and manually change the table references?Thanksramesh Access doesn't provide a way to do this.There are commercial products that do, e.g.: http://www.speedferret.com/-- Allen Browne - Microsoft MVP. Perth, Western AustraliaTips for Access users - http://allenbrowne.com/tips.htmlReply to group, rather than allenbrowne at mvps dot org."Ramesh" <ramesh2020@gmaildotcom> wrote in messagenews:uGgN$EuZHHA.4000@TK2MSFTNGP02.phx.gbl...> Is the...

Auditing Mailbox item access
Don't ask me why I am asking, you don't want to know....but Is it possible to monitor and log access not only to a mailbox, but actually to individual items within the mailbox and be able to trace it back to the specific item and user who accessed it? I am aware of the ability to log when a non-primary account logs into a mailbox, but that is not granular enough for the scenario I need to look into. The powers that be want to be able to see not only who accessed a particular mailbox, but actually who accessed a particular message within that mailbox. Just wanted to know if...

Tying tables to forms
I have four connected tables that work well as table input but when I put them in a form some of the fields will not let me make entries. Does this happen because I am using the Id fields and subsequent data from the wrong tables? -- Taylor It sounds like you have created a non-updatable form. One cautionary note first: Don't tie your forms directly to the tables. Use queries instead. The queries will act as a stop light for which data is written and when. If more than one person tries to make a change to the same record at the same time, you will run into problems. From wha...

Dummy series and data table
Hi, I have a chart that presents 2005, 2006, 2007 summary data as a column chart and then 2007 by month as a line. To show the yearly data I have a yearly category, after which I have individual months where the yearly data is zero - sort of like a dummy series - because I only have one value for them. The 2007 detailed data has zero in the yearly column but all the individual values in the monthly columns. It worked fine until I was asked to add a data table to the chart. Now, since it has 2007 twice - once as the summarized for the year and the other as all these individual months - some us...

Sumif across a table
I am looking for a function that works using a =sumif function to add things that are not in a range that are next to each other as seen below the letters in () are the columns that the values are in... so I am looking for a sum in column A "X" of the total work out time if the appl column is "Y" total work Running (D) Walking (F) Elliptical (H) out time (C) Appl (D) Time (E) Appl (F) Time (G) Appl (H) Time (I) X Y 20 N 0 Y ...

Add items to SupplierList
I just imported a new catalog of items to our database using EMS import, were newly insterted and some were updated. The problem I'm having is getting the supplier cost to update for the items that were in already and adding the new items to the supplierlist table. I imported the SupplierID to the Item table just can't figure out the query to go the other way updating and adding new. Any help would be great. You need to use T-SQL in the management studio. Use an InnerJoin of the supplier id to the item id and set the cost to = supplier cost if it is the most recent. "Do...

Aging report table for accounts receivable
Can somebody tell me what is the table for a/r aging..I want to make query/view in sql server 2005 Michael, You need to use RM20101 and RM10201 tables. You need to use date functions to get the aging for your view based on document date or due date field. If your aging is setup to be by Doc Date, Consider Doc Date and If it is due date, you should be taking it by Due Date. -- Thanks Janakiram M.P. MCP-GP http://janakirammp.blogspot.com "Michael@nyresume.com" wrote: > Can somebody tell me what is the table for a/r aging..I want to make > query/view in sql server 2005...

getting consolidate list of "follow up" items
Dear All, I would like to get a consolidated list of items (sent and received mails)that have matured - i.e. whose follow up time is up. I have the habit of tagging a sent mail (after actually sending) for follow up. Similarly, mails received are also tagged for my further action (for follow up). Would appreciate a consolidated follow up report generation way - rather that opening each folder and looking for mature items (i.e. red). Thanks in advance. Sanjay ...

Pivot table
Can I develop a formula that I can add to those which you pick from whe using the wizard ie sum, average, min, max etc Specifically, I want to add an IF statement to give me a 'flag' i which to summarize the data with elsewhere. The data behind the pivo changes (sales data) and I am trying to flag new customers that hav never worked with us before.....once they have traded with us then the dissappear as they are now an old customer To -- Message posted from http://www.ExcelForum.com Hi no you can't do this -- Regards Frank Kabel Frankfurt, Germany > Can I develop a for...

401k Tracking Without Itemized Details
My 401k does not give me an itemized listing of investments. Instead it lists them by investment type as follows. Type Shares Price Market Value Company Owned Stock 1000 65 65000 Equity Units 150 300 45000 Common Assets 250 1 250 I do know what the company owned stock is given it is who I work for. With each quarterly statement it updates the inform...

pivot tables #3
I am trying to change the order in how the tables display. I don't want an accending or decending alpha order as it is set up now. I would like to pick and choose how I want them listed. How do I change the order? ...

pivot table, How to add 1 column
I just need to add one column only but pivot table create another one? I thinkc because I have a column with 2 parameters. I can turn on / off with the field drop down menu How can I get around with this problem? Thanks Daniel ...

Changing icon for list item
Hi all, I would like to change the icon for the first column of the list control in report view. Right now, the method I used is remove the LVITEM at that location and reinsert at the exact same place with a different icon. I know this is not efficient compared to directly changing the icon. I had tried GetItem adn SetItem but even though i specified a different icon using the index into the imagelist, it still won't change. Could someone please enblighten me on this? thank you very much. Hallo Lonewolf! > I would like to change the icon for the first column of the list &...

delete dupl from 1 table that match table 2
I have 2 tables joined by an acct # but diff data in the 2 other columns. I want to delete the row of information from table A that have a matching acct # in table b. ie: appl acct # amount (table a) appl acct # amount (table b) b 1234 $1.00 b 1234 $5.00 c 111 $1.00 c 12345 $5.00 c 1001 $2.00 c 1001 $3.00 want to delete rows from table a. for accts #1234 & #1001 DELETE [Table A].[Acct #] ...