Programmatically create order with vba from ms access

SUGGESTED

Anyone have experience with creating orders from an external application that uses VBA?

I would assume there is two methods:

1. using an sdk.

- i once looked into this and you couldn't get access to the sdk without paying for it. which is ridiculous. 

2. doing the process manually.  

- has anyone done this before? If so, you wouldn't happen to have a document explaining all database changes that need to be made? :) 

  • 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

  • 0 in reply to Erzsi_I

    Hi Erzi_I, 

    by all means, please point me to some resources. 

    I ended up just taking my order data and creating a script to format it in the Order.txt format that BV expects for it's builtin import, but as i'm sure you're aware from our last chat, there is a bug i found in your Order import and it's been submitted to your dev team (with no expected date of fix because i was told bugs are prioritized, understandably). 

    I have since tabled this mini-project and have been working on something else but still welcome input because i'll have to come back to this. 

  • 0 in reply to slacka

    Hi 

    Thanks for these details. I've forwarded your comments onto Sage BV support management to see if they have any resources. So far I’m not finding an available Sage BV SDK. The Get started developing for Sage Business Cloud Point right https://developer.sage.com/ Page doesn’t lead to Sage BV resources, as it’s cloud focused. So is the product page here Point right https://www.sage.com/en-gb/products/.

    Will update you with any news. 

    Warm Regards, 
    Erzsi

  • 0

    I have created applications using Clarion from Soft Velocity to interact with BV data, but there is not any documentation that I have found explaining all of the data changes recorded by each process (order entry, a/p, etc) .  There is a document in the bv help files explaining most of the data fields. 

  • 0 in reply to Erzsi_I
    SUGGESTED

    Hi ,

    Update from the team that taking your order data and formatting it in the Order.txt file via your script to do the import is the best way. They also checked with R&D regarding your mention of the order import bug, R&D advised that this is not a bug, that it's working as designed. The Ref no. field imports with the order number of the new order number, then adds a “/”, then with the remaining Ref no to obtain 20 characters.  

    They shared that the Sage BusinessVision API "DLL" may be deployed without a fee, but must be used in conjunction with a licensed Sage BusinessVision system. You must be a current Development Partner in good standing in order to develop using the Sage BusinessVision API. For more information, please contact [email protected].

    Hope this helps!

    Warm Regards, 
    Erzsi

  • 0 in reply to ChrisJohnsen

    Thanks. Yes I've already read the docs.  I've also been doing hack add-ons for like 8 years so i feel like i more than one the docs have. haha. 

  • 0 in reply to Erzsi_I

    Sounds like they need to look at that bug again. I tested it LIVE over chat.  It truncates your data when it's within the storage limit already.