what table is to assign paperless office for customers with email address?

SOLVED

I would like to update all our customers to receive invoice via email pdf, what table should I use for import? Also is there a way for us to set all new customers to have the Paperless office PDF to have the email checked?

Thanks.

Parents
  • 0
    SUGGESTED

    AR_CustomerDocuments is the table you are looking for.

    There isn't currently a way to do a default Paperless Office setup for new customers.  That is something being considered for a future enhancement.

  • 0 in reply to Steve Passmore

    I checked the table, but that only shows customers that have already email document checked, is there a way for me to assign customers that do not have paperless office setup through VI, perhaps other table? thanks.

  • 0 in reply to tea

    You would setup a V/I Import into that table, AR_CustomerDocuments.  You can choose in the import to setup the customer for Print, E-mail or Fax.  If E-mail, whether to use the email address in data entry or the customer e-mail.  If Fax, whether to user the fax number in data entry or the customer fax number.  

    If you do not know what to use for the Document field in the import file, just setup a record for a customer for the desired document (example: A/R Invoice, S/O Invoice, A/R Statement, etc) and then look at the data in DFDM to get the value needed.

    You can't import the detail of contact codes and additional e-mail addresses.

Reply
  • 0 in reply to tea

    You would setup a V/I Import into that table, AR_CustomerDocuments.  You can choose in the import to setup the customer for Print, E-mail or Fax.  If E-mail, whether to use the email address in data entry or the customer e-mail.  If Fax, whether to user the fax number in data entry or the customer fax number.  

    If you do not know what to use for the Document field in the import file, just setup a record for a customer for the desired document (example: A/R Invoice, S/O Invoice, A/R Statement, etc) and then look at the data in DFDM to get the value needed.

    You can't import the detail of contact codes and additional e-mail addresses.

Children