Language:


Create Periodic Supplier Statement E-mail

This function will send Periodic Supplier Statements to Suppliers by email. The function will create a separate Mail for each Supplier, as follows:
  • The sender of each Mail will be the current user or, if the current user has no Mailbox, the From System Mailbox specified in the Mail and Conference Settings setting in the E-mail and Conferences module.

  • The Recipient of each Mail will be chosen as follows:

    1. If the Supplier has a record in the Additional Email Recipients setting in the CRM module, the Mail will be sent to the Contact Persons listed with the Form Type "Periodic Supplier Statement" in that record.

    2. If the Supplier does not have a record in the Additional Email Recipients setting or its record has no Contact Persons with the Form Type "Periodic Supplier Statement", the Mail will be sent to the Email Address specified in the Contact record for the Supplier.

    There must be an Email Address in the Contact record for the Supplier, even if the Recipient will be taken from the Additional Email Recipients setting. Otherwise, no Mail will be created for the Supplier.

  • The Subject and Text of the Mail will be taken from the record in the Mail Texts setting in the E-mail and Conferences module in which the Form is "Periodic Supplier Statement". If you have specified a Language in the Contact record for the Supplier and the Mail Text record contains a row for that Language, the Subject and Text will be determined by the fields in that row. Otherwise, they will be determined by the fields in the Mail Text header, as follows:

    1. The Subject in the mail will be composed from the Subject in the Mail Text record (which should not have a trailing space), a colon and the Supplier Number. For example, if the Subject in the Mail Text record is "Statement attached" (without trailing space), the Subject of the Mail will be "Statement attached: XXXX" (where XXXX is the Supplier Number).

    2. The Text of the Mail will be built up as follows:

      1. The initial text will be taken from the Standard Text record quoted in the First Text field in the Mail Text record.

      2. The final text will be taken from the Standard Text record quoted in the Last Text field in the Mail Text record.

    If either Standard Text record is in HTML format, the Mail will be in HTML format as well.

    If there is no suitable record in the Mail Texts setting, the Subject of the Mail will be "Periodic Supplier Statement: XXXX" (where XXXX is the Supplier Number). The Text of the Mail will be "Please see attached file for Periodic Customer Statement".

  • The Periodic Supplier Statement form will be attached to the Mail as a PDF file, accessible through the Document Manager. This requires you to have designed a Form Template to be used by the Periodic Supplier Statement form, and to have assigned that Form Template to the Periodic Supplier Statement using the 'Define Form' function. When you design the Form Template, you may need to use Styles that will embed fonts in PDF files (this will depend on the fonts you use). You may also need to choose a code page and page setup, which you can do in the Form Template Properties. Please refer here for details about designing Form Templates and here for a list of the fields you can include in the Form Template used by the Periodic Supplier Statement form.
By default, the Mails created by this function will not be marked as Sent. So, you will have the opportunity to check and edit them. If necessary, however, you can have them marked as Sent immediately and automatically.

To send Mails to Suppliers using this function, you must be using the External Gateway module, and you must have configured the E-Mail SMTP Server setting. Please refer here for full details about the mailing features in Standard ERP.

Selecting the function brings up the following dialogue box:

Period
Paste Special    Reporting Periods setting, System module
Specify a period to be covered by the statements.

Supplier
Paste Special    Suppliers in Contact register
Range Reporting    Alpha
If necessary, enter here the Supplier Number of the Supplier (or range of Suppliers) for whom you wish to send statements by email.

Category
Paste Special    Supplier Categories setting, Purchase Ledger
If you want to send statements by email to Suppliers belonging to a particular Supplier Category, specify that Category here.

Classification
Paste Special    Contact Classifications setting, CRM module
Enter a Classification Code in this field if you want to send statements by email to Suppliers with a certain Classification. If the field is empty, statements will be sent to all Suppliers, with and without Classifications. If you enter a number of Classifications separated by commas, statements will only be sent to those Suppliers featuring all the Classifications listed.

Creditors Account
Paste Special    Account register, Nominal Ledger/System module
If you need the statements only to list the Purchase Invoices and Payments that post to a particular Creditor Account, specify that Account here.

This field will not be used when calculating opening balance figures.

Suppliers with Balance Only
Check this box to exclude Suppliers with no current balance.

Amounts in Currency
Use this option to specify the Currency that will be used when printing some of the values in the statement.

The following fields will print values in Currency or in Base Currency 1, depending on the option that you choose here: "Change during the Period", "Start Balance"; "Sum".

The following fields will always print values in the Purch. Currency specified in the Contact record for the Supplier (in Base Currency 1 if the Purch. Currency is blank): "Account Balances".

The following row fields will always print values in the currency of the transaction: "Balance"; "Credit Value, row"; "Debit Value, row"; "Invoice Amount"; "Received Value".

Include Ordered Payments
Use this option if you want to include Payments that have been Ordered but not marked as OK in statements.

Show Invoices Records
By default, transactions will be listed in chronological order in statements. For example, if you receive three Purchase Invoices from a Supplier and then pay all three, the statement will list the three Invoices followed by the Payments.

If you use this option, Purchase Invoices will still be listed in chronological order, but the connected Payment(s) will follow immediately. In the example, a statement printed using this option will list the first Purchase Invoice followed by the corresponding Payment, then the second Purchase Invoice followed by its Payment and so on.

Send e-mails automatically
Choose this option if you would like the Mails created by this function to be marked as Sent automatically. As the Mails will be sent to external e-mail addresses, they will be sent to the E-mail Queue immediately. This might be useful if the function creates many Mails but bear in mind that the Mails are created without any Text so you might need to check and update the Mails before sending them.
When the specification window is complete, click (Windows/Mac OS X) or tap (iOS/Android) the [Run] button to activate the function. The relevant Mails will be created with statements attached, to be placed in your Mailbox (or the From System Mailbox). If you did not choose the Send e-mails automatically option, you will need to mark each Mail as Sent and save it in order for it to be sent to the E-mail Queue and from there to the Supplier.

---

Maintenance functions in the Purchase Ledger:

Go back to: