web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MC Statement Blank for...
Microsoft Dynamics GP (Archived)

MC Statement Blank form: Adding the invoice due date?

(0) ShareShare
ReportReport
Posted on by l-thomas 1,325

Hello!

Does anybody know the steps to add the invoices due date to the MC Statement blank form in Report Writer please? I've search Customersource for a TK but nothing came up. I also tried a retired KB 914169 but its not possible.

If anybody has found a way, please let me know.

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • l-thomas Profile Picture
    l-thomas 1,325 on at
    Re: MC Statement Blank form: Adding the invoice due date?

    This is what happens when you dont read instructions correctly!!! I got it to work.

    @Rob - there was absolutely nothing wrong with your instructions. I was starting from the wrong place. I was in the Tables section of the actual report and not starting from Tables in Report writer.

    @Tracy - thanks for the update. My lightbulb switched on this morning.

     

  • Tracey Steere Profile Picture
    Tracey Steere on at
    Re: MC Statement Blank form: Adding the invoice due date?

    Hi Louella,

    I was able to replicate Rob's instructions to achive the due date on my Statement. From his step two line, can you tell me which of the three steps were you not able to do? So could you select the table? If so did the Open button stop you or the relationship button?

    The table you would be looking for is past the RMwritteoff table, as his one has an Underscore after the RM.

    Look forward to your reply.

    Regards

    Tracy

  • l-thomas Profile Picture
    l-thomas 1,325 on at
    Re: MC Statement Blank form: Adding the invoice due date?

    Hello again Rob

    I might have forgotten to mention that I'm using GP10 (10.00.1276). I tried your suggestion and cannot eve move past step 2 :-(

    Are these the steps from KB 914169 perhaps? If so I've already tried it and it doesnt work. Can you please have a further look into this? It must be possible.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: MC Statement Blank form: Adding the invoice due date?

    Hi Louella,

    If you follow these steps you should be able to get the due dates to print om the MC Blank Statement. When I tried it on my install the due dates did print:

    1. In Report Writer, click on the Tables Button.

    2. Highlight the RM_Statements_TRX_TMP table and choose Open, then choose Relationships.

    3. Choose New in the Table Relationship window, then choose the RM Open File as the secondary table.

    4. Link by Key 1 to set up a one to one relationship. Insert the RM Statement Short Form into the modified reports list. Choose open and then choose the Tables button in the Report Definition Window.

    Highlight the RM Statements Transactions Temporary File and choose New. Highlight the RM Open File in the Related Tables Window and choose OK. Go into the report layout and pull the Due Date field on to the report.

    5. Exit Report Writer

    6. Grant security to the report using Security Setup (Setup | System | Security | Alternate/Modified Forms and Reports).

    a. Next to ID, choose the appropriate ID.

    b. Next to Products, choose Microsoft Dynamics GP.

    c. Next to Type, choose Reports.

    d. Expand the Sales folder.

    e. Click on the + next to RM Statement User Definable Form.

    f. Activate the radio button next to the modified version of this report.

    Regards

    Rob

  • l-thomas Profile Picture
    l-thomas 1,325 on at
    Re: MC Statement Blank form: Adding the invoice due date?

    Bump.

    Is there any help out there for this requirement please?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans