Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : EasyPrint Tool : RPOS7 : Profile Type : PURCHASE

Importing purchase invoice using Excel files

HOW TO IMPORT TO THE PURCHASE IMPORT
1. Select the Add Option In Inv,Import
2. Select the Distributor Name
3.Give Any One ref ID Its Very Important
4.Select the Customer Code Same or Different
5.Map the Purchase (excel or csv) file
6.Select the Excel File and Open That File
7.This is The Correct Format for the Excel File
8.Please Enter Any One Tittle For The Purchase File to Allow the Imports
9.Map The Items in Field Wise
10.After Complete The Mapping Click The Save Button
11.Press Ok to Save the Purchase Invoice Header
12.Select the Purchase Invoice Details and Map the Fields
13.If Map the Fields Are Wrongly,Right Click to Select Clear the Field
14.Once Complete the Mapping Click to Save the Transaction
15. After Complete the Mapping Click to Close the Screen
16. Click Browse to Select the Excel File
17. Open the Excel File to Browse Options
18. Click Import the Purchase Entry in the System
19. Map the Item First Time in Every Distributor
20. Go to Purchase Entry Screen and Select the Key Option and Press Yes to Import the Purchase
21. For Selecting The Purchase Invoice No-Wise is Mandatory
22. Load the Invoice in Purchase Entry Screen
23. Check All Option and Click to Save the Purchase
24. Once Imported the Excel it Will Automatically Deleted,Go to this Place and Check the File

STEPS:

1. Select the Add Option In Inv,Import



2. Select the Distributor Name



3.Give Any One ref ID Its Very Important



4.Select the Customer Code Same or Different



4.Map the Purchase (excel or csv) file



6.Select the Excel File and Open That File



7.This is The Correct Format for the Excel File



8.Please Enter Any One Tittle For The Purchase File to Allow the Imports



9.Map The Items in Field Wise



10.After Complete The Mapping Click The Save Button



11.Press Ok to Save the Purchase Invoice Header



12.Select the Purchase Invoice Details and Map the Fields



13.If Map the Fields Are Wrongly,Right Click to Select Clear the Field



14.Once Complete the Mapping Click to Save the Transaction



15. After Complete the Mapping Click to Close the Screen



16. Click Browse to Select the Excel File



17. Open the Excel File to Browse Options



18. Click Import the Purchase Entry in the System



19. Map the Item First Time in Every Distributor



20. Go to Purchase Entry Screen and Select the Key Option and Press Yes to Import the Purchase



21. For Selecting The Purchase Invoice No-Wise is Mandatory



22. Load the Invoice in Purchase Entry Screen



23. Check All Option and Click to Save the Purchase



24. Once Imported the Excel it Will Automatically Deleted,Go to this Place and Check the File




Thanks to use this Kabase


Thanks,
Ssatheesh.

Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB