Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-253190 - Update A/R Failed|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-253190]
* Issue
** CF Tran Calculated Total Amount is not matching to the AR Sales Invoice total amount.
** This is causing the CF Invoice - Update AR process to not work correctly and creating blockers at month end
** In most cases the differences is attributed to taxes
* Requirements
** At the time of Posting CF Trans
*** Ensure that there was no issue with sending data to AR side and that both transactions match.
**** Pre-certify if there is a mismatch of data in CF before posting to AR.
***** This will catch double taxes and missing taxes
***** Before calling AR SP to create tblARInvoice for the transactions
****** Review for transactions where:
******* (CF Net Price x quantity ) + Sum of Calc Tax Amount <> CF Total Amount
******** First part of this must match the same method that AR uses to calculate their invoice amounts
****** Exclude these transactions from posting and mark them as invalid
****** Provide a list at the end of batch posting of invalid transactions
*** Minimize impact to performance for large volume postings.
** Improve Audit Log usage to find cause
*** Add Audit record to CF Tran for Individual Posting
*** Add Audit record to CF Tran for Batch Posting
*** Add Audit record for Batch Recalculate
**** And CF Tran > Recalculate button if needed.
*** Add Audit Record for Created
|