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!

Register Log in
  • Congratulations Chriss Miller 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. pellj001

    AccPac Drilldown

    Thanks, but it is not the way I intended. I need a way to drill-down using the tables/queries in AccPac. I need to know what fields must be used or linked to get such a drill-down.
  2. pellj001

    AccPac Drilldown

    How do you drill down from the GLPost table to the AR or AP entry? I am interested in drilling down receipts and payments only. thanks
  3. pellj001

    Auto Upload Of Invoices

    Thanks DjangMan that would have also solved my original problem, as I believe using view CS0120 uses the AccPac active session. I have version 5.5. The macro creates by ACCPAC generates several entries like: temp = ARRECMAC3batch.Exists Can these be safely removed?
  4. pellj001

    Auto Upload Of Invoices

    I am trying to do the same for the receipts. It is working but it is slow. I am searching by the IDRMIT and IDCUST. Is there any trick to do this more fast like .Order = ??
  5. pellj001

    Auto Upload Of Invoices

    Ok now it's working. I found out what the problem was. Actually there is a process which when uploaded replaces the invoice number and stories it in the PO Number. The actual invoice number is the one generated by AccPac which I cannot determine during the upload routine. Anyway, thanks...
  6. pellj001

    Auto Upload Of Invoices

    Yes, of course they exist. I am uploading it using the macro, and then upload it again, but still no luck. Also, it is taking a lot of time (minutes) to fetch. Thanks again for all your help Joseph
  7. pellj001

    Auto Upload Of Invoices

    I have tried both but still no luck. I think I am missing something but cant figure out. This is the full function which returns the true/false result. Maybe please, you can spot a flaw. //////////// Function CheckUploaded(Customer As String, InvoiceNo As String) As Boolean Dim...
  8. pellj001

    Auto Upload Of Invoices

    Oh sorry for that because I am trying to do both invoice and receipts. I have the same problem for both. However, this is the check for the invoicing i am trying to make. //////////// ARINVOICE3header.Browse "((IDINVC = '123456') AND (IDCUST = 'MYCUSTOMER'))", True temp =...
  9. pellj001

    Auto Upload Of Invoices

    Thanks again. I have modified as suggested as follows but this still always returns false. //////////////// ARRECMAC3header.Browse "((IDRMIT = " & ReceiptHeader.Fields("IDRMIT").Value & ") AND (IDCUST = " & ReceiptHeader.Fields("IDCUST").Value & "))", 0 temp =...
  10. pellj001

    Auto Upload Of Invoices

    Thanks for your reply. I am trying to do this as suggested but cannot get it to work. ////////// Dim ARINVOICE3header As AccpacCOMAPI.AccpacView Dim ARINVOICE3headerFields As AccpacCOMAPI.AccpacViewFields mDBLinkCmpRW.OpenView "AR0032", ARINVOICE3header Set ARINVOICE3headerFields =...
  11. pellj001

    Auto Upload Of Invoices

    I have created a vb script file to automatically upload invoices to AccPac. I am trying to insert a procedure that checks whether this invoices has already been uploaded. This is the code: /////////////// Function CheckUploaded(ZRBRValue As String) As Boolean Dim AccPacCon As New...
  12. pellj001

    Invoice Import Routine

    Yes, it's very possible, I (and lots of others on this forum) do it for a living" Do you do this for your own company or you do it for other companies as we would be interested in contracting someone to develop this for us?
  13. pellj001

    Invoice Import Routine

    I am sorry but I do not understand. So I go in ACCPAC desktop, select macro, start recording, go in the invoicing module, import my xml file and stop recording. This creates an invoice batch depending on the import files (in my test case it is one invoice line value 100). It will then open...
  14. pellj001

    Invoice Import Routine

    Thanks but this still does not solve the problem, since I would still need to create the AVB manually using Visual Basic Editor. As I am seeing it, the AVB files cannot be created or edited using a normal text editor, since when created using visual basic editor, will contain garbage data in...
  15. pellj001

    Invoice Import Routine

    Thanks again. But I need to automate the task of import without manual intervention. I thought may be there is a way to execute the avb code using a command line compiler or an application which accecpts the avb code as a parameter.
  16. pellj001

    Invoice Import Routine

    Thanks for the quick reply. is there an alternative though to what i am trying to achieve?
  17. pellj001

    Invoice Import Routine

    I have a routine which generates xml and dbf files. These are manually imported in ACCPAC 5.5A. I would like to automate this process. I have tried using Macros in ACCPAC and the idea was to record a macro while inputting an invoice. From my application I would then generate the same code...

Part and Inventory Search

Back
Top