MS Dynamics GP AP check how to pay a partial amount?

Sometimes you want to pay a partial amount for a check without doing a scheduled payment.

Once you have selected checks to pay click on the Edit Check Batch button.

If you have selected multiple checks click on Edit Check Batch, or if you have just one check selected you can click Edit Check.  For this example we will click Edit Check Batch.

In the left pane click on the vendor, in this example WESTJUNC0001.  When the right pane is then populated with the details for that vendor, click Edit Check at the bottom of the screen. The Edit Payable Checks window is displayed and populated with the vendor and check information.  Click Apply on this window.

The Apply Payables Document window is then displayed.  To make a partial payment amount click on one of the Apply to Document lines, click in the Apply Amount field.  That is the only field that can be changed.  In this example I type over the $672.56 and change the amount to $100.00.  The Amount Remaining for that line changes from zero to $572.60, and the Apply Amount field is now $100, and the total check amount is now $418.33.  Click OK.

Then click Save on the Edit Payables Checks window, then close the window.

You can now move proceed forward and Print Checks.

 

MS Dynamics GP 2010 new features in Payables.

The Select Checks screen has been modified to present a more standard GP look for selecting and inserting ranges.  You can insert ranges for Vendor ID, Vendor Name, Class ID, Payment Priority, Voucher Number, Document Number, and Discount Date/Due Date.

Click Build Batch.  Then you can select insert a range again and click Add To Batch.  Continue adding to the batch, then click Edit Check Batch to review.

You can also exclude inactive vendors in lookups.  Click the lookup, then right click in the middle section of the lookup screen, select Exclude Inactive Vendors.  To make this the default anywhere this lookup is used click on Set as Default View.

There is a new option to exclude vouchers in the select checks process with expired discounts.  This comes in handy were pay runs need to be done to meet a discount date.  You can set the option in payables setup.

Once set, in the Select Checks process if the Discount Date/Due Date range is selected, vouchers with expired discounts would not be included as in the example below.

 

 

 

MS Dyamics GP Safe Pay – positive pay banking

MS Dynamics GP Safe Pay module provides the capability you need to transmit a positive pay file to your bank.  What is Safe Pay or Positive Pay?

Positive Pay is a fraud detection program provided by your bank.  Your accounting software will provide a file to the bank that includes check number, account number, issue date, and amount.  This list is compared electronically to the check when it is presented to the bank for payment.  These fields must match exactly or the check will not be paid and and an exception notification will be sent to you and you would instruct the bank to either pay or return the check.

In MS Dynamics GP accounts payable checks, payroll checks, and EFT transactions can be included in Safe Pay transactions that are uploaded to the bank.  Payroll Direct Deposit transactions are not included in Safe Pay transactions since payments submitted via ACH files are not subject to the check clearing mechanisms at the bank.

MS Dynamics GP open payables amount remaing zero and shows payment applied.

This is a variation on the problem where payables transactions show as open in inquiry but the amount remaining is zero.  Also, the Aged Payables report may show payments applied that are voided.

These scripts should help you identify the trnsactions and correct or delete them. Of course you should always do a full backup of your database company file before making any changes.

First the current transaction amount in the payables open file is probably zero so identify and correct it.
select * from PM20000 where VENDORID = ‘AMEX-21006′
update PM20000 set CURTRXAM = DOCAMNT where VENDORID = ‘AMEX-21006′ and CURTRXAM = ’0.00000′

There are probably stranded records in the apply to open open file.
SELECT * FROM PM20100 where VENDORID = ‘AMEX-21006′
delete PM20100 where VENDORID = ‘AMEX-21006′ and VCHRNMBR = ’00094327′

Stranded payment apply to records in the apply to work open file may need to be removed.
select * from PM10200 where VENDORID = ‘AMEX-21006′ and VCHRNMBR = ’00094327′
delete PM10200 where VENDORID = ‘AMEX-21006′ and VCHRNMBR = ’00094327′

 

MS Dynamics GP how to delete Payables temp files.

There may be several problems that come up were you need to delete and create the MS Dynamics GP AP temp tables. If you print AP checks and get strange invoices printing on the check stub or duplicates on the check stub you may need to clear out these files.

The temp tables are:

PM10600 PM Distrbution Void Work Temporary file

PM10900 Void Payment Work Temporary File

PM10901 PM Void Transaction WORK Temporary FIle

PM10902 PM Tax Void WORK Temporary File

You should create a full backup of the company file in SQL Server Management Stuidio.

Delete or rename the files.  You must also recreate these files yourself.  MS Dynamics will not recreate these temp files for you if you delete them.

One easy way to do this is go to Maintenance – SQL, select the Company, leave the Product on MS Dynamics GP.  Select the file name in the list that I gave you above.  Click on Drop Table and Create Table, then click Process.  Complete this process for each table in the list above.  You can also hold down the Ctrl key and select multiple table names.

It’s best to be logged when as sa when completing these operations.  You may also need to set permissions to the newly created database files.  To do this go into SQL Server Management Studio, click the + by databases, click the + by tables, right click on the database file for example PM10600, right click and select Properties, click on Permissions, browse to find Dyngrp and click the check box, on Grant click Insert, Update, Delete, and Select, then click OK.

 

Key segment not found and unable to register table GL_Acct_Mstr

This error was encountered after printing a batch of AP checks and during the post operation.  The checks printed fine. However the posting report was lost.  GL seems to have been updated correctly.

I’ve written extensively about the problems with reports dictionaries. It is one of the weak links in GP.  Anyone who tells you to have one shared reports dictionary is not doing you any favors.  Therefore, have multiple copies and backups of your reports dictionaries.

First, delete or rename the reports dictionary.  Launch GP, then import your package file to recreate the reports dictionary.  See post http://evarsys.com/dynamicsgp/?p=253

Second, rebuild the GL account index file.  Below are the complete steps taken from the MS Techknowledge article 855963.  As always make sure to backup your company database in Enterprise Manager or SQL Management Studio.

1. Have all users exit Microsoft Dynamics GP.

2. Delete the contents of the Account Index Master table.

a. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

Method 1: For SQL Server Desktop Engine

If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

Method 2: For SQL Server 2000

If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

Method 3: For SQL Server 2005

If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Method 4: For SQL Server 2008

If you are using SQL Server 2008, start SQL Management Studio. to do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.

b. Run the following statement against the company database:

Delete GL00105

3. Start Microsoft Dynamics GP.

4. Follow the appropiriate step:

In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Maintenance, and then click Check Links.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, on theFile menu, point to Maintenance, and then click Check Links.

5. In the Series list, click Financial.

6. In the Logical Tables list, click Account Master.

7. Click Insert, and then click OK. When you are prompted, click to select the Screen check box to generate the error log report to the screen, and then click OK. After the check links process is complete, a report is generated.

MS Dynamics GP Accounts Payable check batch in printing status.

You have processed checks. You have the checks in hand.  However the process was interrupted and now the status of the check batch says printing.

Click on the MS Dynamics GP button.  Go to Tools – Routines – Batch Recovery.  If the batch is listed there mark the batch and click process or continue.

I have found it helpful at this point to do two things.  One, do a complete backup of the company database, especially if you have a large check batch.  Two, check links the Purchasing Transaction Logical file in Maintenance – Check Links – Purchasing series.

At this point you should be able the Post the checks.  Go to Transactions – Purchasing – Post Checks.  Select the batch, then click Process. If you have not printed the remittance advice report you will be prompted to print it.  This is required.  Make sure to change the selection to Remittance Form and off Remittance Alignment Form.  Once you have printed the remittance click Post, and then Process.

Here it the MS Techknowledge article ID 855595 which could be helpful.

SYMPTOMS

If you click Process Later in the Post Payables Checks window for a computer check, and then you print the check, you receive the following status message: 

Check Printing

You continue to receive this message even after you try the busy batch procedures.

For more information about the busy batch procedures, click the following article number to view the article in the Microsoft Knowledge Base:

850289 A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP

MORE INFORMATION

The Check Printing status persists for the computer check batch until you actually post the batch. 

You can select the batch in the Post Payables Checks window. To do this, click Transactions, click Purchasing, and then click Post Checks.

You cannot select the batch in the Batches window. If you try to do this, you receive the following warning message:

You cannot edit the batch or transactions in the batch. Use Post Payable Checks window to continue processing.

 

How to print 1099 in MS Dynamics GP

1)      Complete all voucher entry and check payments for the year. 

2)      Run a Smart List vendor report for 1099 vendors and check for any missing information such as address information, tax id, or 1099 type.

 MS Dynamics GP prints Dividend, Interest, and Miscellaneous type 1099’s. 

Once you select the tax type you must select the box for printing.  If you have many different tax types and dividend form types that you will print you can segment your vendors as below for easier printing.  If your needs are simple you can probably get by with the three basic types.  You can print all your Miscellaneous type 1099s then load your 1099 Interest forms, then 1099 Dividend forms.  Each form type would be printed separately. 

If you are confused on the form type and box please seek advice from your accountant or tax advisor. 

There are several ways to segment your vendors for easier 1099 printing.  I like to use classes; however there are several ways you can do this in MS Dynamics GP.

 For example, I might have a vendor class called Dividend, and a class called Misc.  All vendors that receive dividend checks will be in the Dividend class, and all vendors that receive miscellaneous 1099 payments will be in the Misc class.

 You could also use user the defined field one under Options to segment your vendors.

 When you print 1099s at the end of the year you can select to print by a vendor range, a class range, or by user defined one. 

3)      You can verify reported 1099 payments amounts by printing a Smart List or printing the 1099s to blank paper.  You should verify addresses, tax ids, box number, and payment amount. 

4)      If you need to modify the reported payment amount go to Cards – Purchasing – Summary. Select the vendor.  Click on Period.  Enter the correct calendar year for which you are making adjustments.  In Month/Period enter the period you want to adjust.  You should see a blue arrow by 1099 amount.  If you don’t it means your vendor is not setup as a 1099 vendor. You would need to correct that situation in the vendor card and then continue.

 Once you click on the blue arrow enter the 1099 corrected amount in the appropriate boxes.  Amounts are accumulated back to the total 1099 amount.  For example, if we enter $100 in rent and $100 in Other Income the total amount for the 1099 Miscellaneous for the period will be $200. 

All amounts or adjustments you enter to the periods are cumulative.  So at the end of this process if you click Yearly, enter the year, and click Calculate you will see the total 1099 accumulation for  the year.

 If you want to enter one total only in say period 12, make sure to enter zero for each previous period that has 1099 amounts or your yearly accumulation will be way off.

 5)      Once you have made all corrections you can print 1099s.

Go to Tools – Routines – Purchasing – Print 1099

Verify company Address, Federal ID number, type of 1099 you are printing, year, and select the proper form type such as Single Feed for Laser 1099s.

The laser 1099 prints two 1099’s per page.  Typically you will print a 4 part 1099 so you will print four runs.

If all your vendors are 1099 Miscellaneous you can leave Vendor ID range on all and just click Print.  You can also choose the sort order.

If however you have segmented your vendors by 1099 class or user defined one you need to click the drop down and select the class range from and to, for example Dividend from the example above.  You would make sure you have the Dividend 1099 form loaded in the printer.

Send the output to the screen.  Click Print, but don’t close the screen.  This way you can print all four copies without repeating the entire process.

6)      Once you have printed all of one type of 1099 you can then change to your next 1099 type and repeat the above instructions.

Previously posted AP checks print on the Check Posting Register in GP

Previously posted and printed Accounts Payable checks continue to print on the check posting register.

Records are hung in one or both of the work file PM10300 and PM10400.  Run a delete query on the files or delete the specifice records from the files.

From the MS Techknowledge on the subject:

Resolution

Those checks seem to be stuck in a Payables Management work table. Follow the steps below to clear out the PM Payment Work (PM10300) and the PM Manual Payment WORK file (PM10400) tables.

Pervasive SQL or ctree database:

1. Make a backup and have everyone out of the system.

2. Post all manual check batches and computer check batches.

3. Rename the PM10300.* and the PM10400.* files. These are found in the Purchase folder in the Company (whatever your company’s name is) folder in the Dynamics data folder on the server.

4. Run Check Links on the Payables Transaction Logical File. Go to File-Maintenance-Check Links, choose Purchasing for the Series, highlight Payables Transaction Logical File, click on Insert, and then click on OK. (This will recreate the PM10300.* and PM10400.* tables.)

Microsoft SQL database:

1. Make a backup and have everyone out of the system.
2. Post all manual check batches and computer check batches.
3. Using Query Analyzer, run the following SQL statements against the company database:

delete PM10300
delete PM10400

4. Run Check Links on the Payables Transaction Logical File. Go to File-Maintenance-Check Links, choose Purchasing for the Series, highlight Payables Transaction Logical File, click on Insert, and then click on OK. (This will repopulate any necessary information in the PM10300 and PM10400 tables.)

Accounts Payable Invoice stuck in open file or fully applied payments stuck in open file.

This is a hard one to find information on. Not much in MS Techknowledge database.

In this case ap vouchers are posted, the ap check has been printed and posted.  However, the Inquiry – Purchasing – Transaction by Vendor screen still shows the invoices as open.  Drilling down into the Document shows the payment as being fully applied.  The Unapplied amount on the Invoice is zero, and the payment shows the Applied amount being equal to the Original amount. So everything looks good.  However the transaction don’t move to the history file.

This is the rule of thumb when working on problems with the open file or history file.  Anytime you have a problem like this or with unexplained problems with the AP Aged Trial Balance or Historical Aged Trial Balance always check for records in the PM20100 and PM20200 files.  These are the temporary or junk files that MS throws everything into when posting problems or other problems occur.

In this case I had records in the PM20100 file relating to a check for which the remittance advice had not been printed.  Normally you would not be able to continue posting the check batch unless the remittance advice is printed. In this case all batches were fully posted.

In SQL Management Studio or SQL Enterprise Manager make a backup of you company database.  It is also a good thing to make a separate copy of the PM20100 or PM20200 file in case sometimes you need to reinsert these records into one of the history tables.

Run the following query against your company database.  Delete PM20100.

Launch MS Dynamics, go to Maintenance – Check Links – series Purchasing.  Insert the Payables History Logical Files and the Payables Transaction Logical Files. Click OK.

The check links process moves the voucher and payment to the history files.

The Inquiry screen and Aged Trial Balance report should now be correct.