Author Archive:

rss feed

Dynamics GP Excel Paste Templates

| 08/03/2012 | 0 Comments

  A new version of Microsoft Dynamics GP Excel Paste has been released, but not the one that pastes with header and details, instead we have decided to release “templates support” version until getting the other version ready due to the high demand to get this feature and to reduce the support tasks that been assigned to the support team. By releasing this version, end users will be able to download ready templates from the following page: http://di.jo/GPExcelPasteTemplates.aspx And simply paste the template into the Dynamics GP Excel Paste Setup form as shown in the video below: Setup Excel Paste Templates Experts can easily create templates, copy what they have created from the grid to Excel and just send it to me for publishing, this will make users life easier! Enjoy! Regards, — Mohammad R.

Continue Reading

Dynamics GP Excel Paste Updates

| 07/27/2012 | 0 Comments

  Since the first day I announced the release of the excel paste , I been getting questions and requests from customers who already purchased the tool to do few modifications.

Continue Reading

Pricing for Microsoft Dynamics GP 2013 has been changed!

| 07/13/2012 | 0 Comments
Pricing for Microsoft Dynamics GP 2013 has been changed!

  Pam over Developing for Microsoft Dynamics GP published an article about the changes on Dynamics GP 2013 Pricelist, take a look into his article below: http://blogs.msdn.com/b/gp/archive/2012/07/11/napkin-pricing.aspx As per the published article at the partner source, prices are expected to be launched in August 1, 2012 “Microsoft Dynamics GP 2013 Draft Price List Coming August 1, 2012” Review the article below: https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID=%7b504666FB-DFE2-43CF-A576-E8DFFCE9DBE7%7d&NRORIGINALURL=%2fpartnersource%2fpartneressentials%2flicensingpolicies%2fperpetual-licensing%3fr%3d13%26l%3d11&NRCACHEHINT=Guest&l=11&r=13 Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Auto Post for Dynamics GP Batches while GP Turned Off! Post Master Enterprise

| 07/11/2012 | 0 Comments

  I noticed an article by Steve Endow introducing a new feature added to the post master utility and I expected this to be an awesome feature, but honestly I never expected to be such a change. Andrew Dean has finalized developing a new enhancement to their Post Master utility to be able to post batches automatically using a windows service that is always running, with the ability to drop reports using PDF into a user specific directory! I saw this in Andrew video below, and as a developer I been sure that all such stuff is doable if GP was running, however the new ERA now is having all these features while GP closed, enjoy watching the video below: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Dynamics GP Excel Paste Now on Microsoft Pinpoint

| 07/10/2012 | 0 Comments

  The tool was approved for publishing yesterday, you can now find it by searching the applications directory: http://pinpoint.microsoft.com/en-jo/applications/microsoft-dynamics-gp-excel-paste-12884944257/reviews I expect a small review from you all to support the tool Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

COPY Advanced Financials Reports Across Companies

| 07/05/2012 | 0 Comments
COPY Advanced Financials Reports Across Companies

  Normally you will need to create your balance sheet and paste it over all your companies, script below will do the task for you:   Download Link: http://www.di.jo/files/COPY Advanced Financials Reports Between Companies.zip   Script: –REPLACE Source with your source Company ID –REPLACE Destination with your destination Company ID INSERT INTO Destination.DBO.AF40100 (RPRTNAME,REPORTID,RPRTTYPE,CLCFRPRT,LSTMODIF,NOTEINDX) SELECT RPRTNAME,REPORTID,RPRTTYPE,CLCFRPRT,LSTMODIF,NOTEINDX FROM Source.DBO.AF40100 INSERT INTO Destination.DBO.AF40101 (REPORTID,MNHDRCNT,MNFTRCNT,SHDRCNT,SFTRCNT,ROWCNT1,COLCNT,SHDRPCNT,SFTRPCNT,MNHDRFLG,MNFTRFLG,SHDRFLAG,SFTRFLAG,MNHDRSIZ,MNFTRSIZ,SHDRSIZE_1,SHDRSIZE_2,SHDRSIZE_3,SHDRSIZE_4,SHDRSIZE_5,SFTRSIZE_1,SFTRSIZE_2,SFTRSIZE_3,SFTRSIZE_4,SFTRSIZE_5,SHDROPT_1,SHDROPT_2,SHDROPT_3,SHDROPT_4,SHDROPT_5,SHDRPRT_1,SHDRPRT_2,SHDRPRT_3,SHDRPRT_4,SHDRPRT_5,SFTROPT_1,SFTROPT_2,SFTROPT_3,SFTROPT_4,SFTROPT_5,SFTRPRT_1,SFTRPRT_2,SFTRPRT_3,SFTRPRT_4,SFTRPRT_5,COLHDCNT,COLDHSIZ_1,COLDHSIZ_2,COLDHSIZ_3,COLDHSIZ_4,COLDHSIZ_5,COLDHSIZ_6,RTOTLSIZ,COLTOSIZ,COLOFSIZ,LFTMARGN,RTMARGIN,TOPMARGN,BOTMARGN) SELECT REPORTID,MNHDRCNT,MNFTRCNT,SHDRCNT,SFTRCNT,ROWCNT1,COLCNT,SHDRPCNT,SFTRPCNT,MNHDRFLG,MNFTRFLG,SHDRFLAG,SFTRFLAG,MNHDRSIZ,MNFTRSIZ,SHDRSIZE_1,SHDRSIZE_2,SHDRSIZE_3,SHDRSIZE_4,SHDRSIZE_5,SFTRSIZE_1,SFTRSIZE_2,SFTRSIZE_3,SFTRSIZE_4,SFTRSIZE_5,SHDROPT_1,SHDROPT_2,SHDROPT_3,SHDROPT_4,SHDROPT_5,SHDRPRT_1,SHDRPRT_2,SHDRPRT_3,SHDRPRT_4,SHDRPRT_5,SFTROPT_1,SFTROPT_2,SFTROPT_3,SFTROPT_4,SFTROPT_5,SFTRPRT_1,SFTRPRT_2,SFTRPRT_3,SFTRPRT_4,SFTRPRT_5,COLHDCNT,COLDHSIZ_1,COLDHSIZ_2,COLDHSIZ_3,COLDHSIZ_4,COLDHSIZ_5,COLDHSIZ_6,RTOTLSIZ,COLTOSIZ,COLOFSIZ,LFTMARGN,RTMARGIN,TOPMARGN,BOTMARGN FROM Source.DBO.AF40101 INSERT INTO Destination.DBO.AF40102 (REPORTID,HDRFTRTY,FLDNUM,FLDPOSX1,FLDPOSY1,FLDPOSX2,FLDPOSY2,FLDTYPE,FLDFRMAT,SBHSBFIN,FLDOPT,FLDOPT2,FLDALIGN,FLDFTFML,FLDFTSIZ,FLDSTYLE_1,FLDSTYLE_2,FLDSTYLE_3,FLDSTYLE_4,FLDSTYLE_5,FLDSTYLE_6,FLDVALUE,FLDVALU2,FLDPRNAM ) SELECT REPORTID,HDRFTRTY,FLDNUM,FLDPOSX1,FLDPOSY1,FLDPOSX2,FLDPOSY2,FLDTYPE,FLDFRMAT,SBHSBFIN,FLDOPT,FLDOPT2,FLDALIGN,FLDFTFML,FLDFTSIZ,FLDSTYLE_1,FLDSTYLE_2,FLDSTYLE_3,FLDSTYLE_4,FLDSTYLE_5,FLDSTYLE_6,FLDVALUE,FLDVALU2,FLDPRNAM FROM Source.DBO.AF40102 INSERT INTO Destination.DBO.AF40103 (REPORTID,COLNUM,CLTKNCNT,COLTYPE,COLSIZE,COLOMCNT,COLOFMRK_1,COLOFMRK_2,COLOFMRK_3,COLOFMRK_4,HIDEFLAG,TEXTVALU,STPERIOD,ENDPEROD,AMNTFROM,HISTYEAR,BUDID,PRTSIGN,PRTCOMMA,PRTPCENT,PRTTEXT,ROUNDOPT,HEADALIN,HDFTFMLY,HDFTSIZE,HEDSTYLE_1,HEDSTYLE_2,HEDSTYLE_3,HEDSTYLE_4,HEDSTYLE_5,HEDSTYLE_6,HEADTYPE_1,HEADTYPE_2,HEADTYPE_3,HEADTYPE_4,HEADTYPE_5,HEADTYPE_6,HEDFRMAT_1,HEDFRMAT_2,HEDFRMAT_3,HEDFRMAT_4,HEDFRMAT_5,HEDFRMAT_6,HEADOPT_1,HEADOPT_2,HEADOPT_3,HEADOPT_4,HEADOPT_5,HEADOPT_6,HEADOPT2_1,HEADOPT2_2,HEADOPT2_3,HEADOPT2_4,HEADOPT2_5,HEADOPT2_6,COLHDNG_1,COLHDNG_2,COLHDNG_3,COLHDNG_4,COLHDNG_5,COLHDNG_6,COLHDNG2_1,COLHDNG2_2,COLHDNG2_3,COLHDNG2_4,COLHDNG2_5,COLHDNG2_6,ALGNOFST,COLEXPER,NOTEINDX,SEGFROM_1,SEGFROM_2,SEGFROM_3,SEGFROM_4,SEGFROM_5,SEGFROM_6,SEGFROM_7,SEGFROM_8,SEGFROM_9,SEGFROM_10,SEGTO_1,SEGTO_2,SEGTO_3,SEGTO_4,SEGTO_5,SEGTO_6,SEGTO_7,SEGTO_8,SEGTO_9,SEGTO_10) SELECT REPORTID,COLNUM,CLTKNCNT,COLTYPE,COLSIZE,COLOMCNT,COLOFMRK_1,COLOFMRK_2,COLOFMRK_3,COLOFMRK_4,HIDEFLAG,TEXTVALU,STPERIOD,ENDPEROD,AMNTFROM,HISTYEAR,BUDID,PRTSIGN,PRTCOMMA,PRTPCENT,PRTTEXT,ROUNDOPT,HEADALIN,HDFTFMLY,HDFTSIZE,HEDSTYLE_1,HEDSTYLE_2,HEDSTYLE_3,HEDSTYLE_4,HEDSTYLE_5,HEDSTYLE_6,HEADTYPE_1,HEADTYPE_2,HEADTYPE_3,HEADTYPE_4,HEADTYPE_5,HEADTYPE_6,HEDFRMAT_1,HEDFRMAT_2,HEDFRMAT_3,HEDFRMAT_4,HEDFRMAT_5,HEDFRMAT_6,HEADOPT_1,HEADOPT_2,HEADOPT_3,HEADOPT_4,HEADOPT_5,HEADOPT_6,HEADOPT2_1,HEADOPT2_2,HEADOPT2_3,HEADOPT2_4,HEADOPT2_5,HEADOPT2_6,COLHDNG_1,COLHDNG_2,COLHDNG_3,COLHDNG_4,COLHDNG_5,COLHDNG_6,COLHDNG2_1,COLHDNG2_2,COLHDNG2_3,COLHDNG2_4,COLHDNG2_5,COLHDNG2_6,ALGNOFST,COLEXPER,NOTEINDX,SEGFROM_1,SEGFROM_2,SEGFROM_3,SEGFROM_4,SEGFROM_5,SEGFROM_6,SEGFROM_7,SEGFROM_8,SEGFROM_9,SEGFROM_10,SEGTO_1,SEGTO_2,SEGTO_3,SEGTO_4,SEGTO_5,SEGTO_6,SEGTO_7,SEGTO_8,SEGTO_9,SEGTO_10 FROM Source.DBO.AF40103 INSERT INTO Destination.DBO.AF40104 (REPORTID,CLCOLNUM,TKNODNUM,TKNTYPE,TKNVALUE,TKNDLVAL,TKNUNACT_1,TKNUNACT_2,TKNUNACT_3,TKNUNACT_4,TKNUNACT_5,TKNUNACT_6,TKNUNACT_7,TKNUNACT_8,TKNUNACT_9,TKNUNACT_10) SELECT REPORTID,CLCOLNUM,TKNODNUM,TKNTYPE,TKNVALUE,TKNDLVAL,TKNUNACT_1,TKNUNACT_2,TKNUNACT_3,TKNUNACT_4,TKNUNACT_5,TKNUNACT_6,TKNUNACT_7,TKNUNACT_8,TKNUNACT_9,TKNUNACT_10 FROM Source.DBO.AF40104 INSERT INTO Destination.DBO.AF40105 (REPORTID,CLCOLNUM,TKNODNUM,TKNTYPE,TKNVALUE,TKNDLVAL,TKNUNACT_1,TKNUNACT_2,TKNUNACT_3,TKNUNACT_4,TKNUNACT_5,TKNUNACT_6,TKNUNACT_7,TKNUNACT_8,TKNUNACT_9,TKNUNACT_10 ) SELECT REPORTID,CLCOLNUM,TKNODNUM,TKNTYPE,TKNVALUE,TKNDLVAL,TKNUNACT_1,TKNUNACT_2,TKNUNACT_3,TKNUNACT_4,TKNUNACT_5,TKNUNACT_6,TKNUNACT_7,TKNUNACT_8,TKNUNACT_9,TKNUNACT_10 FROM Source.DBO.AF40105 INSERT INTO Destination.DBO.AF40106 (REPORTID,ROWNUMBR,TOTKNCNT,ROWTYPE,ROWSIZE,ROLUPFLG,ROWDESC,SUBSUDID,TYPCLBAL,CATNUMBR,PRTSIGN,PRTHEDER,CENTHEDR,ROWFTFAM,ROWFTSIZ,ROWSTYLE_1,ROWSTYLE_2,ROWSTYLE_3,ROWSTYLE_4,ROWSTYLE_5,ROWSTYLE_6,ROFMRKIN_1,ROFMRKIN_2,ROFMRKIN_3,ROFMRKIN_4,ROFMRKIN_5,ROFMRKIN_6,ROFMRKIN_7,ROFMRKIN_8,ROFMRKIN_9,ROFMRKIN_10,ROFMRKIN_11,ROFMRKIN_12,ROFMRKIN_13,ROFMRKIN_14,ROFMRKIN_15,ROFMRKIN_16,ROFMRKIN_17,ROFMRKIN_18,ROFMRKIN_19,ROFMRKIN_20,ROFMRKIN_21,ROFMRKIN_22,ROFMRKIN_23,ROFMRKIN_24,ROFMRKIN_25,ROFMRKIN_26,ROFMRKIN_27,ROFMRKIN_28,ROFMRKIN_29,ROFMRKIN_30,ROFMRKIN_31,ROFMRKIN_32,ROFMRKIN_33,ROFMRKIN_34,ROFMRKIN_35,ROFMRKIN_36,ROFMRKIN_37,ROFMRKIN_38,ROFMRKIN_39,ROFMRKIN_40,CFLOSCTN,RWEXPERR,NOTEINDX,STTACCT_1,STTACCT_2,STTACCT_3,STTACCT_4,STTACCT_5,STTACCT_6,STTACCT_7,STTACCT_8,STTACCT_9,STTACCT_10,ENDACCT_1,ENDACCT_2,ENDACCT_3,ENDACCT_4,ENDACCT_5,ENDACCT_6,ENDACCT_7,ENDACCT_8,ENDACCT_9,ENDACCT_10) SELECT REPORTID,ROWNUMBR,TOTKNCNT,ROWTYPE,ROWSIZE,ROLUPFLG,ROWDESC,SUBSUDID,TYPCLBAL,CATNUMBR,PRTSIGN,PRTHEDER,CENTHEDR,ROWFTFAM,ROWFTSIZ,ROWSTYLE_1,ROWSTYLE_2,ROWSTYLE_3,ROWSTYLE_4,ROWSTYLE_5,ROWSTYLE_6,ROFMRKIN_1,ROFMRKIN_2,ROFMRKIN_3,ROFMRKIN_4,ROFMRKIN_5,ROFMRKIN_6,ROFMRKIN_7,ROFMRKIN_8,ROFMRKIN_9,ROFMRKIN_10,ROFMRKIN_11,ROFMRKIN_12,ROFMRKIN_13,ROFMRKIN_14,ROFMRKIN_15,ROFMRKIN_16,ROFMRKIN_17,ROFMRKIN_18,ROFMRKIN_19,ROFMRKIN_20,ROFMRKIN_21,ROFMRKIN_22,ROFMRKIN_23,ROFMRKIN_24,ROFMRKIN_25,ROFMRKIN_26,ROFMRKIN_27,ROFMRKIN_28,ROFMRKIN_29,ROFMRKIN_30,ROFMRKIN_31,ROFMRKIN_32,ROFMRKIN_33,ROFMRKIN_34,ROFMRKIN_35,ROFMRKIN_36,ROFMRKIN_37,ROFMRKIN_38,ROFMRKIN_39,ROFMRKIN_40,CFLOSCTN,RWEXPERR,NOTEINDX,STTACCT_1,STTACCT_2,STTACCT_3,STTACCT_4,STTACCT_5,STTACCT_6,STTACCT_7,STTACCT_8,STTACCT_9,STTACCT_10,ENDACCT_1,ENDACCT_2,ENDACCT_3,ENDACCT_4,ENDACCT_5,ENDACCT_6,ENDACCT_7,ENDACCT_8,ENDACCT_9,ENDACCT_10 FROM Source.DBO.AF40106 INSERT INTO Destination.DBO.AF40107 (REPORTID ,TOTRWNUM,TKNODNUM,STROWNUM,ENDRWNUM) SELECT REPORTID ,TOTRWNUM,TKNODNUM,STROWNUM,ENDRWNUM FROM Source.DBO.AF40107 INSERT INTO Destination.DBO.AF40108 (REPORTID,TOTRWNUM,MBRWNUM) SELECT REPORTID,TOTRWNUM,MBRWNUM FROM Source.DBO.AF40108 INSERT INTO Destination.DBO.AF40109 (FLDPRNAM,FLDPCTUR) SELECT FLDPRNAM,FLDPCTUR FROM Source.DBO.AF40109 –INSERT INTO Destination.DBO.AF40110 (USERNAME,SHGRDFLG,SHCGRFLG,SHTBARFL,SCDEFAFL,SHRWARFL,SHOFMKFL,SNPTGRFL,SHMARFLG,SHPGBDFL,SHRLRSFL ) SELECT USERNAME,SHGRDFLG,SHCGRFLG,SHTBARFL,SCDEFAFL,SHRWARFL,SHOFMKFL,SNPTGRFL,SHMARFLG,SHPGBDFL,SHRLRSFL FROM Source.DBO.AF40110 Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com www.mohdaoud.com

Continue Reading

What do you expect from Dynamics GP 2013??

| 06/24/2012 | 0 Comments
What do you expect from Dynamics GP 2013??

  I been looking around the blogosphere an noticed an awesome article by Frank Hamelly simply summarizing new features of Dynamics GP 2013, I am sure that you are very much excited to check what that could be therefore I have copied them all, sorry Frank for the infringe of your copyrights! but I wanted to bold features that is useful for customers in my region, blow is the list: Excel Export Using Open XML Enable printing of SSRS report from forms Navigation Lists for Web Client (BA Functionality) Re-architect home pages to WPF New SSRS reports to support Web Client templated forms Business Analyzer WPF upgrade Additional Word Templates for SOP Single Email with multiple attachments SRS Reports Print Customer Items option Select invoice on one-off Email window Notes on Credit Documents Document Attach Item Standard Cost adjustment post to GL Multi-S/N select Inactivate a Site and Item Site Reason Codes for stock movements/adjustments Inactive Items – Inventory Status enhancements Bin Transfer History Tolerance Handling Track Serial Numbers for Drop Ship items Allow prepayments on a PO Prevent PO close prior to Invoice Match Print Button on Pick List Shortage Inquiry Ship to Address has different Company Name Relate / Link Items for suggestions on Sales Integrate AA with Copier Series SOP/POP and GL Copy Add Field Service Allocations to Item Allocation Inquiry Window Update Back Order Quantity in Item Maintenance RMA Entry – Update Contact & Address ID Consolidate Revenue Recognition Item Description from RMA Credit Multi-User check in RMA Entry Equipment Super Session Hotline Update RMA Return Quantity and Type Ship to Address Integration to SOP Cross Ship RMA consolidation Honor Discontinued Item Status Auto Populate Customer ID Add a Contract Number search in Revenue recognition window Allow contract line to be moved to another contract even if on an open service call Option to have an equipment card created when manufacturing receives a serialized item into inventory Contract Workflow Add BAI2 format support to eReconcile FA Calendar Setup FA Intercompany Asset Transfer FA Historical Depreciation Report Lock Current FA Year and Mass Backout FA to GL posting process updates FA Updates for MACRS Integrate Fixed Assets with AA GL Journal Entry Inquiry for History Reconcile Bank Reconciliation with GL Year End Close Options Subledger Reconcile IV to GL Calculate Average Exchange Rate for Currency Translation Integrate GL with encumbrance Enable Enc to assign Multiple GL Budgets for Fiscal Year Encumbrance Cost Diff Notification Restrict Void of reconciled check, display reconcile status in Check Inquiry Void of check returns applied Credits Void credit card payment vendor invoice – void to original vendor EFT add settlement date option EFT Field Length and Delimitation Options Edit Payables Transactions: Remit to Address, 1099 information, Edit Description PM Reprint Checks/Remittance forms Need a 1096 Form Allow renaming of user-defined fields on Customer Address Multicurrency apply in cash entry Database multi-tenancy (named system database) Application multi-tenancy Report deployment and retrieval for multi-tenant Multi-tenant Applications – tenant service Multi-tenant Integration Manager Multi-tenant web service Life Insurance enhancements Check Build Exception Report Stop Duplicate Checks Paycode History Edit Paycode, Deduction, Benefit Modifier FICA TSA Deductions Customer Fields Advanced Warning Notice and Delete History Records Mandatory Arrears Template and Reminders DIA Reporting Voucher Description and Voucher Document Number Voucher Consolidation HR Calendar Negative Carryover PTO Detail and History PTO Manual Checks Year End PTO Office Presence in Advanced HR, Advanced Payroll, Payroll Extensions & PTO Manager HR Requisition List View Consolidated Invoicing Additional String Resources (Dex) Key Relations tracked in index file for source control(Dex) Update VBA Components Enhance the AltMod windows with a mark all/unmark all functionality 64 Bit Support for Email (Dex) Default sort for Customer and Vendor lookups Email Indicators in Transaction lists Save batch approval information Select Printer at time of print AND Support for http:// on the Report Destination window Adding support for the Business Analyzer to NLB Grouped Reports SmartList Builder – remove dependency on having an Admin login after new install Extender Window export/import to include Smartlist integrations Add Extender & SmartList Builder Default Security Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com www.mohdaoud.com

Continue Reading