SAP Business One FAQs

By Maria Harreguy
4 min

 

Happens when posting to a customer that does not have a specific currency set to it in SAP B1. And exchange rate from WB is not 1

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

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

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

 

Cause: Journal Batch is already exported in SAP B1

How to check in SAP: Navigate to Financials > Journal Entry > Enter Ref1 value WB:<BatchNo>, then click Find. This will show the Journal entries for the batch.

 

  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

 

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.

 

  1. Take note of the batch no and Type

     

  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

 

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

 

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.

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.

 

Related content