This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi Tommy ,
thanks for your reply , part of your message had been removed , i do not
know why , i expect you shared a query which can used
actually i am lucky , that i already taking snapshot of inventory balance
and average cost for the items in monthly basis with a stored procedure
and record it in a table
so i am so close to your suggestion , if you have the suggested query it
will be helpful
BR
--
Samir Khodair
Maximo Specialist
Hi Samir,
I didn't write the SQL from my previous email. You can't write the bloody SQL in your BIRT report. You have to create a stored procedure. Basically you have to get:
1. count of matrec receipt.2. count of matrec return.3. count of matuse receipt4. count of matuse return5. count of invtrans physical count with reconciled balance adjustment6. count of invtrans current balance adjustment7. calculate it within the period of time group by itemnum..
After that, you have to call your stored procedure from BIRT. It still takes a very long time to generate the report in eclipse. When you want to import the report into your maximo, you must raise the websphere timeout, so the maximo will render your report until complete. Maximo only renders the report until 60 seconds, more than that it goes blank screen.
Look, this is not a best practice, Sometimes your report will display correct values, sometimes are not. You also need to consider if someone changes the value directly into your transaction tables. No guarantee this way will displayed correct value.
#yiv7199441554 #yiv7199441554 -- #yiv7199441554ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7199441554 #yiv7199441554ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7199441554 #yiv7199441554ygrp-mkp #yiv7199441554hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7199441554 #yiv7199441554ygrp-mkp #yiv7199441554ads {margin-bottom:10px;}#yiv7199441554 #yiv7199441554ygrp-mkp .yiv7199441554ad {padding:0 0;}#yiv7199441554 #yiv7199441554ygrp-mkp .yiv7199441554ad p {margin:0;}#yiv7199441554 #yiv7199441554ygrp-mkp .yiv7199441554ad a {color:#0000ff;text-decoration:none;}#yiv7199441554 #yiv7199441554ygrp-sponsor #yiv7199441554ygrp-lc {font-family:Arial;}#yiv7199441554 #yiv7199441554ygrp-sponsor #yiv7199441554ygrp-lc #yiv7199441554hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7199441554 #yiv7199441554ygrp-sponsor #yiv7199441554ygrp-lc .yiv7199441554ad {margin-bottom:10px;padding:0 0;}#yiv7199441554 #yiv7199441554actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7199441554 #yiv7199441554activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7199441554 #yiv7199441554activity span {font-weight:700;}#yiv7199441554 #yiv7199441554activity span:first-child {text-transform:uppercase;}#yiv7199441554 #yiv7199441554activity span a {color:#5085b6;text-decoration:none;}#yiv7199441554 #yiv7199441554activity span span {color:#ff7900;}#yiv7199441554 #yiv7199441554activity span .yiv7199441554underline {text-decoration:underline;}#yiv7199441554 .yiv7199441554attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7199441554 .yiv7199441554attach div a {text-decoration:none;}#yiv7199441554 .yiv7199441554attach img {border:none;padding-right:5px;}#yiv7199441554 .yiv7199441554attach label {display:block;margin-bottom:5px;}#yiv7199441554 .yiv7199441554attach label a {text-decoration:none;}#yiv7199441554 blockquote {margin:0 0 0 4px;}#yiv7199441554 .yiv7199441554bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7199441554 .yiv7199441554bold a {text-decoration:none;}#yiv7199441554 dd.yiv7199441554last p a {font-family:Verdana;font-weight:700;}#yiv7199441554 dd.yiv7199441554last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7199441554 dd.yiv7199441554last p span.yiv7199441554yshortcuts {margin-right:0;}#yiv7199441554 div.yiv7199441554attach-table div div a {text-decoration:none;}#yiv7199441554 div.yiv7199441554attach-table {width:400px;}#yiv7199441554 div.yiv7199441554file-title a, #yiv7199441554 div.yiv7199441554file-title a:active, #yiv7199441554 div.yiv7199441554file-title a:hover, #yiv7199441554 div.yiv7199441554file-title a:visited {text-decoration:none;}#yiv7199441554 div.yiv7199441554photo-title a, #yiv7199441554 div.yiv7199441554photo-title a:active, #yiv7199441554 div.yiv7199441554photo-title a:hover, #yiv7199441554 div.yiv7199441554photo-title a:visited {text-decoration:none;}#yiv7199441554 div#yiv7199441554ygrp-mlmsg #yiv7199441554ygrp-msg p a span.yiv7199441554yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7199441554 .yiv7199441554green {color:#628c2a;}#yiv7199441554 .yiv7199441554MsoNormal {margin:0 0 0 0;}#yiv7199441554 o {font-size:0;}#yiv7199441554 #yiv7199441554photos div {float:left;width:72px;}#yiv7199441554 #yiv7199441554photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7199441554 #yiv7199441554photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7199441554 #yiv7199441554reco-category {font-size:77%;}#yiv7199441554 #yiv7199441554reco-desc {font-size:77%;}#yiv7199441554 .yiv7199441554replbq {margin:4px;}#yiv7199441554 #yiv7199441554ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7199441554 #yiv7199441554ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7199441554 #yiv7199441554ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7199441554 #yiv7199441554ygrp-mlmsg select, #yiv7199441554 input, #yiv7199441554 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7199441554 #yiv7199441554ygrp-mlmsg pre, #yiv7199441554 code {font:115% monospace;}#yiv7199441554 #yiv7199441554ygrp-mlmsg * {line-height:1.22em;}#yiv7199441554 #yiv7199441554ygrp-mlmsg #yiv7199441554logo {padding-bottom:10px;}#yiv7199441554 #yiv7199441554ygrp-msg p a {font-family:Verdana;}#yiv7199441554 #yiv7199441554ygrp-msg p#yiv7199441554attach-count span {color:#1E66AE;font-weight:700;}#yiv7199441554 #yiv7199441554ygrp-reco #yiv7199441554reco-head {color:#ff7900;font-weight:700;}#yiv7199441554 #yiv7199441554ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7199441554 #yiv7199441554ygrp-sponsor #yiv7199441554ov li a {font-size:130%;text-decoration:none;}#yiv7199441554 #yiv7199441554ygrp-sponsor #yiv7199441554ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7199441554 #yiv7199441554ygrp-sponsor #yiv7199441554ov ul {margin:0;padding:0 0 0 8px;}#yiv7199441554 #yiv7199441554ygrp-text {font-family:Georgia;}#yiv7199441554 #yiv7199441554ygrp-text p {margin:0 0 1em 0;}#yiv7199441554 #yiv7199441554ygrp-text tt {font-size:120%;}#yiv7199441554 #yiv7199441554ygrp-vital ul li:last-child {border-right:none !important;}#yiv7199441554
Hi Samir,
Do you have the query for the inventory closing balance.I also need the same for submitting to my company the monthly balance sheet.