Jimmy,
> Is it too much to ask, you you can be a little more specific to exactly > which table needs to write to?
> and what needs to to the AR table? so i can let the web developers know..
I can give you a quick summary of what you need to do. Beyond that, we'll need to open up a developer support contract as this is beyond the scope of normal Atrex support.
For each order you import, you need to do the following:
1. Create an entry in the ord table. Note that you will need to retrieve the last order number and increment it before doing the insert. Also note that you will need to set the custnum field to match an existing customer entry in the cust table. If the customer does not already exist, you will need to create one and increment the customer number.
2. Create an entry in the oritem table for each item. Make sure that you set the order number that you assigned the order in step 1. You also must ensure that the stock code field is set to an exact match of an item already in the code table. If the item does not exist in the code table, you MUST create it.
3. Increment the code.allocated field for each item quantity on the order.
4. Add an entry in the AR table. Set the transtype to 2 and then set the order number to the number assigned in step 1. Also, if the customer can potentially carry a balance, you will need to retrieve the previous record for the customer and roll the customer balance information (ar.curbal) forward to the new AR record.
The other option is that we can create a custom import routine for you that will handle all of the above. What we would need from your web developers is a web based script (or scripts) that we can call that will do the following functions:
1. Retrieve a list of new orders and return the list in XML.
2. Retreive the contents of a specific order in XML.
3. Set a new order to retrieved so that it will fall off the list retrieved in step 1.
These types of import utilities usually take about 3 to 4 hours of development time ($300 to $400). This can end up saving you a lot of development time on your end since all you have to develop is the extraction of the order information from the web site, and we handle all of the complexity of adding the order, customer, and stock code information on the Atrex side of things.
--
---------------------------------------
Terry Swiers
Millennium Software, LLC
http://www.1000years.com http://www.atrex.com Atrex Inventory Control/POS -
Big business features without spending big business bucks!
Atrex Electronic Support Options:
Atrex Knowledgebase:
http://www.atrex.com/atrexkb.asp Email: mailto:
support@atrex.com Newsgroup:
news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------