Upload Limitations with Adjustments
When updating adjustments there lies the issue where two adjustments can visually appear the exact same in Oracle. Because of this More4Apps is unable to differentiate between two adjustments that appear the same through usual methods. To try to remedy this, More4Apps have included the display only columns in the Adjustments section.
These columns are used to distinguish each record, as shown below:
As we can see above, rows 13 and 14 are identical. Because of this More4apps cannot distinguish these two records so only the first record will be updated when an update is made against these records.
By having these display only columns the Wizard can distinguish rows 12 and 15 so these can be updated freely.
Furthermore with rows 13 and 14 for example - In the scenario where row 13s ‘UOM’ has been modified to ‘KG’ and row 14’s to ‘GRAMS’, when an upload is run, because the records are not distinguishable row 13’s UOM value will be changed to ‘GRAMS’ because this would be the last record processed in the upload.
This is illustrated below:
Before Upload
After Upload
Refer to section: