Importing and Exporting Goods Receipt in Tagrain

Importing and Exporting Goods Receipt in Tagrain

Managing Inventory Transactions in Tagrain is quick and simple. Tagrain allows users to upload Goods Receipt data using Excel based import template. 


Steps to Import Goods Receipt Data

The steps to import Goods Receipt Data using the excel template are listed below:

  1. Open the Tagrain Web application. Navigate to: Home > Inventory Transactions > Goods Receipt. 

  2. Select a Store by clicking on the […] button.

  3. Specify the Goods Receipt Number. The application will auto-populate the field with the Goods Receipt Number pre-defined in the application. This custom code is based on the Document Number Series defined under: Setup > Store Management > Stores.  There is, however, an option to specify a Goods Receipt Number of your choice. 

  4. Pick a date by clicking on the Calendar icon.

  5. Select a Business Partner Type from the drop-down. The available values are: Customer and Vendor

  6. Select a Customer or a Vendor by clicking on the […] button. 

  7. Click on the “Download Template” button to download the Goods Receipt template.

  8. Save the Goods Receipt Detail.xls file. 



  1. The template has tooltips to assist you in filling up the sheet 



The table below shows the Good Receipt Detail.xls file headers that are available to manage the Good Receipt data.

Field

Description/Activity

Product

This field is used to specify the Product Code. 

Quantity

This field is used to specify the Product Quantity. 

Price

This field is used to specify the Price applicable on the Product. 

Tax Code

This field is used to specify the Tax Code applicable on the Product. Tax codes are defined in Setup>Tax Setting. Use the Tax Code that is applicable to the product being defined.

Discount Type

This field is used to specify the Discount Type applicable on the Product. The available values are: 1-For Amount and 2-For Percentage. 

Discount Amount

This field is used to specify the Discount (Amount) applicable on the Product. 

Discount Percentage

This field is used to specify if the Discount (Percentage) applicable on the Product.

Comments

This field is used to specify if the Comments for the Goods Receipt, if any. 


Once the template is properly filled, click the import button on the Goods Receipt Master Screen. Navigate to the location where your Goods Receipt Detail.xls file is saved. Select the file and click OK.  



Suggested Readings

Goods Receipt

Getting Started With Tagrain

Subscription Management


    • Related Articles

    • Importing and Exporting Goods Issue in Tagrain

      Managing Inventory Transactions in Tagrain is quick and simple. Tagrain allows users to upload Goods Issue data using Excel based import templates. Steps to Import Goods Issue Data The steps to import Goods Issue Data using the excel template are ...

    • Importing and Exporting Purchase Order in Tagrain

      Managing Inventory Transactions in Tagrain is quick and simple. Tagrain allows you to upload Purchase Order data using Excel based import templates. Steps to Import Purchase Order Data The steps to import Goods Receipt Data using the excel template ...

    • Importing and Exporting Batch Controlled Products in Tagrain

      Serial and Batch products can be created by activating the "Serial and Batch Product Management" plugin. Introduction Batch controlled products are those products which have a shelf life. For example, all pharmaceutical and food & beverage products ...

    • Performing Goods Receipt using Tagrain Handheld

      In this article: We will cover the steps to perform a Goods Receipt back office transaction using the Mobile App for Inventory Management Plugin. The images used in this article have been created on a device running Android, the application is also ...

    • Importing and Exporting Variant Products in Tagrain

      To be able to Import and Export Variant products in Tagrain, you must subscribe to and activate the Variant and Composite Products Management plugin. Introduction Variant products are those products that have an attribute, or a set of attributes ...