Item level revision numbers on POs

The Item Engineering info on inventory items in manufacturing includes 
revision numbers for items, however because that info is in the manufacturing 
dictionary we can't include through report writer on POs.

I'd like to develop a routine that would copy the revision number from the 
item engineering table to one of the user-defined tables in inventory.  Any 
suggestions on how to do that?  Or an alternate approach to the problem?
-- 
Jim@TurboChef
0
jim.harris (398)
5/19/2006 3:12:01 PM
greatplains 29623 articles. 6 followers. Follow

6 Replies
582 Views

Similar Articles

[PageSpeed] 37

Jim-

This script will put the current Rev level from Item Engineering into User 
Category 1 on the item master.

update iv00101
set uscatvls_1 = 
isnull((select revisionlevel_i from ivr10015
where iv00101.itemnmbr = ivr10015.itemnmbr),'')


Brenner
-- 
www.KlenzmanConsulting.com


"Jim@TurboChef" wrote:

> The Item Engineering info on inventory items in manufacturing includes 
> revision numbers for items, however because that info is in the manufacturing 
> dictionary we can't include through report writer on POs.
> 
> I'd like to develop a routine that would copy the revision number from the 
> item engineering table to one of the user-defined tables in inventory.  Any 
> suggestions on how to do that?  Or an alternate approach to the problem?
> -- 
> Jim@TurboChef
0
5/19/2006 7:05:03 PM
Please let me know if this works for you.  I've been successful in adding the 
inventory user category to SOP documents, but unsuccessful with POP.
Thanks

"Brenner Klenzman" wrote:

> Jim-
> 
> This script will put the current Rev level from Item Engineering into User 
> Category 1 on the item master.
> 
> update iv00101
> set uscatvls_1 = 
> isnull((select revisionlevel_i from ivr10015
> where iv00101.itemnmbr = ivr10015.itemnmbr),'')
> 
> 
> Brenner
> -- 
> www.KlenzmanConsulting.com
> 
> 
> "Jim@TurboChef" wrote:
> 
> > The Item Engineering info on inventory items in manufacturing includes 
> > revision numbers for items, however because that info is in the manufacturing 
> > dictionary we can't include through report writer on POs.
> > 
> > I'd like to develop a routine that would copy the revision number from the 
> > item engineering table to one of the user-defined tables in inventory.  Any 
> > suggestions on how to do that?  Or an alternate approach to the problem?
> > -- 
> > Jim@TurboChef
0
Erickson (3)
5/20/2006 2:25:01 AM
I've used some Report Writer functions in the past to get some of the
information from various dictionaries.

One approach would be to figure out if the Report Writer function such
as RW_TableHeaderString or RW_TableHeaderCurrency would work for this.
If it does, you can pass the Dictionary ID to it to retrieve the
results. More information on these two functions is on Partner Source.

If that approach doesn't work, you can always add report writer to VBA
and add any field you like. 

Hope this helps. 

Thanks,

VJ

0
rutvijrshah (142)
5/22/2006 9:59:21 PM
------=_NextPart_0001_DDEA97F6
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hello Jim,  

I see you got a couple of different options to try.  Just let us know if 
you need any direction on these because they both look like valid ways to 
try and accomplish this.

Thanks
Keith
MSFT
------=_NextPart_0001_DDEA97F6
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hello Jim,  
\par 
\par I see you got a couple of different options to try.  Just let us know if you need any direction on these because they both look like valid ways to try and accomplish this.
\par 
\par Thanks
\par Keith
\par MSFT
\par }
------=_NextPart_0001_DDEA97F6--

0
kvogel1 (8)
5/25/2006 6:32:59 PM
------=_NextPart_0001_F77AA260
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hello - 

Checking in to see if there is anything else we can do for you on this 
topic.
Please post again at your convenience and we will be here for you.

Have a great week!

Jan Smith

Microsoft Online Partner Support

 

When responding to posts, please "Reply to Group" via your newsreader so 
that others may learn and benefit from your issue.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone 
support at no charge during critical LAN outages or "business down" 
situations. This benefit is available 24 hours a day, 7 days a week to all 
Microsoft technology partners in the United States and Can ada.

 

This and other support options are available here:

BCPS: 
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 

Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

 

If you are outside the United States, please visit our International 
Support page: 
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx. 

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.




------=_NextPart_0001_F77AA260
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hello - 
\par 
\par Checking in to see if there is anything else we can do for you on this topic.
\par Please post again at your convenience and we will be here for you.
\par 
\par Have a great week!
\par 
\par Jan Smith
\par 
\par Microsoft Online Partner Support
\par 
\par  
\par 
\par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
\par 
\par =====================================================
\par 
\par Business-Critical Phone Support (BCPS) provides you with technical phone support at no charge during critical LAN outages or "business down" situations. This benefit is available 24 hours a day, 7 days a week to all Microsoft technology partners in the United States and Can ada.
\par 
\par  
\par 
\par This and other support options are available here:
\par 
\par BCPS: https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 
\par 
\par Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
\par 
\par  
\par 
\par If you are outside the United States, please visit our International Support page: http://support.microsoft.com/default.aspx?scid=%2finternational.aspx. 
\par 
\par =====================================================
\par 
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par 
\par 
\par 
\par 
\par 
\par }
------=_NextPart_0001_F77AA260--

0
jsmit (219)
5/30/2006 5:27:17 PM
------=_NextPart_0001_021A1739
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi there

Anything else we can do for you here on this query?

Please post back at your convenience and we will be here for you.
Thanks again for using the partner newsgroups!

Have a great week!

Jan Smith

Microsoft Online Partner Support

 

When responding to posts, please "Reply to Group" via your newsreader so 
that others may learn and benefit from your issue.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone 
support at no charge during critical LAN outages or "business down" 
situations. This benefit is available 24 hours a day, 7 days a week to all 
Microsoft technology partners in the United States and Can ada.

 

This and other support options are available here:

BCPS: 
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 

Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

 

If you are outside the United States, please visit our International 
Support page: 
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx. 

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.




------=_NextPart_0001_021A1739
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi there
\par 
\par Anything else we can do for you here on this query?
\par 
\par Please post back at your convenience and we will be here for you.
\par Thanks again for using the partner newsgroups!
\par 
\par Have a great week!
\par 
\par Jan Smith
\par 
\par Microsoft Online Partner Support
\par 
\par  
\par 
\par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
\par 
\par =====================================================
\par 
\par Business-Critical Phone Support (BCPS) provides you with technical phone support at no charge during critical LAN outages or "business down" situations. This benefit is available 24 hours a day, 7 days a week to all Microsoft technology partners in the United States and Can ada.
\par 
\par  
\par 
\par This and other support options are available here:
\par 
\par BCPS: https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 
\par 
\par Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
\par 
\par  
\par 
\par If you are outside the United States, please visit our International Support page: http://support.microsoft.com/default.aspx?scid=%2finternational.aspx. 
\par 
\par =====================================================
\par 
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par 
\par 
\par 
\par 
\par 
\par }
------=_NextPart_0001_021A1739--

0
jsmit (219)
6/1/2006 7:11:11 PM
Reply:

Similar Artilces:

How do I make numbers become text?
I am trying to create a spreadsheet where numbers entered in one location become text in another. I tried the Help option, but I am still lost. Please help, and thank you. From earlier postings: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;EN- US;140704& and: (courtesy of a cut and paste from a Tom Ogilvy post): If you want an addin that provides a worksheet function that does this, download Laurent Longre's free morefunc.xll addin found here: http://longre.free.fr/english/ It is downloaded in a zip file which also conta...

Excel
Is there a way to change an imported number such as: 7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you, Be -- Message posted from http://www.ExcelForum.com Ben, Yes you can format the cells containing the 10 digit number to a phone number. Highlight all the required cell and on the Main menu choose Format/Cells/Number/Special/Phone Number Charlie O'Neill >-----Original Message----- >Is there a way to change an imported number such as: > >7042626598 and display it as a phone number like: > >(704) 262-6598 > >? > > >...

Entering A Price into POS
I'm trying figure out a way to automaically take a % off an item and enter the regular price into the input field in POS. In other words, we want to enter a regular priced item at the POS and have the program calculate 50% off the price on the fly. This is for a special item that we have a variety of pricing that need to be keyed in. Jerry, Just to clarify you want to take 50% off an item that you have the system prompting you to enter in the price? -- or -- Are these items prices already set? If so, then you can use the Inventory Wizard in Store Ops Manager to set the Sale Price ...

Applying GPOs based on Operating System Version (item-level targetting)
Hi, we have a Win2003 AD with one server acting as the PDC and a small bunch of GPOs. All clients are running WinXP SP3. The whole network / AD is well working. Our management now wants Windows 7, but only on their computers, we're getting a WinXP/Win7 mixed environment (thanks Boss!). Thus we have to split some GPOs (eg. Folder Redirection, etc.). We could clone each security group, one for XP users/computers and the other for Win7 and apply GPOs only to the correct group but that might not be the best solution. We would like to use the item-level targetting like in dri...

Planning Lead time-Item Vendors Maintenance window
Previously used manufacturing and MRP in v9 and the Planning Lead time on the Item Vendors Maintenance window (bottom left corner), we used to enter 7 for the number of days in 1 week. MRP then suggested to place PO's using these 7 days as one week. Now when we enter 35 for example ( V9 calculated 5 weeks for placing the PO) Now since V10 it looks like it is calculating 7 weeks lead time (35 days divided by 5 days) Did something change with V10 on this field and how MRP uses it with the Request Resolution window? thanks! -- Doug The system now looks at calendars and can conside...

Item level revision numbers on POs
The Item Engineering info on inventory items in manufacturing includes revision numbers for items, however because that info is in the manufacturing dictionary we can't include through report writer on POs. I'd like to develop a routine that would copy the revision number from the item engineering table to one of the user-defined tables in inventory. Any suggestions on how to do that? Or an alternate approach to the problem? -- Jim@TurboChef Jim- This script will put the current Rev level from Item Engineering into User Category 1 on the item master. update iv00101 set usca...

Outlook 98 e-mails not going to sent items.
This is a weird problem from my behalf, when i send an e-mial no matter to who, the e-mail does not go to the sent items folder. Can anyone help out, thank you. Marcel. ...

Purpose of Matrix Item Type
Hello, I have been using RMS for over a year, and have never used the matrix item type, mainly because I do not want an unmanageable number of items. The last POS system I used had sub item matrices for size, color, etc. It seems like RMS just adds more items, right? If so, what is the purpose (usefullness?) of matrices? Other than through a member of the matrix, how do you access information about the matrix? Here's and example of what I want to do. Shoe abc, with widths (M, W), and sizes. Sometimes I care about item abc (sales reporting), and sometimes I care about the mor...

opening sent items archive
Can somebody please tell me how to open the archived sent items file?????? I have found the large achive file but I dont know how to open/retrieve it. There is a sent item back in February that I need to sned again !!!! Many thanks. MKL >-----Original Message----- >Can somebody please tell me how to open the archived sent >items file?????? I have found the large achive file but I >dont know how to open/retrieve it. There is a sent item >back in February that I need to sned again !!!! Many >thanks. MKL >. > This is what i think it is. If you get a me...

making items available on website
Is there a way to 'make items available on the website' other than going into each items properties under the Options Tab and checking the box? I would like to make quite a few items available at one time if possible. Thanks for any help. Craig This is a multi-part message in MIME format. ------=_NextPart_000_0465_01C72051.D97BD680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Craig, Backup first!! This will set _all_ items as available for web sales except those that = are marked inactive. UPDATE Item SET WebItem =...

error numbers
Does anyone know if microsoft has a way to look up errors and their resolution by ERROR NUMBER? I have never found anything like that. Now they have something called "Events and Errors Message Center" but even that doesn't appear to let one look up errors by error number! Thanks Hi, Fredrated schrieb: > Does anyone know if microsoft has a way to look up errors and their > resolution by ERROR NUMBER? > > I have never found anything like that. Now they have something called > "Events and Errors Message Center" but even that doesn't appear to...

Conver Numbers to Log 10
How do I convert column of numbers (n=3000) to log 10 column of numbers? Assuming that your column is column A, one way: In an unused column, enter =LOG(A1) and copy down 3000 cells. Copy the column, choose column A and choose Edit/Paste Special, selecting the Values radio button. In article <0CDE6301-FC9C-488C-9D9F-3AD26B46EFCE@microsoft.com>, "Fishfan" <Fishfan@discussions.microsoft.com> wrote: > How do I convert column of numbers (n=3000) to log 10 column of numbers? ...

What is the maximum number of users that can share Excel File?
According to the Excel Help file, all users on your network, unless you restrict the number. "pfine" wrote: > ...

Open Level 2 files
In Outlook 2002, is there anyway to to open level 2 files from outlook? It is a real PITA to save it, find it, then open it. Thanks. ************************************************ Flip the words on the domain name to send email. ************************************************ http://www.slipstick.com/outlook/esecup/getexe.htm should help you out. AFAIK, no, but reading this page might help. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After searching google.groups.com and finding no answer: Curt Bates <crbates@footbig.com> aske...

warcraft power leveling
�й�warcraft gold <http://www.gamegoldvip2.com/warcraftgold.php>ý������Ϊwarcraft gold��˾��warcraft gold������warcraft gold��ҵ�����ҵ�ṩ����warcraft gold���ӹ���˼���������warcraft guide <http://www.blizforum.com>���Ǽ�warcraft guide�ͻ�������warcraft guideý�壬����warcraft guide��Ӫ��Ϊһ������warcraft leveling <http://www.wowgoldvip.com/world-of-warcraft-power-leveling.asp>��˾���Ϻ�warcraft leveling������warcraft leveling������warcraft leveling���������ҹ�˾������warcraft leveling��˾���Ϻ�warcraft leveling��˾�͹���warcraft leveling��˾��ɽwarcraft power leveling��Ϊ�ο��ṩwarcraft power...

lookup row number
Hi, can you tell me how to lookup the row number of a name in a list. EG say I have a list of names as below: Andrew Mike Steve Ian Paul I would normally just add a column with the row numbers and then lookup the row number in the second column but is it possible to do without adding the extra column by using the row formula someohow? Thanks Hi Michael Try the below.. =MATCH("Mike",A:A,0) -- Jacob (MVP - Excel) "Michael" wrote: > Hi, > can you tell me how to lookup the row number of a name in a list. > > EG say I hav...

Maximum number of bits
I have a requirement to find the maximum number of consecutive zeros in a row in a 32 bit binary number. For example 1111 1111 1111 1000 1111 1111 0000 1111 = 4 1111 1110 1111 1110 1111 1111 1110 1111 = 1 I am actually storing the number in a BIGINT for simplicity. I can do this in a udf with a look fairly easily but was wondering if there is something more sql that will do the job. Cheers, Michael That's an interesting question. Does it include leading zeroes? 0000 0000 0111 1000 1111 1111 0000 1111 = 9? -- Thanks Michael Coles SQL Server MVP ...

Printing to Adobe
I get a runtime error everytime I print an invoice to Adobe 6.0. What's the deal? The invoice prints to the adobe distiller and creates the PDF. However MS Money crashes, sometimes it restarts itself to the sign on location other times, it just closes. Is there a fix? Below is error I get: Program: msmoney.exe R6025 - pure virtual function call I am using: MS Money 2006 Small Business version 15.0.150.513 In microsoft.public.money, Caddant wrote: >I get a runtime error everytime I print an invoice to Adobe 6.0. What's the >deal? The invoice prints to the adobe distiller an...

can one cell contain more than one independent number
A cell can contain several numbers, separated by space characters or line breaks (Alt+Enter). However, if you want to perform calculations on the numbers, it's best to keep them in separate cells. John K wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html there's also the option a using matrix formula (list of data) for example you may enter ={1;2;3} in a single cell or selection 'and validate wih CTRL+SHIFT+ENTER but the manipulation of this kinda of formula need to read more about it... ...

finding common numbers in large lists
Hello, I have two large lists of numbers (on two seperate worksheets). By large, I mean that one list is 1000+ numbers, and the second list is 3000+ numbers (each number is in its own cell). The numbers are of the form: xxxx.xxx (that is, they are precise up to three places after the decimal) 1) Is there some quick way that I can find the numbers that are common to both lists? 2) Is there a way I can find the numbers in common to both lists using only the whole number portion (diregarding what comes after the decimal of each number)? Thanks! Hi see: http://www.cpearson.com/excel/duplic...

creating a multilevel numbering sysem
I'm trying to create a multileve numbering system ex: 100, 100.1, 100.1.1, 100.2, 200, 200.1, 2001.1, 200.2, and so on. I would like to have at least 3-4 tiers under each number that would automatically number. And you want this in Publisher? I don't think so... -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "v" <v@discussions.microsoft.com> wrote in message news:C1F59342-9F2F-4E91-BE27-0BA992EB17BE@microsoft.com... > I'm trying to create a multileve numbering system > ex: 100, 100.1, 100.1.1, ...

extracting numbers from a text field and applying formula
here's my question... i have a cell that has a text field of this type: '9-19' (a-b) I want to create a formula that will subtract 19-9 (b-a) and return the result as a number// can anyone help?! is this even doable? I'd really appreciate it! PS also, i'm very fairly new at excel so a detailed response with th formula would really help! ALe ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Try: =MID(A1,FIND("-",A1)+1,99)-LEFT(A1,FIND("...

Imported Numbers not recognized as numbers
Hi there -- I've seen this problem posted a lot before, however haven't yet seen a solution posted that works for my situation. This applies to Office XP... So I copy a column of data (numbers) from a website and paste it int Excel, but the numbers are not recognized as numeric values (can't su them, etc.) I have tried all of the "easy" solutions -- changing their format t general or number, copying a 1 from another cell in a clean workboo and using the paste special/multiply (or a 0 and paste special/add function...I've tried the text to columns thing -- basicall...

Outlook 2002 level 2 security
Is there a way to change Outlook 2002 so that level 2 files open directly rather than saving to disk first? Specifically, I want to open a .url file from Outlook. I moved .url file extension from level 1 but don't see a way to move it to level 3. Is there a way to accomplish this, maybe a 3rd party utility? Thanks. None that I know of but you can check on http://www.slipstick.com/security/getexe to see if one exists. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After searching google.groups.com and finding no answer: Alfonso ...

Mail Merge with Access Report (with grouping levels)
Hi, I have two tables in Access 2003 with a one-to-many relationship, in an access report the grouping works, how do I make this work in a Word 2003 mail merge? The following are not my tables but an example of what I am trying to achieve, where the relationship is 1 to many from Orders to OrderItems: Table 1 - Orders OrderID Date SalesPerson Table 2 - OrderItems ItemID Description QTY Value *OrderID On the 1 Page word document I want to print display as follows This is your <Order ID> on <Date>. Your Salesperson was <Salesperson>. Here is a list of your Items: <...