tag:blogger.com,1999:blog-4968997690016316532024-03-13T06:42:39.636-05:00JD Edwards Inventory Reconciliation TipsCJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-496899769001631653.post-85396641370174308742016-05-02T14:16:00.000-05:002016-05-02T14:16:06.998-05:00<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiklEwXUEIf_qB0kYkoeS1UQXL68jHlHttw1gW0OAZIpTk2p4vpC0jsOP90F037LyEpJv1uZKQ3zBqRx3926C0oIVvaDGboMKOcynS8lpFzzaShJa7DmYFvr9UxfDzXkTG1zmpF8Mmji_Co/s1600/JD+Edwards+Inventory+Assessment.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a></div>
<h2 class="separator" style="clear: both; text-align: left;">
<span style="color: blue;">Free JD Edwards Inventory Integrity/Reconciliation Assessment</span></h2>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: orange; font-size: x-large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiklEwXUEIf_qB0kYkoeS1UQXL68jHlHttw1gW0OAZIpTk2p4vpC0jsOP90F037LyEpJv1uZKQ3zBqRx3926C0oIVvaDGboMKOcynS8lpFzzaShJa7DmYFvr9UxfDzXkTG1zmpF8Mmji_Co/s1600/JD+Edwards+Inventory+Assessment.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiklEwXUEIf_qB0kYkoeS1UQXL68jHlHttw1gW0OAZIpTk2p4vpC0jsOP90F037LyEpJv1uZKQ3zBqRx3926C0oIVvaDGboMKOcynS8lpFzzaShJa7DmYFvr9UxfDzXkTG1zmpF8Mmji_Co/s400/JD+Edwards+Inventory+Assessment.jpg" width="350" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><br /></div>
<span style="color: orange; font-size: large;">CJ Inventory Diagnostics is offering a free JD Edwards Inventory Integrity/Reconciliation Assessment. Click here to </span><a href="http://www.cjinv.com/"><span style="color: orange; font-size: large;">Register</span></a><span style="color: orange; font-size: large;">.</span> <br />
<br />
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/AD9hCG1i_Xo/0.jpg" src="https://www.youtube.com/embed/AD9hCG1i_Xo?feature=player_embedded" frameborder="0" allowfullscreen></iframe><br />
<div style="text-align: left;">
<span style="color: orange; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="color: orange; font-size: large;"><br /></span></div>
<div style="text-align: left;">
<span style="color: orange;"><span style="font-size: large;"></span><br /></span></div>
<h2 style="text-align: left;">
<span style="color: orange;"></span><br /></h2>
CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com0tag:blogger.com,1999:blog-496899769001631653.post-34593038847157541962013-05-02T14:53:00.004-05:002013-05-02T14:53:40.587-05:00Standard Approach to Reconciling Your JD Edwards Inventory Series - Part Three<h2>
Implementation Challenges Cont'd</h2>
<br />
<h3>
<u>AAI's</u></h3>
<span style="font-size: 22pt;"><span style="color: #ff6600; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41543 As of to General Ledger Integrity report relies
on AAIs to analyze data and identify</span><br />
<div style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">variances</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">The good news is that
fixing your AAIs should eliminate some variances</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">The bad news is that
depending on your configuration this can be tedious</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cautions:</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span><span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Inventory Related
AAIs should point only to inventory accounts in your general ledger</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span><span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">COGS Related AAIs
should point only to COGS or Expense accounts in your General ledger</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span><span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">AAIs typically work
in pairs and are used by specific programs.<span style="mso-spacerun: yes;">
</span>A pair of AAIs that should hit inventory with an offsetting entry to
COGS should be set up this way.<span style="mso-spacerun: yes;"> </span>If you
have an inventory Account in the COGS AAI or a COGS account in and Inventory
AAI, you will get unusable results when running the R41543</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">
</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span> </div>
<h3>
<u>Configuration</u></h3>
<span style="font-size: 26pt;"><span style="color: #ff6600; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Your configuration may require modifications to the
standard reports</span><br />
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">WAC/Cost Level 2/Lot </span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">serialization: </span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span><span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">If you use cost level
2 but identify each piece individually with a unique lot number,</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41544 will
generate useless results</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span><span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">You will need to
modify this report to evaluate amount variances consistently with how</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">you value
your inventory</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span><span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">You will want to use
the standard report for detailed quantity analysis</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">
</span></div>
<br />
<h3>
<u>Establish A Monthly Inventory Close</u></h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgApBCQLz3Mc6sd0yo_emMzQoq0MDJziSl9dKSRn5_3JTmRyj90bqIku1sF0ZU12IA70I3pWWWG23e1_w4oJ6srenAK1SuHU2Lpt_EWgGwpN0j_0raDREWYyv8zcqPPUfSWmjv0BQq_vZ2J/s1600/Montly+Close+Process+2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgApBCQLz3Mc6sd0yo_emMzQoq0MDJziSl9dKSRn5_3JTmRyj90bqIku1sF0ZU12IA70I3pWWWG23e1_w4oJ6srenAK1SuHU2Lpt_EWgGwpN0j_0raDREWYyv8zcqPPUfSWmjv0BQq_vZ2J/s320/Montly+Close+Process+2.jpg" width="294" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="color: black; font-family: Calibri; font-size: 20pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-size: small;"> </span></span><span><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Reports/Processes executed at different points in time
will generate timing variances that aren’t </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">real variances</span><br />
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span><br />
<div style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Implement a monthly close with a cutoff period where all users are locked out of the system</span></div>
<div style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span> </div>
<span><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Use this time to run all programs and processes required
to ensure that all tables are in sync </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">before integrity processes are run</span><br />
<span><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;"></span></span><br />
<span><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Sequence</span><br />
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Run Updates</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Run Integrity Reports</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span></span>Run Informative
Reports</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span> </div>
<h3>
<u>Inventory Processes</u></h3>
<br />
<div style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="font-size: 14pt;"><span style="color: #ff6600; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 14pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Your companies processes should be designed to ensure
that all related tables are updated at the same time:</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="font-size: 13pt;"><span style="color: #0000bf; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; font-size: 13pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Manufacturing
Accounting should be executed as least once daily</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">When you issue
material to a Work Order, the material is removed from on hand.<span style="mso-spacerun: yes;"> </span>Manufacturing accounting removes it from
inventory in the General Ledger</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">When you complete
material for a Work Order, On Hand is updated.<span style="mso-spacerun: yes;">
</span>Manufacturing accounting puts the amount in Inventory in the General
Ledger</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="font-size: 13pt;"><span style="color: #0000bf; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; font-size: 13pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Manufacturing
Accounting should be run on all open work orders before a standard cost roll to
avoid integrity issues</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">When you issue
material or complete a work order, the cost that updates the item ledger comes
from the cost ledger, the cost that updates the general ledger comes from the
cost components table</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="font-size: 13pt;"><span style="color: #0000bf; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; font-size: 13pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Reversals – Material
Issues, work order completions, outside processing, etc.</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Due to the complexity
of the tables and how they are updated, reversals in the shop floor control
process can cause integrity issues</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">The safest way to
ensure that an integrity error does not occur is to run manufacturing
accounting between each step</span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="font-size: 13pt;"><span style="color: #0000bf; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; font-size: 13pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Reattaching a parts
lists</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Parts lists should
not be re-attached after the work order has reached a certain status</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">This is especially
true if any activity has been recorded against the work order i.e. material
issues, outside processing, etc. </span></div>
<div class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
<span style="font-size: 13pt;"><span style="color: #0000bf; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 5; mso-special-format: bullet;">}</span></span><span style="color: #1f497d; font-family: Calibri; font-size: 13pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cancelling work
orders</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cancelling a work
order after there has been activity recorded against it<span style="mso-spacerun: yes;"> </span>and before manufacturing accounting has been
run will cause an integrity issue<span style="mso-spacerun: yes;"> </span></span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="font-size: 11pt;"><span style="color: #bcbcbc; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 0; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">It is always
recommended that any activity recorded against a work order should be reversed
before cancelling it</span><span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">
</span></div>
<div class="O2" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed;">
<span style="color: black; font-family: Calibri; font-size: 11pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span> </div>
<span style="font-family: Calibri; font-size: small;"><strong>Conclusion</strong></span><br />
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; font-family: Calibri;">This concludes part three of this series. Stay tuned for Tips & Tricks.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri; font-size: small;"><strong>Questions</strong></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;"> Visit us at: <a href="http://www.cjinv.com/"><span style="color: #fc6d0e;">www.cjinv.com</span></a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;">Email us at: <a href="mailto:jjensen@cjinv.com"><span style="color: #fc6d0e;">jjensen@cjinv.com</span></a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<strong><br /></strong></div>
<div align="left" class="O1" style="-ms-word-break: normal; direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed;">
</div>
CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com1tag:blogger.com,1999:blog-496899769001631653.post-63187444319459551052012-02-09T15:10:00.005-06:002013-05-02T13:12:43.003-05:00Standard Approach to Reconciling Your JD Edwards Inventory Series - Part Two<strong><span style="font-size: large;">JDE Inventory Integrity Process Cont'd</span></strong><br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4Io1X-APSd1DTFqIkws2dxV8owWuKaRJHsk0TxrWmRwLk-p3YaN3EhIuZwtAu9_lm6L4ReE6ShpVo-ZjwBSgiI7RrPqeK-nDzsn3OHr7Fcwd4AB2sKfyr7CxKAnoJanBC8_4-iL4JQDyP/s1600/JDE+Inventory+Integrity+Process+3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="176" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4Io1X-APSd1DTFqIkws2dxV8owWuKaRJHsk0TxrWmRwLk-p3YaN3EhIuZwtAu9_lm6L4ReE6ShpVo-ZjwBSgiI7RrPqeK-nDzsn3OHr7Fcwd4AB2sKfyr7CxKAnoJanBC8_4-iL4JQDyP/s400/JDE+Inventory+Integrity+Process+3.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div align="left">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: 24pt;"><span style="color: #ff6600; font-family: "Wingdings 3"; font-size: 76%; mso-color-index: 4; mso-special-format: bullet;">}</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;">Reports should be run nightly on a scheduler in sequence</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41542 As-Of Update</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41544 Item Balance to Ledger Integrity</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41543 Cardex to General Ledger Integrity</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">This process identifies the variances – You have to solve them!</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<br /></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><strong>Implementation Challenges!</strong></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">After populating </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">As-Of and running these reports, you may </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">find </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">it</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> difficult to understand the results.<span style="mso-spacerun: yes;"> </span>Many </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">factors will impact the</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> usability </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">of these </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">reports</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Have you implemented all SARS for the process?</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Is As-Of populated correctly?</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Are your AAIs set up correctly?</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Does your configuration require modifications to the </span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">s</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">tandard integrity reports?</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Are all of your inventory processes implemented to ensure consistency?</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<br /></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><u>SARS</u></span> </div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Log into to My Oracle Support and perform a search on both</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> the R41543 and the R41544</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="mso-spacerun: yes;"> </span>Ensure that you have downloaded any SARS that directly</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> impact the accuracy of these reports</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><u>Populating As OF</u></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-family: Times New Roman; font-size: small;"> </span><span style="color: #ff6600; font-family: "Wingdings 3"; mso-color-index: 4; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Initial build of As-Of can be time consuming</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span></span><span style="font-size: large;"></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41542 - As Of Generation summarizes Cardex activity in the</span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> As Of Table by month </span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">On your first pass you will want to select the following</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> processing options:</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Processing Options:</span></div>
<div class="O4" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.5in; margin-top: 3pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;"><span style="font-size: small;">¨</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Regenerate = 1</span></div>
<div class="O4" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.5in; margin-top: 3pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;"><span style="font-size: small;">¨</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Completion Report = 1</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Data Selection: 1/1/xx to 12/31/xx</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">On subsequent passes select following processing options</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Processing Options:</span></div>
<div class="O4" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.5in; margin-top: 3pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;"><span style="font-size: small;">¨</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Regenerate = </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Blank</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></div>
<div class="O4" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.5in; margin-top: 3pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;"><span style="font-size: small;">¨</span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Completion </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Report = 1</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Data Selection: </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">1/1/</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">xy</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">to </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">12/31/</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">xy</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41548 – As Of Update creates starting balances for each year</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Run this program after each year created with R41542</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Processing Option: Specify Year for which you are creating</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> starting balances</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span><br /></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000bf; font-family: "Wingdings 3"; mso-color-index: 5; mso-special-format: bullet;">}</span><span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cautions:</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41542 </span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Will delete all records in As OF if you enter the wrong<span style="mso-spacerun: yes;"> </span>processing option</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Should be run for Jan 1 through Dec 31 for each year</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">R41548 </span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Should be run after each run of R41542 to create starting balances in the As Of table for each subsequent year</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Specify the year for which you are creating starting balances when you run this program</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cardex Changes:</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">If records have been deleted from the </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">C</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">ardex, you will not get correct balances in As Of</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">If you have used<span style="mso-spacerun: yes;"> </span>Direct As Of Data Entry (P41112A) in the past to fix As Of, you will need to make those same changes after building the effected year</span></div>
<div class="O2" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.9in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #bcbcbc; font-family: "Wingdings 3"; mso-color-index: 0; mso-special-format: bullet;">}</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Other changes<span style="mso-tab-count: 1;"> </span></span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">If you have mane any changes to your primary unit of measure for an item, you will have issues</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #0000a8; font-family: Wingdings; mso-color-index: 5; mso-special-format: bullet;">¨</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">If you are missing any conversion factors back to the primary UOM for an item, you will have issues</span></div>
<div class="O3" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.2in; margin-top: 4pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.25in; unicode-bidi: embed; word-break: normal;">
<span style="color: #1f497d; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 3; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span> </div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri; font-size: medium;"><strong>Conclusion</strong></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; font-family: Calibri;">This concludes part two of this series. Stay tuned for part three.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri; font-size: medium;"><strong>Questions</strong></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;">Visit us at: <a href="http://www.cjinv.com/"><span style="color: #fc6d0e;">http://www.cjinv.com/</span></a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;">Email us at: <a href="mailto:jjensen@cjinv.com"><span style="color: #fc6d0e;">jjensen@cjinv.com</span></a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<strong><br /></strong></div>
<div align="left" class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.6in; margin-top: 5pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;">
</div>
CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com0tag:blogger.com,1999:blog-496899769001631653.post-76586816886187109972012-01-31T17:19:00.000-06:002012-02-09T13:47:15.481-06:00Standard Approach to Reconciling your JDEdwards Inventory Series - Part 1<strong><span style="font-family: Times, "Times New Roman", serif; font-size: large;">Better Late Than Never?</span></strong><br />
<br />
<span style="font-family: Times, "Times New Roman", serif;">Well folks, I realize this is long overdue. I promised this series would start in November. I do apologize for the delay. I suppose it's better late than never. So without further delay.... Standard approach to reconciling your JDEdwards inventory - part 1.</span><br />
<br />
<div style="text-align: left;">
<span style="font-family: inherit;"><strong><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;">Inventory</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt; mso-text-raise: 0%; vertical-align: baseline;"> Reconciliation Overview</span></span></strong></span></div>
<div style="text-align: left;">
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0762Q99cp3wM9JijBtiClvc5l7VwXeAA81Z5fLT3hElmoo1UlTHJeJaaY2NlC6vgl7jyrwh6KQCexh20oPbKQbAyzIrqmYoqMSNXZrEereO9r4hv3W6Kdvwk13TYmFi9Sh0mhQBqoKFHj/s1600/IR+Overview+Pic.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="163" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0762Q99cp3wM9JijBtiClvc5l7VwXeAA81Z5fLT3hElmoo1UlTHJeJaaY2NlC6vgl7jyrwh6KQCexh20oPbKQbAyzIrqmYoqMSNXZrEereO9r4hv3W6Kdvwk13TYmFi9Sh0mhQBqoKFHj/s200/IR+Overview+Pic.jpg" width="200" /></a><br />
<br />
<span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;"></span></span><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Typical approach is to compare GL inventory to OH value</span></span><br />
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.72pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Many companies assume the OH value is correct and plug the GL </span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.72pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">to tie to On Hand</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.72pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.72pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><strong>Quantity & Amount Variances</strong></span></span></span><span style="font-family: inherit;"><strong><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt; mso-text-raise: 0%; vertical-align: baseline;"> </span></strong></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.72pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-family: inherit;"><strong><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt; mso-text-raise: 0%; vertical-align: baseline;"> </span></strong></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.72pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-family: inherit;"><strong><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt; mso-text-raise: 0%; vertical-align: baseline;"></span></strong></span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuwFtypcdlMH-Erv0VmDCT_youI2AR_E9CQqrhBLvcFqcnkA7eIbOztP87Ca8eLhyF2RiypeaC9Lycvba2p5q1nxWqFRGsJqgW_00sIQU7rFrdm-4sHCmpjYscIbYqb1Au-NMQw1bx9ZdA/s1600/Quantity+and+Amount+Variances+Pic.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="104" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuwFtypcdlMH-Erv0VmDCT_youI2AR_E9CQqrhBLvcFqcnkA7eIbOztP87Ca8eLhyF2RiypeaC9Lycvba2p5q1nxWqFRGsJqgW_00sIQU7rFrdm-4sHCmpjYscIbYqb1Au-NMQw1bx9ZdA/s400/Quantity+and+Amount+Variances+Pic.jpg" width="400" /></a></div>
<div style="text-align: left;">
<span style="font-family: inherit;"><strong><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Arial; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt; mso-text-raise: 0%; vertical-align: baseline;"></span></strong></span> </div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Quantity variance created when material was removed from </span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">inventory and On Hand was not updated</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Amount variance created when transactions did not hit the GL</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">correctly</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><strong>Cardex is the Key</strong></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM1fT_pAwzAFPbfoumCI2uA_xyVqfkyXW8BxO2HVCx4CUoe7nUuDStfnlS59HADHPZnY4Mqtig9s6wTUYMDaqFm7pnDCndmKyo09oHdqhE_0GE9yBNJ4Jx-ogfdLliRdeQzCxmFkoiLaOw/s1600/Cardex+is+Key+pic.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM1fT_pAwzAFPbfoumCI2uA_xyVqfkyXW8BxO2HVCx4CUoe7nUuDStfnlS59HADHPZnY4Mqtig9s6wTUYMDaqFm7pnDCndmKyo09oHdqhE_0GE9yBNJ4Jx-ogfdLliRdeQzCxmFkoiLaOw/s400/Cardex+is+Key+pic.jpg" width="400" /></a><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;"></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cardex includes history recorded to both OH and GL</span></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span></span><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cardex provides data required to identify quantity problems in</span></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">OH</span></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span></span><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cardex holds a lot of records…</span></span><span style="color: black; font-family: Calibri; font-size: 26pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; font-size: 26pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span></span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><strong>JDE Inventory Integrity Process</strong></span></span></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"></span></span></span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><strong><span style="font-size: x-small;"> </span></strong></span></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><strong> </strong></span></span></span></span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;">Tables</span></span></span></span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 6.48pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><strong><span style="font-size: large;"></span></strong></span></span></span></span> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEific5vQKDCAtzCKsWfcg292uDJUuyiZMtiTktJX-g5naqsCIl9-apyUo_XZN8zqzeFm2cRlEdcIUoJm9mbXjQHeOc57PMNmmUPN7lnJEx7JtdjAzKxIbmPG-fbOnCXuETh7yxNeCjQkXwA/s1600/JDE+Inventory+Integrity+Process.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="54" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEific5vQKDCAtzCKsWfcg292uDJUuyiZMtiTktJX-g5naqsCIl9-apyUo_XZN8zqzeFm2cRlEdcIUoJm9mbXjQHeOc57PMNmmUPN7lnJEx7JtdjAzKxIbmPG-fbOnCXuETh7yxNeCjQkXwA/s320/JDE+Inventory+Integrity+Process.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 7.2pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">The Process compares three tables</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.06in; margin-top: 6.24pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.56in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: +mj-lt; mso-special-format: "numbullet3,1";">1.</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Calculate cumulative amounts and quantities based on </span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.06in; margin-top: 6.24pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.56in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cardex records</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.06in; margin-top: 6.24pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.56in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: +mj-lt; mso-special-format: "numbullet3,1";">2.</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Compare Cardex cumulative amounts and quantities to On</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.06in; margin-top: 6.24pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.56in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Hand Quantity and Amount</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.06in; margin-top: 6.24pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.56in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: +mj-lt; mso-special-format: "numbullet3,1";">3.</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Compare Cardex cumulative amounts to Inventory Balance</span></span></div>
<div class="O1" style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 1.06in; margin-top: 6.24pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.56in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">in General Ledger</span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 7.2pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Identify Variances</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span></div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 7.2pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
</div>
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 7.2pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.38in; unicode-bidi: embed; word-break: normal;">
<span style="font-size: large;"> Reports </span></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1IEKr_7IS0MqOwUiSQ6HbHhQRoAzMkR_Jia29NmFgBm-ymA8rPLEHg9i_fEOdOkPkouxTIIDoA5vA5u6R4Di_J7hW6MZVQYGoSYQmWhKAQ_yYPDfsFdQ91nQNp-Xi-JqgeY6U0dccxxrL/s1600/JDE+Inventory+Integrity+Process+2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="51" sda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1IEKr_7IS0MqOwUiSQ6HbHhQRoAzMkR_Jia29NmFgBm-ymA8rPLEHg9i_fEOdOkPkouxTIIDoA5vA5u6R4Di_J7hW6MZVQYGoSYQmWhKAQ_yYPDfsFdQ91nQNp-Xi-JqgeY6U0dccxxrL/s320/JDE+Inventory+Integrity+Process+2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">The Process relies on three reports</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span></span><span style="font-size: large;"><span style="font-family: +mj-lt; mso-special-format: "numbullet3,1";"> 1. </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">As Of Update sums Cardex Quantities and Amounts and</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">writes them to the As-Of table</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span><span style="font-size: large;"><span style="font-family: +mj-lt; mso-special-format: "numbullet3,1";">2. </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Item Balance to Ledger compares the summed Cardex</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> Quantities and Amounts to On Hand</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span><span style="font-size: large;"><span style="font-family: +mj-lt; mso-special-format: "numbullet3,1";">3. </span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Cardex to GL compares summed Cardex Amounts to the</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> General Ledger</span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mj-cs; mso-color-index: 1; mso-fareast-font-family: +mj-ea; mso-font-kerning: 12.0pt;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"><span style="font-size: large;"><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span></span><span style="font-size: large;"><span style="font-family: Arial; mso-special-format: bullet;">•</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;">Each report generates a detailed listing of variances</span><span style="color: black; font-family: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: +mn-cs; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri; font-size: large;"><strong>Conclusion</strong></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;">This concludes part 1 of this series. Stay tuned next week for part two. I promise this time. =)</span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri; font-size: large;"><strong>Questions</strong></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;">Visit us at: <a href="http://www.cjinv.com/">http://www.cjinv.com/</a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Calibri;">Email us at: <a href="mailto:jjensen@cjinv.com">jjensen@cjinv.com</a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com2tag:blogger.com,1999:blog-496899769001631653.post-36737873280827681152011-11-14T13:41:00.000-06:002011-11-14T13:41:50.403-06:00Reconciling Your Inventory Is Only The First Step<strong>Basic Concept</strong><br />
<br />
The basic concept behind the standard methodology for reconciling your inventory in JD Edwards is to compare the balances in the following three tables, and identify any variances that exist.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5PjTPCpdeZu_5RPMQ4na0tGMH-_V7l_2NT5is8m9-a7Brjj_q8U9DRT3U104ypfGITjxS6oeHIS9RDHdiwsYJKDbPzM4rH1Znhbd8x-rsaXGfxL_YHWPtWCwRqxPeiSdtCkoxcxpN9ECo/s1600/JDE+Inventory+Recon+Overview.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="75" nda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5PjTPCpdeZu_5RPMQ4na0tGMH-_V7l_2NT5is8m9-a7Brjj_q8U9DRT3U104ypfGITjxS6oeHIS9RDHdiwsYJKDbPzM4rH1Znhbd8x-rsaXGfxL_YHWPtWCwRqxPeiSdtCkoxcxpN9ECo/s320/JDE+Inventory+Recon+Overview.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">There is more than one way to do this. </div><div class="separator" style="clear: both; text-align: left;"></div><strong>So what are your options?</strong><br />
<ol><li>You can implement the standard JD Edwards inventory integrity process and use the standard tools provided to reconcile inventory.</li>
<li>You can develop your own set of custom tools to reconcile inventory, and monitor inventory integrity issues.</li>
<li>You can purchase a 3rd party tool to do it all for you.</li>
</ol><strong>The keys to remember when selecting your option for reconciliation are:</strong><br />
<ol><li>Ensure that variances are being identified between On Hand and Cardex as well as Cardex and GL. Variances can and DO exist in both places, and WILL impact you at month end.</li>
<li>Ensure that varaiances are being identified at a granular enough level so that the root cause of the variance can be determined. Once the root cause is determined the variance can both be explained and corrected.</li>
</ol><strong>Getting to the root of the problem...</strong><br />
<br />
Remember, regardless of what tool you decide to use to reconcile your inventory, none of them will solve the root issues that are causing your variances. Variances can be caused due to issues with:<br />
<ul><li>Configuration</li>
<ul><li>AAI's </li>
<li>Lot serialization</li>
<li>Cost levels</li>
<li>Cost methods</li>
</ul><li>Bad Processes</li>
<ul><li>Improper cancellation of work orders</li>
<li>Timing of re-attaching parts lists</li>
<li>Reversals of work order transactions</li>
<li>Cost Changes</li>
<li>Month-End process timing and cut off periods</li>
</ul><li>Corrupt Data</li>
<ul><li>Unapplied ESU's</li>
<li>Changes to primary UOM</li>
<li>UOM conversion factors</li>
<li>Commit Fails</li>
</ul></ul>.....and the list goes on.....<br />
<br />
<strong>It's What We Do</strong><br />
<br />
CJ Inventory diagnostics specializes in determining and solving the root cause of your variances in order to eliminate them from recurring every month. Find out more about us at: <a href="http://www.cjinv.com/">http://www.cjinv.com/</a>, or email me directly at <a href="mailto:jjensen@cjinv.com">jjensen@cjinv.com</a>.<br />
<br />
<strong>Stay Tuned!</strong><br />
<br />
Beginning next week I will start a series about implementing and understanding the standard approach to reconciling your inventory in JD Edwards.CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com0tag:blogger.com,1999:blog-496899769001631653.post-25368478837701117642011-11-01T11:44:00.000-05:002011-11-01T11:44:30.501-05:00As OF - Did you know?<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVD6SPTumpVgXYw0WnJ4P-wyRG51Z9eU-pSWY3NLmPgM29aC2_2zyshY0G95FsC_fPghwut8TlDyh2ASGW5WaNOPnR0WYNLd5fZVxGzUVLNiTUvBhKXg5_NWCXCD-zP5W16nUSyzJ9dCBE/s1600/As+Of.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="216" ida="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVD6SPTumpVgXYw0WnJ4P-wyRG51Z9eU-pSWY3NLmPgM29aC2_2zyshY0G95FsC_fPghwut8TlDyh2ASGW5WaNOPnR0WYNLd5fZVxGzUVLNiTUvBhKXg5_NWCXCD-zP5W16nUSyzJ9dCBE/s400/As+Of.png" width="400" /></a></div><div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;"><br />
</div><div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;"> </div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><br />
</div><br />
<br />
<div style="direction: ltr; language: en-US; margin-bottom: 0pt; margin-left: 0.3in; margin-top: 6pt; mso-line-break-override: none; punctuation-wrap: hanging; text-align: left; text-indent: -0.3in; unicode-bidi: embed; word-break: normal;"><span style="color: black; font-family: Calibri; font-size: 14pt; language: en-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-color-index: 1; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"></span></div><ul><li><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><span style="font-family: Calibri;">The As Of Posted Code (PC) in the cardex tells you the progress of a transaction in the cardex <span style="mso-spacerun: yes;"> </span></span></div></li>
<li><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><span style="font-family: Calibri;"><span style="mso-spacerun: yes;"></span></span><span style="font-family: Calibri;">If the As Of Posted Code is = 'S', then the transaction has not been recorded in the General Ledger<span style="mso-spacerun: yes;"> </span></span></div></li>
<li><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><span style="font-family: Calibri;"><span style="mso-spacerun: yes;"> </span>If the As Of Posted Code is = to ‘ ‘, then the transaction has been recorded in the general ledger, but has not been processed to As Of </span></div></li>
<li><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><span style="font-family: Calibri;">If the As Of Posted Code is = 'X', then the transaction is not a reconciling item and will not get processed to As Of<span style="mso-spacerun: yes;"> </span></span></div></li>
<li><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><span style="font-family: Calibri;"><span style="mso-spacerun: yes;"></span>If the As Of Posted Code is = to 'Y', then the transaction has been processed to As Of </span></div></li>
</ul><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><span style="font-family: Calibri;">Reconciling the general ledger directly to the cardex and/or on hand can be challenging, because not all transactions post to the general ledger immediately. They do, however, update on hand and cardex immediately. So if you try to reconcile these tables without knowing this information, you will have variances due to timing that are not true variances. The standard JD Edwards methodology for reconciling inventory is to use the as of process which takes these timing differences into account as illustrated above. So the key to a much smoother reconciliation is to incorporate the as of process. We will discuss this process and the standard approach to JD Edwards inventory reconciliation in future posts. Stay tuned!</span></div><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;">Visit us on the web at: <a href="http://www.cjinv.com/">http://www.cjinv.com/</a> or email me directly at <a href="mailto:jjensen@cjinv.com">jjensen@cjinv.com</a>.</div><div class="MsoNormal" style="margin: 0in 0in 10pt 0.25in;"><br />
</div><br />
<br />
<br />
<br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"></div>CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com2Greater Houston, Texas, USA29.745301876559193 -95.38330115625001328.704421376559193 -96.517619656250019 30.786182376559193 -94.24898265625tag:blogger.com,1999:blog-496899769001631653.post-69725504269607189852011-10-26T19:27:00.000-05:002011-10-27T11:44:43.019-05:00JD Edwards Inventory Reconciliation Challenges PollI am looking for some feedback regarding how many companies are currently experiencing challenges when reconciling inventory in JDE at month end. <br />
<br />
Question: Do you find reconciling inventory in JD Edwards to be<br />
<br />
A. Easy<br />
B. Moderate<br />
C. Challenging<br />
D. I give up!<br />
<br />
Please leave your answer in a comment, or email me directly at <a href="mailto:jjensen@cjinv.com">jjensen@cjinv.com</a>.<br />
For more information on CJ Inventory Diagnostics, visit us at: <a href="http://www.cjinv.com/">http://www.cjinv.com/</a>.<br />
<br />
Thanks in advance for your participation!CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com2tag:blogger.com,1999:blog-496899769001631653.post-32339523021084339732011-10-25T20:27:00.000-05:002011-10-26T00:24:13.734-05:00Standard Cost - Behind the Scenes<div class="separator" style="clear: both; text-align: center;">
High Level Illustratation of How Standard Cost Impacts the Shop Floor Control Process</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWovPBZG7whSMGnie5oCrfIuwS_gQzwYjUeY4hjwp_A_b_ZAdJo2dG1YAi8QOVvwtk89KXa8XaGFhyphenhyphenghJa5HjQ7XKtvp3wnJwcI0-fqguEDBv5URy1gvCuPev0ZSI4nPFTRTyhvNogGovu/s1600/Standard+Cost+and+SFC+Illustration.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" ida="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWovPBZG7whSMGnie5oCrfIuwS_gQzwYjUeY4hjwp_A_b_ZAdJo2dG1YAi8QOVvwtk89KXa8XaGFhyphenhyphenghJa5HjQ7XKtvp3wnJwcI0-fqguEDBv5URy1gvCuPev0ZSI4nPFTRTyhvNogGovu/s320/Standard+Cost+and+SFC+Illustration.png" width="320" /></a></div>
<br />
<ul>
<li>Standard cost is comprised of two key tables: the cost ledger (F4105) and the cost components table (F30026)</li>
<ul>
<li>The cost components table contains the material, labor, outside processing, over head and extras components that make up the standard cost. This table also contains both the simulated and frozen values for these components.</li>
<li>The cost ledger table contains the sum total of these components.</li>
</ul>
<li>Did you know that shop floor control transactions such as material issues and work order completions hit the cardex with the standard (07) cost in the cost ledger (F4105) while the journal entries that are written for these transactions are updated with the cost from the cost components (F30026) table?</li>
<li>How can this impact you?</li>
<ul>
<li>If these two tables get out of sync, then it can cause an integrity issue between the Cardex (F4111) and the General Ledger (F0911) making it very difficult to reconcile inventory at month end.</li>
</ul>
<li>What can you do to prevent this?</li>
<ul>
<li>Never update the standard (07) cost in the cost ledger (F4105) manually. Always use the simulated and frozen cost programs UBE's to update the standard cost.</li>
<li>There is a processing option that can secure this field from being updated manually.</li>
</ul>
</ul>
<br />
<div style="text-align: center;">
Visit us at: <a href="http://www.cjinv.com/">http://www.cjinv.com/</a></div>
<div style="text-align: center;">
Email questions to: <a href="mailto:jjensen@cjinv.com">jjensen@cjinv.com</a></div>
<div align="center">
</div>CJ Inventory DIAGNOSTICShttp://www.blogger.com/profile/10718454360437594554noreply@blogger.com1