Archives of the TeradataForum
Message Posted: Mon, 14 Apr 2003 @ 20:45:01 GMT
I guess it would depend on where the transaction surfaced. At one of the retailers I did some work for Back Posting was not uncommon. However, if the transaction was discovered at the day/item/shop level being their lowest level then it was input and rolled up to the higher level tables and all the aggregates were re-calculated again. On the other hand it could also have been submitted as a store adjustment if that was what the business wanted to do. If an entire week was missing or miss calculated I have actually gone in and deleted the week or the date range and then re submitted the transactions and processed then for re-aggregation and rollup. This can get tricky, but it can be done. You almost have to process them independently and then merge each set into it's own table or group after the processing is over.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|