Archive for February 17th, 2013
A client was experiencing an issue recently with how their Standard Cost was rolling up when they specified a ‘Component Fixed Quantity’ in a Manufacturing Bill of Material. The Component Fixed Quantity is used to specify a quantity of component that is ‘fixed’, regardless of the size of the order. An example might be components used in the setup of an operation, but not consumed in the actual production of the finished product. It’s similar to setup labor in a routing. The issue the client had was that the Component Fixed Quantity (CFQ) was being rolled up into the Standard Cost of the product rather than being pro-rated across the production run.
I got an interesting question from one of the GP users requesting a list of unused Journal Number, therefore I decided to scratch my head and write this query, below will help: SELECT DISTINCT NUMBER FROM MASTER..spt_values WHERE NUMBER BETWEEN (SELECT MIN(JRNENTRY) AS FROMNUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND (SELECT MAX(JRNENTRY) AS TONUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND number NOT IN (SELECT DISTINCT JRNENTRY FROM GL20000) Happy tracking…! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo
If there are any SharePoint users who also happen to be my blog readers, please note that we have a SharePoint Conference for Business Users in Atlanta, called SHARE . The above link take you to Wendy Neal’s blog post on her blog SharePointWendy . VAIDY