18 Customer Supplier Statement of Account

This chapter contains these topics:

Section 18.1, "About Customer Supplier Statement of Account,"
Section 18.2, "Processing Options,"
Section 18.3, "Data Selection,"
Section 18.4, "Data Sequencing,"
Section 18.5, "Report,"
Section 18.6, "Fields Description."

18.1 About Customer Supplier Statement of Account

Navigation

From Correspondence (G74R09), select 24 CustSup Statement of Account

Russian Legislation defined Legal Reports to be presented to the Fiscal Authority.

One report is the Customer Supplier Statement of Account based on Correspondence Accounting information.

This process generates the formatted report that meets the legal requirement.

This is a batch process that takes data from the Correspondence Transaction Detail File, the Account Master File, and the Correspondence Balance File.

The Processing Options establish Selection criteria and Mode of Processing.

The information entered into the processing options is validated, if errors are found, a Report indicating the error message prints and the process ends.

The system only prints Accounts from the Correspondence Balance File that meet the Selection criteria in Processing Options and Data Selection.

18.2 Processing Options

See Section 52.4, "Cust/Sup Statement of Account - Detailed (P74R0923)."

18.3 Data Selection

Data Selection is based on F0901 file - Account Master.

You can choose any field in the Account Master File for Data Selection.

If during the process no data is selected as a result of Selection criteria in Processing Options and Data Selection, the following Error Message prints:

116V - No Data Found. No data was found for this instance. Check your data selection.

18.4 Data Sequencing

The process contains two DREAM Writer Versions, one to print the report in Detailed mode and the second to print the report in Summary mode.

The Data Sequencing for Summary mode has as first sequence field the Category Code XX, where XX must be the Summary Account Category Code Nbr assigned to contain the Summary Statutory Account Code in the range of 01-20.

The Data Sequencing for Detailed mode has as first sequence field the Category Code XX, where XX must be the Acct Category Code Nbr in the Correspondence Setup File (X0CCNB).

Figure 18-1 Data Sequence Set-up (Customer Supplier Statement) screen

Description of "Figure 18-1 Data Sequence Set-up (Customer Supplier Statement) screen"

The users are responsible to correctly set the Category Code Number in the first Sequence field of the DREAM Writer.

18.5 Report

Figure 18-2 Customer Supplier Statement of Account Report (1 of 2)

Description of "Figure 18-2 Customer Supplier Statement of Account Report (1 of 2)"

Figure 18-3 Customer Supplier Statement of Account Report (2 of 2)

Description of "Figure 18-3 Customer Supplier Statement of Account Report (2 of 2)"

18.6 Fields Description

18.6.1 Report Heading

Field	Explanation
Selected Period	From Processing Option 1.
Legal Company	From Processing Option 2.
Correspondence Account Code	For Summary mode, the two-character Summary Statutory Code that resides in the Category Code informed in Processing Option 6. For Detailed mode, the four Statutory Code characters that reside in the Category Code Nbr indicated in the Correspondence Setup File (X0CCNB).
Currency Code	From Processing Option 6.
Name of the Account	The Name of the Account is retrieved from the Description 1 (DL01) of the UDC 09/nn, where nn is the Category Code Number entered in the Processing Option for Summary mode or, if the PO is left blank, the Category Code Number entered in the Correspondence Setup File (X0CCNB).
Currency Code Description	The Description of the Currency Code is retrieved from the Description (DL01) of the Currency Code File (F0013).
Customer/Supplier	Address Book Number from processing option 10.
Customer/Supplier Name	From Alpha Name in F0101 (ABALPH).

18.6.2 Detail

Field	Explanation
Opening Balance	Prints at the beginning of the detail section. Retrieved from Correspondence Balance File corresponding to the period of the beginning date. The obtained amount is Debit Balance (from XBAPYC to XBAN14 fields of F74R0912) - Credit Balance (from XBBGBL to XBAN28 fields of F74R0912). The Bal.FWD is added only if the account is not a Profit & Loss account. If the obtained amount is greater than zero, it is placed in the Debit column, if it is less than zero; it is placed in the Credit column. For Summary mode or Correspondence Accounts added up by Address Book Number, the F74R0912 has several records, and then the system prints a sum of these amounts.
G/L Date	From the transaction (XLDGJ).
Document Date	Invoice Date, Only for Batch Types I and V. G/L Date for Batch Types R, M, K.
Document number	Invoice Number (VINV) for Batch Type V, else Document Number (DOC).
Debit	Debit amount from F74R0911 (XLAA2). If XLAA2 is not equal to zero the Primary Account Code is placed. If XLAA2 is equal to zero the Secondary Account Code is placed.
Credit	Credit amount from F74R0911 (XLAA3). If XLAA3 is not equal to zero the Primary Account Code is placed. If XLAA3 is equal to zero the Secondary Account Code is placed.
Explanation	Is the field GLEXA from the file F0911 that corresponds, to the transaction of F74R0911 that is being processed.
System Reference	Concatenating Batch Number, Batch Type, Document Number and Document Type.

18.6.3 Footer

Field	Explanation
Total Activity	Aligned with its column, the added amount of the Debit amounts included in the detail. Aligned with its column, the added amount of the Credit amounts included in the detail. This is the summary of the detail transactions and does not include the opening balance.

Field

Explanation

Total Activity

Aligned with its column, the added amount of the Debit amounts included in the detail.

Aligned with its column, the added amount of the Credit amounts included in the detail.

This is the summary of the detail transactions and does not include the opening balance.

18.6.4 Separate Final Page

Field	Explanation
Opening Balance	Retrieved from Correspondence Balance File corresponding to the period of the beginning date. The obtained amount is Debit Balance - Credit Balance. For Summary mode, the F74R0912 has several records and the system prints a sum of these amounts. For All Accounts calculate the opening net balance by adding up the appropriate period DR column - CR column from the balance file for that account. (XBAN15 - XBAN28) subtracted from (XBAN01 to AN014). The Bal.FWD is added only if the account is not a Profit & Loss account. If the net result is a positive amount and accounts is A, then print as positive and print literal as DR If the net result is a positive amount and accounts is P, then print as negative and print literal as CR If the net result is a positive amount and accounts is B, then print as positive and print literal as DR If the net result is a negative amount and accounts is A, then print as negative and print literal as DR If the net result is a negative amount and accounts is P, then print as positive and print literal as CR If the net result is a negative amount and accounts is B, then print as positive and print literal as CR
Total DR Movements	Aligned with the previous amount, the added amount of the Debit Amounts included in the detail. DR literal prints on the right side of the amount.
Total CR Movements	Aligned with the previous amount, the added amount of the Credit Amounts included in the detail. CR literal prints on the right side of the amount.
Closing Balance	If Closing Date does not correspond to the initial day of the period a zero displays. For All Accounts calculate the closing net balance by adding up the appropriate period DR column - CR column from the balance file for that account. (XBAN15 - XBAN28) subtract from (XBAN01 to AN014). If the net result is a positive amount and accounts is A, then print as positive and print literal as DR. If the net result is a positive amount and accounts is P, then print as negative and print literal as CR If the net result is a positive amount and accounts is B, then print as positive and print literal as DR If the net result is a negative amount and accounts is A, then print as negative and print literal as DR If the net result is a negative amount and accounts is P, then print as positive and print literal as CR If the net result is a negative amount and accounts is B, then print as positive and print literal as CR
Literal 'ERROR'	Displays if closing calculated balance is not equal to the corresponding closing balance from F74R0912 File. Note, the Closing balance calculation is: Beginning Balance Amount + Accumulated Debit Amounts - Accumulated Credit Amounts. If Beginning/Closing Date does not correspond to final day of the period, this verification is not made.