Convergence 2007 - Copenhagen (Must attend)

Agenda

Partner Day is Monday, 22 October and is for partners only. If you are a partner, click here for more information regarding the agenda, marketing materials and more!
(this link will open a new window and direct you to PartnerSource)

Tuesday 23 October 07:30 Registration open 09:00 – 10:30 Keynote: Jeff Raikes 10:30 – 16:30 Expo 11:00 – 12:00 General Sessions 12:00 – 13:30 Lunch 13:30 – 14:30 General Sessions 15:00 – 16:00 Breakout Sessions / Chalk & Talk 16:30 – 17:30 Breakout Sessions / Chalk & Talk 17:30 – 20:00 Expo Reception	Wednesday 24 October 07:30 Registration open 08:30 – 10:00 Keynote: Kirill Tatarinov 10:00 – 16:00 Expo 10:30 – 11:30 Breakout Sessions / Chalk & Talk 12:00 – 13:00 Breakout Sessions / Chalk & Talk 13:00 – 14:30 Lunch 14:30 – 15:30 Breakout Sessions / Chalk & Talk 16:00 – 17:00 Breakout Sessions / Chalk & Talk 17:30 – 18:30 Breakout Sessions / Chalk & Talk	Thursday 25 October 08:00 Registration open 09:00 – 10:00 Breakout Sessions / Chalk & Talk 10:30 – 15:00 Expo 11:00 – 12:30 Breakout Sessions / Chalk & Talk 12:30 – 14:00 Breakout Sessions / Chalk & Talk 13:30 – 15:00 Lunch 15:00 – 16:30 Breakout Sessions / Chalk & Talk 16:30 – 18:00 Breakout Sessions / Chalk & Talk

How to configure Business Alert for Dynamics GP (GL Module)

Hi Zeeshan,

Please follow these steps to create the business alert

1- Create New Business Alert

2- Use these tables in "select tables" window

GL00100

GL10001

3- Provide this relationship in "Joining Table" window

GL00100.ACTINDEX= GL10001.ACTINDEX

4- Define this alert formula in "Business Alert Formula" window

GL00100 ( GL00100_T2.ACTNUMBR_1 = 100 OR GL00100_T2.ACTNUMBR_1 =

200 ) AND ( GL00100_T2.ACTNUMBR_3 = 01 OR GL00100_T2.ACTNUMBR_3 =

02 ) AND

(GL10001_T1.DEBITAMT >= 50000 OR GL10001_T1.CRDTAMNT >= 50000)

5- You have done. Next you can setup the alert notification.

Best Regards,

Waqas Butt

Microsoft Business Solutions Consultant

Mbl: +97150 1606879

-----Original Message-----

From: Zeeshan_butt via ms-greatplains-l

[mailto:ms-greatplains-l@groups.ittoolbox.com]

Sent: Tuesday, September 25, 2007 4:36 PM

To: Waqas_Butt

Subject: [ms-greatplains-l] Business Alert

Hi All:

I am trying to create a Business alert in GP. Give me an alert If GL Open

Transaction amount posted >50000 for an account which have got segment 1 =

100 or 200 and segment 3 = 01 or 02 and segment 2 = any

I will be thankful for your help in this.

Zeeshan

Receivables Analysis in Excel

 

One Report Showing:

1. Location

2. Company

3. Aging

4. Figures in One.

FA

Microsoft Dynamics GP - Analysis Cubes for Excel

How to configure;

 

1. Install Analysis Cube for Excel Library

go to Tools>Analysis Cubes>Create PivotTable Reports

Please add required fields

Click Save

Click Excel

Wait for few minutes, depending upon the data size it might take a little longer Your results are displayed in Excel.

please write feedback to farhan.ahmad.cheema@gmail.com

Company Setup in GP 10.0

Explaining GP 10 Company Setup Window

Option	Explanation
Use Shipping Method When Selecting Default Tax Schedule	During Tax calculation if it is required to have multiple taxes for different states, this option is very helpful. e.g. if shipment is for CA, it will deduct CA state Tax, if it is for NY, it will deduct NY Tax
Calculate Terms Discount Before Taxes	If taxes doesn't support Term Discounts, Amount to be calculated on Total and not on discounted amount
enable Intrastat Tracking	If wants to track Intrastat enable this
Separate Payment Distributions	if GL is required to keep track of transactions for each module entry, mark this option for payment GL accounts to keep additional record
Merge Trade Discount and Markdown Distributions in Sales	If you don't mark this option, the distributions that are of the same type with the same account number will be combined. (Suggested to keep it un checked for Pakistan)
Merge Trade Discount Distributions in Purchasing	If this option is not marked, the trade discounts and markdown distributions will e separated from the sales Distribution
Calculate Tax Rebates	Mark This option to allow correcting tax amounts for a transaction with a terms discount
Enable Posting Numbers in General Ledger	Use this option if you want solid numbering of Transactions, without gaps, solid numbering is a legal requirements in few countries
Enable GST for Australia	Enable GST for Australia
Enable Tax Date	If tax date is different from the document date, you can check this option and a tax date field will be available on all control documents
Enable Reverse Charge Taxes	Helpful for negative taxation, like withholding tax
Calculate Taxes in General Ledger	option available if paying without BR module and wants tax calculation in GL
Allow Summary-Level Tax Edits	if editing allowed in summary windows, check this option
Require Tax Details totals to Match the Pre-Tax Amount	If proposed and actual is same mark this
Specify Tax Details for Automatic Tax Calculation	if multiple taxes are assigned, you may select which tax to be activated
Enable EU Transaction Tracking	for Enabling EU Transactions
Enable DDR and European Electronic Funds Transfer	for EU
Enable Canadian Tax Detail	for Canada

 

Withholding Vendor ID:

specify which vendor to Act as Tax Authority

Withholding File/Reconciliation Number

Withholding Tax Rate

Default 3.5% in case of Pakistan

Display Posting Number Per: Year or Period

Interface in Dynamics GP 10.0

Lets talk about UI of Dynamics GP

Navigation Pane

 

1. ShortCut Area
   
2. Create Shortcuts, external, internal, within GP
   
3. Add Folder, Add Window, Add Macro, Add Webpage, Add External Shortcut

Navigation Pane Button Area

1. Add new buttons
   
2. Configuration Button
   

Dynamics GP 10.0 - How to Log on?

Starting Dynamics GP is like any other windows program, Click >Start>All programs>Microsoft Dynamics>GP 10.0>GP

Enter user name and password;

Select Which company you would like to log on to?

You should be able to see similar screen;

Are you interested in Testing your skills? wait till next post :-)