Verifying WIP

GP 10.0
GP Manufacturing Order Processing

I am looking at the Work in Process SmartList (SmartList>Manufacturing>Work 
in Process).  I want to see get a WIP cost report by item.

Once I get my SL configured, how can I take an item and verify the 
quantities and cost in WIP (via SQL or other)?

Thanks, as always, in advance.

-- 
Jim Lines
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist
0
2/3/2009 6:41:02 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
472 Views

Similar Articles

[PageSpeed] 26

You can look at WIP work order by work order but not item by item.  What is 
the difference?  You can issue a work order to make 100 pieces and put costs 
into wip but you don't know whether you will produce 10 pieces, 90 pieces, 
100, or 110 pieces until the work order is closed.  There are scrap factors, 
yeilds, et cetera to be considered depending on your type of manufacturing.  
Then you have cost variances.

Now the Variance Inquiry (manufacturing->Inquiry->MO->Variance) will show 
you how much money has been placed into WIP for each MO, how much has been 
taken out so far, and how much remains in WIP for the MO.

The sum of these figures for each OPEN work order should equal WIP.

What are you trying to achieve exactly?

-- 
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



"Jim Lines" wrote:

> GP 10.0
> GP Manufacturing Order Processing
> 
> I am looking at the Work in Process SmartList (SmartList>Manufacturing>Work 
> in Process).  I want to see get a WIP cost report by item.
> 
> Once I get my SL configured, how can I take an item and verify the 
> quantities and cost in WIP (via SQL or other)?
> 
> Thanks, as always, in advance.
> 
> -- 
> Jim Lines
> Sr. Microsoft Dynamics GP Applications Consultant
> Certified Microsoft Dynamics GP Specialist
0
info4071 (3004)
2/4/2009 3:42:01 AM
Is it possible to report Historically on WIP in GP?  If not, what options are 
out there?

"Richard Whaley -- MVP 2006-2008" wrote:

> You can look at WIP work order by work order but not item by item.  What is 
> the difference?  You can issue a work order to make 100 pieces and put costs 
> into wip but you don't know whether you will produce 10 pieces, 90 pieces, 
> 100, or 110 pieces until the work order is closed.  There are scrap factors, 
> yeilds, et cetera to be considered depending on your type of manufacturing.  
> Then you have cost variances.
> 
> Now the Variance Inquiry (manufacturing->Inquiry->MO->Variance) will show 
> you how much money has been placed into WIP for each MO, how much has been 
> taken out so far, and how much remains in WIP for the MO.
> 
> The sum of these figures for each OPEN work order should equal WIP.
> 
> What are you trying to achieve exactly?
> 
> -- 
> 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
> 
> 
> 
> "Jim Lines" wrote:
> 
> > GP 10.0
> > GP Manufacturing Order Processing
> > 
> > I am looking at the Work in Process SmartList (SmartList>Manufacturing>Work 
> > in Process).  I want to see get a WIP cost report by item.
> > 
> > Once I get my SL configured, how can I take an item and verify the 
> > quantities and cost in WIP (via SQL or other)?
> > 
> > Thanks, as always, in advance.
> > 
> > -- 
> > Jim Lines
> > Sr. Microsoft Dynamics GP Applications Consultant
> > Certified Microsoft Dynamics GP Specialist
0
rpatey1 (3)
3/12/2009 3:36:34 PM
Reply:

Similar Artilces:

Exchange 2003 Sp1: How verify when a mail enters the user mailbox?
Hello, I have a domain with windows 2003 exchange 2003 sp1 configured to have all the mailboxes inside it. Sometimes a user says that a mail he was waiting for have not arrived but the tracking center says me that it was delivered, but the user doesn't see it. How Can I verify the mailbox to see if the mail was delivered and where it is? Thanks in advance for help Lorenzo Ivaldi On Fri, 09 Dec 2005 10:54:40 +0100, Lorenzo Ivaldi <lorenzo.ivaldi@gmail.com> wrote: >Hello, I have a domain with windows 2003 exchange 2003 sp1 configured to > have all the mailboxes inside...

verify contact mailing address
Hello, Until recently whenever I eneter a mailing address in a contact outlook 2007 would throw up a small dialog asking me to verify the structure of the address. This was very usefull as we often do searches by post (zip) code or county (state) etc. This seems to have stopped! Is there any way I can turn it back on? Did that make sense? Stuart 1. Open any new or existing contact. 2. Click the button for the Home, Business or Other address. 3. Check the box for "Show this again when address is incomplete or unclear." -- Sue Mosher, Outlook MVP Author o...

What causes cost diff to hit WIP?
We use 9.0 with Manufacturing Quick MO's. Normally when we have qty overrides an auto post to GL for cost differences hits inventory and our offset inventory account. This past week, we noticed that instead of hitting the offset inventory account, the difference is hitting our WIP account. We checked all item cards and none have the WIP account as an offset. The GL code begins with IVA and this is the first time it has happened....thanks Sevral things actually.... If you are on standard cost and do not have variance accounts setup (or the WIP account is listed as the variance accou...

Verify User-Group Level Password
Hi, I'm looking for some VBA code that will enable me to verify if the password entered in a textbox control on a startup form matches the User-Group Level Password so that the user is allowed to have access to the Database window (hidden at startup). If the password is wrong, the database window stays hidden. Anyone can help? Thanks in advance! On Thu, 28 Feb 2008 05:14:02 -0800, Gaetan <Gaetan@discussions.microsoft.com> wrote: What do you mean with "User-Group Level Password"? Are you talking about workgroup-level security? -Tom. >Hi, > >I'm lookin...

Unable to create the required MAPI profile. Please verify that you have sufficient permissions to write to the MAPISVC.INF file
Hi, I have two Exchange Servers in the Organisation and I cannot migrate mailboxes from the Exch2000 server to the new Exch2003 server. When i try i get the above message. I have checked the permissions on the file and they are; Administrators FULL CONTROL Auth Users READ SYSTEM FULL CONTROL Any help would be appreciated. Sean http://support.microsoft.com/?id=316792 Verify that you have all the required permissions in the "move mailbox" section. On Fri, 31 Dec 2004 07:41:06 +0800, "Sean Christmass" <seancATmanjimup.wa.gov.au> wrote: >Hi, > >I ha...

COGS/WIP distribution(s) does not equal the actual amount
This error (Article# 934281) had been reported in March 2007. Has anyone found a solution to this (MS/GP is "still investigating it")? I am adding more & more projects to the list of ones "stuck" where I cannot properly invoice them or recognize revenue to clear out WIP. GP fixed it in previous versions, but not version 9 yet --- I'm willing to work with someone to resolve it if it'll help. ...

Mfg WIP Material Balance
I am trying to provide support for the GL balance at a given date for the WIP Material account. The problem with this is that there does not appear to be a way to get this information using an 'as of date'. I have not found a date field in the relevant tables (Ex. MOP1000, MOP1002) that would work. I can easily calculate the remaining WIP Material Balance by MO number, but not as of a certain date. Has anyone come up with a solution or is it just not possible? ...

Excel should have a function to verify the check digit on UPC num.
Standard UPC are 12 digits long. The last digit is a check digit based on the previous 11 digits. It would be nice if you could have a function that checked the accuracy of the UPC entered in a cell. Bernard Liengme answered that one in August 2004. Here's Google's archive link: http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_thread/thread/749b4736e2e89eed/4e7ebfb311cbcad4?q=upc+check+digit+group:*excel*&_done=%2Fgroups%3Fq%3Dupc+check+digit+group:*excel*%26start%3D0%26safe%3Dimages%26lr%3D%26hl%3Den%26&_doneTitle=Back+to+Search&&d#4e7ebfb3...

Manufacturing WIP sheets
I am struggling to find a report that will list the components, lot number qty still in WIP by each MO. This is a report we use at year end, physical inventory and our auditors use to verify our WIP. I cant find a report and also cant find the correct tables needed to produce this in Crystal Reports. Can anyone direct me to a report, or the SQL tables I can use for a crystal report? thanks! -- Doug One of the problems with such a report is the form of the items in WIP. For some firms, when part A is issued to WIP it is easily identified as that part through the entire manufacturin...

Money 2005 Passport
Word to the wise. DO NOT WASTE YOUR TIME WITH TECH SUPPORT. If you are having trouble getting your "sign-in information verified," AKA your .NET passport is not working to log into Microsoft Money its not going to work. I was literally on the line with tech support for over 2 hours trying to figure this out and i have found numerous forums on how this is a problem. Dont get me wrong, I originally bought Microsoft Money because I was impressed with the older version that my roommate was using, but 2005 has too many problems. It has to do with XP SP2. If you are going to p...

SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST
I need to count a total for a series of text vales and multiply that by a number that appears in a a corresponding cell in an array of text. The multiplying number is always relative to the text. Also not sure if it affect things but the Text is derived from data verified drop down list. eg: COL 1 COL2 COL3 COL 4 MEL 2 ADE 3 MEL 1 MEL 2 SYD 3 SYD 1 I need a formula that would return the following counts for the example above; MEL = 5 ADE = 3 SYD = 4 Try =SUMIF(A2:C5,"MEL",B2:D5) HTH Bob "F...

Verify if Acct # that is on wksheet is on another
I have a main worksheet with all available accounts. I want to see if there are accounts on my other worksheets that are already on my main worksheet. Thanks, -- Donna Easy enough using Edit>Find and set Look in: option to "Workbook" But what do want to do if you find a duplicate? Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 13:40:01 -0800, Donna <Donna@discussions.microsoft.com> wrote: >I have a main worksheet with all available accounts. I want to see if there >are accounts on my other worksheets that are already on my main worksheet. > >Thanks, ...

please verify that your username & password are correct... try your call again.
Keep getting this message, but I've already verified that my username and password are correct...what do i do now? In microsoft.public.money, suzanne wrote: >Keep getting this message, but I've already verified that >my username and password are correct...what do i do now? Starting some version of Money? Downloading transactions from a particular financial institution? If the latter, sometimes the FI is having a temporary problem with the server. ...

WIP report by routing sequence
I would like to be able to see the total amount of inventory at each routing step linked to my BOM, including the total labor and material cost associated with it (WIP). We have multiple MOs open in varying degrees of completion, many of which will be at the same routing sequence. Is there a way to create a report that would sum the values for all open MOs at all routing steps in the BOM? -- The best laid plans ... ...

SOLUTION: Unable to logon to the server. Please verify that server name, port, account name, and password are all correct.
If you are receiving the following error from Exchange Server Migration Wizard I a the solution that worked for me after digging and digging and not able to find the problem. ERROR: Verify that server name, port, account name, and password are all correct. I was hung up this problem.... Go to the Exchange 5.5 server Exchange Administrator, go to Protocols / LDAP and check the port number. Mine had been changed from 389 (default) to 390. I probably did it but missed this completely looking through the problem, certainly didn't know the solution of specifying LDAP server port in the wizar...

WIP Labor
There are smartlists for WIP Material, showing amount issued and then consumed. I am trying to find the same for WIP labor but am struggling a bit. Can anyone suggest a way to see WIP labor and how much has been consumed? Thanks! -- Doug Doug, Depending on what you want to see..... If you want to see WIP labor applied to a specific MO, Inquiry->Manufacturing->Manufacturing Orders->Variance Inquiry. Look at the labor applied to the job and drill down to get details. If you want to see labor for the week, Transactions->Manufacturing->WIP->DC Summary (I think, Im...

Verifying Reporting Services Installation
Hello all We have just finished installing CRM following the steps in the Implementation Guide. The last section in the chapter is to verify the installation. The first part is to verify the CRM Server installation by typing http://localhost:5555 in a browser window; this works fine. The second part is to verify the Reporting Services installation by opening CRM (as above) and clicking REPORTS under Workplace > My Work. Now, when I do this, I get a message window that says: "Error - An error has occurred. For more information, contact your system administrator." I don't ...

Verifying IMF Version
Hi all, Can someone please tell me how to verify what version of IMF I am rumming on exchange 2003. I have applied SP2 but I am told I may need to remove IMF version 1 before version 2 will install. Is this correct and if so can you point me to a link describing how to uninstal version 1 and install version 2 Many Thanks -- Vince Yes IMF v1 should have been un-installed before applying SP2: http://www.exchangeinbox.com/articles/017/imfproblems.htm#v1onsp2 Do you see an IMF uninstall in the Add/Remove programs? If yes try to uninstall from there. Otherwise you can re-install IMF v1 and...

Verifying Public Folder Replication is complete
Is there a way to verify public folder replication is 100% done between a new Exchange 2003 server and an older Exchange 2000 server before removing the Exchange 2000 server (according to the appropriate ms kb article)? Sorry - the reason I'm asking is that I'm testing E2K to E2K3 migration and I finally got PF replication partially? working. After a day of replication - the counts/sizes don't look the same from ESM and the pub1.edb and pub1.stm don't look the same on both servers (on E2K3 the pub1.stm is larger than the E2K pub1.stm). The public folder hierarchy looks...

IC-Verify and POS
I have found where RMS works with IC-Verify, does POS? If it does how is it integrated? First Data refuses to work with us since we didn't buy MS POS directly from them even though we are a First Data Customer. I am searching for another solution. I am hoping IC-Verify will work. Thanks, Do you have dsl at your business? If you do you do not need IC verify you can run Credit cards thru the pos and gift cards to thru Valutec. First Data should be able to give you a spec sheet on how to set up If you need my help just email. If you want to switch to a better processor Call Jim D...

reading and verifying digital certificate
Friends, How to read the key to digital sign your data and later to validate the digitally sign data. for that sake we need to first extract private key and public key from the digital certificate. Please advice how to proceed. Regards, Vivek ...

Verify Domain User account SPN error
Does anybody have any ideas where to look to solve the following error installing crm 3.0? "Verify Domain User account SPN for the Microsoft CRM ASP.NET Application Pool account." I hadsimilar errors. You need the SetSPN tool from the windows server registry kit. http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/setspn-o.asp has the tool. Then you need to register accounts in Active Directory. Good luck. took me like a week of searching trhough newsgroups to get my upgrade working. Perhaps you could also post the exact setspn commands you used. I have the ...

Trouble using Static Driver Verifier
Hi I'm trying to run Static Driver Verifier, which comes with the WDK, on one of the samples. I am following the instructions in "Quick Start: Using SDV to Find Defects in Drivers", which is part of the WDK help. I am using the driver in tools\sdv\samples\kmdf\fail_driver1\driver When I try to run SDV on the driver's library files, via the "staticdv /lib" command, I get the following error: C:\WinDDK\7600.16385.0\tools\sdv\samples\fail_drivers\kmdf\fail_driver1\driver>s taticdv /lib ----------------------------------------------------------...

How to verify a dll file shared by multi-programs?
Hello all: I know that a dynamic-link library can be shared by multi-program,I want to verify this fact,how to do?Thanks very much. On Jul 5, 2:30 am, "Lee Tow" <f...@pub3.fz.fj.cn> wrote: > Hello all: > I know that a dynamic-link library can be shared by multi-program,I want > to verify this fact,how to do?Thanks very much. Dont know exactly what you are looking for. You can use the same DLL in multiple projects(compile/link). At run time the DLL will be loaded in each of these processes. --- Ajay "Lee Tow" <fbjlt@pub3.fz.fj.cn> wrote ...

Crystal Reports Logon Error: Please verify that you have enough Crystal licenses
Argh! I'm searching and searching for a solution to this wretched problem. Scenario: I have a fresh installation of MS CRM 1.0. Everything seems to be working, but for the Reports, which give the error above when a CRM user tries to branch into a specific Report area. In the Event (Application) Log I get: Source: Microsoft CRM Category: None EventID: 2 Error: Unable to access crystal; check to see if you have enough licenses: Unable to log into crystal; check to see if you have enough licenses. In the Event (System) Log I get: Source: DCOM Category: None EventID: 10002 Access ...