Created by Maria Harreguy
Just a moment ago
3 min readAnalytics
| Expand |
|---|
| title | Create VAT rows automatically - posting in a tax account. Make sure the GL account being exported is not a tax account in SAP B1 |
|---|
|
 |
...
| Expand |
|---|
| title | Date deviates from permissible range |
|---|
|
Solved by checking Allow Future Posting Date in SAP B1 Admin > System Initialization > Document Settings > General tab > tick Allow Future Posting Date
 |
| Expand |
|---|
| title | Job 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 |
|---|
| title | How to Trigger Manual Sync |
|---|
|
Open Management Console then click Sync. 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. Locate agent configuration file, look for ManagementConsole value
 How to locate where the Agent is installed. Open Event Viewer, locate the agent, ideally prefixed with WBSAPAgent- Each log details show where the SAP agent is installed  Image Modified
How to change sync interval Navigate to where the agent is installed and locate the config file - Workbench.Agent.BusinesOne.Service.exe.config Open config file and change the value of SyncIntervalInMinutes to desired value. Restart the agent service.
 How to restart SAP agent Open Services, locate service, ideally prefixed with WBSAPAgent- Click restart.
 |
| Expand |
|---|
| title | How to handle stuck In Progress exports |
|---|
|
Take note of the batch no and Type
 Image ModifiedIn Scaffold locate base table , filter for BatchNo. 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 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  Image Modified
How to restart SAP agent Login to client’s server where the agent is installed. This is usually the SQL server of their SAP database. Open Services, locate service, ideally prefixed with WBSAPAgent- Click restart.
|
| Expand |
|---|
| title | Sync 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. |