Create Journal Entry Vouchers using Web Service ManageAccountingEntryIn

[SRuthe]

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.

[FX]

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

[SRuthe]

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

[pratyushkumarpatnaik]

Hi Sissi,

Very helpful blog, Thank you very much!

 

Best Regards,

Pratyush

 

[Jacques-Antoine]

Hello fxlepoutre ,

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

[Tri]

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

[edwinvk]

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 profit center/segment

Am I missing something ?

Best Regards,

Edwin

[SRuthe]

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

[SRuthe]

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

[edwinvk]

Thanks for your answer

[arif_esa]

Dear all ,

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

best regards

arif

[langyue1988]

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>

[SRuthe]

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

[former_member842385]

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

[langyue1988]

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>

[langyue1988]

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)

 

 

[SRuthe]

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

[SRuthe]

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

[hari_1503]

Hello Sissi,

I'm inquiring whether there is a possibility to utilize the web service for uploading the JEV while it is in either the In-preparation status or the Not Posted status.

Upon my investigation, I have been unable to locate this particular option.

Could you kindly provide your guidance on this matter?