Mass import shipping addresses

SOLVED

Good day,

Fairly new to Sage, even more so to this community. Tried researching but couldn't find a suitable answer, sorry if this is considered a duplicate.

Q: We signed a new supplier with 437 point of sales. I would like to import the 437 shipping address directly into Sage (Sage 50 Accounting Quantum 2018.4) I can't imagine retyping all of those.  Is there available documentation on hold I could do so?

Thank you for your support,

Jeff 

Parents
  • 0

    Hi ,

    Thanks for reaching out. Did you ever find a resolution to this issue? If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

    Warm Regards,
    Erzsi

  • +1 in reply to Erzsi_I
    verified answer

    Good day,

    I found the tables and was about to upload them via ODBC but I couldn't get past the max 100 shipping address limitation.

    We endedup creating 437 new customers, it's aweful for reporting, A/R reports and what not but we had to invoice asap, couldn't find an answer/solution and could no longer wait.

    If you or anyone has any pointers, options, solutions, ... it would still help as we are about to sign a new drugstore chain with about 310 point of sales.

    Thank you for your time,

    JF

Reply
  • +1 in reply to Erzsi_I
    verified answer

    Good day,

    I found the tables and was about to upload them via ODBC but I couldn't get past the max 100 shipping address limitation.

    We endedup creating 437 new customers, it's aweful for reporting, A/R reports and what not but we had to invoice asap, couldn't find an answer/solution and could no longer wait.

    If you or anyone has any pointers, options, solutions, ... it would still help as we are about to sign a new drugstore chain with about 310 point of sales.

    Thank you for your time,

    JF

Children
No Data