Note!: The GetPeriodBalances method will no longer be supported. Thefunctions will be replaced by the GetPeriodBalances method in objecttype BUS1028 of the general ledger.
If you have previously used this method, change the usage to that of thenew method in object type BUS1028.
Use the method in object type BUS1028 the next time you use thisfunction.Functionality
This method returns the G/L account balances per posting period for agiven fiscal year.
The user can choose whether a balance is returned in the transaction orcompany code currency except for G/L accounts managed in differenttransaction currencies. Only the company code currency is returned forsuch accounts.
The balance as determined by the system and the currency are returnedwith any problems appearing in the form of a return code. Notes
The same authorization checks are carried out as take place whendisplaying information within a transaction.
The system does not convert the input parameter COMPANYCODE, meaningthat leading blank characters within this parameter are not cleared.Likewise, no conversion is carried out for the parameter GLACCT. G/Laccount numbers must therefore be entered with the leading zeros (e.g.0000113100).
Messages are displayed in the RETURN parameter the documentation forwhich contains the return values and their meaning. Description
Account balance carried forward from the previous fiscal year. Thecurrency can be taken from the table for balance data specifications. Description
The return code for the method is supplied in a structure containingfive fields. You will find information on the significance of theindividual fields in the relevant data element documentation.
Layout of structure
TYPE Message type
CODE Message code
MESSAGE Message text
LOG_NO Application log: Log number
LOG_MSG_NO Application log: Sequence number of messageDescription
You will find information on the significance of the company code inthe relevant data element documentation:
Company codeDescription
You will find information on the significance of the currency type inthe relevant data element documentation:
Currency typeValue range
00 = Balance in transaction currency
10 = Balance in local currency Description
You will find information on the significance of the fiscal year in therelevant data element documentation:
Fiscal yearDescription
You will find information on the significance of the G/L account numberin the relevant data element documentation:
G/L account numberDescription
The balances for each posting period for the G/L account are suppliedin a table. You will find information on the significance of theparameters in the relevant data element documentation.
Structure of table
COMP_CODE Company code
GL_ACCOUNT G/L account number
FISC_YEAR Fiscal year
FIS_PERIOD Fiscal period
DEBITS_MTH Total of the debit postings for the month
CREDIT_MTH Total of the credit postings for the month
MNTH_SALES Month's sales
BALANCE Account balance
CURRENCY Currency key |