IMPORT EXCEL SHEET TO RECKON

OZFLEX
OZFLEX Member Posts: 30 Reckoner Reckoner

How easy or hard is it to import an excel sheet to Reckon ?

What rules do you need to be followed (format/column naming etc) ?

Can anyone do the import file ?

I really need to know as I am receiving Supplier price files in excel and without manual entry I would like to format for import

Comments

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 319 Reckon Legend Reckon Legend

    Hi,

    I'm not sure how other people do that, but as a developer, I recently built some similar tools that export/import item lists in batch. This way, you can easily export a list of items, edit the price manually in the excel file and re-import. Or you can have a file from your supplier, then it can be updated back to your Reckon file.

    Let me know if you want to learn more about the custom solution.


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au


  • OZFLEX
    OZFLEX Member Posts: 30 Reckoner Reckoner

    Yes I would love to learn more as we constantly get price updates from suppliers and it is a completely manual process to enter each new price at item level in to Reckon.

    Also would love to be able to populate the bar code field electronically as well as other fields so I suppose one solution fits all

    Appreciated

  • PhuongDo
    PhuongDo Reckon Developer Partner Posts: 319 Reckon Legend Reckon Legend

    Please send me an email. It is phuong@cactussoftware.com.au


    Phuong Do / Reckon Developer Partner

    phuong@cactussoftware.com.au