Interface – Client / Supplier / Payment

This interface allows you to generate records in an existing DeMaSy database.

Here the tables structure :

Here the different interface options:

  • Import file : XML file to select.
  • Allows interfacing invoice details multiple times:
    If TRUE : invoice details are always interfaced, even if they exist already.
    If FALSE : invoice details are not interfaced if they exist already.
  • Allows interfacing payments multiple times:
    If TRUE : payments are always interfaced, even if they exist already.
    If FALSE : payments are not interfaced if they exist already.
    The existence verification criteria are as following:
    1) Invoice number 2) Payment date 3) Bank account 4) Bank Statement 5) Amount
    6) Description.
  • Update client name based upon file number :
    If TRUE : client is identified by his name, in first. If necessary, by file number.
    If FALSE : client is identified by his file number, in first. If necessary, by name.
    Also, if client name and file number are specified in file, client name is updated for the given file number.