Nice explanation. I always recommend cleansing prior to extraction. Cleansing should be done at source. Why? There would be multiple mock cycles and cleansing at source keeps master data clean during all mocks without repeating cleansing activities at each time saving time during cutover. Thoughts?
True but sometime cleansing can't be done because the source is messed up. I remember a case where the customer was migrating from sage and the asset depreciation was not correctly calculated. The team wasn't able to fix that on sage so we did it on excel after extraction. I agree if cleansing can be done in the source then it's much better
@@AbdullahGalal in this case the cleansing could be a part of transformation if it follows some logics and only if it could be applied, otherwise, as you said we just need to clean the extraction file manually.
Hi abdulh! Hope you are fine! I have a case to discuss! When we clear more then one customer invoice through f-32 and Cash discount is granted to each invoice.Then Cash discount is debited to rebare and discount Gl cumulatively but we want line wise or invoice wise posting of Cash discount after simulation. Please guide