Determine posting to an asset between two dates

[Former Member]

Hello all,

How do you calculate the postings made to an asset between two dates? I looked at the logical database ADA, but got lost in the source code.

For example, if these posting were made to an asset between start & end date, the total I would want would be $300.

Post $200

post $100

post $200

reserse the 2nd $200.

Thanks

Bruce

[Former Member · Accepted solution]

Dear Friend,

Its very easy, simply execute transaction SQV and follow the below steps

Quick Viewer Screen appers

Create a new quick view

Give it a name, data source as table join, press enter.

Press Shift+F1, put the table name ANEK and press enter

Again press Shift+F1, put the table name as ANEP this time.

Press F3 or back button

Explode the Documnet Header and select List Filed and Selection Field check box for 1. Company Code 2. Main Asset Number, 3. Asset Sub Number,4. Fiscal Year, 5. Sequence Nuber, 6. Document Date or any other date on the basis of which you want to check the postings (e.g. posting date, entery date, asset valud date etc).

Press Execute button and enter.

A Report selection will appear, put the company code other parameters you have with you inclduing the date and execute again.

This will give you all posting between particular date.

Hope this solve your issue.

Thanks!!!

Murlidhar Khatri

[former_member205041]

Hello Bruce,

I'm sorry I don't understand the question.

regards Bernhard