Need to generate a report of all invoices with WORK status for all vendors.
*This post is locked for comments
If I understand correctly you are looking for Unposted Cash Receipts correct? If so, and you have access to SQL, you can run the following SQL query.
Select * from RM10201
If you have Smartlist Builder or Smartlist Designer, you can also add this into a Smartlist to then export to Excel.
Hi Mr.Mariano
first thanks for your prompt reply .,, but after i applied what you mentioned .,, i didn't get what i need ,, i don't know where's problem is .. i attached screen shot showing cash receipts after saved ( as work transcationn) but on smarlist i didn't find it ?????
Yes, this is also available for the Receivables Transactions smartlist:
1. Open the Receivables Transactions smartlist
2. Click on Columns
3. Click on the Add button
4. Locate and highlight the Document Status column
5. Click OK to close the Columns window
6. Click OK to close the Change Column Display window
7. Click the Search button on the SmartList toolbar
8. Pick the Document Status column
9. Select Unposted
10. Click Search
Hi,
is this feature available in receivable transactions smartlist , for reviewing puposes... i need to export all " work " cash receipts ???
Hi,
Go to your Payables Transactions SmartList, add the column Document Status. Documents with a status of Unposted are in the WORK table. If you want to delete them, I'd put them all in the same batch and then delete the batch.
Kind regards,
Leslie
What have you tried so far?
I'd start with a SmartList. Purchasing > Receivings Transactions > * (default)
Set Posting Status = Unposted
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156