Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Removing invoices with the status WORK

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Need to generate a report of all invoices with WORK status for all vendors.

*This post is locked for comments

  • Suggested answer
    Rick Hollis Profile Picture
    Rick Hollis 495 on at
    RE: Removing invoices with the status WORK

    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.

  • Blue Smart Profile Picture
    Blue Smart 110 on at
    RE: Removing invoices with the status WORK

    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 ?????2018_2D00_02_2D00_23_5F00_231953.jpg_5F00_Work-Sales-_2E00_.-test.jpg

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Removing invoices with the status WORK

    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

  • Blue Smart Profile Picture
    Blue Smart 110 on at
    RE: Removing invoices with the status WORK

    Hi,

    is this feature available in receivable transactions smartlist , for reviewing puposes... i need to export all " work " cash receipts ???

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Removing invoices with the status WORK

    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

  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: Removing invoices with the status WORK

    What have you tried so far?

    I'd start with a SmartList.  Purchasing > Receivings Transactions > * (default)

    Set Posting Status = Unposted

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans