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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics Gp 2010 mofif...
Microsoft Dynamics GP (Archived)

Dynamics Gp 2010 mofifying the check stub

(0) ShareShare
ReportReport
Posted on by Andrea Kelley 275

Hello,

I am trying to modify the check stub top and bottom-graphical. First I am looking at the PM tbls PM10300 and PM10801 to see what fields are applied where on the check stub. Am I understanding this correctly that OPEN invoices sit on the PM10801? Or is it only invoices that have been applied to a batch?

Next I want to idetify the columns on the chek stub with the columns on the table. Currently our stubs don't show in the preferred order. Am I going abou this in the correct order?

 

Thank for any assistance you can provide.

Andrea

*This post is locked for comments

I have the same question (0)
  • Bradley Gehrls Profile Picture
    Bradley Gehrls on at

    Hello Andrea,

    Thank you for using Microsoft Online Communities.  I understand that you are trying to modify the stub on top and bottom graphical check in payables.  

    To give you a little background on the process of going through a select checks and what tables get updated and where the system is looking for invoices.

    You are correct when you process a select check the check information is held in the PM10300 table.  The system will look through the PM20000 table to find the open invoices that fits the range that is selected in the select checks window.  Once the payment batch is saved after the invoices have been applied the system will create apply records in the PM10200 and the PM20100(the records in this table are only used for printing on the check stub and are deleted once they have been printed).

    The PM10801 table is a check stub duplicate table and is only populated at the time checks are printed and will clear out once you post the batch.  

    In regards to your question the check portion of the report will come from the PM10300 and the stub portion should be coming from the PM10801 table.  There are calculated fields on the report that that also display different information.  It will depend what fields you are looking on the report that seem to be off.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx

    This posting is provided AS IS with no warranties, and confers no rights

  • Andrea Kelley Profile Picture
    Andrea Kelley 275 on at

    Hi Brad,

    Thank you so much for the response. The info you provided was precisely what I was looking for.  This makes so much sense according to the destination plans.

    I added the Trde DIscount field to the chek stub, which appears correctly but how would I get a total  added to the bottom of the column?

    Thank you,

    Andrea

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans