I want to create a cash receipt in A/R module with SData. I have identified the required tables for it.
- GL_CompanyActiveBatch
- GL_CompanyActiveBatch is read-only for SData, so I am not able to create the record here.
- AR_CashReceiptsDeposit
- I am able to create the record here.
- AR_CashReceiptsHeader
- Here I am getting the error like "Deposit is out balance", so the record is not created here.
- AR_CashReceiptsDetail
- There is no header record, so details record also not creating.
Anybody tried this scenario. If this is not possible with SData, is there any other interface I can use to create the Cash receipt in Sage. I am using this in C#.