Hi everyone,
I'm trying to include unapplied Customer Deposits on the Customer Statement PDF. Ideally, I'd like to display them in a separate table below the standard statement transaction list.
Is this possible using the standard Advanced PDF/HTML Customer Statement template? If so, how can I access unapplied Customer Deposit data within the template?
I was also considering a SuiteScript solution. However, my understanding is that a script would only be able to retrieve unapplied deposits as of the current date. Customer statements can be generated for historical statement dates, so I'm not sure how I would accurately retrieve the historical unapplied deposit balance for a past statement date without recreating the historical data using searches or SuiteQL.
Has anyone implemented this before, or is there a recommended best practice for displaying unapplied Customer Deposits on customer statements?
Any suggestions or guidance would be greatly appreciated.
Thank you!