Home > Default > Accounts Receivable Reports:Table and field required

Accounts Receivable Reports:Table and field required

November 30Hits:0
Advertisement
Hi experts,
My user requires said reports in the following formats:
Posting date Invoice no. Customer  code  Invoice amount  Payment received outstandig amount
Now i want to customized this reports.I have got table and fields for "posting date,invoice no,customer code ,invoice amount".
But i am unable to get table and field for "payment received and outstanding amount".
Please advise.
Regards,
Samaar

Answers

Hi,
You can get the values in the below fields of BSEG / BSID / BSAD tables.
REBZG,  REBZJ,  REBZZ, DMBTR.
But prerequisite for this is that, your incoming payment document must have been posted with reference to an existing outgoing invoice. Means posting made without any reference (on account payments) cannot be identified as a payment for a particular invoice item.
The balance amount will be a derived value field. ( inv amount - payment amount = Balance receivable)
Please co ordinate with yout ABAPer in order to fullfil your requirement.
Regards,
Srinu

Read other 3 answers

Tags:

Related Articles

  • Accounts Receivable Reports:Table and field requiredNovember 30

    Hi experts, My user requires said reports in the following formats: Posting date Invoice no. Customer  code  Invoice amount  Payment received outstandig amount Now i want to customized this reports.I have got table and fields for "posting date,invoic

  • Customer reports-Table and field requiredNovember 30

    Hi experts, We have customized on customer reports.We raise billing in USD4,in INR and in other currency.At present,they can get reports in INR,USD4 and other currency separately.Now my user requires,the whole reports in USD4,that means all other cur

  • Accounts Receivable Report: Customer Wise Ageing Analysis report -FI moduleOctober 11

    Hi Gurus,              Can anyone help me in providing standard report(source code) or already done sample report(source code) for Accounts Receivable Report: Customer Wise Ageing AnalysisThis is in FI Module. Though it is FI Module we need to fetch

  • Custom report table and field mappingOctober 11

    Hi Experts, i am writing a functional spec for the custom report to be developed by developers and need to know the table and field name for the following items: Employee Number Name Original Hire date Adjusted Hire date Salary Class Rate of Pay Emp.

  • Account receivable  reportsNovember 30

    what are the  Accounts Receivable Invoices thanks mvnrHi, Your query is not so clear. However, I understand, you require reports for Accounts Receivables in SAP. Please go through following path for finding different reports : SAP Easy Access Menu ->

  • About Asset report - table and fieldsOctober 11

    Hi , I am developing an Asset Report, I need table and field names for following - a) GL A/C P&L b) ASSET DEPRECIATION SCHEDULED c) FORCASTED DEPRECIATION d) PLANNED EXPENSES VERSES ACTUAL EXPENSES e) GAP DEPRECIATION CATEGORY e) When user enters the

  • Accounts Receivable - Report which includes Volumetrics i.e. Material/Volume/PriceNovember 30

    Hello, What report can be used to obtain the following for Accounts Receivable (all in one report would be preferred):      AR Aging      Material Code      Volume      Price of material For example, AR has $1M due from a customer (its current/within

  • Table and field requirementNovember 30

    I want to use CPU User% , CPU Sys%, CPU Idle% field in my report. This field is already displaying in tcode OS06-> Detailed Analysis menu->Display within server.Here date wise entry found. can anybody tell me how to retrive these values in my report

  • Table and Fields RequiredOctober 11

    Dear Guru's, We are trying to build a project profitability report for which we are unable to find the tables for, 1. Planned Revenue 2. Actual Revenue 3. Budget 4. Actual Cost In our case we are using sales contract as sales document. I am not able

  • Accounts receivable ReportNovember 30

    Dear all Ours is an Export oriented company. Is there any report available for the details of the Customer & its realization vessel wise with Quantity & value Pls guide Thanks & Regards VeenaDear Veena It is a general practice that shipment de

Copyright (C) 2017 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 15 q. 0.854 s.