We are in service business used to collect one time refundable deposit from Sub Franchise, apart from this we are not dealing with them directly, all business transaction will happen through Franchise account only.
Now we are accounting all these deposits in Franchise accounts, identification of deposit (Belongs to Franchise and Sub Franchise) is happening only basing on text, this is creating problem in identification of deposit details for a given period (Month end / Yearend) for reporting and also while refunding the deposits to Sub Franchise, as transactions relating to deposits from Franchise and Sub Franchise are clubbed in one account. (User discipline is playing crucial role in this scenario).
Without creating separate customer master for sub franchise (To reduce customer master data in SAP) is there any other solution for identification of sub franchise deposit details. If required we are ready to enter some additional data while accounting deposit to get required details.
Can any body Kindly suggest to resolve our issue
Thanks & Regards