To re-print Bank Reconciliation Reports

This is how you re-print the Bank reconciliation reports - Reconciled/un-reconciled


GoTo InquiryàFinancialàCheckbook Register
Select the Checkbook

In the Include – Select Unreconciled/Reconciled

Click on redisplay

Then click on the printer icon, this will print the list of unreconciled transactions.

Business Intelligence Training from Microsoft

Bi Training Video from Microsoft. (Enjoy)

http://www.microsoftvirtualacademy.com/training-courses/business-intelligence-in-microsoft-dynamics-gp-2013

GP 2015 New Features - Distribution

GP 2015 New Features - Distribution

Edit email for historical documents - sales and purchases

Now you can edit and re-send email messages that contain sales or purchasing documents that have been sent to customers or vendors. The new option is available from the Sales inquiry Zoom and Purchase Inquiry Zoom windows, if the ability to send documents using e-mail has been enabled for the company you're working in. Similar functionality allows you to re-send statements to customers and remittance documents to vendors.
This feature also enables you to mark multiple documents and send them all through email to an address from the navigation list.
Edit email for historical purchasing documents Similarly, for customer statements, e-mail functionality enables you to embed documents in the body of an email message and send it to customers or prospects from Microsoft Dynamics GP. Now you can edit email addresses and re-send documents that have been send previously. The Edit E-mail button is added to the Sales E-mail Detail Inquiry Zoom window, which opens the Edit Sales E-mail Detail Inquiry window. All the existing email addresses are listed in the scrolling window, and if necessary, you can add new e-mail addresses to the list.

Payment termsAdditional options have been added to the Payment Terms Setup window that provide more flexibility and greater control over how discount dates and transaction due dates are calculated wherever payment terms are used.
A new field, Calculate Date From is added to the Payment Terms Setup window. The field includes the following options:
Transaction Date Calculates the transaction due date from the date the transaction was entered on
Discount Date Uses the calculated discount date to then calculate the transaction due date.
Additional selections are added for the Due and Discount fields, you can set up payment terms that go beyond the next month, extending out a year or more, and even a specified date. With these options, the discount date could be available later than the transaction due date.

GP 2015 New Features - Financials

GP 2015 New Features - Financials

Additional workflow functionality

Workflow in Microsoft Dynamics GP enables you to define approval processes that must be completed before the task or process that's approved can be completed. Each workflow defines how a document "flows" through the system by showing who must approve it, and the conditions under which they must approve it. For Microsoft Dynamics GP 2015, additional workflows have been defined and included in the product by default:
• General Ledger batch approval • Payables batch approval • Vendor approval • Receivables batch approval • Employee skills approval • W4 approval • Project expense report approval

Intercompany enhancements
Information for intercompany transactions is now easier to see and intercompany transaction processing has been changed to provide improve efficiency.
When viewing transactions in the Journal Entry Inquiry window, more complete transaction information is now displayed, including the destination company and the offset accounts that were used.
Intercompany transaction processing has been updated so that if a change is made to a transaction for the originating company, the change is automatically made for all destination companies, as well. For example, if you void an intercompany sale in the originating company, the sale is voided in the destination companies at the same time.

Warning of vendors that have purchase orders
An option has been added to the Payables Management Setup window that displays a warning that open purchase orders exist in the system before the transaction can be saved or posted. The warning displays when entering a payables transaction to help prevent entries in the wrong module.
The option, Warn if Vendor has existing purchase order, has been added to the Payables Management Setup window. If this option is marked, the system will check for open purchase orders for a vendor when you select to save or post that transaction for the same vendor in the Payables Transaction Entry window.


Fixed Assets year-end close report
An optional report is now available when you close a year in Fixed Assets. The assets that are included on the report are categorized by asset book and are listed according to their asset IDs. The report also lists the current fiscal year for each asset book, as well as any adjustments that were made to the assets during the process of closing the year.

Void Intercompany Transactions

In Microsoft Dynamics GP 2015, users will have the ability to void an intercompany journal entry, including entries posted in destination companies, by voiding the original entry in the originating company. This eliminates the need to void an entry in both the originating company, and individually in each destination company as separate steps.

When the user voids the entry in the originating company, intercompany entries are also created automatically in destination companies to void the original intercompany entries.

Payment Terms – Discount Date Calculation

With the changes for the transaction due date, we’ve extended the options for the discount date also in Microsoft Dynamics GP2015.

Now you have the same calculation options for discount date that you do for transaction due date. You choose among calculation options like annual, next month or month/date and being able to add days, months, or years to the calculation gives you greater flexibility when setting up your payment terms.

The ability to calculate an example when you are creating the payment term gives you greater flexibility and quicker verification of the option you want.

Payment Terms – Transaction Calculation

In Microsoft Dynamics GP 2015 you now have greater flexibility to configure payment terms for the transaction due date.

A new selection was added to calculate the transaction due date from the transaction date or from the discount date. Additional calculation options like annual or month/date and being able to add days or months to the calculation gives you greater flexibility when setting up your payment terms.

The ability to calculate an example when you are creating the payment term gives you greater flexibility and quicker verification of the option you want
 

GP 2013 R2 Document Attach 2.0

GP 2013 R2 Document Attach 2.0

Another new feature that is part of the just released GP 2013 R2 is Document Attach 2.0.
There are several areas that have been enhanced with this new feature.

1. Scanning documents and attaching them directly to a master record, document, transaction or line item.

a. Select the record.

b. Click the Attach Management icon. This will open the Document Attachment Management window.

 

 

 

 

 

 

 

 

 

c. Place the document in the scanner.

d. Choose Scan to open the Select Device window. (The Scan button is only available if you are using a Windows Image Acquisition (WIA) scanner.)

e. Selection your scan options.

f. Choose Scan. The document is saved in a JPEG format.

 2.  Document Attachment in Accounts Payable Transactions, flowing from the Vendor Card.

 

 

 

 

 

 

 

 

 

 

This is a Picture attachment of a Logo that is added to a Vendor Card. This could be a Contract, Order or any other document you specify.

It has been marked to flow thru to transactions and to allow sending as an attachment in email.

The Document from the Vendor Card will automatically be added to the invoice.

3. The Doc Attach Functionality will replace the OLE file attachment functionality on notes. The files will be stored in the SQL    databases. This will work on both the Desktop Client and Web Client.

4. The Document Attachment File Utility can be used to delete attachments that are no longer linked to transactions or master records based on a selected date.  (Administration à Utilities à Company à Delete Attachment Files)

Here are the Audit Trail Codes For Financial Module in GP

You can find the Audit Trail codes that are associated with the transactions for each module by going to the path below. The one that I have below is for Financials, if you would like to see it for other modules then just select a different module from the combo box and there you are.

Microsoft Dynamics GPàToolsàSetupàPostingàAudit Trail Codes.

 

SQL Script to change decimal places of Item Currency

This script changes decimal places of currency effective for an item. It must update the DECPLCUR column of 2 gp dynamics inventory table, IV00101 and IV00105 to complete the desired results.

To set to 2 decimal places, specify a value of "3" for DECPLCUR. For 3 decimal places use "4".. and so on..

UPDATE IV00105 SET DECPLCUR = 3

WHERE ITEMNMBR = 'XXX'

GO

UPDATE IV00101 SET DECPLCUR = 3

WHERE ITEMNMBR = 'XXX'