Is there any possibility to access lists available on Vendors Defaults from SDK ?
I just want to get Payment Methods - as I have seen even in example it was hard coded to Master Card and I haven't found any object which could give me acces to that.
Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…
I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.
Hi All,
I am new for ACCPAC .Net APIs, I want to import customer data into Sage 300 using APIs, can anyone help or give me some hint for this?
Or share some sample code and data dictionary, please?
Thanks for your help
hello
i want to access sage 500 database , i am creating an application where we get the data from the client and we are going to run few calculations and implement it on sage 500
thank you
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax:
Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)
But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…
Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
We are upgrading our Sage HRMS from FoxPro to SQL. We have a custom timesheet system that was developed internally and need to update scripts that pull from ABRA. Does anyone know where the old PRALLOC.DBF table maps to in the SQL version? Its not listed…
Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?
Hello!
Our legacy data includes special characters and odd formatting for part numbers that I guess we made up along the way and I want to standardise them.
Is there a way to wholesale change part numbers where, for example:
export part numbers…
Timeslips 2012
When using transport.xfr I get the following error message. I tried a DATA VERIFICATION on both machines and have NO errors. I can exchange clients and professionals but NOT tasks or expenses - tried each separately.
Any help would…
II need to import OE from an external application. Spent many hours trying to create a valid script without success. I am not using serialized or lotted items but the import function keeps looking for them even though System Information does not list…
I'm wanting to add about 600 items to an already existing list of products in our datasbase.
So, I exported 3 lists:
I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…
Hello,
Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory?
Thanks,
Dave
Hello, would like some help/advice.
We uploaded a vendor selling price file into BV and there were about 8000 parts. We later found out we only use 1000 of the parts therefore the system updated 7000 additional parts. Is there an easy way to delete…
Hello,
Everyone has been so helpful in the past, I thought I would ask about another issue I am having.
While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…
We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…