Movement Statistics exception CUSTOMER_VAT_NUMBER
(Doc ID 577273.1)
Last updated on APRIL 04, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10 and laterInformation in this document applies to any platform.
INVSMDRB.pls
INVTTMVT.fmb
Symptoms
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?
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |