Programmatically create order with vba from ms access

Question

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? :)

Erzsi_I · Answer

Hi slacka , 
 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 &ldquo;/&rdquo;, 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 dppsupportbv@sage.com . Hope this helps! Warm Regards, Erzsi

Sage BusinessVision

Programmatically create order with vba from ms access

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING