Function #39: Schedule Vendor Statements

Function #39: Schedule Vendor Statements



Hello everyone!

As we continue our series, today we bring you a function that automatically sends vendor statements at scheduled intervals, similar to the function we previously shared for sending customer statements. By minimizing the need for manual intervention, this function ensures that your vendors promptly receive detailed statements of your purchases and outstanding dues.

Prerequisites:

1. Create a Connection named "zbooks" to successfully execute the function. You can watch the GIF attached below to know how to create the connection.



2. Create a date-type custom field called "Statement Date" for the vendors and input the starting date for sending statements into this field. If the date is the same for all vendors, you can set it as the Default value when creating the custom field.



Custom Function:

Navigate to Settings -> Automation -> Workflow Actions -> Custom Functions -> +New Custom Function > Add the function code from this GitHub link -> Hit Save.

Workflow Rule: 

Go to Settings -> Automation -> Workflow Rules -> +New Workflow Rule and set up the workflow rule as shown below:






Select your preferred Execution Time and Execution Cycle. In the final step of this workflow rule, associate the custom function you created and then hit Save.

By scheduling the vendor statements, you and your vendor can streamline and expedite the reconciliation process. Should you require any assistance in configuring this custom function, please don't hesitate to reach out to our support team at support[at]zohobooks[dot]com.

Regards,
Shireen Farhana
Zoho Books