Importing and Exporting Goods Issue in Tagrain

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 listed below:

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

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

  3. Specify the Goods Issue Code. The application will auto-populate the field with the Goods Issue 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 Issue 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 Issue template.

  8. Save the Goods Issue Detail.xls file. 


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



The table below shows the Goods Issue 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. The available values are: VAT and Exempt. 

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 Issue Master Screen. Navigate to the location where your Goods Issue Detail.xls file is saved. Select the file and click OK.  

 


Suggested Readings

Goods Issue

Getting Started With Tagrain

Subscription Management


    • Related Articles

    • 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 ...

    • Performing Goods Issue using Tagrain Handheld

      In this article: We will cover the steps to perform a Goods Issue 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 ...

    • How To Issue Goods Out?

      Goods Issue and Goods Receipt transactions are available in three plugins: Serial and Batch Product Management, Variant and Composite Product Management and Product Purchase Management. Login to the application and navigate to Home > Inventory ...

    • 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 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 ...