x Want to participate? Join the group to interact

Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion Miscellaneous Payments

State Verified Answer
Replies 7 replies
Subscribers 134 subscribers
Views 3122 views
Users 0 members are here

Browse Forums

268

topics

260

replies

Databases and Operating Systems

758

topics

2k

replies

Financials Suite

1k

topics

3k

replies

General Discussion

2k

topics

10k

replies

Operational Suite

851

topics

2k

replies

Reporting and Analytics

1k

topics

3k

replies

Reports, Macros, and Customizations

876

topics

3k

replies

Sage CRM for Sage 300

182

topics

410

replies

Miscellaneous Payments

SOLVED

Posted By DaneArxis over 8 years ago

Does anyone know of a way to query Miscellaneous Payments only in A/P? I am poking around and can't see a way to do it. Thanks in advance.

0 Ettienne Schwagele over 8 years ago

select * from APPYM where APPYM.SWNONRCVBL = 1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DaneArxis over 8 years ago in reply to Ettienne Schwagele

I'm sorry - I wasn't clear. I didn't mean a SQL query - I meant a way for the end user to look them up. I would know how to query them in SQL. :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 berniel over 8 years ago in reply to DaneArxis

verified answer

Did you try payment inquiry and make the from and to vendor blank
Cancel
Vote Up 0 Vote Down

Sign in to reply

Reject Answer

Cancel
0 DaneArxis over 8 years ago in reply to berniel

AHA! That's it! Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jim Love over 8 years ago in reply to DaneArxis

AP miscellaneous payments may use vendors, in which case they will not show up if you leave the To vendor field blank. And in which case they cannot be listed separately.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DaneArxis over 8 years ago in reply to Jim Love

Right, but in this case the client only wanted to see payments without a vendor. :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 berniel over 8 years ago in reply to DaneArxis

To see all misc. export out all the cheques from payment inquiry to excel and then filter on the misc invoice
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel