Skip to main content

pVault Help

Vault Bridge Settings

Use the Bridge page to set up the connect or "bridge" between the pVault® system and your accounting/ERP system.

This "bridge" provides data lookups for indexing documents and throughout APFlow™ Invoice Entry (including Routing and Approval).

Note

A page with the same functionality exists within APFlow™ Settings, but the full procedure to configure the bridge for both pages can be found below. See APFlow™ Bridge for more information.

Important

The fields that display on this page may be different depending on the accounting system to which you are bridged. Before you successfully bridge to an accounting system, None displays in the visible fields.

  1. From My Paperless, click Vault Settings.

  2. In the Vault Settings navigation bar, click Bridge.

    The following page displays:

    VaultSettingsBridgemain-mh.PNG
  3. From the Bridge Type dropdown, click to select the appropriate bridge type.

    The Bridge Type dropdown reflects the business categories available. Construction in the most common choice in pVault.

    Note

    If the Bridge Type dropdown is set to None, then the Bridge Product field is not active.

    BridgeTypeDropdown.png
  4. From the Bridge Product dropdown, click to select the appropriate accounting system.

    The Bridge Product dropdown is connected with the bridge type and reflects those accounting systems associated with a specific business category. Based on the selected Bridge Type and Bridge Product, the remaining fields that display on the Bridge update.

    BridgeProductDropdown.png

The vault "bridge" connects the pVault® system to Acumatica. The bridge provides all of the data lookups and exporting features needed to run pVault.

Once the Bridge Type and Bridge Product fields are populated in Vault Bridge Settings, you can access the Validation Configuration grid fields.

  1. The Connection Url field should systematically populate. If it does not, enter your company's Connection Url in this field.

    Important

    The Connection Url value must end with: /entity

  2. In the Company Id field, enter your company ID.

  3. In the User Name field, enter your username.

    APFlowSettingsBridgeAcumaticaBridgeCompanyfieldvisible-mh.PNG
  4. In the Password field, enter the associated password.

  5. Click Validate Connection.

    The page updates to confirm your connectivity and the Bridge Company field displays.

    Note

    Once bridged, if you need to change the password associated with the Company Id, click Update Password.

    VaultSettings_Bridged_Accumatica_PVC.png
  6. Click Select Company to Bridge to access your Bridge Lookup list similar to the following:

    APFlowSettingsBridgeAcumaticaSelectCompanyToBridgeBridgeLookup-mh.PNG
  7. Click the check box associated with your bridged company.

  8. Click Add.

  9. Click Save.

Important

If you bridge to Acumatica and our customization is not installed in Acumatica, you can log in to view what customization is required. However, the Download Customization button is not visible.

  1. After you are done bridging and have validated the connection, click Download Customization.

    VaultSettings_Bridged_Accumatica_PVC.png

    The file downloads similar to the following:

    AcumaticaDownloadCustomizationdropdown-mh.PNG
  2. Open the download folder.

  3. Right click on the file and click Properties.

    A dialog similar to the following displays:

    APFlowSettingsBridgeFileSettingsdialog-mh.PNG
  4. Verify that the Unblock check box is selected. If it is blank, select it.

  5. Click OK to close the dialog.

Import Customization Project

To upload the customization project deployment package, import the project using the Customization Projects (SM204505) form.

  1. Log in to the Acumatica instance under the tenant being integrated to pVault®.

  2. From Systems, click Customization.

  3. Click Manage.

  4. Select Customization Projects.

    The Customization Projects window similar to the following displays:

    AcumaticaImportCustomizationProjectswindow-mh.PNG
  5. In the form toolbar, click Import.

    The Open Package dialog displays:

    image197.png
  6. In the File path field, select the deployment package file to be uploaded.

  7. Click UPLOAD.

Publish Customization Project

To publish customization projects, the following actions must be performed on the Customization Projects (SM204505) form.

  1. Log in to the Acumatica instance under the tenant being integrated to pVault®.

  2. From Systems, click Customization.

  3. Click Manage.

  4. Select Customization Projects.

    The Customization Projects window similar to the following displays:

    AcumaticaImportCustomizationProjectswindow1-mh.PNG
  5. In the Project Name column, click the associated check box(es) in the unlabeled column at the far left for the customization projects to publish.

    Important

    Be sure to include all existing items, previously published customizations and the new pVault PV customization.

  6. Click Publish to initiate publication of the selected projects.

    Warning

    Active website users are logged out.

    A Compilation window similar to the following displays:

    AcumaticaImportCompilationwindow-mh.PNG
  7. After the compilation is complete, click Publish to finalize publication.

    The Compilation window resembles the following:

    AcumaticaImportCompilationcompletewindow-mh.PNG
Update Customization Project

To update the PV Customization Project to a new version, perform the following actions.

  1. Log in to the Acumatica instance under the tenant being integrated to pVault®.

  2. From Systems, click Customization.

  3. Click Manage.

  4. Select Customization Projects.

    The Customization Projects window similar to the following displays:

    AcumaticaImportCustomizationProjectswindow1-mh.PNG
  5. Follow the steps to import the updated Customization Package. See Import Customization Project.

  6. Clear the previously checked boxes (in the unlabeled column) and check only the check box for the new PV Customization.

  7. On the toolbar, click Publish to initiate publication of the selected project.

    Warning

    Active website users are logged out.

  8. After the Compilation is complete, click Publish to finalize publication.

  9. To remove the previous PV custom project after it is unpublished, select the row to highlight it and then click the X in the toolbar, (Delete Row). Then, click Save.

    AcumaticaImportCustomizationProjectsDeleteRowwindow-mh.PNG
Remove Customization Project

To remove the pVault® customization project from publication, complete the following steps:

  1. Log in to the Acumatica instance under the tenant being integrated to pVault.

  2. From Systems, click Customization.

  3. Click Manage.

  4. Select Customization Projects.

    The Customization Projects window similar to the following displays:

    AcumaticaImportCustomizationProjectswindow1-mh.PNG
  5. In the Project Name list, be sure the boxes are checked associated with projects that should remain published and clear those check boxes for the PV customization project.

  6. On the toolbar, click PUBLISH to initiate publication of the selected project.

    Warning

    Active website users are logged out.

  7. After the Compilation is complete, click Publish to finalize publication.

  8. Remove the previous PV custom project after it is unpublished, select the row to highlight it.

  9. Click the X in the toolbar to delete the row.

  10. Click Save.

    AcumaticaImportCustomizationProjectsDeleteRowwindow-mh.PNG
  11. Then, remove the endpoint from the Acumatica database:

    1. From Integration, click Web Service Endpoints.

    2. Select PVEndpoint for the endpoint name.

      AcumaticaImportWebServiceEndpointswindow-mh.PNG
    3. Select Endpoint Version matching the customization being removed.

      AcumaticaImportEndpointVersionswindow-mh.PNG
    4. Click the Delete delete_icon2.svg icon to remove the endpoint from the database.

      AcumaticaImportEndpointVersionsdeletewindow-mh.PNG

To view Bridge Lists or Sync Errors, click View Sync Log.

A dialog similar to the following displays:

APFlowSettingsBridgeAcumaticaViewSyncLogpage-mh.PNG

Select individual lists or the check box in the header to select all lists to be synced. Then, click Sync.

Sync Errors

pVault® support personnel use the data that displays in the Sync Errors tab for issue troubleshooting.

The vault "bridge" connects the pVault® system to FlooringOS. The bridge provides all of the data lookups and exporting features needed to run pVault.

Once the Bridge Type and Bridge Product fields are populated in Vault Bridge Settings, you can access the Validation Configuration grid fields.

  1. The Connection Url field should systematically populate. If it does not, enter your company's Connection Url in this field.

  2. In the API Key field, enter your company's appropriate key.

    APFlowSettingsBridgeFlooringOSBridgeCompanyfieldvisible-mh.png
  3. Click Validate Connection.

    The page updates to confirm your connectivity and the Bridge Company field displays.

    Note

    Once bridged, if you need to change the password associated with the Company Id, click Update Password.

    VaultSettings_FlooringOSConnected.png
  4. Click Select Company to Bridge to access your Bridge Lookup list similar to the following:

    APFlowSettingsBridgeAcumaticaSelectCompanyToBridgeBridgeLookup-mh.PNG
  5. Click the check box associated with your bridged company.

  6. Click Add.

  7. Click Save.

To view Bridge Lists or Sync Errors, click View Sync Log.

A dialog similar to the following displays:

APFlowSettingsBridgeAcumaticaViewSyncLogpage-mh.PNG

Select individual lists or the check box in the header to select all lists to be synced. Then, click Sync.

Sync Errors

pVault® support personnel use the data that displays in the Sync Errors tab for issue troubleshooting.

The vault "bridge" connects pVault® to Sage Intacct. The bridge provides all of the data look-ups and exporting features needed to run the pVault system.

Once the Bridge Type and Bridge Product fields are populated in Vault Bridge Settings, the Validation Configuration fields are accessible.

Complete the following steps:

  1. The Connection Url field should systematically populate. If it does not, enter your company's Connection URL manually in this field.

    Vault_Settings_Bridge_Sage_Intacct_Empty-PVC.png
  2. In the Company Id field, enter your company id.

  3. In the User Name field, enter your user name.

  4. In the Password field, enter the password associated with your account.

  5. Click Validate Connection.

    The page updates to confirm your connection and a Bridge Company field displays:

    APFlowSettingsBridgeSageIntacctBridgeCompanyfieldvisible-mh.PNG

    Note

    Once bridged, if you need to change the password associated with the Company Id, click Update Password.

  6. Click Select Company To Bridge to access your Bridge Lookup list similar to the following:

    APFlowSettingsBridgeSageIntacctSelectCompanyToBridgeBridgeLookup-mh.PNG
  7. Select the check box associated with your bridged company.

  8. Click Add.

  9. Click Save.

To map your transactions, refer to Purchases Configuration.

After bridging to Sage Intacct from pVault, a Paperless Integration application is systematically installed in Sage Intacct.

The application facilitates the systematic syncing of data from Sage Intacct to pVault as data is added, edited or deleted in Sage Intacct. You can access this application in Sage Intacct under the Platform Services menu.

image209.png

From here, you can view the Paperless Integration. No action is needed to facilitation the install or the update of the Paperless Integration application.

Instead of having a section for Purchase Orders and another for Subcontracts, Intacct implemented configurable transactions and workflows in their Purchasing module. These transaction types can be configured to fit your company's needs.

To integrate pVault® with Intacct's Purchasing module, you will need to map your transactions into our provided line types. You can map multiple transactions to the same line type.

In Intacct
  1. Navigate to the Purchasing module.

  2. Click the Setup tab.

  3. In the More section, click Transaction definitions.

    SageVaultPropertiesIntacctPurchasingConfigurationIntacctscreenTransactiondefinitions-mh.PNG
  4. In the Transaction Definitions: Purchasing page, identify transaction definitions, descriptions and workflow categories based on your company's needs.

    For example:

    SageVaultPropertiesIntacctPurchasingConfigurationIntacctscreenTransactiondefinitionexamples-mh.PNG
  5. Be sure to make a note of how you configured your company's purchasing transactions.

Edit Subtotal Dimensions at the Top Level Setting

To edit dimension values on subtotal lines at the top level, complete the following steps:

  1. From the Purchasing toolbar dropdown, click Configure Purchasing.

  2. Under the Enable functionality dropdown, select Edit subtotal dimensions at the top level check box.

  3. Click Save.

    With this functionality selected, dimension amounts distributed either systematically or manually may be edited as needed.

In pVault®
  1. From My Paperless, click APFlow™ Settings.

  2. In the APFlow™ Settings navigation bar, click Bridge.

    A page similar to the following displays:

    SageIntacctBridgetopVault-blue.png
  3. Click Purchases Configuration.

    The Purchases Configuration dialog displays:

    APFlowSettingsBridgeSageIntacctBridgePurchasesConfigurationdialog-mh.PNG
  4. Click Add.

    The New Purchase Configuration dialog displays:

    APFlowSettingsBridgeSageIntacctBridgePurchasesConfigurationdialogNewPurchaseConfigurationdialog-mh.PNG
  5. From the Line Type dropdown, select the purchase transactions that you configured in Intacct. See In Intacct for more information.

    APFlowSettingsBridgeSageIntacctBridgePurchasesConfigurationdialogNewPurchaseConfigurationLineTypefielddropdown-mh.PNG

    The fields that display are based upon the line type you select. In this instance, PO Receiving, was selected. These are the fields that display to support that selection:

    APFlowSettingsBridgeSageIntacctBridgePurchasesConfigurationdialogNewPurchaseConfigurationLineTypefieldNonCommitment-mh.PNG
  6. Click Add.

    • Non-Commitment: Used for creating invoices in the Purchasing module that do not convert from another transaction type. You can map invoice template type transactions that have a create policy of new document only or new document or convert.

    • Purchase Order: Used for processing purchase orders that can be converted to an invoice. You can map order template type transactions that can be converted to an invoice template type transaction that has a create policy of convert only or new document or convert.

    • Subcontract: Used for processing subcontracts that can be converted to an invoice. You can map order template type transactions that can be converted to an invoice template type transaction that has a create policy of convert only or new document or convert.

    • PO Receiving: Used for processing purchase orders that you receive first before converting to an invoice. You can map list template type transactions that can be converted to an invoice template type transaction that has a create policy of convert only or new document or convert.

    • Debit Memo: Used for processing returns for items already invoiced. You can map an invoice template type transaction with a return workflow category to any of the existing mappings by selecting the transaction from the return transaction dropdown list. The transaction needs a create policy of convert only or new document or convert.

A completed Purchases Configuration dialog resembles the following:

APFlowSettingsBridgeSageIntacctBridgePurchasesConfigurationdialogcomplete-mh.PNG

As data is added to the Sage Intacct accounting system, that information is systematically synced to pVault®. However, if there is data you know was added or you added it yourself and it is not visible, click View Sync Log where you can manually submit a request for the sync process to run.

A dialog similar to the following displays:

image218.png

Select individual lists or the check box in the header to select all lists to be synced. Then, click Sync.

Sync Errors

pVault® support personnel use the data that displays in the Sync Errors tab for issue troubleshooting.

Prior to connecting pVault® to Vista™ by Viewpoint via the vault "bridge," the Paperless Environments support team must manually configure connection in Trimble's integration platform called App Xchange. App Xchange serves as a centralized hub that connects and synchronizes data between applications like Vista by Viewpoint and pVault Cloud.

After the App Xchange set up is underway, support assists in configuring the bridge, as it requires a coordinated sequence of steps between the two systems.

When support lets you know it is time to configure the bridge in pVault, complete the following steps:

  1. Select Vault Settings > Bridge.

  2. In the Bridge Type field, select Construction.

    BridgeVistaViewpointpage.png
  3. In the Bridge Product field, select Vista by Viewpoint.

  4. In the Workspace Name field, enter the name provided by support.

    This name must match the workspace name in App Xchange exactly.

  5. In the Bridged Company field, enter the number of the Vista company you want to bridge.

    VaultSettingsBridge_BridgeVistaViewpointPagePopulated.png

    Note

    To locate this value, log in to Vista Construction. The various companies can be found in the Company dropdown or by navigating to Headquarters > Programs > HQ Company Setup.

    VaultSettingsBridge_ViewpointVistaConstructionBridgedCompany.png
  6. Click Save.

    Upon saving, the Master Vault ID value is generated.

  7. Provide the Master Vault ID number to support so they can use it to complete the Vista <> Paperless connection in App Xchange.