Check DMAAIs missing in Chart of Accounts F0901 & F4095

SELECT gm.gmco, gm.gmaid, ml.mlanum, gm.gmobj, gm.gmmcu, gm.gmsub, gm.gmdl01,
       ml.mlobj, ml.mlmcu, ml.mlsub, ml.mldct, ml.mldcto, ml.mlglpt,
       ml.mlcost, gm.gmlda, gm.gmpec
  FROM cnvdta.f0901 gm, cnvdta.f4095 ml
 WHERE ml.mlco = '00205'
   AND gm.gmmcu(+) = ml.mlmcu
   AND gm.gmobj(+) = ml.mlobj
   AND gm.gmsub(+) = ml.mlsub
   AND gm.gmco(+) = ml.mlco
   AND gmaid IS NULL

Inventory Valuation with Missing Costs - F47122 & F4105

SELECT T1.MJMCU,
       T1.MJLITM,
       T1.MJAITM,
       T1.MJITM,
       T2.IMDSC1,
       T2.COLEDG,
       T1.QTY,
       T2.STD_COST
  FROM (SELECT MJMCU, MJLITM, MJAITM, MJITM, SUM(MJTRQT / 1000) AS QTY
          FROM TESTDTA.F47122
         WHERE MJEDSP = ' '
           AND MJMCU = '     2050012'
         GROUP BY MJMCU, MJLITM, MJAITM, MJITM) T1
  LEFT OUTER JOIN (SELECT COITM,
                          COLITM,
                          COAITM,
                          IMDSC1,
                          COMCU,
                          COLEDG,
                          COUNCS / 10000 AS STD_COST
                     FROM TESTDTA.F4105, TESTDTA.F4101
                    WHERE COITM = IMITM
                      AND COLEDG = '07') T2
    ON T1.MJITM = T2.COITM
   AND T1.MJMCU = T2.COMCU

WHERE -- Comment the next 3 line if you want to see Inv Valuation
    ( COLEDG IS NULL
     OR STD_COST = 0)

Count on F30026 & F4105

select current_timestamp,ieledg, iemmcu, count(distinct(IEITM)) from proddta.F30026
where
ieledg in ('02', '01', '07') and
iexsmc >0
group by ieledg, iemmcu
order by ieledg, iemmcu

----------------------------------------------------------------------------------------------


select to_char(systimestamp, 'HH24:MI:SS.FF3'),comcu,  coledg, count(*) from proddta.F4105
where coUNCS <> 0
and coledg = '01'
group by coledg, comcu order by coledg, comcu

Costed Inventory

SELECT
    trim(T2.LIMCU),
    TRIM(T1.IMLITM),
    TRIM(T1.IMAITM),
   TRIM( T1.IMDSC1),
    T3.COLEDG,
    T2.LIGLPT,
    T3.COUNCS/10000 AS COST,
    SUM(T2.LIPQOH)/1000 AS TTL_QTY
FROM
    PRODDTA.F4101 T1,
    PRODDTA.F41021 T2
LEFT OUTER JOIN
    (
        SELECT
            *
        FROM
            PRODDTA.F4105
        WHERE
            COLEDG = '07'
    )
    T3
ON
    T2.LIITM = T3.COITM
AND T2.LIMCU = T3.COMCU
WHERE
    T1.IMITM = T2. LIITM
AND T2.LIPQOH <>0
GROUP BY
    T2.LIMCU,
    T1.IMLITM,
    T1.IMAITM,
    T1.IMDSC1,
    T3.COLEDG,
    T2.LIGLPT,
    T3.COUNCS
HAVING
    SUM(T2.LIPQOH)<>0
ORDER BY
    T2.LIMCU,
    T1.IMLITM

JDE Developer Positions

I have urgent opening for JD Edwards IT Developer @ CT

Duration Full time
Skills: JD Edwards One World development, Payroll & HR, SQL
If interested send your resume to ashish.kumar@two95intl.com

__________________________________________________________________________________

Applications Support Specialist/JD Edwards E1 Developer needed for Greater NYC area company. 5+ years Functional Expertise Required - $100K+

Manufacturing/Distribution company based in the Greater NYC area is seeking an experienced Technical Applications Support Specialist to join their team. The ideal candidate will have 5+ years experience as a Business Analyst and also possess very heavy JD Edwards EDI development experience, perhaps as a Developer within JD Edwards EnterpriseOne, or E1, environments. The experience must be within an implementation or process improvement level; not just as an end-user. The role will also require the individual to provide training to end users. This individual will serve a multi-purpose role of Business Analyst and Developer with a focus on EDI, although not exclusively. Email me at TH@NielsenStaffing.com or call            631-582-4010       x18. Immediate hire. Referrals welcome.

_____________________________________________________________________________________

Looking for a JD Edwards Developer for a permanent position in Cleveland, Ohio. Email me if you or someone you know may be interested: mbrace@murtechconsulting.com

_____________________________________________________________________________________

JD Edwards EnterpriseOne Technical Developer Consultant

Terillium is an Oracle Platinum Partner, achieving the highest partner level possible within the Oracle Community. Specializing in reselling and implementing JD Edwards solutions and Oracle’s E-Business Suite: Terillium enables companies to develop a competitive edge by utilizing technology and process improvements. Our clients are Mid-Market corporations that are growing and have complex business requirements, yet need a rapid, lower-cost business system solution. Our years of experience, proven success, and focus on client satisfaction ensure a streamlined process and cost effective solution.

We are looking for talented industry and consulting professionals to join with our core team. Our focus is directed at EnterpriseOne and eBusiness implementations and upgrades. Our consultants are required to assist clients in developing new business processes and use Oracle’s product to support these processes.

We have a requirement for a Senior EnterpriseOne Developer that has EnterpriseOne implementation experience and working knowledge in the following:

Skills Required
Strong skill set in JD Edwards EnterpriseOne Toolset and experience with interactive application development (FDA), batch application development (RDA), table conversion development and Business Function Development (NER/ C). Skills must also include: tables/indices, business views, media objects, versions, data dictionary, udc’s, task views and OMW. Must have experience designing, developing and testing reports, interfaces, data conversions and enhancements. Excellent technical problem solving skills combined with the ability to debug operational and system issues. Ability to communicate ideas in both technical and user-friendly language. Prefer those candidates with experience withBI Publisher, workflow, portal development, business services, financial report writing, UPK, EDI and RPG.

Additional Requirements:
Bachelor’s degree, Masters preferred
Consulting Experience
Multiple E1 implementations
8.12/9.0 Experience is a plus
Travel is required
Midwest Geographic Residence Preferred


Please visit http://www.terillium.com/ for more information.

__________________________________________________________________________________________

Job Description

Six months or greater contract to hire opportunity working for afortune 500 company in Texas

The JD Edwards Applications Developer must be able to applycritical thinking to analyze and diagnose customer issues related to JDEsystem, facilitate and engage in discussions with clients and team members todiscuss potential solutions, and implement solutions that are most appropriatein a timely and quality manner.

Requirements:

• 5+ years of experience in software development out of which atleast 1 year should be in JDE EnterpriseOne environment
• Must have experience providing support in a JD Edwards environmentthat is highly customized (not just out of the box)
• Must have experience in formal methodologies in technology systemsimplementations and software development including Agile methodologies
• Must be able to create/review and approve functionaldesign documents and technical design documents
• Must have strong knowledge and experience in JDE OMW development toolsand processes to create UBEs, applications and business functions
• Experience in estimating projects, development effortsand implementation efforts
• Business knowledge and experience providing day-to-day productionsupport for issues
• Mustbe able to provide timely and complete responses to customer requests in bothwritten and verbal manner
• Mustprovide accurate and consistent status reports to clients and otherstakeholders
• Proficientin MS Office Word, Excel, Outlook and PowerPoint
• Mustbe able to travel to various client locations when necessary

Desired Skills & Experience

Preferred:

• Knowledgeand experience with business intelligence systems
• Familiaritywith the functional and technical aspects of manufacturing, logistics and/ordistribution modules of JDE EnterpriseOne 9.0

Skills:

• Interact with IT and business leadership team and lead such meetingswhen necessary
• Musthave the ability to multi-task and organize effectively to meet client servicelevel expectations
• Adept and proactive at problem solving and conflict resolution
• Demonstrates strong analytical skills and develops solutions toproblems independently and through facilitated team discussions
• Abilityto actively participate in team and client meetings, andlead meetings as needed
• Motivated and shows initiative
• Workswell independently and within a team
• Excellentwritten and verbal communication skills
• Possessesa professional demeanor
• Greatorganizational, time management and problem solving skills
• Prioritizesworkload, meets deadlines and manages competing priorities under pressure
• Adaptto different client work environments
• Workin a fast paced environment

Education:

• Bachelor’s degree (business, engineering or related fieldrecommended); knowledge of theories, principles and concepts typically acquiredthrough completion of a bachelor’s degree.

Company Description

Smartbridge, LLC is a dynamic technology consulting company with a steady growth serving its clients for over 8 years. It’s located in Houston, TX with clients and associates located across Texas and other states. Smartbridge provides enterprise technology strategies, systems integrations and mobile applications to deliver new capabilities to its clients, both in the public and private sectors. Smartbridge offers an entrepreneurial work environment with a technically skilled and disciplined team that has high customer satisfaction ratings.

Additional Information

Posted:

January 31, 2012

Type:

Full-time

Experience:

Mid-Senior level

Functions:

Information Technology 

Industries:

Management Consulting 

Compensation:

DOE

Job ID:

2483401

____________________________________________________________________________

JDE Technical Developer needed for 6-8 weeks in TN call or email rachel@r-e-s.com             720-420-6257      

_______________________________________________________________________________________

JDE Senior programmer 

Contact hilda@systemsr.com or call 770-475-7997x1

____________________________________________________________________________________

Doug

I am currently seeking a Senior JD EDWARDS ENTERPRISEONE DEVELOPER. Permanent position for a growing and very reputable client in the Northwest!

Minimum 7 years of experience with JD Edwards EnterpriseOne development tools .
Experience and/or knowledge of .Net, VB.Net, C, C++, MS SharePoint would be a plus.

Benefits: Base pay 95k -110k plus bonus! Excellent benefits, profit sharing, health, etc.

I am their primary recruiter so I have an excellent chance of getting you or any of my candidates an interview. I will be setting up interview next week!

Please send your resume to: dwintz@wincostaffing.com or call me ASAP if you or anyone you know would be interested? I will be more than happy to provide additional details when we speak!

Thanks,

Doug Wintz
            (561)616-7386      

__________________________________________________________________________

JDEdwards EnterpriseOne and JDEdwards World Opportunities

Contact Lucy Marquardt at Tri-S Recruiters – lucym@trisrecruiters.com /            630.325.7373       - Forward a copy of your updated resume today. Please include salary requirements to lucym@trisrecruiters.com or via phone at             630-325-7373      . Our firm has over 20 years of IT recruiting experience and has focused on JDEdwards candidates and clients for the past 9 years.