How do you create payment spreadsheet for multiple items under one payment id?
I need to upload a deposit that has one payment id but multiple items that the payment will be applied against. Also, there could be multiple customers. When entering the data into the excel upload template, do you need to populate all fields in record type 000 and 001 for each item that pertains to that payment? I have been leaving the fields blank since it relates to the same deposit/payment. Review of the payment tables, it appears that the data is loaded correctly but AR Update is not posting the deposit.