Skip to Content
-1

Balance in Transaction Currency error during Advance Payment Posting via BAPI_ACC_DOCUMENT_POST?

Jan 24 at 03:43 PM

88

avatar image
Former Member

Hi,

I'm trying to Advance Payment from Customers (F-29 Tcode) using BAPI_ACC_DOCUMENT_POST function module.

I have passed the entries like below.

DOCUMENTHEADER

----------------------------------------------------------

BUS_ACT RFBU

USERNAME C5257976

HEADER_TXT DZ TETSING

COMP_CODE 0071

DOC_DATE 24.01.2018

PSTNG_DATE 24.01.2018

DOC_TYPE DZ

ACCOUNTGL

--------------------------------------------------------------

ITEMNO_ACC 0000000002

GL_ACCOUNT 115501

ITEM_TEXT ITEMTEXT-GL

ALLOC_NMBR ASSIGMENT-GL

TAX_CODE GB

ITEMNO_TAX 000001

VALUE_DATE 23.01.2018

ACCOUNTRECEIVABLE

----------------------------------------------------------------

ITEMNO_ACC 0000000001

CUSTOMER 31117

ALLOC_NMBR ASSIGMENT-Customer

ITEM_TEXT ITEMTEXT-Customer

TAX_CODE GB

SP_GL_IND A

ACCOUNTTAX

-----------------------------------------------------

ITEMNO_ACC 0000000003

GL_ACCOUNT 175101

COND_KEY ZOCG

ACCT_KEY ZOC

TAX_CODE GB

TAX_RATE 9,000

TAX_DATE 24.01.2018

ITEMNO_TAX 000001

ITEMNO_ACC 0000000004

GL_ACCOUNT 175102

COND_KEY ZOSG

ACCT_KEY ZOS

TAX_CODE GB

TAX_RATE 9,000

TAX_DATE 24.01.2018

ITEMNO_TAX 000001

CURRENCYAMOUNT

-------------------------------------------------------

ITEMNO_ACC 0000000001 (Customer Entry)

CURR_TYPE 00

CURRENCY INR

AMT_DOCCUR 1.579,5000-

ITEMNO_ACC 0000000002 (GL Entry)

CURR_TYPE 00

CURRENCY INR

AMT_DOCCUR 1.579,5000

ITEMNO_ACC 0000000003 (CGST Tax Entry)

CURR_TYPE 00

CURRENCY INR

AMT_DOCCUR 120,4700-

AMT_BASE 1.338,5600-

ITEMNO_ACC 0000000004 (SGST Tax Entry)

CURR_TYPE 00

CURRENCY INR

AMT_DOCCUR 120,4700-

AMT_BASE 1.338,5600-

I have used CALCULATE_TAX_FROM_GROSSAMOUNT function module to get Tax Entries which was passed in ACOUNTTAX table above.

Actually the entries to be passed should be like below.

115501 1.579,5000 GL Item 31117 1.579,5000- Customer Item 175101 120,4700- Tax Item(SGST) 175102 120,4700- Tax Item(CGST) 171010 3,050,800 Nullified Item against Tax Items

Here I'm not able to pass the nullfiable entry against Tax Items because function module CALCULATE_TAX_FROM_GROSSAMOUNT is giving only 2 Tax entries CSGT & SGST only.

Can anyone please suggest me how to pass data to the BAPI for advance payments from customers as well for other different business scenarios if possible.

Thanks in advance.

Regards,

Ramana.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 26 at 08:05 AM
-1

Hi Villers,

Thanks for your response.

We are trying to post the Accounting Document from Excel upload. So I'm trying to use BAPI_ACC_DOCUMENT_POST or BDC to upload the data from Excel.

Kindly provide any function module which will provide Tax entries.

Regards,

Ramana.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 24 at 04:32 PM
0

You can post it with ACC_DOCUMENT idoc directly, this should be able to calculate your taxes directly.

Share
10 |10000 characters needed characters left characters exceeded