Troubleshooting
Problem
This documentation provides info on other fields which must be considered when increasing the length or scale of Unit Cost and Line Cost fields in Maximo 7.5.x and Maximo 7.6.x.
Resolving The Problem
Customers may increase or decrease the length or scale of Purchasing Cost related fields. For example, the length of the Unit Cost on a Purchase Order Line (POLINE.UNITCOST) may be increased to 15, and the scale to 5. After increasing or decreasing the length or scale of a field related to purchasing cost, other attributes must also be configured.
This document lists tables and attributes which must be configured for the Purchase Requisitions, Purchase Orders, Receiving, Invoices, Request for Quotations, Contracts, Inventory, and Desktop Requisitions applications. Tables and attributes listed in this document apply to out-of-box base Maximo 7.5 or 7.6 installations.
Additionally, customers need to identify cost-related customization attributes in each application and alter those attributes as well.
Steps
1) In Database Configuration, apply the new length or scale to attributes on tables for the application you wish to alter.
2) In Database Configuration, Select Action “Field Length and Format”. Change Amount Length or Scale to the new length/scale.
3) To approve PRs, apply the new length/scale to attribute PRLIMIT in the LIMITTOLERANCE table.
To approve POs, apply the new length/scale to attribute POLIMIT in the LIMITTOLERANCE table.
To approve Invoices, apply the new length/scale to attribute INVOICELIMIT in the LIMITTOLERANCE table.
To approve Contracts, apply the new length/scale to attribute CONTRACTLIMIT in the LIMITTOLERANCE table.
To approve Desktop Requisitions, apply the new length/scale to attribute MRLIMIT in the LIMITTOLERANCE table.
4) Here are the relevant tables and attributes for each application:
Purchase Requisitions Application
In the PR table
PRETAXTOTAL
TOTALBASECOST
TOTALCOST
TOTALTAX1
TOTALTAX2
TOTALTAX3
TOTALTAX4
TOTALTAX5
In the PRLINE table
LINECOST
LINECOST2
LOADEDCOST
TAX1
TAX2
TAX3
TAX4
TAX5
UNITCOST
Purchase Orders Application
In the PO table
PRETAXTOTAL
RECEIVEDTOTALCOST
TOTALBASECOST
TOTALCOST
TOTALTAX1
TOTALTAX2
TOTALTAX3
TOTALTAX4
TOTALTAX5
In the POLINE table
LINECOST
LINECOST2
LOADEDCOST
PRORATECOST
RECEIVEDLINECOST
RECEIVEDTOTALCOST
RECEIVEDUNITCOST
TAX1
TAX2
TAX3
TAX4
TAX5
UNINVOICEDCOST
UNITCOST
In the INVVENDOR table
BIDPRICE
LASTCOST
Receiving Application
In the MATRECTRANS table
CURRENCYLINECOST
CURRENCYLOADEDCOST
CURRENCYORDERUNITCOST
CURRENCYTAX1
CURRENCYTAX2
CURRENCYTAX3
CURRENCYTAX4
CURRENCYTAX5
CURRENCYUNITCOST
INVOICEMATUNITCOST
LINECOST2
LOADEDCOST
POLINECOST
POUNITCOST
PRORATECOST
TAX1
TAX2
TAX3
TAX4
TAX5
UNINVOICEDCOST
In the MATUSETRANS table
CURRENCYLINECOST
CURRENCYUNITCOST
LINECOST2
In the SERVRECTRANS table
ACCEPTEDCOST
CURRENCYLINECOST
CURRENCYLOADEDCOST
CURRENCYORDERUNITCOST
CURRENCYTAX1
CURRENCYTAX2
CURRENCYTAX3
CURRENCYTAX4
CURRENCYTAX5
CURRENCYUNITCOST
INSPECTIONCOST
LINECOST2
LINECOSTALREADYRECVD
LOADEDCOST
PRORATECOST
REJECTCOST
TAX1
TAX2
TAX3
TAX4
TAX5
TEMPLOADEDCOST
UNINVOICEDCOST
Invoices Application
In the INVOICE table
DISCOUNT
LINETOTAL
PAID
PRETAXTOTAL
PRETAXTOTALFORUI
TOTALALLOCATED
TOTALCOST
TOTALCOSTFORUI
TOTALTAX1
TOTALTAX1FORUI
TOTALTAX2
TOTALTAX2FORUI
TOTALTAX3
TOTALTAX3FORUI
TOTALTAX4
TOTALTAX4FORUI
TOTALTAX5
TOTALTAX5FORUI
TOTALTOALLOCATE
UNINVOICEDTOTAL
VARIANCE
In the INVOICELINE table
LINECOST
LINECOST2
LINECOSTFORUI
LOADEDCOST
LOADEDCOSTFORUI
PRICEVAR
PRORATECOST
TAX1
TAX1FORUI
TAX2
TAX2FORUI
TAX3
TAX3FORUI
TAX4
TAX4FORUI
TAX5
TAX5FORUI
UNITCOST
In the INVOICECOST table
LINECOST
LINECOSTFORUI
UNITCOST
In the INVOICEMATCH table
LINECOST
In the INVOICETRANS table
CURRENCYLINECOST
LINECOST2
Request for Quotations Application
In the RFQLINE table
LINECOST
UNITCOST
In the QUOTATIONLINE table
LINECOST
LINECOST2
TAX1
TAX2
TAX3
TAX4
TAX5
UNITCOST
Contracts Applications
In the CONTRACT table
TOTALBASECOST
In the CONTRACT LINE table
LINECOST
LINECOST2
UNITCOST
In the CONTRACTPURCH table
AMTREMAINING
MAXRELVOL
MAXVOL
In the CONTRACTSFW table
AMTREMAINING
MAXRELVOL
MAXVOL
In CONTLEASEENDASST table
RMNCOST
TAX1
TAX2
TAX3
TAX4
TAX5
In SCHEDULE table
INTERIMCHARGE
LINECOST
LOADEDCOST
TAX1
TAX2
TAX3
TAX4
TAX5
In SCHEDULELINE table
INTERIMCHARGE
LINECOST
LOADEDCOST
TAX1
TAX2
TAX3
TAX4
TAX5
Inventory Application
In the INVTRANS table
LINECOST
LINECOST2
Desktop Requisitions Application
In the MR table
BASETOTALCOST
BASETOTALCOST2
TOTALCOST
In the MRLINE table
LINECOST
LINECOST1
LINECOST2
UNITCOST
5) Additionally, some customers may use high-precision quantities for costing purposes. For example, a customer may place an order for 1.62510 units of a material priced by Gallon. If customers use high-precision quantities in cost calculations, the following quantity, balance, and amount attributes should be updated. However, these changes are unnecessary for customers whose quantities are low-precision values such as integers.
Purchase Orders Application
In the POLINE table
AMOUNTTORECEIVE
INTRANSITQTY
QTYTORECEIVE
RECEIPTTOLAMT
RECEIPTTOLQTY
RECEIVEDQTY
UNINVOICEDQUANTITY
Receiving Application
In the MATRECTRANS table
ACCEPTEDQTY
INSPECTEDQTY
NEWPHYSCNT
ORDERQTY
QTYALREADYRECVD
QTYHELD
QTYOVERRECEIVED
QTYREQUESTED
QUANTITY
RECEIPTQUANTITY
REJECTQTY
RESERVEDQTY
UNINVOICEDQUANTITY
In the MATUSETRANS table
NEWPHYSCNT
PHYSCNT
POSITIVEQUANTITY
QTYREQUESTED
QTYRETURNED
QUANTITY
RESERVEDQTY
In the SERVRECTRANS table
ACCEPTEDQTY
INSPECTEDQTY
ORDERQTY
QTYALREADYRECVD
QTYOVERRECEIVED
QTYTORECEIVE
QUANTITY
REJECTQTY
UNINVOICEDQUANTITY
Invoices Application
In the INVOICELINE table
INVOICEQTY
QTYFORUI
QTYOVERRECEIVED
In the INVOICECOST table
QTYFORUI
QUANTITY
In the INVOICEMATCH table
QUANTITY
Inventory Application
In the INVTRANS table
CURBAL
PHYSCNT
QUANTITY
In the INVUSELINESPLIT table
NEWPHYSCNT
PHYSCNT
QUANTITY
Desktop Requisitions Application
In the MRLINE table
QTY
QTY_V
Should you need any assistance, please contact IBM Maximo Support
Related Information
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21962935