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

    how to exclude all pending invoices?

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

    how to exclude all pending invoices?

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

    how to exclude all pending invoices?

    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?
  4. pavelm

    how to exclude all pending invoices?

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

    how to exclude all pending invoices?

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

    how to exclude all pending invoices?

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

    how to exclude all pending invoices?

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

    how to find all unpayed invoices without system check run?

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

    how to find all unpayed invoices without system check run?

    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?
  10. pavelm

    how to find all unpayed invoices without system check run?

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

    how to find all unpayed invoices without system check run?

    yes, sure. Accpac 5.4A Service Pack 2
  12. pavelm

    how to find all unpayed invoices without system check run?

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

    how to add multiple entries to A/P batch?

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

    how to find all unpayed invoices without system check run?

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

    how to add multiple entries to A/P 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...
  16. pavelm

    how to add multiple entries to A/P batch?

    Actually, I'm doing it. Below is the generated macro code, which has no problems. My code uses same idea: generate header, generate details, insert details, insert header - move to the next header... but why it fails on IDINVC assigment? I know it looks stupid and annoying, sorry... Do you...
  17. pavelm

    how to add multiple entries to A/P batch?

    Code below runs perfectly one-by-one - when I run it over single line item in a file, and hangs on IDINVC assignment if I'll group two SAME line items per file (of cause I'm restoring DB backup every time): foreach (HBCheckLineItem lineItem in file.LineItems) {...
  18. pavelm

    how to add multiple entries to A/P batch?

    also, I've noticed, that if I change in my code line ap0021.IDINVC.Value = lineItem.VendorInvoiceNumber; to ap0021.IDINVC.PutWithoutVerification(lineItem.VendorInvoiceNumber); I will have same problems during record insertion on last ap0021.Insert(); command
  19. pavelm

    how to add multiple entries to A/P batch?

    Your code inserts multiple ApInvoiceDetails, but a single AP Invoice Header. I need to insert multiple Invoice Headers... I found, that field IDINVC (which I have problems with) belongs to second composite key: Vendor Number/Document Number: ORIGCOMP, IDVEND, IDINVC - may be it is the reason...
  20. pavelm

    how to add multiple entries to A/P batch?

    Thank you for response, but problem still exists. Task: insert into A/P batch a new batch record, and multiple entries each with a single details record. What I'm doing: usual compositions, than: ap0020.CNTBTCH.PutWithoutVerification(0); ap0020.RecordClear(); ap0020.RecordGenerate(true)...

Part and Inventory Search

Back
Top