Sending Posted Sales Invoices and Posted Sales Credit Memo's with Customer Statements
If you wish to send Customer Statements using Document Delivery that will also attach any relevant Posted Sales Invoice and Credit Memo the Customer has open still, then follow the below instructions.
- Open the "STMNT" doc type and select Linked Tables in the ribbon.
- We need to associate the Sales Invoice Header and Sales Credit Memo Header tables to this Doc Type so create 2 new Link No's, choosing Tables '112' and '114'.
- Highlight the line for the 'Sales Invoice Header' and in the LINKS FastTab below, ensure the below 2 lines are added. This will then check to ensure the 'Bill to Customer No' matches from the Customer Statement to the Sales Invoice and will also only try and attach any Sales Invoices that are not yet 'Closed', therefore is still outstanding.
- Next, we'll do the same thing but instead, highlight the Link No for the 'Sales Credit Memo' and this time, add the below lines for this table. Again, this ensures that a check is made to the 'Bill to Customer No' on the credit and will only return Sales Credit memo's as attachments where they are not yet 'Paid'.
- Now that you have added the Linked Tables, go back to the Document Type for the 'STMNT' and add the 2 reports into the Attachment FastTab as per below image.
- Highlight the 'Sales Credit Memo' line and click into the Doc Type Attachment Card.
Ensure the Report Filter Source is 'Linked Table' and select the Sales Credit Memo Link No from the dropdown list. Repeat this action on the 'Sales Invoice' line in the Attachments FastTab, ensuring the Report Filter Source No specifies the 'Sales Invoice' Link No.
- Finally, decide if the reports are Optional. Having this as 'Yes' means if one of the reports cannot be run (i..e the customer has no open credit memo's for example), then Document Delivery will simply send the Customer Statement and Sales Invoice attachments, bypassing the requirement for Credits. Where this is 'No', this makes the document a requirement, so if in the instance there are no open credits, then Document Delivery will error and the attachments will not be sent.
This process will now send Customer Statements as well as Invoices and/or credits that still have remaining balances.