cancel
Showing results for 
Search instead for 
Did you mean: 

How to find Down Payment document with vendor details from AW01N

former_member650819
Participant
0 Kudos

Hi,

I am trying to do partial settlement in KO88, for AUC to Fixed Asset. While running the T Code I am getting the following error message.

Down payment to recipient 100620 0 area 01 amount   13,181,454.04 not cleared

Message no. AW605

I went through many threads for this issue and I am trying to clear the downpayment in F-54. But I am not able to find the Vendor details to whom the Down Payment was done, neither the dosument number against which the downpayment has to be cleared.

I tried finding these details in AW01N. I could find the amount reflecting in the Planned and Posted tab in the first section.

But was not succesful to find the documents and vendor details from there.

In the second section in Planned Tab, I am finding some transactions. There I am finding Down Payment mentioned. When I double click on Down Payment in AW01N, I am taken to the document which is a clearing of Down Payment. You can see the below entry.

81008100Fixed Assets Interim1,049,371.84-
30300100000000900000 00002,538,367.44
30520000Clg Cap D-Pmts-T-Ast2,538,367.44-
30300100000000900000 00001,049,371.84
30300100000000900000 0000101,948.00-
30520000Clg Cap D-Pmts-T-Ast101,948.00

Now, how do I know which documents to be cleared to which Invoice and the vendor details.

Kindly help me with this issue.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

You can find the transaction details in AW01N under planned values tab. If you do not have transactions in current year then just it in previous year. There you can find the down payment transaction. Still you are not getting it, then provide screen shot of AW01N, which has transactions details.

Regards,

Mukthar

former_member650819
Participant
0 Kudos

You can see the screen shots attached. I am not able to find from where the amount 11198883.19 is coming.

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

The change in down payment is showing correctly. Please refer below for its calculation.

180       160,313.10
180     2,538,367.44
180     6,012,304.45
180   10,060,882.30
181   -7,049,272.00
181      -421,764.10
181       -101,848.00
  11,198,983.19

Regards,

Mukthar

former_member650819
Participant
0 Kudos

Hi,

Thanks. Kindly suggest now, how to find the documents and vendor details from there.

When I double click on any Down Payment in AW01N, I am taken to the document which is a clearing of Down Payment. You can see the below entry.

81008100Fixed Assets Interim1,049,371.84-
30300100000000900000 00002,538,367.44
30520000Clg Cap D-Pmts-T-Ast2,538,367.44-
30300100000000900000 00001,049,371.84
30300100000000900000 0000101,948.00-
30520000Clg Cap D-Pmts-T-Ast101,948.00

Now, I want to clear the down payments in F-54, but how do I know which documents needs to be cleared to which Invoice and the vendor details. Since I am getting error while executing KO88 AUC transfer to Assets.

Down payment to recipient 100620 0 area 01 amount   12,832,161.41 not cleared

Message no. AW605

Diagnosis

All downpayments were not cleared for the asset under construction for the receiver 100620 0 in area 01. An amount of   12,832,161.41 was not cleared, or too much was cleared.

You can only completely transfer an asset under construction if you reverse the down payments in the current fiscal year beforehand.

Procedure

Clear the downpayments that you want to settle to receiver 100620 0.

Check screen shot.

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

First you take the all details of down payments for the asset using the t.code. AR05. Specify the transaction type as 180 & 181 and execute the report. Here you will get all the details of down payments. The transaction type 180 is down payment posting & 181 is down payment clearing. Based on this you can find out the down payment which are not cleared till now.

Still if you are unable to find out, then provide the screen shot of the above.

Regards,

Mukthar

former_member650819
Participant
0 Kudos

Hi,

I am attaching the screen shot. I am unable to track which documents are still pending to be cleared.

Since I am getting error while executing KO88 AUC transfer to Assets. The amount shown as uncleared is Total Down Payment shown in AW01N, but in this screen I can see net figure as INR 11,198,883.19.

Down payment to recipient 100620 0 area 01 amount   12,832,161.41 not cleared

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

Here I cannot find the details for 16547391.06.Please select the reporting date as 31.12.2013 and execute it. If you cannot find the details on said date. Then select the date as 31.12.2012 execute it and do it for 2011 & 2010 etc. until you can get the details.

Regards,

Mukthar

former_member650819
Participant
0 Kudos

Hi,

PFA attachment for the INR 1,633,278.22 pulled out in 2013-14 report.

The asset was created on November 2012.

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

Still you have not provided complete details for the asset. I need details from initial postings of the asset. As you said, the asset was created on Nov'12. Please provide the details from Nov'12 onwards.

Regards,

Mukthar

former_member650819
Participant
0 Kudos

I am sending the last report, beyond which there is no document or data available. 2012-13

Kindly verify the list, there is no Transaction Type with 180 or 181.

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

You have below down payments outstanding for the assets. Please find the details:

30.09.2013        427,368.47
31.10.2013    1,103,600.00
31.01.2014                                           361.75
30.04.2014    2,538,367.44
31.05.2014  10,060,882.30
30.06.2014    6,012,304.45
30.06.2014    (7,049,272.00)
31.08.2014        160,313.10
31.08.2014      (421,764.10)
  12,832,161.41

As per the error message, these down payments are posting for the vendor 100620. Please clear the advances for the vendor using the t.code.F-44.

Regards,

Mukthar

former_member650819
Participant
0 Kudos

Hi,

100620 is Fixed Asset number.

Hence, I need to find the details like vendor code and the Invoice against which these down payments are to be cleared.

How do I get these details?

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

First collect document nos for the above down payments outstanding. After that go to table BSEG and enter these document nos collectively or individually along with the fiscal year & co.code. After that you get the details from these documents you can get the vendor details. After get the details, clear them by F-44.

Regards,

Mukthar

former_member650819
Participant
0 Kudos

Hi,

I am unable to find all the documents in BSEG table.

Only 3 are visible when I execute the table as shown below.

INR 427,368.479500000287
INR 1,103,600.00 9500000298
INR 361.759500000318

I am unable to trace the remaining documents.

2,538,367.44
10,060,882.30
6,012,304.45
7,049,272.00
160,313.10
421,764.10

Please suggest how do I find the remaining documents whereabouts.

former_member198650
Active Contributor
0 Kudos

Hi Nabin,

I think you have provided fiscal year in BSEG, the remaining documents has posted in different fiscal year. Try to check fiscal year before execute it.

Regards,

Mukthar