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 Reply Children
  • 0 in reply to tea

    I made a mistake, I should have tried setting up a V/I job before I posted.  You CAN import both the AR_CustomerDocuments and AR_CustomerDocumentContacts detail in one V/I job.  It is a header/detail import similar to a sales order or invoice import.

    There isn't anything different for importing new records versus updating existing records.  The V/I import will add the record if it doesn't exist or update it if it does exist.  Updating the detail in AR_CustomerDocumentContacts would be an issue without knowing the LineKey$ of the existing record, but you mentioned you want to create new entries so that shouldn't be an issue for you.