Search results for query: *

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.

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

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?

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 = ??

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...

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

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...

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 =...

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 =...

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 =...

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...

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?

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...

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...

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.

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

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...