Ansicht
Dokumentation

J_1GCUST_VAL - Customer Open Item Valuation

J_1GCUST_VAL - Customer Open Item Valuation

RFUMSV00 - Advance Return for Tax on Sales/Purchases   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

Description

The report generates a list of those open items that can be accrued within a given time period.

The list contains those customer items posted by the specified key date and still open on this key date.

Output

The report outputs the following information for each account with selected postings:

  • Account name
  • All items of the selected type according to the chosen sorting sequence, if item output is not suppressed by means of the parameter "X - Line Items Required"

The following information is issued at item level:

  • Debit and credit amount in document currency
  • Debit and credit amount in local currency, if the parameter "Total by Currency" is set
  • Dunning level
  • Payment method
  • Amount qualifying for cash discount in document currency
  • Payment data (baseline date for payment, payment conditions, due date for net payment)
  • Reason code

The following appear for the higher group levels:

  • Debit and credit total and balance of open item postings (postings that affect sales/purchases)
  • Total receivables at this group level
  • Total receivables grouped according to sales type

The total receivables can also be grouped according to the following:

  • Currency
  • Business area

If, however, every document was posted in the local currency of the respective currency code, then breakdown according to currency is suppressed, since where documents are posted in this way, the total displayed agrees with the total liabilities.

Higher group totals are not output if they are identical to the totals of the lower level.

Database: DD (Customer database)

You can influence sorting using the following parameters:

  • S Sort indicator (1-8)
(for master data information)
  • P Sort indicator (1-8)
(for item data information)

The list can be sorted according to different criteria. For details, see the documentation for the individual selection parameters.

Sort sequence for the normal version:

  • Company code
  • S Sort indicator (1-8)
  • Account number
  • P Sort indicator (1-8)
  • Assignment number
  • Posting date
  • Currency key
  • Tax on sales/purchases code
  • Business area

Since for the group version, the account number is the first sort criterion, if you make an entry under "S Sort indicator (1-8)", this does not affect the sorting. However, the corresponding value is taken into account for creating subtotals.

If the item output is suppressed by selecting "X - Line Items Required", the header item in the list specifies the sort sequence. In other cases, the sort sequence is output at the start of each company code (normal version) or at the start of the list (group version). of the list (corporate version).

Since the account number is the principal sort criteria in the corporate group version, selecting "S-sort indicators (1-8)" as a criteria has no effect on the sorting. This value is, however, included in the subtotal.

If no items are displayed, due to the instruction "X - open items required" not being selected, the heading line of the list shows the sort sequence. Otherwise the sort sequence is displayed at the beginning of every company code (standard version) or at the beginning of the list (corporate version).






CL_GUI_FRONTEND_SERVICES - Frontend Services   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 4384 Date: 20240531 Time: 144509     sap01-206 ( 57 ms )