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.
This year I ran Inventory's zero year to date quantities as one of my to
do list for the end of fiscal year 2011. But come to find out earlier this
year, due to some performance issues with Maximo, I set the
mxe.db.sqlserverPrefetchRows to 200, which in turn only zero out the first
200 lines in the Inventory list. Several issues and returns transactions
have occurred since then.
What needs to happen:
Move inventory.issueytd to inventory.issue1yrago, inventory.issue1yrago to
inventory.issue2yrago... - ones that got bypassed
zero out the issueytd - what to do with the ones that's been issued or
returned?
Regards,
Dennis B
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Hi Dennis: I had to do that one before - here's the query I have:
update inventory set issue3yrago = (select -1*sum(quantity) as TQty
FROM MATUSETRANS
WHERE MATUSETRANS.ITEMNUM = INVENTORY.ITEMNUM
AND ACTUALDATE BETWEEN add_months(trunc(sysdate, 'YYYY'), -36)
and add_months(trunc(sysdate, 'YYYY'), -24) AND PONUM is null
group by itemnum)
This is just for the Issue3YrAgo one, but you get the idea.
Of course, this is also Oracle Syntax.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
dennis_belandres@denso-diam.com
Sent: April-12-12 7:30 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Zero year to date quantities
This year I ran Inventory's zero year to date quantities as one of my to
do list for the end of fiscal year 2011. But come to find out earlier this
year, due to some performance issues with Maximo, I set the
mxe.db.sqlserverPrefetchRows to 200, which in turn only zero out the first
200 lines in the Inventory list. Several issues and returns transactions
have occurred since then.
What needs to happen:
Move inventory.issueytd to inventory.issue1yrago, inventory.issue1yrago to
inventory.issue2yrago... - ones that got bypassed
zero out the issueytd - what to do with the ones that's been issued or
returned?
Regards,
Dennis B
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.