Last updated on NOVEMBER 30, 2015
Applies to:Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
Movement Statistics Exception Report has returned a "Missing/Incorrect Trading Partner VAT Number" error (movement 5020).
User then populates a VAT number against the corresponding Customer Bill To site and returns to Movement Statistics records. User tries to validate movement record using Tool>Validate option but error message remains.
There is no field on the Movement Detail form to populate the Trading Partner VAT Number. How can these exceptions be resolved ?
Table MTL_MOVEMENT_STATISTICS includes a column: CUSTOMER_VAT_NUMBER which is populated by the Movement Statistics Processor with the value in the 'Tax Registration Number' field on the customer's Account Bill-to Site. If a user has failed to enter a 'Tax Registration Number' value on the bill to site, the column will be null for any movement created for that customer Bill-to. The user would then need to correct the movement record and would normally do so using the
Inventory Superuser>Transactions>Movement Statistics form. However there is no field on that form which allows the user to update the null value for a movement record. How does a user maintain/correct information held in this table?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms