Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Created by Maria Harreguy

Just a moment ago

3 min readAnalytics

 Create VAT rows automatically - posting in a tax account. Make sure the GL account being exported is not a tax account in SAP B1
 In "Amount (FC)" "From" field, enter a number, 'AUD'

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

 Date 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

 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

 GL Journal Batch XYZ already exists in SBO

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.

 How 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

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.

 How to handle stuck In Progress exports
  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.

  • No labels