Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Removing invoices with the status WORK

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans