Related topics
- About working with A/P transactions
- About working with A/R transactions
- Rebuild A/P payment statistics
- Rebuild A/R payment statistics
In this routine you can re-calculate the A/R and A/P turnover amounts, based on the G/L postings related to the entered transactions. You use this routine to rebuild the turnover amounts if you suspect the present turnover amounts in the A/R and A/P transaction files to be corrupt.
This routine replaces the turnover amount stored in the transaction files (SRODTAI and SROLTAI) with the new calculated values. The update of the statistics files (SROPAY and SROLPS) must be run separately by executing the Rebuild A/R and A/P payment statistics routine.
The turnover amount is calculated as follows:
- If the used VAT handling code has Turnover amount set to NO, then the new calculated turnover amount will be zero.
- If the used VAT handling code has Turnover amount set to YES and Turnover net amount is set to YES in the A/R control file, then the new calculated turnover amount will be the sum of the reference amount in transaction currency of all the related VAT postings.
- If the used VAT handling code has Turnover amount set to YES and Turnover net amount is set to NO in the A/R control file, then the new calculated turnover amount will be the sum of the reference amount in transaction currency and the amount in transaction currency (VAT amount) of all the related VAT postings.
Selection
- A/R
- Indicate if you want to re-calculate the turnover amounts for A/R transactions
- A/P
- Indicate if you want to re-calculate the turnover amounts for A/P transactions.
- Start period
- If you enter a start period, you can choose to rebuild the turnover amounts of the A/R and A/P transactions from a certain accounting period and keep the turnover amounts of your historical transactions unchanged up to that period. If you leave this field blank, then all transactions will be re-calculated.
- Document type
- Select one or more document types. Selection can be made via range selection or combined selection, depending on the parameter.
Range selection is possible when there are only two selection fields for a parameter. State the range (from-to) of values to include. The system checks that the ending value is greater than or equal to the starting value. Leave the fields blank, if all values should be included.
Combined selection is possible when there are several selection fields for a parameter, preceded by a one-position field. You can state either individual or a range of values to include. You determine the type of selection to use by entering 1 or 2 in the first field:
- For individual selections, enter 1, and then the relevant values in the following fields. For parameters controlled by a table or a file, the system will check that the entered values exist.
- For a range selection, enter 2, and then the first and last value of the range in the two subsequent fields. Do not complete the last fields. The system checks that the ending value is greater than or equal to the starting value. Leave the fields blank, if all values should be included.
A record is only included if it fulfils all selection criteria.
Click OK to run the routine in batch mode, or press F2 to run the routine interactively.