Editing the data in the database is sometimes required. But you always want to ask why did you have too. Then chance backward. Perhaps their is a control file that is not filed out correctly, and you will have to repeat your action over and over.
Which piece of the distribution hit the ARDISFIL with no mn_no (Sales or Receivables) Sales side would check the AR SET File and sure the accounts are setup correctly, then would follow the hierarcy of posting to the Customer Type File.
Sales - Again the AR Setup File, then Product Category Location for sales, then Customer Type
Freight - would be AR Setup, Ship Via Code