Data in the Commissions test query not getting up to date
The comms query for some manual adjustments ( like the one for this doc-801774961) the value appears with the ERROR beside it.
From our survey what we found is:
On checking upon Comms query, we found that the feild Subtotal 3(local) reflects the value, but along with that it also reflects Error beside it.
On checking upon the infoprovider, we found that:
The Document No: 801774961, having Start Date: 03/31/2014 has the CALMONTH reflecting as 000000, LOCAL CURRENCY feild is Empty.
Where as the same Document No: 801774961, having different Start Date has the proper Currency field, Month and Week mentioned properly.
There are also few more Document Item which contains Source id for which it reflects Error beside the result, when the Commissions Query report is being run in BeX.
Checking on the Transformation we couldnot find any direct connection between Local Currency and CALMONTH. Where as other Document Item are getting updated with proper records locally.
Could anyone please advice why an Error is getting reflected beside the value when the report gets generated?