How to import Stock Opening Balance in Delphi

Before Proceed Solution, we double check Stock Opening Balance Record

Note: No any record.

Step 1 – Prepare a Stock Opening Excel File.

User can get the format from : https://drive.google.com/file/d/1EPzyVVGVyI3CFXuldCd_2HlDIdqdQIN1/view?usp=sharing

After fill in info, open the excel format with Open Office .

Save As dBase .

Step 2 – Click File à Click Utilities à Click Import and Export à import master data from other Database.

Step 3 – after Click Import Master data。

Click ‘Yes’.

Step 4 – After Click Yes à System will prompt below message à you can click ‘No’ , if you already done Backup.

If user not yet backup, please click ‘Yes’, to proceed backup before proceed Import Stock Opening Balance.

Step 5 - After Click No .Below Screen will pop out > Select Dbase .

Step 6 - After Select DBase > Click Browse

Step 7 – Select Stock Opening Tabà From Table : Select StockOP (which is our Dbase Name)

Step 8 –Select the field name, (all below field name are from excel field).

Step 9 – Click Import

Done.

Step 10- Now we check Stock Opening Balance Transaction.

Result: