x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 7 replies
  • Answers 2 answers
  • Subscribers 48 subscribers
  • Views 3948 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
Matthew S

ODBC customer ID

SOLVED
Posted By

I am making an ODBC connection from UPS WorldShip to BusinessWorks 2013. I am able to map most of the WorldShip values to BusinessWorks values in the ARInvoice table. I want to link the BW customer ID or number to UPS.

1. Does one of the values in the ARInvoice table map to the BW Customer ID? If so, which one? None looked obvious to us.

2. If not, within WorldShip we can create a link between two foreign tables (Businessworks database tables) and then grab the customer ID from a different BW table. If #1 is a no, what fields would we need to link here?

Matthew

  • 0
    verified answer

    ARInvoices connects to ARCustomer via ARInvoice.FKARCustomer & ARCustomer.SKARCustomer

    Tables for fields can be found here

    na.sage.com/.../resources

    then under Product & Information  --> Tables and Fields

    EDIT 2017

    See KB 19339

  • 0 in reply to Vince Settipane

    That did it. I then linked ARCustomer::ID to the UPS Worldship Customer ID field. I also had to close and reopen UPS Worldship to have it take effect. Thanks!

  • 0 in reply to Vince Settipane
    This link (na.sage.com/.../resources) no longer lists Tables and Fields under Product Information. Does anyone have a current link?
  • 0 in reply to Heather@KauffmanBrands
    If you can't find it. Private message me your email address, I keep on my desktop the file for 2013 & 15 , I haven't located the 2017 file, if there were changes.
  • 0 in reply to Heather@KauffmanBrands
    SUGGESTED
    Heather- We have an article in our Knowledge Base for Tables and Fields. Open the BWGFormats.pdf file in Attachments in the Knowledge Base article #19339 "Where do I find the table and field names?" Note: The file structure has not changed since 2013, so the article does indicate 2013 File Formats.
    Thanks,
    Coleen
  • 0 in reply to Coleen Graber
    Those directions read:

    Resolution
    Go to Sage Businessworks Homepage
    Select Sage BusinessWorks News
    Expand Features sheets
    The sixth item down is the File Formats

    Problem is, I'm not seeing a "New" on the homepage. I think this KB needs updated as file is now under Resources. I was also hoping that the file would contain a relational database map, which it does not.
  • 0 in reply to Heather@KauffmanBrands
    SUGGESTED
    Heather- I am sorry you are having issues access the File Formats document. You can access the File Formats by going to resolution #19339 I mentioned above and opening the .pdf attachement. In that article, if you scroll all the way to the bottom, there is an ATTACHMENTS section. In there is a .pdf file you can open for the file formats (BWGFormats.pdf). The steps in the article show how to get to the file formats within the Sage BusinessWorks program. I tested those steps and they are working successfully for me. To verify you were at the correct Sage Businessworks Home page, in BusinessWorks go to View and make sure "Viewer" is selected. If selected that will dispay the Sage Businessworks Home page in the center of your Sage BusinessWorks screen. You should see "Welcome" , "All About Sage BusinessWorks", etc... Under the All About Sage BusinessWorks, you should see "What's New?", "Community" and then "Sage BusinessWorks News". If you select "Sage BusinessWorks News", that will open you to a Resources screen. In there you will see an optionfor "Features sheets". Hit the plus sign (+) to expand it. Once expended, the 6ths item down is "File Formats". That will open the File Formats document. Note: If you are not on a current version (v2017), your links may not be pointing to the correct location. Let me know if you are still unable to open the File Formats.
    Thanks,
    Coleen

*Community Hub is the new name for Sage City