Import and Export Goods Issue in Tagrain

Introduction

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.

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 Reading

How to create Goods Issue in Tagrain?

• Related Articles

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

• Import and Export Goods Receipts in Tagrain

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

• Import and Export Products in Tagrain

  Introduction Adding a single Product record in Tagrain is quick and simple. What if you want to add multiple products? Tagrain makes that easy too by allowing you to import Product information using an excel spreadsheet. You can create multiple ...

• Import and Export Gift Card Products in Tagrain

  Introduction Gift Cards products are vouchers that can be exchanged for a specified cash value of goods or services from a particular business. The holder of the card is entitled to receive goods or services, equivalent to the currency value ...

• Import and Export Gift Card Management Information in Tagrain

  Introduction To know the total number of Gift Cards that have been issued in Tagrain, you can use the excel based export template. This allows you to: View the existing Gift Cards, Check the Customer to whom the Gift Card was sold Check Store that ...