Before You Begin

To get started, ensure you have your username and password ready. Once logged in, you will land on the welcome screen.

1.1 Add GRN Invoice:

Add a GRN Invoice - Step-by-Step:

Step 1: Reach the GRN Invoice Screen

From the main side menu, click on "Accounts," then go to "Operations," and finally select "GRN Invoice." This will open the GRN Invoice Search page.

Step 2: Adding a GRN Invoice

On the top right of the GRN Invoice Search page, you'll see an "Add GRN Invoice" button. Click this button.

Step 3: Fill in Details

• Supplier: [Dropdown] (Mandatory) Select the supplier.
• Invoice Type: [Dropdown] (Mandatory) Select the invoice type (e.g., Purchase Inward, Service DC Inward, or Supplier Job Work Inward). You must select the supplier first to choose an invoice type.
• GRN/DC Number: [Dropdown] (Mandatory) Select one or more GRN/DC numbers as needed.

The dropdown values are dynamically populated based on the selected invoice type:

• If "Purchase Inward" is selected, the dropdown displays GRN numbers from Purchase Inward details.
• If "Service DC Inward" is selected, the dropdown displays DC numbers from Service DC Inward details.
• If "Supplier Job Work Inward" is selected, the dropdown displays DC numbers from Supplier Job Work Inward details.

After clicking the "Get Line Items" button, you can view the selected GRN/DC number line items and advance amount details at the bottom.

• Invoice Number: [Text Field] (Mandatory) Enter the invoice number for the selected details.
• Invoice Date: [Date Field] (Mandatory) Select the GRN invoice date.
• Other Charges: [Number Field] (Optional) Enter any additional charges (supports up to two decimal places).

Note: GST fields are displayed based on the supplier and organization billing addresses.

• CGST Percentage and SGST Percentage: [Number Field] (Optional) Applicable if the supplier and organization billing addresses are in the same state. By default, it displays the higher CGST and SGST values but can be edited.
• IGST Percentage: [Number Field] (Optional) Applicable if the supplier and organization billing addresses are in different states or countries. By default, it displays the higher IGST value but can be edited.

• Category: [Dropdown] (Mandatory) Select the category.
• TDS: [Number Field] (Optional) Enter the Tax Deducted at Source (TDS) charges value.
• TCS: [Number Field] (Optional) Enter the Tax Collected at Source (TCS) charges value.

Note: You can provide either TDS or TCS, but not both.

• Due Days: [Number Field] (Mandatory) By default, it displays the higher due days value based on supplier payment terms within the expire and effective date range. This field can be edited if necessary.
• Due Date: [Date Field] (Mandatory) By default, it displays the due date calculated based on the due days and invoice date fields.
• Remarks: [Text Field] (Optional) Enter additional details or comments for the GRN invoice.
• Advance Amount: Displays advance amount details. If you need to deduct the advance amount, click the checkbox. By default, the advance amount to deduct shows all the advance amount value and can be edited.

• Taxable Amount: [Auto-Calculated] Displays the taxable amount based on the selected GRN/DC line-item details.
• Tax Amount: [Auto-Calculated] Displays the tax amount based on the selected GRN/DC line-item details.
• TDS Value: [Auto-Calculated] Displays the calculated TDS value if applicable.
• TCS Value: [Auto-Calculated] Displays the calculated TCS value if applicable.
• Grand Total Amount: [Auto-Calculated] Displays the final total amount, including all charges and taxes.

NOTE: If you need to clear all the details, you can click the "Clear" button.

Step 4: Calculation Operations

Taxable Amount: To calculate the total taxable amount, sum all the line items' taxable values in the line items table.

Taxable Amount = Total Qty * Rate Per Unit

If other charges are present, their value will be added to the total taxable value.

Tax Amount: The total tax amount is calculated as follows:

1. If CGST & SGST are present in the line items table:

   The tax amount is calculated by multiplying the taxable amount by the combined percentage of CGST and SGST. The combined percentage is obtained by adding the CGST and SGST values and dividing by 100.

   Tax Amount = Taxable Amount * ((CGST + SGST) / 100)

2. If IGST is present in the line items table:

   The tax amount is calculated by multiplying the taxable amount by the combined percentage of IGST. The combined percentage is obtained by adding the IGST values and dividing by 100.

   Tax Amount = Taxable Amount * (IGST / 100)

   Finally, each line-item tax amount will be added to the tax amount.

3. If other charges are present in the form:
   • If CGST & SGST fields have values:

     The total tax amount is calculated by multiplying the other charges and the combined percentage of CGST & SGST. The combined percentage is obtained by adding the CGST & SGST values and dividing by 100.

     Fields Tax Amount = Other Charges * ((CGST + SGST) / 100)

   • If IGST field has a value:

     The total tax amount is calculated by multiplying the other charges and the combined percentage of IGST. The combined percentage is obtained by adding the IGST values and dividing by 100.

     Fields Tax Amount = Other Charges * (IGST / 100)

     Finally, the fields tax amount will also be added to the tax amount.

TDS Amount: Calculates the TDS amount by taking the total taxable amount, multiplying it by the TDS percentage from the form, and dividing the result by 100. If no TDS value is provided, the calculation defaults to 0.

TDS Amount = (Total Taxable Amount * TDS) / 100

TCS Amount: Calculates the TCS amount by taking the total taxable amount, multiplying it by the TCS percentage from the form, and dividing the result by 100. If no TCS value is provided, the calculation defaults to 0.

TCS Amount = (Total Taxable Amount * TCS) / 100

Grand Total:

• If TDS is present:

  Grand Total = Total Taxable Amount + Total Tax Amount + TDS Amount

• If TCS is present:

  Grand Total = Total Taxable Amount + Total Tax Amount - TCS Amount

• If Advance Amount is present:

  Grand Total = Grand Total - Advance Amount

Step 5: Save, Draft, or Cancel

At the bottom of the page, the following actions are available:

• Draft: Save the details as a draft for later editing or submission.
• Confirm: Finalize the GRN invoice for processing.
• Back: Navigate back to the search page without saving changes.

Additional Notes:

• Ensure mandatory fields are completed before confirming the invoice.
• The system calculates default values for GST, Due Days, and Due Date, but these can be overridden based on requirements.

1.2 Search GRN Invoice

Search a GRN Invoice - Step-by-Step:

Step 1: Start Searching

Navigate to the GRN Invoice Search page. You can search using the following filters:

• Supplier: [Dropdown] (Optional) Select one or multiple suppliers from the dropdown.
• Invoice Type: [Dropdown] (Optional) Select the type of invoice (e.g., Purchase Inward, Service DC Inward, or Supplier Job Work Inward).
• Invoice No: [Text] (Optional) Enter the invoice number to search for specific invoices.
• Invoice From Date: [Date] (Mandatory) Select the starting date for the invoice range.
• To Date: [Date] (Mandatory) Select the ending date for the invoice range.
• Exported Status: [Dropdown] (Optional) Choose the export status. By default, this field is set to "All" but can be changed to filter specific export statuses.
• Once the desired filters are selected, click the “Search” button to begin.

Note: You must provide the Invoice From Date and Invoice To Date, along with any other optional filters or a combination of values.

Step 2: See the Results

After clicking "Search," the results matching your criteria will be displayed in a table format:

• Supplier: Displays the supplier name(s) associated with the invoices.
• Invoice Type: Displays the supplier name(s) associated with the invoices.
• Invoice No: Displays the corresponding invoice number(s).
• Invoice Date: Displays the date of the invoice.
• Status: Shows the current status of the invoice (e.g., CONFIRMED, DRAFT).
• Exported Status: Displays whether the invoice has been exported or not.
• Action: Includes options such as a checkbox for bulk actions and a View/Edit button for individual invoice actions.
• If you searched using Exported Status, Invoice From Date, and Invoice To Date, the results will match these filters precisely.
• For searches using any other combination of filters, the table will display the corresponding details that match your criteria.

Key Notes:

• You can perform a search using a single filter or a combination of filters.
• The Invoice From Date and Invoice To Date fields are mandatory for all searches.
• The system allows flexibility in using optional filters like Supplier, Invoice Type, Invoice No, and Exported Status to refine the results.

Export for Tally

The result table includes a checkbox column, allowing you to select the GRN invoices you want to export to Tally.

• After selecting the checkboxes, the total count of selected GRN invoices will be displayed at the top of the result table.
• To export the selected GRN invoices, click the "Export for Tally" button. This action will download an Excel sheet containing the details.

Important: While exporting, if any GRN/DC number's line item does not have a valid GST value, a popup will appear listing the affected GRN/DC numbers. You must ensure all line items have standard GST values to proceed.

To deselect all checkboxes, click the "Uncheck All" button.

Note: If your GRN invoice is in DRAFT status, you cannot export it for Tally.

1.3 Edit GRN Invoice

Edit a GRN Invoice - Step-by-Step:

Step 1: Access the Edit GRN Invoice Page

After performing a search, locate the GRN Invoice Result Table. Click the "View/Edit" button next to the GRN invoice you wish to edit.

Step 2: Update Details

On the Edit GRN Invoice page, review the existing details. Make the necessary changes to the editable fields as required. If a file upload is needed, you can attach a file at the bottom of the page. The file should be in PDF format.

Note: Uploading a file is optional.

Key Restrictions While Editing

• Supplier and Invoice Type fields are read-only and cannot be changed.
• You can remove existing GRN/DC numbers or add new ones. However, after making changes to the GRN/DC numbers, you must click the "Get Line Items" button to refresh the line item details.
• The "Clear" button is disabled during the edit process.

Step 3: Save or Cancel Changes

At the bottom of the page, you will see the following options:

• Confirm: Saves the updated details and finalizes the changes to the GRN invoice.
• Back: Discards any unsaved changes and navigates back to the search page without updating the GRN invoice.

That's It! You’ve successfully learned how to search and add GRN invoices based on multiple filters using the DMeX app.

THANK YOU! For further assistance, contact the Support Team.