Issue: Users may encounter the following error message when uploading allocation files: “Cumulative allocation percentage for valid vendors should be 100%. Current valid allocation: NaN%” Steps Taken: The user uploaded an allocation file

Issue Summary:

Users are unable to upload manually added charges through the Custom Charge upload sheet. Additionally, there's a mismatch in the total invoice value in the carrier_wise_cost_report even after the removal of manual charges.

Root Cause:

1. Duplicate Data in Upload Sheet:

   • The same charge has been entered multiple times with 100% allocation.

   • Example:

     • Invoice Number: CAR-XXXXXXXXXXXXX

     • Charge Name: Tolkosten:ALBERTHEIJN_DCT/2/DCT|202518|2371//MC MIDDELENCENTRUM TILBURG

   • In such cases, the allocation percentage should be adjusted:

     • If two identical entries exist, set allocation to 50% each.

     • For more than two entries, divide 100% equally.

2. Incorrect Total Invoice Value Post Deletion:

   • Although manual charges were removed (as per AH user's request for Week 18), the total invoice value was not cleared from the dataset.

   • This results in a mismatch in the carrier_wise_cost_report.

Action Taken:

• Manual charges for Week 18 have been successfully removed from Production.

• Identified the issue with the total invoice value persisting in the background.

• This has now been rectified by also removing the associated invoice value along with the charge records.
  
  

Solution:

1. For Uploading Manual Charges:

   • Ensure no duplicate invoice + charge name combinations exist.

   • If duplicates are valid, divide the allocation percentage appropriately so the sum equals 100%.

2. For Invoice Value Correction:

   • When removing manual charges from the system, ensure the related total invoice value is also cleared from reports like carrier_wise_cost_report.