Sunday, 15 June 2014

Microsoft Dynamics Business Analyzer - An enormous reporting tool

Microsoft Dynamics Business Analyzer


Microsoft Dynamics Business Analyzer is a familiar and easy to use solution that can help accelerate your business with actionable and engaging business insights across your organization.
Tailored for specific roles it provides pre-configured business insights and a user experience that can be personalized to fit your needs.
Whether you are in the office or on the go you can discover and interact with your favorite charts and financial reports or collaborate and share insights to help drive decisions more quickly.

  • Pre-configured Out-of-the-box dashboard experience that you can personalize for your needs helps you find business insights fast.

  • Interact with and explore business data from Microsoft Dynamics SL 2011 FP1 reports with a pre-configured and connected experience.

  • Deploys independent of the Microsoft Dynamics® SL rich client
  • Turn any Quick Query View into an SSRS report that Business Analyzer can use
  • Report generation wizard creates and deploys Microsoft SQL Server reports that can be viewed in the Business Analyzer
  • Creates summary and detail reports that provide drill down capabilities

  • Creates links to Microsoft Dynamics SL screens as well
  • Displays Microsoft SQL Server Reporting Services reports
  • Collaborate with others through real-time communication (Ex. Microsoft Lync™) or by sharing a snapshot.

Sunday, 23 March 2014

Correcting / Reversing Journal Entries Easily in SL 2011

"Correct Journal Transactions" feature will Reverse, Reverse and Correct and Copy an existing journal entries (This feature will only applicable for GL entries not for Sub Ledger entries like AP, AR, etc.). This wills avoid user’s manual Journal entry correction/ reversal effects. 
User can invoke this feature through Correct Journal Transaction button which is available in Journal Transactions screen under General Ledger Module.

This Correct Journal Transaction screen has the follow three options:

Reverse – This option allows the original batch to be reversed (meaning it will offset the original batch making the transactions null and void) by creating a reversing batch. This batch is identical to the original batch except the debits and credits have been reversed to back out the original transaction amounts. The only fields that may be edited, in the new batch, are Batch Handling and Period-to-Post

Reverse and Correct
 – Creates a reversing batch for the original batch. This batch is identical to the original batch except the debits and credits have been reversed to back out the original transaction amounts. The only fields that may be edited are Batch Handling and Period-to-Post. A second, new batch will be created identical to the original batch and any field in the new batch may be edited.

Copy – Creates a new batch matching to the original batch and all fields can be modified. The period defaults to the current period. 

Hope this Helps for someone!!!

Microsoft Dynamics Community

Monday, 27 January 2014

Link AP and PO Documents

Link Accounts Payable and Purchase Order documents using "Link AP and PO Documents (03.560.00)" screen

This screen will be used to make a connection between a purchase order, receipt & return transaction generated in the Purchasing module and a released Accounts Payable voucher / debit adjustment transaction.

Unlinked Voucher or Debit Adjustment Transactions Area

Lists Accounts Payable transactions based on criteria you specify in the Selection Criteria for Vouchers or Debit Adjustments area of this screen
Unvouchered Purchase Order, Receipt, or Return Transactions Area
Lists purchasing transactions that match criteria you specify in the Selection Criteria for Purchase Orders, Receipts, or Returns area of this screen.

While clicking the "Link Transactions" button system will link the selected PO and AP transaction 

User can use this Link AP and PO Documents (03.560.00) Screen for the following Scenarios:
1) If used missed to link the PO and Receipt information during Invoice booking through Voucher and Adjustment entry screen

2) Before making the Receipt User needs to pay the invoice. In this scenario user can make the voucher without PO and receipt information. After receipt creation easily map those two documents using this screen

Hope this helps!!!

Microsoft Dynamics Community

Monday, 16 December 2013

Making SL DH File easily using SQL Scripts

DH file formation (for Solomon User tables) will always consume huge amount of time to complete the entire content for the specified tables. 

Using this procedure, user can get an entire DH file content quickly by just passing the table name as parameter.

Steps to form the DH file:

1) Download the following SQL file

2) Execute the SL_DH_File_Creation.SQL file under Solomon Application database through SQL Server Management studio.

3) Execute the DH File creation procedure in the following way under Solomon Application Database

DH File for new Screen development :
--Execute  ProcedureName  'TableName'
  EXECUTE SL_DH_File_Creation 'xTable'

DH File for Customization's:
--Execute  ProcedureName  'TableName'
  EXECUTE SL_DH_File_Customization 'xTable'

Hope this blog will be very useful for SL-Developers!!!

Microsoft Dynamics Community

Friday, 6 December 2013

Set “Unvouchered Purchase Orders” exist alert during Invoice Booking

To avail this feature, user has to select the “Warn of Unvouchered Purchase Orders” option under AP setup screen. 

Once this option is selected, system will check the Unvouchered purchase order records under Purchasing module during voucher or debit adjustment entry creation for the corresponding vendor through Voucher & Adjustment Entry screen.

Then this warning message appears when a user navigates to the detail grid of Voucher & Adjustment entry screen during voucher or debit adjustment entry creation.

Using this alert, user will never forget the Unvouchered receipts if exists for the  selected vendor.

Hope this Helps!!

Microsoft Dynamics Community

Sunday, 24 November 2013

Making Transaction screen data as Template in SL 2011

Copy Special - Option 

This option is used to copy all data items in a screen or a specific section of a screen.

The name and number of the current screen from which you accessed the Copy Special dialog box will be displayed in the Screen field.

  • All — Select and copy all data items at all levels in the source screen.
  • Selected — Copy only those data items selected for copying in the source screen. Select all items to copy before opening the Copy Special dialog box.
  • Order/Batch/Detail/Customer/Transaction — Select and copy all data items in the specified major screen section only; options vary from screen to screen, depending on the function of the screen.

User can select any on the following copy options.

User can use the Paste menu option to paste the copied records from the Copy Special
By this way we can easily form the template for each Transaction screen.     

Hope this helps!!!!!!!!        

Microsoft Dynamics Community

Thursday, 25 April 2013

Link multiple SL users to a single Windows user

We can link multiple Microsoft Dynamics SL users to a single Windows user using Windows User Maintenance (95.310.00) screen.



> Open Windows User Maintenance (95.310.00) screen

> In Windows User ID, select the windows User-ID you want to link

> In User ID, select the Microsoft Dynamics SL User-ID you want to link. The name of the user appears in User Name.

> Select Default User to specify the Microsoft Dynamics SL user.  The system will automatically select for the Windows user ID if another is not supplied.

> Click the Save button on the toolbar.

Hope this helps!!!!!!!!

Note:  As per the above scenario all the SL users( SYSADMIN, TESTUSER, TESTUSER2 & TESTUSER3) can login to Solomon using the selected Window's User ID (Domain\User-ID)

Microsoft Dynamics Community