Jump to content

KenM

Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by KenM

  1. UPDATE:

    I SUCCESSFULLY imported from the simple 2 line CSV I had exported from Express Invoice, the Field assignment process works 100%,
    so if we stick to the CSV rules a detailed above then I believe all should work as expected. For foreign data we need to a bit of bulk editing to ensure the data meets the requirements.
    Onwards and upwards...

  2. I have been so far been singularly unsuccessful with Importing CSV data, say customer lists etc.
    Being an engineer I have gone back to simpler analysis skills.
    1: Let's see what format NCH actually creates for a CSV, so I added to customers by hand in NCH Express Invoice, which worked OK, then Exported the list to a CSV file with defaults etc.
    The result I got you can see below:

    "Customer","Contact","FirstName","Address","Shipping Address","Phone","Phone2","Fax","EMail","Notes","Salesperson","Additional Info"
    "Joe Bloggs","Joe Bloggs","Joe","","","011 888 1957","","","kenm@openworldit.co.za","","",""
    "Mary JANE","Mary JANE","Mary","","","011 888 1957","","","kenmurd@gmail.com","","","" 

    I think the key is to ensure the correct format of the CSV, please note the " [ quotes ] around the data fields etc.
    My next step is to confirm this by re-importing from the above 2 line export file.
    If it works then we have a 'Template' showing clearly how our foreign data should be formatted to be handled correctly by Express Invoice.

    As i confirm my suspicions to be true or not I will feedback my results to this topic on this Forum.
    I welcome all comments and shared experiences to be added.
    Otherwise have a great day all.

  3. As a newbie to Express Invoice Plus I would like to ADD a prefix to my Invoice Number, ie: put my short company name into every Invoice number created.
    For example my company shortname is OWIT and my invoice number series starts with 100, so it should appear if I set the prefix to OWIT_ the result should be OWIT_100, or so Id hoped.
    What I need is confirmation this works and some pointers as to where to set it up as the default and get me back on track with implementing the package for my purposes.
    Many thanks in eager anticipation of comments and pointers.

×
×
  • Create New...