How to show only invoices on the payables check stub in GP

Here is a question that is brought up frequently by Dynamics GP users – how do we only show invoices that we are paying with this AP check on our check stub?  By default GP will show you everything applied, including credit memos and even non-check payments made between the current check and the last one.  There are 2 ways to control this – globally for the entire company, or one time for a particular check.  Here are the details (click on the screenshots to see larger/clearer versions):

Globally

Change the Payables Management Setup by going to Tools > Setup > Purchasing > Payables, changing the List Documents on Remittance setting to Invoices Only and unchecking the List Previously Applied Documents on Remittance:

pm-setup

Important note – only checks created after you make these changes will behave how you want because these settings control the behavior at the time of check creation.

One time

When you are creating a check (no matter what method you’re using for creating it) you have the option to Edit Check – choosing this brings you to the Edit Payables Checks window.  You can also get to to this window by going to Transactions > Purchasing > Edit Check.  On the bottom of the Edit Payables Checks window is a Check Stub button:

check

The Check Stub button will bring up the Payables Check Stub Documents window, listing all the items that can be shown on this check stub:

stub

You can deselect anything except invoices that this particular check is paying and only selected items will print on the check stub.  No setting is saved anywhere and only this one check is changed.  This method can be very useful for a quick ‘clean up’ of a check.

Trackbacks/Pingbacks

  1. Show Only Invoices on AP Check Stub - DynamicAccounting.net - December 4, 2008

    [...] Only Invoices on AP Check Stub Victoria Yudin has a nice post up today with information on how to show only invoices on the payables check stub. Victoria tackles this from both a global and a one time perspective with lots of screen shots. [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 486 other followers