Versions Compared

Old Version 3

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
titleHow 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.

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.