Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Nitin, I just want to be sure you see what I see. When I open the report, I see total open debits, total open credits, total balance and total accumulated, on one line for the year. I then double-click the customer dimension, and I see the same information by individual customer. Below is a running balance by month for the total. If I double click a customer, I can isolate that customer for the same columns, and the data below gives me their numbers by month. Is that not what you wanted? Am I missing any columns? - Lou
| | | ---------------Original Message--------------- From: Tiger100 Sent: Monday, October 24, 2011 7:03 AM Subject: Tables to Write a Query for Daily Customer Report Hi, I am making a query for Daily customer report in which my user want fields Total Debit posting, Total Credit Posting, Balance Carryforward and Accumulated balance based on the selection of Posting date. When I am trying to do that I am unable to find all the tables for this report as we have the field Balance carry forward in KNC1 or KNC3 but when we join the tables it doesn't show any link. Please help me on it. Also, I am unable to find out the Accumulated balance field in any table if we don't have that field then how to get that field updated. Please write about the tables in detail. Thanks in advance Regards Nitin | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | LCC352 SAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Popular White Papers In the Spotlight _.____.__ |