Recent content by pavelm

thank you very much, everything works, rocks and just perfect. appreciate your help. Thank you.

strange, but why it affects all others? I actually don't need them... Thanks for incredibly useful help... Just to clarify: Order selects the index to use? So, if view has many indexes, it can be order=2, order=3 and so on, depending on my search criteria? And one more question - what is...

by the way, I'm using C# and there every Accpac view has a function Browse(string search_criteria, bool ascending); I always use Browse (something, false) and thought it's same that setting Order=1. I was not right?

it seems, that it works much faster also if I made those ap0031-32-33 compositions... How it could be? thank you, tuba, trying it right now

also, note: ap0033 has no compositions with 0032, 0031, etc. - because I'm not doing any modifications - just querying and checking if record exists.

Hello again, I've got serious perfomance problem. I run two nested cycles: first over AP0025 (APOBL) view with SWPAID = 0 criteria. Second cycle is nested - for all unpayed invoices I'm trying to find if they are already created but not posted: cycling over AP0033 (APTCP) with criteria...

Hello everyone, some time ago I asked how to find all unpayed invoices without system check run on Accpac 5.4 (means, CS0120 view and SQL queries are not yet available). tuba2007 gives me a perfect hint - I need to run query SELECT * FROM APOBL WHERE SWPAID = 0 using AP0025-APOBL view. That's...

Thank you for prompt and informative responses! It really helps. By the way, do you know any other good sites with Accpac programmers? I found tek-tips is the best so far, but who knows... I have a relatively small project which integrates Accpac with some other home-made system using...

Djang, are you sure CS0120 exist in Accpac 5.4A Serv.Pack 2? I can't open it. Also, I looked at Accpac Object Model here: http://support.accpac.com/TechSupport/AOM/Advantage.ASP and can't find it. May be it was introduced only in 5.5?

Thank you for great hint - I never heard about CS0120. By the way, can I use directly AP0025 view (which corresponds to APOBL table)? It looks like a simpler solution...

yes, sure. Accpac 5.4A Service Pack 2

Thanks for prompt response. Can I do this if I don't have direct access to SQL DB, only Accpac API?

Code below runs successfully on C#, it's almost direct translation from VB script. Strange, but it doesn't work if I'm using my lib with view names/fields shortcuts, which seems to work well before... May be bug is there. Thank you, tuba, I'll try to find it myself. using System; using...

I have some posted A/P invoices, which is not payed. I need to generate A/P payment batches in a special manner, so they correspond to invoice batches, with a special names, entry description etc. To do so I need to find all posted but non-payed invoices. I can execute Create Payment Batch...

Looks, like there is an error somewhere in Accpac C#.NET library or so... in any case cleaned-up VB script works without any problems from Accpac, while absolutely same C# code have problems with IDINVC assignment...