Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DanFuhrmann

    What DB Field can I find the Open AR Amount in?

    I need to Sync down a customers Open AR Amount from a ACCPAC ERP Advantage 5.5 database. Looking at the ARCUST Table I see that there are alot of fields that start with AMTBAL... I believe the value of one of these fields are what I want. Is there any documents that map/describe the tables...
  2. DanFuhrmann

    Updating Order Detail Unit Costing ?

    Thanks! - the problem was the item was not set to User Specific Costing Method. And because of that I could not originally do the macro. I am glad you guys are around to share the knowledge!
  3. DanFuhrmann

    Updating Order Detail Unit Costing ?

    You guys help out alot the other day. Here's another issue that has been causing me greif I am trying to update an Orders Detail lines Unit Costing. It is readonly in the ACCPAC O/E screen so I can use the marco function to figure this one out. (Although that has helped alot!) Im developing...
  4. DanFuhrmann

    Creating Invoice from Order and specificing Invoice Number

    Thanks! That is all helpfull. The macro is a great suggestion.
  5. DanFuhrmann

    Creating Invoice from Order and specificing Invoice Number

    Thanks for the help. Do you know is there a manual for the ACCPAC COM? I am going off some previous code. It looks like it was not necessary to do the shipping step in the past. So I am flying blind. It looked logically from what happened when the first order posted and the shipping record auto...
  6. DanFuhrmann

    Creating Invoice from Order and specificing Invoice Number

    That does stop the error. But now it does not create an invoice. Do I need to somehow generate a shipping record first?
  7. DanFuhrmann

    Creating Invoice from Order and specificing Invoice Number

    I am writing an interface to insert orders and create invoices for ACCPAC Advantage 5.5A. Im using the COM objects. In the past we insert the new order, change the invoice number, and then create the invoice. Here's the code where I find the order, process any order header updats, and create...

Part and Inventory Search

Back
Top