Record Quantity/Value Adjustments

Component overview

Unified glossary

Basics of using Ramco Enterprise series web page

Using online help

This page allows you to make value and Quantity adjustments in tax amounts / taxable quantities, after the authorization of invoices. On authorization of the adjustment, system generates a Journal voucher (for value adjustments) in authorized status and they will not be available for reversal in the Journal Voucher component.

The “Record Quantity/Value Adjustments” page appears.

Tax Type

Use the drop-down list box to select the required tax type. Mandatory. The combo will be loaded with options “Excise”, “VAT” and “SER”.

Tax Community

Use the drop-down list box to select the required tax community. The first value loaded in the list is displayed on launch of the page as default. Tax community is the government authority administering the tax laws.

Tax Region

Use the drop-down list box to select the required tax region Mandatory. On selecting the tax type the tax regions set for the tax type are loaded in the list.

Tax region is the place at which the declaration of tax is made.

On change of tax region, the system loads the tax code list with the tax codes for the tax type.

Adjustment No.

The required tax Adjustment No (Alphanumeric, 18). Mandatory. The number allotted to the adjustment entry.

Help Facility available.

Numbering Type

Use the drop-down list box to select the required numbering type or Manual. If the numbering type is manual and if Tax adjustment number has been entered the system checks for uniqueness for the transaction type.

The system displays in the following fields in the “Adjustment Information” group box:

Status

The status of the adjustment.

Adjustment Date

The adjustment date (Date format) Mandatory.

Adjustment Type

Use the drop-down list box to select the required adjustment type from the following values: Quantity, Value and Both. On launch of the page the system displays ‘Both’ as default. Quantity Adjustment is applicable only for the tax type "Excise".

Nature Of Adjustment

The Nature of adjustment of the adjustment no. The Values can be Increase / Decrease.

Finance Book

Use the drop-down list box to select the required finance book Mandatory. The finance book in which the transaction is accounted. The finance books available for the company will be filled in the list and the first, loaded finance book will be displayed

Reason Code

Use the drop down lost box to select the Reason Code for the adjustment. The Codes created in the Reason Code Component for the tran type will be available for selection.

Description

On Selection of the Reason code the system will display its relevant description.

Ref. Doc. No.

The Reference Document No. for the Adjustment No. It can be the transaction no for which the adjustment is created. Eg. Inventory Issues, Invoice Nos.

Ref.Doc.Date

The Date of the Reference Document.

Remarks

Remarks for the Adjustment.

Ref. Doc. Type

Use the drop-down list box to select the Reference Document Type. It will be blank on launch of the page.

When the Tax Type is "Excise", then the combo will be loaded with options ‘Supplier Direct Invoice’, ‘Goods Receipt’ and 'Tax Adjustment Voucher'.

When the ‘Classification’ is selected as ‘Deferred Credit Transfer’ the Reference Document Type should be either ‘Supplier Direct Invoice’, ‘Goods Receipt’ or  'Tax Adjustment Voucher' For Other types of adjustments if it pertains to ‘Supplier Direct Invoice’ or ‘Goods Receipt’ then it can be selected else it needs to be Blank.

When the Tax Type is SER, then the reference document type will be loaded with the options - Customer Account Based Credit Note, Customer Item Based Credit Note, Customer Account Based Debit Note, Customer Item Based Debit Note, Customer Direct Invoice, Customer Miscellaneous Invoice, Customer Pack Slip Invoice, Customer Order Based Invoice, Supplier Account Based Credit Note, Supplier Item Based Credit Note, Supplier Account Based Debit Note, Supplier Item Based Debit Note, Supplier Direct Expense Invoice, Supplier Direct Item Invoice, Supplier Delivery Charges Invoice and Supplier Order Based Invoice.

Ref .Doc. OU

Use the drop-down list box to select the Organization Unit of the Reference Document. The Login OU and Blank will be available for selection. When the ‘Classification’ is selected as ‘Deferred Credit Transfer’ the Reference Document combo needs to be selected. For other types of adjustment it can be selected when reference document no and reference document type are selected.

Classification

 Use the drop-down list box to select the classification of the adjustment:

  • For the tax type Excise, the values will be ‘Normal’ , ‘Opening Balance Entry’, ‘Deferred Credit Transfer’ and "Excise Settlement”.

  • For the tax type VAT, the values will be ‘Normal’ , ‘Opening Balance Entry’ and ‘Deferred Credit Transfer’.

  • For the tax type SER, the value will be ‘Normal’.

  • For the tax type GST, community australia / New zealand, the values will be ‘Normal’  and ‘Bad Debts Adjustment’

  • For the tax type GST, community Malaysia, the values will be ‘Normal’ , ‘Bad Debts Adjustment’ and "Outstanding document adjustment"

Note: The Reference Document Details are mandatory when the Classification is selected as ‘Deferred Credit Transfer’ and the entered reference document details will be validated for ‘Deferred Credit Transfer’ .For other types of adjustment the reference document details will be validated only when the reference document type is selected as other than ‘Blank’.

Note: The status of the document will be “Blank” when the page is launched. When the adjustment is created, status will be set to “Fresh”.

Account Code

The code identifying the account to which the contra entry will be posted (Alphanumeric, 32). The account codes must have been created in the “Create Operative Chart of Accounts” activity of the “Accounting Setup” business component.

Note: The Account code should be mapped to the Finance book selected as on the transaction date. Account properties (that is Account Group, Account Classification, Auto Posting Account type and Control Account type) of the selected Account code should not be excluded for Journal Voucher type in  “Maintain Posting Rule” activity in “Accounting Setup” business component.

Help facility available.

Analysis Code

The analysis code to which the selected 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).

Cost Center

The cost center to which the amount must be posted (Alphanumeric, 10). Data-entry in this field is mandatory if the account code has been mapped to a cost center in the “Cost Setup” business component.

Help facility available.

Tax Code

Use the drop-down list box to select the required tax code.

The list is loaded with the tax codes for the tax type tax region and the system displays the first loaded value.

Account Type

Use the drop-down list box to select the required tax account type.

The list is loaded with the tax account types as applicable for the tax type and tax community.

Tax Amount

The Tax Amount for which the adjustment needs to created (Integer).

Dr/Cr Indicator

Use the drop-down list box to select whether you want to “Debit” or “Credit” the voucher entry that is being created in the corresponding account code. The system displays “Debit” by default at the launch of the page.

Account Code

The code identifying the account to which the accounting entries will be posted (Alphanumeric, 32). The account codes must have been created in the “Create Operative Chart of Accounts” activity of the “Accounting Setup” business component.

Note: The Account code should be mapped to the Finance book selected as on the transaction date. Account properties (that is Account Group, Account Classification, Auto Posting Account type and Control Account type) of the selected Account code should not be excluded for Journal Voucher type in  “Maintain Posting Rule” activity in “Accounting Setup” business component.

Help facility available.

Analysis Code

The analysis code to which the selected 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).

Cost Center

The cost center to which the amount must be posted (Alphanumeric, 10). Data-entry in this field is mandatory if the account code has been mapped to a cost center in the “Cost Setup” business component.

Help facility available.

Manufacturer Name

The name of the manufacturer.

Manufacturer Invoice No

The invoice number of the manufacturer.

Invoice Date

The date on which the invoice was raised.

Amount

The  amount of the supplier invoice

Registration Details

The excise registration details of the manufacturer.

Note: The Manufacturer Invoice Details can be provided for adjustments created for accounting the input credits which were not accounted at the time of ‘Goods Receipt’.

Tax Category

Use the drop-down list box to select the required tax category.                                                                

The Tax Categories as applicable for the tax type and tax community will be available for selection

Tax Class

Use the drop-down list box to select the required tax Class

The Tax Classes as applicable for the tax type and tax community will be available for selection

Remarks

Remarks for the Value adjustment Line.

 

Item Code

The code identifying the item for which the quantity adjustments to be done. The Item codes should have been defined in Inventory and mapped to tax groups for the tax type selected.

Help Facility available.

Item Variant

The variant of the item.

Type of Material    

Use the drop-down list box to select the type of material. The combo is loaded with ‘Capital’ and ‘Non Capital’.

UOM

The Unit of  Measurement in which the quantity adjustment should be done. The UOM should be the UOM of the tax group to which the item is mapped for the tax type, tax community and tax region combination. The UOM should be a valid UOM defined in the UOM component.

Help Facility available.

Quantity

Quantity that needs to be adjusted for the Item Code.

Tax Group

When the Item Code UI task is executed the system will display the tax group to which the item is mapped for the tax type, tax community and tax region combination.

Data Hyper Link  available for viewing the details of the tax group.

Tax Category

Use the drop-down list box to select the required tax category.                                                            

The Tax Categories as applicable for the tax type and tax community will be available for selection.

Tax Class

Use the drop-down list box to select the required tax class.

The Tax Classes as applicable for the tax type and tax community will be available for selection.

Numbering Type

Use the drop-down list box to select the required numbering type for generating the Journal Voucher for Value adjustments.

The system displays the following fields:

Voucher No.

Voucher No. generated on authorization of the adjustment no. for value adjustments.

Data Hyper Link available for viewing the details of the voucher no.

Voucher Date

The Date of the Journal Voucher

Total Value

The Total Value for which the voucher is generated.

To proceed, carry out the following

Go top