Hi,
We have barcode scanner where i can scan multiple barcode with Quantity, When i plug in this barcode device i am able to get all scanned items in excel, csv and text format.
What i need is there any way where ENTER SALES screen can directly read from this file(excel,csv, txt),
Barcode should go to Item Number field and Qunatity should go to Ship field.
How can i achieve this?
Thanks
Thanks for your post. You can import sales via the Import and Export Assistant. You will have to fill out more fields to make sure it works. Ideally you would work with an import template. Read more about the mandatory fields and creating a template for importing: Import and export fields.
Thanks for reply but it doenst work because it says Inc-Tax Amount is mandatory field and i dont know what is that for and why do i need it here.
Should the file have {} contained in the first line, such as what AccountRight 2021 will export, will use a set of fields that doesn't require the Inc-GST amount. This set of fields will use the Amount and Tax Amount to add values.
I have tried to import sales myself and it doesn't seem to be a mandatory field. Just like the linked help article had suggested the following fields (marked with asterix-*) are mandatory: Amount and Account No.
Make sure to create a correct import template by exporting data out of AccountRight as described in the help article without removing the {}.
