Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: Import Journal Voucher JV from Excel - QNE Delphi Firebird

Import Journal Voucher JV from Excel - QNE Delphi Firebird

Article ID: 61270 Email Print
Question
Import Journal Voucher JV from Excel - QNE Delphi Firebird

Answer

[Feb 2 2015 1:04PM] Emily - 2/2/2015 12:38:07 PM, Victor: XLS document must contain either of the following sheetnames: QnE_JV QnE_OR QnE_PV QnE_Bill QnE_Invoice The XLS contains sheetname "QNE_JV20150108HOTEL" and is considered as not valid by the import procedure. Please rename the sheet to "QnE_JV" as per item #3 in the note above: 3) The excel file sheet same is QNE_JV


[Feb 2 2015 9:04AM]  The error msg is "Invalid journal format" and the version is 691. Task assigned to programmer Victor. From Wilkinson.


[Feb 2 2015 8:37AM] Dear Madam, Can i know where you want to import the excel? Journal Voucher? What is the error msg the system prompted? pls attach the print screen of the error msg. Pls make sure your excel file meet the below format requirement : Journal Entries Excel File Format ----------------------------------------------------------- Field Name & Field Type 1) Journal No - Varchar (20) 2) Journal Date - Date (dd/mm/yyyy) 3) A/C Code Description - Varchar (100) 4) Currency Code - Varchar (20) 5) Currency Rate - Double 6) Cancelled - (Y/N) 7) GST Rate - Double 8) Acc Code - Varchar (20) 9) Item Description - Varchar (100) 10) Item Project - Varchar (20) 11) Item Department - Varchar (20) 12) Item Ref No - Varchar (50) 13) Debit - Double 14) Credit - Double 15) Tax Type - (Input GST/Output GST) 16) GST Code - For Input GST (Standard-Rated/Zero-Rated/PTax@TaxCustom/Major Exporter Scheme/NA/PM) - For Output GST (Standard-Rated/Zero-Rated/Exempted/Out-Of-Scope/NA/PM/Sales Tax Taxable) 17) GST Amount - Double ***NOTE*** 1) If the Journal No already exist in QnE database, the whole document will not imported. 2) If the account code not exist in QnE database, the whole document will not imported. 3) The excel file sheet same is QNE_JV 4) Both DR & CR amount cannot empty at the same time. 5) Both DR & CR amount also cannot have a value at the same time. 6) When Start New Document, must have 1 empty row to determine the new document started. 7) Import process will stopped when "ENDING" word (In Column Journal No) is detected.


related articles

Article Details
Views: 2910 Created on: Feb 02, 2015
Date updated: Feb 02, 2015

Poor Outstanding