How to Import Stock item into Delphi System ?
To Import Stock item into Delphi System .
Note : Please Create the Preset code 1st.
Example : I have different Sales GL account for different type of Sales .
If All Sales is combine in one GL account . Preset Code one is enough .
To Import Stock in Delphi Step 1 .
After fill in as Example .
You will need open office to save this excel into a new document .
Please Save as DBase .
Step 1 – Open ‘Open Office ’ Click File > Click Open > Select the excel file .
Step 2 – After open the excel file > Save as Dbase .
Note : Click Keep Current Format .
Note : Click ‘OK’
Check the file .I save at Desktop
Now is time to import Stock item to Delphi.
Click File > Import and export > Import master data from other database.
Click Yes > Backup is important, Backup Before you import.
After Backup below screen will pop out .
Please Select DBase , and Click Browse > Select the folder which you place the document just now .
I save at desktop , so then I browse desktop . does not need to point exactly the document ,
Just click desktop then click ok , system will auto detect DBASE.
From Table select your dbase .
Posting Account is your Preset Code .
If you got only one preset code the select that preset code.
From Field > just select back the same name as your excel File .
Master field is StockCode > From Field will also select StockCode .
Item type then item type
Stock name ,then Stock Name .
Only above 3 item is compulsory .
Other is optional , if you need then have to fill-in excel .
After Finish Click Import .
Full documentation please click VIEW to display in PDF format.