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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to find all unpayed invoices without system check run?

Status
Not open for further replies.
pavelm

pavelm

Programmer
Nov 4, 2009
21
UA
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 dialog and it will generate SYSTEM GENERATED payment batch, but it is not what I want - I want to group checks in some other way.

Can I query all posted but non-payed invoices without generation of system batch?
Currently, the only alternative I have - is to generate batch, and than iterate through all of its items - and move them (delete/re-create) to payment batch generated by me.

 
Sort by date Sort by votes
Thanks for prompt response.

Can I do this if I don't have direct access to SQL DB, only Accpac API?
 
Upvote 0 Downvote
Are you comfortable writing macros? What version of Accpac are you running?
 
Upvote 0 Downvote
yes, sure. Accpac 5.4A Service Pack 2
 
Upvote 0 Downvote
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...
 
Upvote 0 Downvote
You can but CS0120 allows you to run SQL statements which allows you to join multiple tables together. Plus you get the benefit of using the server's power vs. the Accpac view's business logic. CS0120 does have some oddities, however, but I like having access to it.
 
Upvote 0 Downvote
I thought it was in 5.4 but apparently not. It's here for 5.5:


There's nothing technically to open until you give it a SQL statement and .Browse using the SQL statement as it is links you to a record set returned by the database.

Go back to your original thought of using AP0025.

Or upgrade. :)
 
Upvote 0 Downvote
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 background-running Windows service.
Have some non-trivial pure Accpac problems, want to continue bothering people... :)
 
Upvote 0 Downvote
There are the Sage Community forums but considering the members who are here you aren't likely to find better help.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vbdbcoder
  • Locked
  • Question
"Ship All" function does not work for 1 customer
Replies
2
Views
368
vbdbcoder
vbdbcoder
ExtraLean
  • Locked
  • Question
ACCPAC VisionPoint 10 - Need workstation installer or another way to put on new machines
Replies
0
Views
294
ExtraLean
ExtraLean
vbdbcoder
  • Locked
  • Question
Is there a good way to complete an order line with qty backordered?
Replies
2
Views
257
vbdbcoder
vbdbcoder
jsh8286
  • Locked
  • Question
Sage 300c V2021 All Reports in system will not run when printing to preview
Replies
3
Views
430
jsh8286
jsh8286
Nway ERP
  • Locked
  • Question
How to Effectively Implement New Construction Management Software?
Replies
0
Views
116
Nway ERP
Nway ERP

Part and Inventory Search

Sponsor

Back
Top