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'
--/////////////////--Example-/////////////////
  EXECUTE SL_DH_File_Creation 'xTable'
--////////////////////////////////////////////

DH File for Customization's:
--////////////////////////////////////////////
--Execute  ProcedureName  'TableName'
--/////////////////--Example-/////////////////
  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