Creating reversal provision request

Glossary

Basics of using Ramco Enterprise series web page

Using online help

This page allows you to search and select the documents for which the provision must be reversed. Tell me more.

The “Create Reversal Request” page appears.

The system displays the following fields:

Request No.

The number identifying the provision reversal request. This number is automatically generated by the system at the time creating the provision reversal request.

Status

The status of the provision reversal request. The various statuses of the provision reversal request are

 
  • Fresh – Indicates that the request has just been created.

 
  • Authorized – Indicates that the Journal Voucher generated against the request is authorized and the accounting entries are posted in the books of accounts. The vouchers can be picked up for authorization in “Journal Voucher” business component.

 
  • Deleted – Indicates that the request in “Fresh” status is deleted. The request can be deleted in the “Edit Request” activity of this business component.

Request Date

The date on which the request for provision reversal was raised (Date Format). Mandatory. The request date must be later than the due date of all the documents and the provision created date. The system date is defaulted on launch of the page.

Finance Book

Use the drop-down list box to select the code identifying the finance book in which the reversal accounting entries must be posted. The system lists all the finance books mapped to the login organization unit for selection. The finance book set in ‘Set Function Defaults’ activity of this component is defaulted on launch of the page. 

Customer Code From

The starting codes in the range of customer codes from which the details are to be retrieved (Alphanumeric, 16). The system retrieves the customer codes that are greater than or equal to the code specified here.

 

If this field is left blank and “To” field is entered, then the system retrieves the customer code from the first customer code till the code specified in the “To” field.

To

The ending codes in the range of customer codes till which the details are to be retrieved (Alphanumeric, 16). The system retrieves the customer codes that are less than or equal to the code specified here. The code specified must be greater than or equal to the code specified in “Customer Code From” field.

 

If this field is left blank and the “Customer Code From” is entered, then the system retrieves the customer code from the code specified in the “Customer Code From” field till the last customer code available.

Billing Point

Use the drop-down list box to select the organization unit in which the document has been raised. The system lists all the organization units mapped to the login company for selection. The system displays “All” by default on launch of the page.

Doc. No. From

The starting number in the range of document numbers for which the details are to be retrieved (Alphanumeric, 18). The system lists all the document numbers that are greater than or similar to the value entered here.

 

If this field is left blank and the “To” field is entered, then the system retrieves the documents starting from the first document till the document specified in the “To” field.

To

The ending number in the range of document numbers for which the details are to be retrieved (Alphanumeric, 18). The system lists all the document numbers that are lesser than the value entered here. The number entered here must be greater than the number entered in the “Document No. From” field.

 

If this field is left blank and the “Document No. From” entered, then the system retrieves the documents starting from the number specified in the “Document No. From” field till the last voucher.

Doc. Type

Use the drop-down list box to select the document type. The document types available are “Order Based Invoice”, “Direct Invoice”, “Debit Note”, and “Transfer Debit Note”. The system displays “All” by default on launch of the page.

Overdue Amount From

The starting overdue amount in the range of amount for which the details are to be retrieved (Decimal). The system retrieves all the documents whose overdue amount is greater than the amount entered here. The amount entered here must be lesser than the amount entered in the “To” field.

 

If this field is left blank and the “To” field is entered, then the system retrieves the document from the first document in the database till the document with the overdue amount as specified in the “To” field.

To

The ending overdue amount in the range of amount till which the details are to be retrieved (Decimal). The system retrieves all the documents whose overdue amount is less than the value entered here.

 

If this field is left blank and the “Overdue Amount From” field is entered, then the system retrieves all the documents whose amount is greater than the value entered in the “Overdue Amount From” field from the database

Currency

Use the drop-down list box to select the currency in which the document has been raised. The system lists all the currencies for the customer receivables. If the base currency is one of the currencies in the list, then the system displays the base currency by default on launch of the page. 

Due Date From

The starting date in the range of due date of the receivables, from which the document details must be retrieved (Date Format). The system lists all the documents with the receivable due on the date specified here.

 

If this field is left blank and the “To” field is entered, then the system retrieves the documents starting from the first document in the database till the documents raised on the date specified in the “To” field.

To

The ending date in the range of due date of the receivable till which the document details must be retrieved (Date Format). The system lists all the documents starting from the documents with the due date earlier than the date specified here. The date specified here must be greater than or equal to the date entered in the “Due Date From” field.

 

If this field is left blank and “Due Date From” field is entered, then the system retrieves all the documents with the due date as specified in the “Due Date From” field till the last document in the database.

Note: The “Due Date From” and “To” must be less than or equal to the request date

Provision Request No.

The number identifying the provision request (Alphanumeric, 18). The system retrieves the documents based on the request number specified here.  This facilitates the exact reversal of a provision request.

 

Help facility available.

Overdue Days From

The starting day in the range of overdue days from which the details are to be retrieved (Integer). The number of specified here must be less than the days specified in the “To” field. The system retrieves the documents whose overdue days is greater than or equal to the days specified here.

To

The ending day in the range of overdue days till which the details are to be retrieved (Integer). The system retrieves the document with overdue days less than or equal to the days specified here.

Sort By

Use the drop-down list box to select the order in which the documents must be retrieved. The various options available are “Document Type”, “Customer Code” and “Overdue Days”. The system displays “Overdues Days” by default on launch of the page.

Excess Provision

Check this box to retrieve the only those documents for which excess of provision has been created over an unadjusted amount

Note: Excess Provision results when receipts have been made against a document for which provision has been created.

The system displays the following fields in the “Document Information” multiline:

Doc. Type

The document type, which could be “Order Based Invoice”, “Direct Invoice”, “Debit Note”, and “Transfer Debit Note”.

Doc. No.

The number identifying the document for which the provision amount has to be created.

Customer

The code identifying the customer from whom the receivables are overdue.

Due Date

The date on which the receivables are due from the customer.

Due Amount

The amount due from the customer.

Overdue Days

The number of days the receivables are pending from the customer after due date.

Currency

The currency in which the document is raised.

Overdue Amount

The due amount pending from the customer.

Provision Amount

The provision amount that already exists for the document.

Written-Off Amount

The provision amount that has been written off. The provision amount is written off in the “Writeoff Bad Debts” activity of this business component.

Reversal Amount

The amount to be reversed in the provision amount (Decimal).

The system displays the following fields:

Exchange Rate

The exchange rate of the currency.

Base Amount

The base amount of the reversal amount. The system displays the product of the reversal amount and the exchange rate.

Billing Point

The organization unit in which the document has been raised.

Note: Atleast one row in the multiline must be marked for computing total.

The system computes the base reversal amount for the selected documents.

The system also computes the parallel base amount, if parallel base currency exists for the company.

The system displays the following fields in the multiline below the multiline:

Total Base Amount

The total of base provision reversal amount of all the selected document in the multiline.

Voucher No.

The number identifying the voucher generated in the “Journal Voucher” business component at the time of creating the provision reversal request.

CC

The cost center to which the amount must be posted (Alphanumeric, 10). Data entry in this field is mandatory if the bad debts expense account code has been mapped to a cost center in the “Management Accounting” BPC.

Analysis Code

The analysis code to which the bad debt expense account is mapped in the "Assign Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5).

 

Help facility available.

Sub Analysis Code

The sub-analysis code, which is mapped to the analysis code in the "Assign Sub-Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5).

Note: The “Analysis / Sub-analysis Code applicability” parameter must be set to “Yes” in the “Company Process Parameter” business component. The account code must be mapped to the cost center.

Remarks

Any remarks pertaining to the creation of provision request (Alphanumeric, 100).

 

Zoom facility available.

The system generates a provision reversal request for the provision reversal amount based on the numbering type set for the “Provision Reversal Request” transaction type.

The system generates a voucher in the “Journal Voucher” business component corresponding to the Provision Reversal Request.

The system automatically updates the status of the request number to “Fresh”.

The system saves the login ID of the user and the system date along with the creation details.

To proceed, carry out the following

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Creating reversal provision request – An overview

Activity overview

You can specify the date on which the entries posted must be reversed and the code identifying the finance book in which the accounting entries must be posted on reversal. You can retrieve the documents by carrying out the search using the code identifying the customer, the organization unit in which the documents has been raised, the number identifying the document, the document type, the amount due from the customer, the date on which the payment is due and the transaction currency of the document.  The documents retrieved would be for the finance book selected in the header. 

The system retrieves the document information based on the search criteria. You can specify the provision reversal amount for each document. The system computes the total base amount of the reversal amount of the selected documents. You can also specify the code identifying the cost center and the analysis and the sub-analysis code.

The system generates the provision reversal request number on creating the request. The system updates the status of the provision request to “Fresh”. The system also saves the login ID of the user and the system date along with the creation details.