Skip to Content
Product Information
Author's profile photo Sissi Ruthe

Create Journal Entry Vouchers using Web Service ManageAccountingEntryIn

With SAP Business ByDesign Release 2202 web service ManageAccountingEntryIn has been added to further improve the integration of external applications. In this blog post I provide a short introduction to it.

In some cases, the information for journal entry vouchers is provided by an external system, as for example the monthly salary posting. These journal entry vouchers must be created in the system. In general, we provide three options to create journal entry vouchers in the system:

  • Create journal entry vouchers via user interface in the General Ledger work center.
  • Create journal entry vouchers using the Microsoft Excel® template to upload them.

  • Create journal entry vouchers using web service ManageAccountingEntryIn.

Related to journal entry vouchers please find more details in the SAP Business ByDesign Library under “Journal Entry Vouchers Quick Guide”.

Here is an example of a simple web service request.

This example will create the following journal entry voucher in the system.

This short introduction on web service ManageAccountingEntryIn shall help you to start using it in SAP Business ByDesign.

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo François-Xavier LEPOUTRE
      François-Xavier LEPOUTRE

      Hello Sissi Ruthe ,

      Good news !

      Would it be possible to have samples for each Journal Entry Type and Screen Variant ? I am struggling with a "Manual Write-Up/Write-Down for Materials" for instance.

      Thanks a lot,

      FX

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hello François-Xavier,

      please find an example for the "Manual Write-Up/Write-Down for Materials". I will provide additional examples.

      Best regards,

      Sissi

      Author's profile photo Jacques-Antoine Ollier
      Jacques-Antoine Ollier

      Hello François-Xavier LEPOUTRE ,

      did you have any success with the  write-up/down?

      If you need any help, you can ping me by messages and I will be glad to see how I can help you.

      Best regards

      Jacques-Antoine

      Author's profile photo Pratyush kumar Patnaik
      Pratyush kumar Patnaik

      Hi Sissi,

      Very helpful blog, Thank you very much!

       

      Best Regards,

      Pratyush

       

      Author's profile photo Minh Tri Le
      Minh Tri Le

      Hi Sissi Ruthe,

      Thanks for a great blog.

      I have a question regarding the AccountingDocumentTypeCode.

      As I check Overview | Manage Journal Entry Vouchers | SAP API Business Hub,

      it said

      Constraints and Integrity Conditions

      Note

      Currently only Manual Posting - Journal Entry Voucher of Journal Entry Type is supported.

      Is this still correct?

      Regards,

      Tri

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hi Tri,

      thanks for your question.

      Please refer to my answer https://blogs.sap.com/2022/02/07/create-journal-entry-vouchers-using-web-service-manageaccountingentryin/comment-page-1/#comment-616299 which provides an example for a "Manual Write-Up/Write-Down for Materials" Journal Entry Type.

      I will ask our user assistance team to update the documentation accordingly.

      Best regards,

      Sissi

      Author's profile photo Edwin Kwikkelberghe van
      Edwin Kwikkelberghe van

      Hi Sissi,

      Thanks for the blog.

      I am struggling with the overwrite of the profit center in the JEV. I can not find the field to set the mark.

      Change%20profit%20center/segment

      Change profit center/segment

      Am I missing something ?

      Best Regards,

      Edwin

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hi Edwin,

      thanks for your comment.

      Currently, it is not exposed to overwrite the profit center in the journal entry voucher through the web service. On the business object level it is also not exposed in the Public Solution Model.

      Best regards,

      Sissi

      Author's profile photo Edwin Kwikkelberghe van
      Edwin Kwikkelberghe van

      Thanks for your answer

      Author's profile photo Arif Esa
      Arif Esa

      Dear all ,

      do we have the same integration to Business One as well?

      best regards

      arif

      Author's profile photo Yu Xue
      Yu Xue

      Can you help me resolve this issue about CashLedgerAccountItem by  manageaccountingentryin interface .

      this following is payload XML,Maybe about CashLedgerAccountItem not valid

      <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
      <soap:Header/>
      <soap:Body>
      <glob:AccountingEntryBundleMaintainRequest_sync>
      <BasicMessageHeader> </BasicMessageHeader>
      <!--1 or more repetitions:-->
      <AccountingEntry>
      <ObjectNodeSenderTechnicalID>_LAND_OA</ObjectNodeSenderTechnicalID>
      <CompanyID>JQPM</CompanyID>
      <Note languageCode="CN">冲6530外币户系统生成汇兑损益</Note>
      <!--Optional:-->
      <AccountingDocumentTypeCode>00083</AccountingDocumentTypeCode>
      <!--Optional:-->
      <EntryDate>2023-05-01</EntryDate>
      <PostingDate>2023-05-01</PostingDate>
      <BusinessTransactionTypeCode>636</BusinessTransactionTypeCode>
      <!--Optional:-->
      <TransactionCurrencyCode>CNY</TransactionCurrencyCode>
      <!--1 or more repetitions:-->
      <Item>
      <DebitCreditCode>1</DebitCreditCode>
      <ChartOfAccountsItemCode>1002030000</ChartOfAccountsItemCode>
      <!--Optional:-->
      <TransactionCurrencyAmount currencyCode="CNY">668</TransactionCurrencyAmount>
      <!--Optional:-->
      <ProfitCentreID>Z01</ProfitCentreID>
      <CashLedgerAccountItem>
      <HouseBankID>1000000</HouseBankID>
      <CashLocationID>CN</CashLocationID>
      <CashLocationTypeCode>005</CashLocationTypeCode>
      <Bank Account or Petty Cash ID>74103855300000096</Bank Account or Petty Cash ID>
      <Cash flow key>CF004</Cash flow key>
      </CashLedgerAccountItem>
      </Item>
      <Item>
      <DebitCreditCode>2</DebitCreditCode>
      <ChartOfAccountsItemCode>6603040300</ChartOfAccountsItemCode>
      <ProfitCentreID>Z01</ProfitCentreID>
      <!--Optional:-->
      <TransactionCurrencyAmount currencyCode="CNY">668</TransactionCurrencyAmount>
      </Item>
      <SetOfBooks>
      <!--Optional:-->
      <SetOfBooksID>0001</SetOfBooksID>
      </SetOfBooks>
      </AccountingEntry>
      </glob:AccountingEntryBundleMaintainRequest_sync>
      </soap:Body>
      </soap:Envelope>

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hello Yu Xue,

      please check in your payload <ChartOfAccountsItemCode>1002030000</ChartOfAccountsItemCode>. The id of the chart of accounts is missing here: listID="XXXX", see in my example <ChartOfAccountsItemCode listID="ZDE1">095000</ChartOfAccountsItemCode>.

      Please check if this resolves the issue.

      Best regards,

      Sissi

      Author's profile photo Yu Xue
      Yu Xue

      Hi Sissi,

       

       

      <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
      <soap:Header/>
      <soap:Body>
      <glob:AccountingEntryBundleMaintainRequest_sync>
      <BasicMessageHeader> </BasicMessageHeader>
      <!--1 or more repetitions:-->
      <AccountingEntry>
      <ObjectNodeSenderTechnicalID>_LAND_OA</ObjectNodeSenderTechnicalID>
      <CompanyID>JQPM</CompanyID>
      <Note languageCode="CN">支付员工加班费</Note>
      <!--Optional:-->
      <AccountingDocumentTypeCode>00083</AccountingDocumentTypeCode>
      <!--Optional:-->
      <EntryDate>2023-05-13</EntryDate>
      <PostingDate>2023-05-13</PostingDate>
      <BusinessTransactionTypeCode>636</BusinessTransactionTypeCode>
      <!--Optional:-->
      <TransactionCurrencyCode>CNY</TransactionCurrencyCode>
      <!--1 or more repetitions:-->
      <Item>
      <DebitCreditCode>1</DebitCreditCode>
      <ChartOfAccountsItemCode>2211010100</ChartOfAccountsItemCode>
      <!--Optional:-->
      <TransactionCurrencyAmount currencyCode="CNY">668</TransactionCurrencyAmount>
      <!--Optional:-->
      <ProfitCentreID>Z01</ProfitCentreID>
      </Item>
      <Item>
      <DebitCreditCode>2</DebitCreditCode>
      <ChartOfAccountsItemCode>6603040300</ChartOfAccountsItemCode>
      <ProfitCentreID>Z01</ProfitCentreID>
      <!--Optional:-->
      <TransactionCurrencyAmount currencyCode="CNY">668</TransactionCurrencyAmount>
      <CashLedgerAccountItem>
      <HouseBankID>1000001</HouseBankID>
      <CashLocationID>CN</CashLocationID>
      <CashLocationTypeCode>04</CashLocationTypeCode>
      <Bank Account or Petty Cash ID>990110100177500201</Bank Account or Petty Cash ID>
      <Cash flow key>CF005</Cash flow key>
      </CashLedgerAccountItem>
      </Item>
      <SetOfBooks>
      <!--Optional:-->
      <SetOfBooksID>0001</SetOfBooksID>
      </SetOfBooks>
      </AccountingEntry>
      </glob:AccountingEntryBundleMaintainRequest_sync>
      </soap:Body>
      </soap:Envelope>

      Author's profile photo Yu Xue
      Yu Xue

      CashLocationID and CashLocationtypecode from Cash Location datasource

      So I entry it according this values from datasource. But system also post error message (such as up screen)

       

       

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hello Yu Xue,

      chart of accounts id ZDE1 was just an example. You need to use in your payload the chart of accounts defined in your system.

      To be able to analyze your issue in detail, please create an incident in your system.

      Thanks and best regards,

      Sissi

      Author's profile photo imad khan
      imad khan

      i want to post a JE through web service, but i am facing internal server error 500 there is my code:

      <soap:Envelope
      xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
      xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
      <soap:Header/>
      <soap:Body>
      <glob:AccountingEntryBundleMaintainRequest_sync>
      <BasicMessageHeader></BasicMessageHeader>
      <!--1 or more repetitions:-->
      <AccountingEntry>
      <ObjectNodeSenderTechnicalID>3</ObjectNodeSenderTechnicalID>
      <CompanyID>700</CompanyID>
      <Note languageCode="EN">English</Note>
      <!--Optional:-->
      <AccountingDocumentTypeCode>00085</AccountingDocumentTypeCode>
      <!--Optional:-->
      <EntryDate>2023-05-10</EntryDate>
      <PostingDate>2023-05-11</PostingDate>
      <BusinessTransactionTypeCode>628</BusinessTransactionTypeCode>
      <!--Optional:-->
      <TransactionCurrencyCode>USD</TransactionCurrencyCode>
      <!--1 or more repetitions:-->
      <Item>
      <DebitCreditCode>1</DebitCreditCode>
      <ChartOfAccountsItemCode>110000</ChartOfAccountsItemCode>
      <!--Optional:-->
      <TransactionCurrencyAmount currencyCode="USD">900</TransactionCurrencyAmount>
      <!--Optional:-->

      </Item>
      <Item>
      <DebitCreditCode>2</DebitCreditCode>
      <ChartOfAccountsItemCode listID="ZDE1">235000</ChartOfAccountsItemCode>

      <TransactionCurrencyAmount currencyCode="USD">900</TransactionCurrencyAmount>
      </Item>
      <SetOfBooks>
      <!--Optional:-->
      <SetOfBooksID>700</SetOfBooksID>
      </SetOfBooks>
      </AccountingEntry>
      </glob:AccountingEntryBundleMaintainRequest_sync>
      </soap:Body>
      </soap:Envelope>

      Thank You!

      Regards,
      Imad Khan

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hello Imad,

      please create an incident in your system. Without further information from the system it is not possible for me to analyze the issue.

      Thanks and best regards,

      Sissi