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
In MX75 and the IBM Preview database, can anyone explain why this don't update the Primary Vendor ?
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns1:CreateMXINVENTORY xmlns:ns1="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ns1:MXINVENTORYSet>
<ns1:INVENTORY>
<ns1:BINNUM>F1-L4</ns1:BINNUM>
<ns1:CURBAL>1</ns1:CURBAL>
<ns1:ISSUEUNIT>EACH</ns1:ISSUEUNIT>
<ns1:ITEMNUM>10521</ns1:ITEMNUM>
<ns1:ITEMSETID>SET1</ns1:ITEMSETID>
<ns1:LOCATION>PKG</ns1:LOCATION>
<ns1:MANUFACTURER>EVERGR</ns1:MANUFACTURER>
<ns1:MINLEVEL>0</ns1:MINLEVEL>
<ns1:MODELNUM>ADEPT</ns1:MODELNUM>
<ns1:ORDERQTY>1</ns1:ORDERQTY>
<ns1:ORDERUNIT>EACH</ns1:ORDERUNIT>
<ns1:ORGID>EAGLENA</ns1:ORGID>
<ns1:REORDER>0</ns1:REORDER>
<ns1:SITEID>BEDFORD</ns1:SITEID>
<ns1:VENDOR>EVERGR</ns1:VENDOR>
<ns1:INVCOST>
<ns1:AVGCOST>600</ns1:AVGCOST>
<ns1:LASTCOST>600</ns1:LASTCOST>
<ns1:ORGID>EAGLENA</ns1:ORGID>
</ns1:INVCOST>
</ns1:INVENTORY>
</ns1:MXINVENTORYSet>
</ns1:CreateMXINVENTORY>
What else is required to import primary vendor?
Even after importing invbal and invvender the primary vendor field is empty.
Probably a rookie mistake but I've spent a day with this now :-(
BR/David
You need an entry for the invvendor table at the same time. You can modify the integration object and then export the template.
Pat Morrow
pmorrow8@yahoo.com
On Thursday, January 9, 2014 2:14 PM, "david.andersson@ericsson.com" <david.andersson@ericsson.com> wrote:
Hi
In MX75 and the IBM Preview database, can anyone explain why this don't update the Primary Vendor ?
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns1:CreateMXINVENTORY xmlns:ns1="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ns1:MXINVENTORYSet>
<ns1:INVENTORY>
<ns1:BINNUM>F1-L4</ns1:BINNUM>
<ns1:CURBAL>1</ns1:CURBAL>
<ns1:ISSUEUNIT>EACH</ns1:ISSUEUNIT>
<ns1:ITEMNUM>10521</ns1:ITEMNUM>
<ns1:ITEMSETID>SET1</ns1:ITEMSETID>
<ns1:LOCATION>PKG</ns1:LOCATION>
<ns1:MANUFACTURER>EVERGR</ns1:MANUFACTURER>
<ns1:MINLEVEL>0</ns1:MINLEVEL>
<ns1:MODELNUM>ADEPT</ns1:MODELNUM>
<ns1:ORDERQTY>1</ns1:ORDERQTY>
<ns1:ORDERUNIT>EACH</ns1:ORDERUNIT>
<ns1:ORGID>EAGLENA</ns1:ORGID>
<ns1:REORDER>0</ns1:REORDER>
<ns1:SITEID>BEDFORD</ns1:SITEID>
<ns1:VENDOR>EVERGR</ns1:VENDOR>
<ns1:INVCOST>
<ns1:AVGCOST>600</ns1:AVGCOST>
<ns1:LASTCOST>600</ns1:LASTCOST>
<ns1:ORGID>EAGLENA</ns1:ORGID>
</ns1:INVCOST>
</ns1:INVENTORY>
</ns1:MXINVENTORYSet>
</ns1:CreateMXINVENTORY>
What else is required to import primary vendor?
Even after importing invbal and invvender the primary vendor field is empty.
Probably a rookie mistake but I've spent a day with this now :-(
BR/David
Hi Pat, so it needs to be done at the same time?, a separate import into invvendor using the default objectstructure MXInvvendor will not work?
/David
---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote:
You need an entry for the invvendor table at the same time. You can modify the integration object and then export the template.
Pat Morrow
pmorrow8@...
On Thursday, January 9, 2014 2:14 PM, "david.andersson@..." <david.andersson@...> wrote:
Hi
In MX75 and the IBM Preview database, can anyone explain why this don't update the Primary Vendor ?
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns1:CreateMXINVENTORY xmlns:ns1="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ns1:MXINVENTORYSet>
<ns1:INVENTORY>
<ns1:BINNUM>F1-L4</ns1:BINNUM>
<ns1:CURBAL>1</ns1:CURBAL>
<ns1:ISSUEUNIT>EACH</ns1:ISSUEUNIT>
<ns1:ITEMNUM>10521</ns1:ITEMNUM>
<ns1:ITEMSETID>SET1</ns1:ITEMSETID>
<ns1:LOCATION>PKG</ns1:LOCATION>
<ns1:MANUFACTURER>EVERGR</ns1:MANUFACTURER>
<ns1:MINLEVEL>0</ns1:MINLEVEL>
<ns1:MODELNUM>ADEPT</ns1:MODELNUM>
<ns1:ORDERQTY>1</ns1:ORDERQTY>
<ns1:ORDERUNIT>EACH</ns1:ORDERUNIT>
<ns1:ORGID>EAGLENA</ns1:ORGID>
<ns1:REORDER>0</ns1:REORDER>
<ns1:SITEID>BEDFORD</ns1:SITEID>
<ns1:VENDOR>EVERGR</ns1:VENDOR>
<ns1:INVCOST>
<ns1:AVGCOST>600</ns1:AVGCOST>
<ns1:LASTCOST>600</ns1:LASTCOST>
<ns1:ORGID>EAGLENA</ns1:ORGID>
</ns1:INVCOST>
</ns1:INVENTORY>
</ns1:MXINVENTORYSet>
</ns1:CreateMXINVENTORY>
What else is required to import primary vendor?
Even after importing invbal and invvender the primary vendor field is empty.
Probably a rookie mistake but I've spent a day with this now :-(
BR/David
If you have a system you can play with, turn auditing on and then add an item with a primary vendor to inventory. Capture the sql insert and that should show what you need to do.
I think you can add both at the same time, but have not tried that myself.
Pat Morrow
pmorrow8@yahoo.com
On Thursday, January 9, 2014 3:38 PM, "david.andersson@ericsson.com" <david.andersson@ericsson.com> wrote:
Hi Pat, so it needs to be done at the same time?, a separate import into invvendor using the default objectstructure MXInvvendor will not work?
/David
---In MAXIMO@yahoogroups.com, <pmorrow8@...> wrote:
You need an entry for the invvendor table at the same time. You can modify the integration object and then export the template.
Pat Morrow
pmorrow8@...
On Thursday, January 9, 2014 2:14 PM, "david.andersson@..." <david.andersson@...> wrote:
Hi
In MX75 and the IBM Preview database, can anyone explain why this don't update the Primary Vendor ?
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns1:CreateMXINVENTORY xmlns:ns1="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ns1:MXINVENTORYSet>
<ns1:INVENTORY>
<ns1:BINNUM>F1-L4</ns1:BINNUM>
<ns1:CURBAL>1</ns1:CURBAL>
<ns1:ISSUEUNIT>EACH</ns1:ISSUEUNIT>
<ns1:ITEMNUM>10521</ns1:ITEMNUM>
<ns1:ITEMSETID>SET1</ns1:ITEMSETID>
<ns1:LOCATION>PKG</ns1:LOCATION>
<ns1:MANUFACTURER>EVERGR</ns1:MANUFACTURER>
<ns1:MINLEVEL>0</ns1:MINLEVEL>
<ns1:MODELNUM>ADEPT</ns1:MODELNUM>
<ns1:ORDERQTY>1</ns1:ORDERQTY>
<ns1:ORDERUNIT>EACH</ns1:ORDERUNIT>
<ns1:ORGID>EAGLENA</ns1:ORGID>
<ns1:REORDER>0</ns1:REORDER>
<ns1:SITEID>BEDFORD</ns1:SITEID>
<ns1:VENDOR>EVERGR</ns1:VENDOR>
<ns1:INVCOST>
<ns1:AVGCOST>600</ns1:AVGCOST>
<ns1:LASTCOST>600</ns1:LASTCOST>
<ns1:ORGID>EAGLENA</ns1:ORGID>
</ns1:INVCOST>
</ns1:INVENTORY>
</ns1:MXINVENTORYSet>
</ns1:CreateMXINVENTORY>
What else is required to import primary vendor?
Even after importing invbal and invvender the primary vendor field is empty.
Probably a rookie mistake but I've spent a day with this now :-(
BR/David