mO SharemO Share

Adding, Editing, Deleting & Printing PI (Purchase Invoice) in Ginesys Web

What is Purchase Invoice?

PI (Purchase Invoice) is raised by the Purchaser after he receives the purchased goods from the Supplier. The Invoice bears all the details of the transaction with the total amount owed to the Supplier. If a Purchase Invoice is not created, then the Supplier account will not reflect the purchase amount in its ledger. Purchase invoice is issued by the purchaser to the seller for confirming the receipt of the order.


What is the purpose of this form?

The current module outlines the general Purchase Invoice. For making an Invoice for Consignment purchase you have to raise it at Consignment Invoice module. Under this module you can only make Invoices for Non-Consignment purchase.



Purchase Invoice and Consignment Invoice are merged in the Ginesys web module. This article describes the process of manage Purchase Invoice in Ginesys web. 

 Add Purchase Invoice

Prerequisites

  1. The users' role must have access to the Add app operation in the Purchase Invoice feature in Procurement - Operation - Invoicing through Roles in Ginesys Web - Admin - Security.

  2. Supplier must be created. 

  3. Site must be created. 

  4. The document numbering scheme for Purchase Invoice must be present for the connected site. 

  5. The following masters need to be created and updated in AdminInventory and Procurement modules:

      Admin module
    1. RolesApplication operations assigned for Purchase Invoice module.

    2. User Profile -  User need to select the settings related to Purchase Invoice in Admin > Security > User Profile > Procurement Tab. New setting options related to GRT are given below:

      1. Display rate and value in Receipts and Returns (selected by default, may be de-selected if required).

      2. Allow rate modification in Adhoc Returns.

      3. Allow auto creation of Purchase Invoice and Purchase Invoice.

      4. Document adjustment is mandatory in Purchase Invoice.

    3. User Role, Profile Policy and Sites to be assigned for Purchase Invoice.

    4. Document Numbering SchemeScheme needs to be created and tagged with Purchase Invoice module in Web.

    5. Organization SitesDocument numbering schemes tagged with Purchase Invoice module need to be allowed.

    6. Finance MonthRespective Finance Months for entry date should remain Open.
     Inventory Module
    1. Item Group and ArticlesProduct hierarchy for the returned items should be defined. Articles, if separately maintained, must be created for respective items.

    2. Item It is advisable that items returned should be created with respective Tax information before transaction entry.

    3. Stock Point Location where the goods are to be stored need to be defined as Stock Points.

    4. GST/Tax RateApplicable tax rates for the period to be defined.
     Procurement Module
    1. Vendor - Vendors, from whom the goods are purchased, must be defined with respective Terms and settings in Procurement tab. Ensure that applicable Trade Group and Purchase Order Booking Currency are selected for respective vendors.

    2. Charge Charges applicable on the purchase made must be defined.

    3. TermsTerm applicable for the respective vendor must be defined.

    4. Assign Organization Site  [Optional] - Only when the vendor is specific for any site, then assignment is required. If Trade Group/Terms etc differs for sites, then those need to be assigned here.

    5. Price Chart  [Optional] - will be required only if made applicable for the vendor, and should be defined with respective items purchased.

    6. Margin Rule  [Optional] - will be required only if user profile requires such setup.

    7. Margin Rule Allocation  [Optional] - will be required only if Site wise - Vendor Wise - Article wise Margin is to be maintained.

Step-by-step guide

The steps are as follows:

  1. Go to Ginesys Web > Procurement > Operation > Invoicing > Purchase Invoice.

  2. Purchase Invoice window will open. 

  3. Previously created Purchase Invoice will be listed.

  4. Click on the Add button. 

  5. Purchase Invoice window will open. 



  6. You will get group of icons at the top right corner of the window.



    1. The icons name from left to right are - Expand All, Collapse All, Print Document Report, Attachments, Clear Form and Open Side Panel. 

      1. Expand All: Clicking on this icon, all the sections will be Expand if they are collapsed.

      2. Collapse All: Clicking on this icon, all the sections will be Closed if they are expanded.

      3. Print Document Report: Clicking on the Down Arrow beside this icon, you will get Print Preference option with already created Report File Template. This option is used to print document.

      4. Attachments: You can Upload some required documents from this option.

      5. Clear Form: Clicking on this icon, you can Clear all the data already entered. 

      6. Open Side Panel: Clicking on this, you will get the details of the current Purchase Invoice as follows:

        1. Document Summary:  In this section you will get the details of Selected Items, Sale Type, Owner Site, Modified by etc. 

        2. Vendor Details: You will get the Selected Customer Details like Address, Contact Details, Tax Region, Credit Limit, Overdue Amount etc. 

        3. Vendor Statistic: This section describes the Received not Invoiced amount, Outstanding Amount, Last Invoice Date etc. 

  7. You will get three section in the Purchase Invoice main form - General, Item Details and Others.

  8. General:



    1. Select the Owner Site (Mandatory Field) for which you want to create the Purchase Invoice.

    2. Select a Invoice No. (Mandatory Field) which is already created.

    3. Select the Vendor (Mandatory Field) from the drop down list.

    4. According to the selected Vendor, other fields like Reference Site, Trade Group, Term Name, GRC Type, Purchase Ledger, Currency etc will be populated.

    5. System Date will be populated in the Date field (Mandatory Field).

    6. Document No., Agent and Document Date are mandatory fields.

  9. TDS Information:



    1.   TDS Information will be updated automatically as per Vendor.

  10. Item Details:
     


    1. You will get two sections in the Item Details - Receipt Information and Item Information.

      1. Receipt Information:

         
        1. Click on Select Item Receipt. 

        2. Select Receipt window will open.

          {page

        3. You will get the list of GRC in the Receipt Information section.

        4. Select the GRC against which you want to return.

        5. The items, present in the selected GRC, will be populated in the Item Information section.

        6. Click on the OK button.

        7. The selected GRC will be populated in the Receipt Information section with Receipt Date, Vendor Doc No. and Stock Point.

        8. If you click on the  button left side of the populated GRC, you will get a drop down list. 


        9. You will get Delete Record and Item Charge.

          1. Delete Record: You can delete the populated item from the list as per your requirement.

          2. Item Charge: The charges applied on the particular item will be displayed by clicking on this option. However, you may change the factors of the charges applied based on the settings in your user profile. 

      2. Item Information:


        1. The items, present in the selected GRC, will be listed in the Item Information section with Barcode, Item Description, Order No. etc.
           
        2. You can modify Invoice Qty. and Rate. 

        3. If you click on thebutton left side of the populated item, you will get a drop down list. 


        4. You will get Delete RecordItem Charge and View Properties.


          1. Delete Record: You can delete the populated item from the list as per your requirement.

          2. Item Charge: The charges applied on the particular item will be displayed by clicking on this option. However, you may change the factors of the charges applied based on the settings in your user profile. 

          3. View Properties: You can check the item details by clicking on this option. It will open the Item Master window but you cannot edit any details. 

  11. Others:



    1. You can also put in Remarks field in Others section.

  12. Now you need to calculate Charge. Click on the Calculate Charge button. But even if you skip this step, charges applied will be automatically calculated on saving the form.

  13. Charge will be calculated and the final amount after charge application will be populated as Net Amount.

  14. If you click on any applicable charge, Applicable Item window will open. You can alter the charge factor if you have enabled the proper user profile setting. The applicable charge amount or discount amount will be divided between all the items. 

  15. Click on the Save button to save Purchase Invoice. You will get a message - "Document <Purchase Debit No:> saved successfully."

 Edit Purchase Invoice

Prerequisites

  1. The users' role must have access to the Edit app operation in the Purchase Invoice feature in Procurement - Operation - Invoicing through Roles in Ginesys Web - Admin - Security.

  2. Purchase Invoice must be created and Un-Posted.          

Step-by-step guide

The steps are as follows:

  1. Go to Ginesys Web > Procurement > Operation > Invoicing > Purchase Invoice.

  2. Purchase Invoice window will open. 

  3. Previously created Purchase Invoice will be listed.

  4. Select the PI you want to edit.

  5. You can use Filter to search particular PI(s).

    Note: If you select multiple Purchase Invoice, you will get the Edit option disabled. You cannot edit multiple PI at a time.

  6. Edit: Purchase Invoice window will open. 


  7. All the details will be populated.

  8. You will three new icons at the top right corner of the window - Show Message, Delete and Revert.



    1. Show Message: You will get a message regarding edit of Purchase Invoice.

    2. Delete: You can Delete the Purchase Invoice from the Edit Mode by clicking on this icon.

    3. Revert: You can Revert the Purchase Invoice from the Edit Mode by clicking on this icon.

  9. If you want to modify the Vendor, you need to remove the Receipt. Otherwise you will get a message - "Please remove the receipt(s) before changing the Vendor.". Others details will be changed as per Vendor changed. 

  10. You can modify Agent, Reference Site, Term etc.

  11. You can also modify and delete Receipt and Items

  12. Click on the Save button to save the modified Purchase Invoice. 

  13. You will get a message - "Document <Purchase Debit No:.> saved successfully."

 Delete Purchase Invoice

Prerequisites

  1. The users' role must have access to the Delete app operation in the Purchase Invoice feature in Procurement - Operation - Invoicing through Roles in Ginesys Web - Admin - Security.

  2. Purchase Invoice must be created and Un-Posted.   
     
  3. Purchase Invoice must not be Released.

Step-by-step guide

The steps are as follows:

  1. Go to Ginesys Web > Procurement > Operation > Invoicing > Purchase Invoice.

  2. Purchase Invoice window will open. 

  3. Previously created Purchase Invoice will be listed.

  4. Select the PI you want to delete.

  5. You can use Filter to search particular PI(s).

  6. Go to Acton > Delete


  7. You will get a message - "Document once deleted cannot be retrieved. Do you want to delete this document?"

  8. If you click on Yes, you will get a confirmation message "<Purchase Debit No::> - Successfully deleted".

 Release Purchase Invoice

Prerequisites

  1. The users' role must have access to the Release app operation in the Purchase Invoice feature in Procurement - Operation - Invoicing through Roles in Ginesys Web - Admin - Security.

  2. Purchase Invoice must be created and Un-Posted.     

  3. Purchase Invoice must not be Released.

Step-by-step guide

The steps are as follows:

  1. Go to Ginesys Web > Procurement > Operation > Invoicing > Purchase Invoice.

  2. Purchase Invoice window will open. 

  3. Previously created Purchase Invoice will be listed.

  4. Select the PI you want to release.

  5. You can use Filter to search particular PI(s).

  6. Go to Acton > Release


  7. You will get a message - "Document(s) once released cannot be modified. Do you want to proceed?"

  8. If you click on Yes, you will get a confirmation message "Debit No <Purchase Debit No:> - Released Successfully ".

 Revert Purchase Invoice

Prerequisites

  1. The users' role must have access to the Revert app operation in the Purchase Invoice feature in Procurement - Operation - Invoicing through Roles in Ginesys Web - Admin - Security.

  2. Purchase Invoice must be created and Un-Posted.   
     
  3. Purchase Invoice must not be Released.

Step-by-step guide

The steps are as follows:

  1. Go to Ginesys Web > Procurement > Operation > Invoicing > Purchase Invoice.

  2. Purchase Invoice window will open. 

  3. Previously created Purchase Invoice will be listed.

  4. Select the PI you want to release.

  5. You can use Filter to search particular PI(s).

  6. Go to Acton > Revert


  7. You will get a message - "Finance postings of the selected document(s) will be reverted. Auto DN/CN, if any, will also be deleted. Do you want to proceed?"

  8. If you click on Yes, you will get a confirmation message "Invoice No. <Purchase Debit No:> - Reverted Successfully ".

 Print Purchase Invoice

Prerequisites

  1. The users' role must have access to the Revert app operation in the Purchase Invoice feature in Procurement - Operation - Invoicing through Roles in Ginesys Web - Admin - Security.

  2. Purchase Invoice must be created.

  3. Printer must be connected to the device.

Step-by-step guide

The steps are as follows:

  1. Go to Ginesys Web > Procurement > Operation > Invoicing > Purchase Invoice.

  2. Purchase Invoice window will open. 

  3. Previously created Purchase Invoice will be listed.

  4. Select the PI you want to print.

  5. You can use Filter to search particular PI(s).

  6. Go to Acton > Print


  7. You will get previously created template.

  8. Click on the required template to print.

  9. A new window will open.

  10. Click on the Print to print the Purchase Invoice.

    Note: You can print using Print Preference.


TDS deduction on Services was formerly allowed in Ginesys, now with new statutory changes being put in place through TDS Section 194Q - deduction of TDS on purchase of goods worth more than fifty lakh rupees (₹ 50,00,000) has been enabled. Please note the following major points as encapsulated in the section194Q -

  • Buyer is responsible for the deduction.

  • The deduction is applicable for the purchase of any goods of value INR 50 Lakhs or more in any financial year. Note that the total purchase value of the transactions throughout the year should be INR 50 Lakhs or more for the deduction to be applicable.

  • Deduction is of 0.1 per cent. of such sum exceeding fifty lakh rupees, as income tax.

  • Deduction has to be made at the time of providing the money to the seller through credit of such sum to the account of the seller or at the time of payment thereof by any mode, whichever is earlier.

Earlier, TDS deduction on Services was reflected only in Service Invoice. But from now TDS deduction is also available on Goods, so it will be reflected in Purchase Invoice also. 

Changes in Purchase Invoice
INTRODUCTION OF THE TDS INFORMATION BLOCK

  • A new block name as TDS Information is introduced under General Information in Purchase Invoice

  • The TDS Information block contains four fields as ‘TDS Applicable', ‘TDS Source’, ‘TDS Name’, 'TDS Section’.

  • All the above field values populate on a selection of Vendor Name.

  • TDS Name field displays only non-extinct Goods type of TDS, from vendor master if tagged, otherwise from TDS section definition.

DERIVATION OF TDS RATE

  • TDS Rate gets derived based Vendor Amount i.e. sum of TDS Applicable amount from Purchase Invoice, TDS Journal and TDS Reversal entries, w.r.t. the TDS name.

  • TDS Rate gets fetched from two places - Vendor master and TDS Section definition.

    • If Vendor Amount + TDS Applicable Amount of Invoice <= Maximum Limit specified in Vendor master, then TDS Rate gets fetched from the Vendor master Exception details.

    • Else, gets populated from the TDS Section definition.

  • Example: If Vendor Amount <= Exception Limit 50L, then TDS @ 0%. Else if Vendor Amount > 50L, then TDS @ 0.1%. 
CREATION OF TDS JOURNAL

  • If Purchase Invoice is TDS Applicable then during Release from the list view and edit mode -

    • If TDS entry is not found then creates TDS Journal entry. The TDS Amount gets auto-adjusted with the Invoice Amount.

    • If TDS entry is found then opens prompt to adjust the TDS Amount with the Invoice Amount.

  • Note:

    • TDS Applicable Purchase Invoice cannot be released without adjusting the TDS Journal amount.

REFLECTION IN CHARGE VIEWS

  • Charge Details window opened from the Charge Summary block contains a new field named 'Include in TDS'. This field contains a dropdown list having two values - Yes/No.

    • By default, the value populates from Purchase Term.

    • The field remains editable for change in the Purchase Invoice document.

REFLECTION IN PANEL INFORMATION

  • In ‘Item Summary' section, TDS related information has been added - ‘TDS Applicable Amount’, ‘TDS Charge Amount’, ‘TDS Net Amount’, ‘TDS Rate’, 'TDS Amount’.

REFLECTION IN LIST VIEW

  • New columns have been added to the list view for - 'TDS Applicable', 'TDS Amount', 'TDS Source', 'TDS Name' and 'TDS Section'.