Versions Compared

Old Version 2

changes.mady.by.user Maria Harreguy

Saved on

compared with

New Version Current

changes.mady.by.user Maria Harreguy

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Expand
titleCreate VAT rows automatically - posting in a tax account. Make sure the GL account being exported is not a tax account in SAP B1

...

Expand
titleDate deviates from permissible range

  1. Solved by checking Allow Future Posting Date in SAP B1

  2. Admin > System Initialization > Document Settings > General tab > tick Allow Future Posting Date

Expand
titleJob xxxx not found of ARInvoice line 01

Sample error:

Cause: Job is not exported to SAP yet when the batch is exported

Resolution: Check Projects in SAP, make sure that the Job Code exits. If not, trigger a manual sync of Job to SAP B1 or wait for the Job to sync to SAP

...

Expand
titleHow to Trigger Manual Sync

  1. Open Management Console then click Sync.

  2. If user wants to sync on an earlier date, change the date that correspond to the object, click Update, then Sync

How to know Management Console URL.

  1. Locate agent configuration file, look for ManagementConsole value

How to locate where the Agent is installed.

  1. Open Event Viewer, locate the agent, ideally prefixed with WBSAPAgent-

  2. Each log details show where the SAP agent is installed

  3. Image Modified

How to change sync interval

  1. Navigate to where the agent is installed and locate the config file - Workbench.Agent.BusinesOne.Service.exe.config

  2. Open config file and change the value of SyncIntervalInMinutes to desired value.

  3. Restart the agent service.

How to restart SAP agent

  1. Open Services, locate service, ideally prefixed with WBSAPAgent-

  2. Click restart.

Expand
titleHow to handle stuck In Progress exports

  1. Take note of the batch no and Type

    Image Modified

  2. In Scaffold locate base table , filter for BatchNo.

    1. If it's all blank, it means no data is exported to SAP, it is safe to re-export

      Image Modified

How to re-export

  1. Go to BatchHeaders table and remove Export status. Then re-export the batch, if the batch is still stuck In Progress, restart the SAP agent

  2. Image Modified

How to restart SAP agent

  1. Login to client’s server where the agent is installed. This is usually the SQL server of their SAP database.

  2. Open Services, locate service, ideally prefixed with WBSAPAgent-

  3. Click restart.

Expand
titleSync clients/suppliers bank account detail changes to Workbench

When a new company is created in SAP B1 and the company is synced to Workbench, the Bank account details are populated in WOrkbench Company/s Financial tab.

However when these details are updated in SAP B1, these will not come through to Worbench unless a trigger wb_TR_OCRB_Upd_Ins is installed in the SAP B1 DB.

OCRD.updatedate (this is used to determine which companies are updated and for import) is not updated when bank details in the OCRB (bank details table) are updated. This means, that if the bank details are updated in SAP, the company will not be picked up by the import since the update happens on another table.

To address this issue, please install trigger wb_TR_OCRB_Upd_Ins on the client SAP database. This updates the OCRD.updatedate column whenever the bank details table (OCRB  ) is updated.