Please show me how to do the transformation and determine total account receivable and balance amount for each sale more details and step by step.  

Fluffy allows their customers to pay in installments. In the current system, sales orders and payments are recorded in two separate files. The SalesOrders file records the amount the customer owes Fluffy and the payments that have been received. The CashReceipts file records all payments received. Samples of both files are shown here.

Questions:

1. Identify and explain the primary issue in the data set.

2. Describe how you would reorganize the data to enable the calculation of accounts receivable.