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

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

How to create Goods Receipt in Tagrain?

• Related Articles

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

• 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 Purchase Order in Tagrain

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

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