Dynamics GP - Knowledge Share

Next Document Number Web Service using eConnect

2012-04-14T18:59:00.001-07:00

Below is sample code for creating custom Web Service using eConnect for Next Document Number.

using Microsoft.Dynamics.GP.eConnect;

[WebMethod]

public string NextSopDocumentNumber(string TransactionType, string salesDocID)

{

GetNextDocNumbers sopTransNumber = new GetNextDocNumbers();

string nextTransactionNumber = string.Empty;

try

{

///string sConnectionString = ConfigurationManager.ConnectionStrings["GpeConnectConnectionString"].ToString();

string sConnectionString = ="server=YourServerName;database=YourDatabaseName;Integrated Security=SSPI;persist security info=False

switch (TransactionType)

{

case "SalesQuote":

nextTransactionNumber = sopTransNumber.GetNextSOPNumber(IncrementDecrement.Increment, salesDocID, SopType.SOPQuote, sConnectionString);

break;

case "SalesOrder":

nextTransactionNumber = sopTransNumber.GetNextSOPNumber(IncrementDecrement.Increment, salesDocID, SopType.SOPOrder, sConnectionString);

break;

case "SalesInvoice":

nextTransactionNumber = sopTransNumber.GetNextSOPNumber(IncrementDecrement.Increment, salesDocID, SopType.SOPInvoice, sConnectionString);

break;

case "SalesReturn":

nextTransactionNumber = sopTransNumber.GetNextSOPNumber(IncrementDecrement.Increment, salesDocID, SopType.SOPReturn, sConnectionString);

break;

case "SalesBackOrder":

nextTransactionNumber = sopTransNumber.GetNextSOPNumber(IncrementDecrement.Increment, salesDocID, SopType.SOPBackOrder, sConnectionString);

break;

}

return nextTransactionNumber;

}

catch (Exception ex)

{// If an error occurs, diplay the error information to the user

throw ex;

}

finally

{

sopTransNumber.Dispose();

}

}

Below are eConnect schemas to get other transaction type Next Doucment Number.
http://msdn.microsoft.com/en-us/library/ff623613.aspx

To Rollback Transactions Number:

[WebMethod]

public void RollBackMyDocumentNumber(string strTransactionType, string strDocNumber)

{

DocumentRollback TransRollback = new DocumentRollback();

string sConnectionString = ConfigurationManager.ConnectionStrings["GpeConnectConnectionString"].ToString();

try

{

switch (strTransactionType)

{

case "SOP":

TransRollback .Add(TransactionType.SOP, strDocNumber);

break;

case "Adjustment": //Adjustment

TransRollback.Add(TransactionType.IVTrans, strDocNumber);

break;

case "IVTransfer":

TransRollback.Add(TransactionType.IVTransfer, strDocNumber);

break;

case "POPReceipt":

TransRollback.Add(TransactionType.POPReceipt, strDocNumber);

break;

}

catch (Exception ex)

{// If an error occurs, diplay the error information to the user

throw ex;

}

finally

{

TransRollback.Dispose();

}

Below is more details on RollBackDocument

http://msdn.microsoft.com/en-us/library/ff623621.aspx

http://msdn.microsoft.com/en-us/library/ff623629.aspx

Feel free to email me if you need any further assistance or please share your code for same.

Happy coding!!!
Thanks
Sandip

Professional Services Tools – Import Button

2011-12-08T08:14:00.000-08:00

Got request from user that they want to modified Item Numbers, we already have Professional Service Tools license but problem was it not just one item I have to modify where I will enter starting number and ending and it’s done.

There were 100 + items need to modify!!! I was trying to use Import button to update Item Number using excel à created excel file with header “Starting Item Number” , “New Item Number” to match what I see in PSTL Item Modifier screen and then converted Excel file into CSV , validate but it didn’t work it was giving me error “Source Item not found” to find answer searched in Partnersource, Google didn’t help much as Integration Manager support CSV file even Sql Profiler and DexSQL Log file was not showing any logical error which help me to import these Items. Other options I was thinking to create Mail Merge Macros to import these Items to avoid manual entry.

Just to check I converted Excel file into Tab Delimited without Tab header information Validated Walla!!! It works no more error!!! Imported all items using Tab Delimited file instead of going each items or creating mail merge macro.

Until Next post!!!

Thanks

Sandip Jadhav

Refund Cash to Customer

2011-11-22T17:23:00.000-08:00

Refund Cash to customer

In Dynamics GP have option for "Refund to Customer" (Transactions-->Sales-->Refund Checks) but in small scale company it is not possible to make payment through checks for every customers.

When we create Refund from Dynamics GP it transfer Receivable balance to Payables Management creating checks for customer.

Scenarios:

1) Received access payment from customer through credit card and need to return cash back to him.

2) Access Payment Received from customer and need to pay back cash.

Make Debit Memo from Transaction-->Sales-->Receivable Transaction-->Debit Memo and apply to Invoice.

Distributions:

Debit : Accounts Receivable (Refund Amount)
Credit : Accounts Receivable Misc

With above distribution your Receivable will be get zero.

To Bank:

Transaction-->Financial -->Bank Transactions

Change entry to "Decrease Adjustment" and enter the amount for Refund.

Distribution:

Debit: Accounts Receivable Misc (Refund Amount)

Credit: Cash A/c

Simple Cash Refund entry without Checks(Cheques)

Thanks
Sandip Jadhav

How to get beginning account balance when past year not closed yet?

2011-08-23T17:28:00.000-07:00

If previous year is not closed Microsoft Dynamics GP does not displaying account balances for Balance Sheet accounts for New Year. This can give wrong account information to Financial users.

Suggestions:

1) If you know your previous year balance i.e. Closing Balance pass one GL Entry for opening entry i.e. on 01/01/2011 and then reverse it before you close the Year

This way you will see opening Balance for new year and once you ready to close previous year reverse the same entry.

2) There is no issue to close Fiscal Year because transactions still be posted to closed Fiscal Year. With this solution no need to pass and reverse dummy entry to get opening balance.

I will recommend to go for second suggestion if you can close Fiscal Year.

Thanks

Sandip

Installing, Troubleshooting Dynamics GP Smart Tag

2010-10-12T07:44:00.000-07:00

Dynamics GP Smart Tag really work “smart” and after installing users was very excited to see inquiry window from Word, Excel and Outlook.

Below are steps I followed to installed Smart Tag on Production Environment and it working successfully.

1) Created Windows Security Group for each type of Security e.g.

Make sure one user should not available in another group e.g. if you think user “abc” is having access of Accounts Receivable and Accounts Payable do not assign that user in both group instead of create another group call “Dynamics GP_APnAR” and assigned to it.

If user is exist in more than one group in Smart Tag Configuration window on client machine you will not see Entities.

2) a) After creating Window Security Group installed Smart Tag Server on Dynamics GP Database Server, run Dynamics GP Utilities to get require table populated. Make sure take good backup of Dynamics and Production DB.
b) Add Group in Smart Tag Manager Enable respective Entities, Action and most important Companies
for each Windows Group.

Now ready to install Smart Tag on Client Machine before that do the following setup or check following important task in Word, Excel and Outlook.

1) In Word, Excel and Outlook -->Goto-->Tools-->Macros-->Security In Security Level Select “Medium” and in Trusted Publisher tab select “Trust all Installed add-ins and templates”

2) Goto--> Auto Correct options-->Smart Tag mark “Label data with smart tag”

Installed Smart Tag client version , Goto--> Administration page you should see “Entities” and verify on Word or Excel smart tag is working or not.

If not then follow below steps:-

a) windows Security for user is assigned or not

b) User should not be duplicate in other Groups

c) Check Company is enable or not for windows group in GP Server “Manage Groups” screen.

d) Close Smart Tag Manager and then Goto --> C:\Program Files\Office Smart Tag Manager\temp and Delete/Rename “stConfig” and “Stterms” files. “stConfig” is hidden file. Reopen Smart Tag Manager and verify Entities in Administration. Type any Smart Tag word in Word or Excel to recreate above files.

e) If above option didn’t work reinstalled smart tag Manger.

f) Generate Debug Report to understand issue.

        1. Click Start, click Run, type Regedit, then press ENTER.
        2. In Registry Editor, locate the following registry subkey:
            HKey_Local_Machine\Software\Microsoft\BusinessSolutions\Office Smart Tag Manager\9.0
            \Administration
       3. Set the Debug key to ON. Then, re-create the issue. After the error occurs, set the Debug key to
           OFF.
       4. Submit the OXPSTMAdminDLL-DebugLog.txt file to Support.

g) If Smart Tag is not recognizing in Word or Excel in my case in Excel Smart Tag was not working. Detect and Repair utility in Excel help me to resolve issue.It will repair Ms-Office application.
    Goto--> Help-->Detect and Repair Select both options and start repairs. You may need to do setup again for Outlook. Remove and reinstalled smart tag again. After detect and repairs check security and AutoCorrect options and mark “Label data with smart tag” in smart tag tab before installing Dynamics GP Smart Tag.

To change Update Rate for Smart Tag :-
    1. Click Start, click Run, type regedit, and then click OK.

    2. Expand HKEY_LOCAL_MACHINE.
    3. Expand Software.
    4. Expand Microsoft.
    5. Expand Business Solutions.
    6. Expand Microsoft Office Smart Tag Manager.
    7. Expand 9.0.
    8. Click Engine.
    9. Right-click LOADREFRESHRATE, and then click Modify.
    10. Change the value in the Value data field.
Note: The change is instant and does not require that you restart the computer.

Thanks

Sandip

Common mistake by Payable Clerk with POP transactions

2010-09-04T09:09:00.000-07:00

1) Purchase Order-->Received Inventory . When Invoice is received instead of matching Invoice created Payable Transaction with same invoice no. PO which is has Inventory Receipt didn't matched with Invoice. PO Status is still show open.

2) Purchase Order created --> Receipt with Landed Cost . Invoice Matched without Landed Cost.

3) Purchase Order created-->Receipt with Landed Cost. matched Invoice for Receipt , AP Clerk forgot to matched / Apply Landed cost in Purchasing Invoice. After receiving separate Invoice for Landed Cost Expenses AP clerk created Payable Transaction for Landed Cost Invoice and paid.

4) Purchase Order -->Partial Receipt with Vendor Confirmation that he is not going to ship other Item. Instead of cancelling other Line Items in Receipt. AP Clerk Received Item --> Matched Invoice. As line Item for those PO is not cancelled PO status still show open.

All above mistake can cause Purchase Order status open and Accrued Purchase Account will show balance. Make sure to check when you will do edit PO it will create some GL Transaction for cancelled/closed PO Line Items.

For landed cost Invoiced adjustment which is not matched, to closed PO user must need to matched Landed Cost and create Credit Memo with proper GL Account and apply Landed Cost Invoice to avoid Voiding all payment and payable transactions.

Customers Item same like Vendor Items ???

2010-07-16T13:09:00.000-07:00

Do we have same option like Vendor Item in Dynamics GP for Customer Items? Yes. How it useful in Purchasing Module when user select “Vendor Item Option” it shows only those items which is assigned to Vendors and it help user for smooth data entry. Same option is available in Dynamics GP called “Customer Items Maintenance”

Once user assigns Customer Items in Customer in Sales Transactions it will display only those Items which is assigned to customer.

How to assign – GOTO --> Cards-->Sales-->Customer Items

In Sales Transaction Entry

Select Customer Items in Item Lookup and it will display only those Items which assigned in Customer Items Maintenance window.

Thanks

Sandip

There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Check DUinstall.log for more information

2010-06-27T20:27:00.000-07:00

Okay, So I was upgrading Dynamics GP 9.0 installed service pack 4 and Payroll Year end 2009 but I was getting error.. "There was a problem ascertaining product version information.. ..... check Duinstall.log for more information"

When I checked for Duinstall.log file it was showing Error for product id 0 and 309 that is Dynamics GP and Fixed Assets Module. Spend 4 days almost to research on this issue but no luck. There were several blogs about above error but nothing was helping me and Microsoft KB article 952054 was not just enough to resolve issue it didn't give any resolution.

Decided not to leave this issue and not to open support request with Microsoft. After going through Microsoft Knowledgebase on Dynamics GP 9.0 upgrade path it says if Upgrading GP9.0 or other older version for Dynamics GP10.0 need to install Patch.. it installed and upgrade went to very smoothly.

** Link to upgrade path.

https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={300CEDF2-CB9E-4934-BAB8-FC2ABED28439}&NRORIGINALURL=/customersource/support/knowledgebase/hottopics/hot_topic_updatingmicrosoftdynamicsgp10.htm?printpage=false&NRCACHEHINT=Guest&printpage=false

I try to list all blogs and other links reference to above error. Hope it will help you.

1) http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.greatplains&tid=7f497181-9aad-4745-9b87-d3452b951ab4

2) http://dynamicsconfessions.blogspot.com/2009/02/problem-ascertaining-product-version.html

3) http://www.keyongtech.com/5254080-upgrade-failure-release-10-0-a

4) http://www.keyongtech.com/3603302-product-0-does-not-support

5) https://community.dynamics.com/forums/p/34451/60089.aspx

May be one of them will help you to resolve this error.. I got it resolved by GP10 hotfix.

Until next post !!!

Sandip

Types of Integration methods with Dynamics GP

2010-04-27T19:27:00.000-07:00

1)   Integration Manager-To import Masters and Transactional data from excel sheet, Tab Delimited or comma delimited files. Integration Manager can used to import opening balances. It required user interfere but can schedule integration manager.

Microsoft allowed 90 days free use of Integration Manager

2)   eConnect- One of the another way to integrated Data into Dynamics GP, required programming experience to used eConnect API. user can do VB,VB.NET or C# coding to use eConnect. Required license for Developer Toolkit to used eConnect.

Pro-eConnect used windows login id that means user need not to be Dynamics GP user.

Cos-Need to install eConnect on every machine where it required to used.

3)   Dynamics GP Web Services- Web Services created using behind the screen eConnect API, again user need to have programming experience to create integration utility using web services. Dynamics GP Web Service Management Console offer user level integration rights where it can assigned specific user certain right e.g. to only import purchasing information or Receiving Transaction only.

4)    Rapid Implementation Tools- Used to copy existing data from one company to another with all setup information. useful to migrate data from QuickBooks and version 2.0 can migrate from Peachtree.

5)   SQL Query (Insert statement)- again need to be very careful need to follow all Dynamics GP logic to run Insert statement against table. Need to verify and populate all related table.. risky process !!!

6) Macro's - Macros can also used to create integration in Dynamics GP and it follow all GP Logic

7) Table Import-Dynamics GP utility that allow to import data from file directly into Dynamics GP table which I don't recommend because if you miss a related table it will be problem or must need to populate those table also or must run checklinks after table import in mostly it created required data in related table.

8) Copy Company Utility-This utility allows you to set up new company from existing company and can import all master records as well as transactional data also.

Do you know any other way to integrate data into Dynamics GP ?

Chage Item Option from "None" to "Lot" or "Serial"

2010-03-27T20:23:00.000-07:00

To change Item tracking option from None to Lot Number Item Qty on hand must be zero.

Click on Option

Following steps to change Item tracking option from "None" to "Lot"

1) Create negative Adjustment Entry from Transactions---> Inventory ---> Transaction Entry for those Item you want to change to "lot item"

2) Post Transaction.

3) Goto Item Maintenance-->Option, make Changes in Item Maintenance from None to Lot.

4) Add Adjustment Entry for "On Hand" Qty with Lot information

Creating Test Company

2010-02-11T19:02:00.000-08:00

Several time user want production data in Test company. Once you create Test Company and Restore Production database on Test Company please make sure to cover following two important point.

1) Make sure your test company name will end with "<TEST>" i.e. “MY Dummy Company <TEST>"

Advantage :

a) System will understand this is test company as well as user will get prompt that your login in test company

b) If user create test company and assigned company name without word "<TEST>" and Payroll module is installed system will count total number employees from Production Company + Test Company. But if test company name is created "<TEST>" word it won’t count Employee of test company.

If you are changing existing Test company Name with word "<TEST>" do not forget to run check link on Employee Maintenance to get correct employee count.

Again it’s very small but important "<TEST>" word to avoid all future confusion after creating test company.

2) Run Microsoft SQL Script after restoring Production Data into Test Company its available in KB872370

Account Alias-Speed up your GL Transaction Entry

2010-01-17T19:59:00.000-08:00

Account Alias use to speed up GL Transaction Entry. In above Example “LI-A” alias assigned to Life Insurance - Administration, instead of typing whole Account No user can use Alisa to speed up Journal General Entry (Transactions-->Financial-->General) .

Click on arrow to open Account Entry window Type “LI-A” in Alias field and press tab, as soon as user press tab Alias will recognized Account Number and display same in Transaction Entry screen.

Very small but interesting feature , have you ever used Alias feature before ?

PS: Use Alias feature not only for General Transaction but for entering big Distributions in other Transactions.

Remove Dynamics GP Web Service

2010-01-15T17:09:00.000-08:00

Steps to remove Microsoft Dynamics GP Web Services

1. Remove “Adam Instance DynamicsSecurityService” in Add\Remove Programs.

2. In IIS Manager, delete “Dynamics Security Admin Service” Web site.

3. In IIS Manager, delete “DynamicsGPWebServices” and DynamicsSecurityService” virtual directories from the Web site that the Web Services for Microsoft Dynamics GP was installed on.

4. In IIS Manager, delete the “DynamicsSecurityAdminServiceAppPool”, DynamicsSecurityServiceAppPool”, and “GPWebServicesAppPool” application pools.

5. Delete the “Microsoft Dynamics” folder from C:\Program Files\Common Files\Microsoft Shared.

6. Delete “GPWebServices” folder from C:\Program Files\Microsoft Dynamics (This is the default location for Web site files.).

7. Delete “Dynamics GP Web Service Exception Management Console” and “Dynamics Security Console” shortcuts from Administrative Tools program folder.

8. Delete related Registry Keys for Web Services for Microsoft Dynamics GP 9.0.

9. Remove the DynamicsGPWebServices key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\

Run following SQL Script to remove SQL Objects from DYNAMICS as well as Company Database.

Against DYNAMICS DB :

drop view ReqCurrency
drop view ReqCurrencyAccess
drop table WSErrorProperties
drop table WSExceptionLog
drop table WSInstallStatus
drop table WSInstallSteps
drop procedure ws_delete_WSExceptionLog
drop procedure ws_deleteall_WSExceptionLog
drop procedure ws_get_MC40200
drop procedure ws_get_SY01500
drop procedure ws_get_WSErrorProperties
drop procedure ws_get_WSExceptionLog
drop procedure ws_get_WSExceptionLog_Summary
drop procedure ws_get_WSExceptionLog_ValidationException
drop procedure ws_get_WSInstallStatus
drop procedure ws_getall_WSInstallStatus
drop procedure ws_insert_WSExceptionLog
delete eConnect_Out_Setup where DOCTYPE in('WSCompany', 'WSCurrency', 'WSCurrencyAccess')

Run following sql script against all Company Database

drop view ReqCurrencyPostingAccountView
drop view ReqGLAcct
drop view ReqGLFixedAllocAcct
drop view ReqGLFixedAllocDistAcct
drop view ReqGLHeaderView
drop view ReqGLLineView
drop view ReqGLPostingAcct
drop view ReqGLPostingAcctCurrencies
drop view ReqGLUnitAcct
drop view ReqGLVarAllocAcct
drop view ReqGLVarAllocDistAcct
drop view ReqGLVarAllocDistBreakAcct
drop view ReqIVFee
drop view ReqIVHeaderView
drop view ReqIVItemCurrency
drop view ReqIVItemHeader
drop view ReqIVItemQuantity
drop view ReqIVItemQuantityBinDetail
drop view ReqIVItemVendor
drop view ReqIVItemWarehouse
drop view ReqIVKit
drop view ReqIVKitComponent
drop view ReqIVLineBinDetailView
drop view ReqIVLineLotDetailView
drop view ReqIVLineSerialDetailView
drop view ReqIVLineView
drop view ReqIVPricing
drop view ReqIVPricingDetail
drop view ReqIVSalesItem
drop view ReqIVService
drop view ReqPAAccounts
drop view ReqPAChangeOrderHeader
drop view ReqPAContractHeader
drop view ReqPAEmpExpDist
drop view ReqPAEmpExpHeader
drop view ReqPAEmpExpLine
drop view ReqPAEmpExpLineTax
drop view ReqPAMiscLog
drop view ReqPAMiscLogDist
drop view ReqPAMiscLogLines
drop view ReqPAProjectBudgetHeader
drop view ReqPAProjectHeader
drop view ReqPATimesheetDist
drop view ReqPATimesheetHeader
drop view ReqPATimesheetLine
drop view ReqPaymentCard
drop view ReqPMHeaderDistView
drop view ReqPMHeaderTaxView
drop view ReqPMHeaderView
drop view ReqPMVendor
drop view ReqPMVendorInetAddress
drop view ReqPMVendorPAOptions
drop view ReqPOHeaderFreightTaxView
drop view ReqPOHeaderMiscTaxView
drop view ReqPOHeaderTaxView
drop view ReqPOHeaderView
drop view ReqPOLineTaxView
drop view ReqPOLineView
drop view ReqPurInvDistView
drop view ReqPurInvHeaderFreightTaxView
drop view ReqPurInvHeaderMiscTaxView
drop view ReqPurInvHeaderTaxView
drop view ReqPurInvHeaderView
drop view ReqPurInvLineApplyRecptView
drop view ReqPurInvLineTaxView
drop view ReqPurInvLineView
drop view ReqPurRecptDist
drop view ReqPurRecptHeader
drop view ReqPurRecptLine
drop view ReqPurRecptLineBin
drop view ReqPurRecptLineLotNum
drop view ReqPurRecptLineSerNum
drop view ReqRecvDocComm
drop view ReqRecvDocDist
drop view ReqRecvDocHeader
drop view ReqRecvDocTax
drop view ReqRMCashReceiptDist
drop view ReqRMCashReceiptHeader
drop view ReqRMCorporateAccount
drop view ReqRMCustomer
drop view ReqRMCustomerAddress
drop view ReqRMCustomerInetAddress
drop view ReqRMSalesPersonCommisionsView
drop view ReqRMSalespersonInetAddress
drop view ReqSODistributionView
drop view ReqSOHeaderFreightTaxView
drop view ReqSOHeaderMiscTaxView
drop view ReqSOHeaderTaxView
drop view ReqSOHeaderView
drop view ReqSOLineComponentView
drop view ReqSOLineTaxView
drop view ReqSOLineView
drop view ReqSOLotDetailView
drop view ReqSOSerialDetailView
drop table WSPolicyBehaviorSelectionParameter
drop table WSPolicyBehaviorSelection
drop table WSPolicyBehavior
drop table WSPolicy
drop table WSParameter
drop table WSBehaviorOption
drop table WSBehavior
drop procedure ws_delete_WSBehavior
drop procedure ws_delete_WSBehaviorOption
drop procedure ws_delete_WSParameter
drop procedure ws_delete_WSPolicy
drop procedure ws_delete_WSPolicyBehavior
drop procedure ws_delete_WSPolicyBehaviorSelection
drop procedure ws_delete_WSPolicyBehaviorSelectionParameter
drop procedure ws_get_Behavior
drop procedure ws_get_MC40000
drop procedure ws_get_Policy
drop procedure ws_get_PolicyByOperation
drop procedure ws_get_PolicyNoDefaulting
drop procedure ws_get_SY00300
drop procedure ws_insert_WSBehavior
drop procedure ws_insert_WSBehaviorOption
drop procedure ws_insert_WSParameter
drop procedure ws_insert_WSPolicy
drop procedure ws_insert_WSPolicyBehavior
drop procedure ws_insert_WSPolicyBehaviorSelection
drop procedure ws_insert_WSPolicyBehaviorSelectionParameter
drop procedure ws_update_WSPolicyBehaviorSelection
drop procedure ws_update_WSPolicyBehaviorSelectionParameter
delete eConnect_Out_Setup where DOCTYPE = 'WSBank'
delete eConnect_Out_Setup where DOCTYPE = 'WSCashReceipt'
delete eConnect_Out_Setup where DOCTYPE = 'WSCompanyAddress'
delete eConnect_Out_Setup where DOCTYPE = 'WSCorporateAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSCountryRegionCode'
delete eConnect_Out_Setup where DOCTYPE = 'WSCurrencyPostingAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSCustomer'
delete eConnect_Out_Setup where DOCTYPE = 'WSCustomerAddress'
delete eConnect_Out_Setup where DOCTYPE = 'WSFee'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLAccountCategory'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLAccountFormat'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLFixedAllocationAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLPostingAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLTransaction'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLUnitAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSGLVariableAllocationAccount'
delete eConnect_Out_Setup where DOCTYPE = 'WSInventoriedItem'
delete eConnect_Out_Setup where DOCTYPE = 'WSInventoryAdjustment'
delete eConnect_Out_Setup where DOCTYPE = 'WSInventoryTransfer'
delete eConnect_Out_Setup where DOCTYPE = 'WSInventoryVariance'
delete eConnect_Out_Setup where DOCTYPE = 'WSItem'
delete eConnect_Out_Setup where DOCTYPE = 'WSItemClass'
delete eConnect_Out_Setup where DOCTYPE = 'WSItemCurrency'
delete eConnect_Out_Setup where DOCTYPE = 'WSItemVendor'
delete eConnect_Out_Setup where DOCTYPE = 'WSItemWarehouse'
delete eConnect_Out_Setup where DOCTYPE = 'WSKit'
delete eConnect_Out_Setup where DOCTYPE = 'WSMulticurrencySetup'
delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesCreditMemo'
delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesDocument'
delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesFinanceCharge'
delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesInvoice'
delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesMiscellaneousCharge'
delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesReturn'
delete eConnect_Out_Setup where DOCTYPE = 'WSPaymentCardType'
delete eConnect_Out_Setup where DOCTYPE = 'WSPaymentTerms'
delete eConnect_Out_Setup where DOCTYPE = 'WSPriceLevel'
delete eConnect_Out_Setup where DOCTYPE = 'WSPricing'
delete eConnect_Out_Setup where DOCTYPE = 'WSProject'
delete eConnect_Out_Setup where DOCTYPE = 'WSProjectBudget'
delete eConnect_Out_Setup where DOCTYPE = 'WSProjectChangeOrder'
delete eConnect_Out_Setup where DOCTYPE = 'WSProjectContract'
delete eConnect_Out_Setup where DOCTYPE = 'WSProjectEmployeeExpense'
delete eConnect_Out_Setup where DOCTYPE = 'WSProjectMiscellaneousLog'
delete eConnect_Out_Setup where DOCTYPE = 'WSProjectTimesheet'
delete eConnect_Out_Setup where DOCTYPE = 'WSPurchaseInvoice'
delete eConnect_Out_Setup where DOCTYPE = 'WSPurchaseOrder'
delete eConnect_Out_Setup where DOCTYPE = 'WSPurchaseReceipt'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesCreditMemo'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesDebitMemo'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesDocument'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesFinanceCharge'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesInvoice'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesReturn'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesServiceRepair'
delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesWarranty'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesBackorder'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesDocument'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesDocumentTypeSetup'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesFulfillmentOrder'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesInvoice'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesItem'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesOrder'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesperson'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalespersonCommissions'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesProcessHoldSetup'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesQuote'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesReturn'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesSetup'
delete eConnect_Out_Setup where DOCTYPE = 'WSSalesTerritory'
delete eConnect_Out_Setup where DOCTYPE = 'WSService'
delete eConnect_Out_Setup where DOCTYPE = 'WSShippingMethod'
delete eConnect_Out_Setup where DOCTYPE = 'WSUofMSchedule'
delete eConnect_Out_Setup where DOCTYPE = 'WSVendor'
delete eConnect_Out_Setup where DOCTYPE = 'WSVendorAddress'
delete eConnect_Out_Setup where DOCTYPE = 'WSWarehouse'

Dynamics GP Web Service Installation Error

2010-01-05T14:19:00.000-08:00

Dynamics GP Web Service Installation Error troubleshooting.

1) Uninstalled Completely Dynamics GP Web Services.

2) Remove ADAM instance prior to the reinstall of GP WebService

3) Make sure eConnect is not installed on Dynamics Database server before installing Dynamics GP Web Service. If eConnect is installed Uninstalled eConnect with all SQL objects.

4) Run following SQL Script to verify Dynamics GP Database is exist in SQL Server or not

a. Select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

b. Select * from Dynamics..DB_Upgrade

c. Select * from Dynamics..DU000020 order by companyID

5) DB_Upgrade will show if any company is not with Current Version and SP.

6) If you found any discrepancy in physically available Dynamics GP Company Database in SQL and Select Statement in “SY01500” run clearcompanies sql script from Microsoft, Download from KB973027 (Point No : 4)

If you found any discrepancy in Version please upgrade company or if you don’t want those company drop Company DB and run above script to clear company from system table.

7) Verify ISO code enter or not with following script or Login to Dynamics GP and Enter ISO code to all Currency follow Microsoft Dynamics GP Web service Installation document for ISO Code.

Run the following script against each company that is running in Dynamics:

select CURNCYID, CURRNIDX, ISOCURRC from DYNAMICS..MC40200

select FUNLCURR, FUNCRIDX from MC40000

Most important in ISO code make sure it 3 Digit ISO Code for each currency.

8) Once you've finished removing Web Services, verify that you are logged onto the IIS Server as a domain account with these permissions:

a) Use Domain Account is SQL Server is on a different machine than IIS server.

b) Local Administrator permission on both the IIS and SQL Servers.

c) Rights to create objects in SQL Server. I usually recomment the dbCreator and SecurityAdmin SQL Role if not sysadmin

d) Also Make sure this Domain Account user has the DYNGRP and public role permission for "DYNAMICS" and all of your GP Company Databases. DYGRP will give Domain Account user the Select, Insert , Delete and Update permission needed to update Dynamics GP Database.

e) Create anew WebSite in IIS Manager to install Web Services. I would recommend using a New Site Name and New Port Number if possible.

9) Run Installation file with following command it will help to create log if it show any installation error.

msiexec.exe/i "C:\Path\DynamicsGPWebServices.msi"/l*v C:\WSVerbose.log"

*****replace Path with the actual pathname to the DynamicsGPWebServices.msi file, in which you're using to start the install*****

Hope it will help you to resolve issue. Do not forget to go through Log file it will help you to understand issue.

Account Rollup, Summaries Group of Account

2009-12-29T12:07:00.000-08:00

How to monitor total of Group of Accounts say Cash A/c, Inventory or Payroll Account from different department, Account Rollup features in Dynamics GP is good option to create summary total of group of Accounts.

Following steps to create Account Rollup inquiry.

1) Goto--->Inquiry--->Financial-->Account Rollup

2) Click on Modify button

3) Enter Option ID

4) Select Segment for sorting option

5) Enter No of Columns in above example I selected 2 Columns one is for Actual and another for budget . Give column Name like “Actual” and “Budget”.

How to create Calculated Columns please go through with Dynamics GP Help.

6) Select option for Accounts i.e. Accounts is Posting Account or Unit Account

7) Select Range of Accounts and insert.

8) Save Accounts Rollup Inquiry options

9) User can callback Option Id from same screen and click on Inquiry Button or

Goto -->Inquiry-->Financial-->Account Rollup

Recall Option ID and Click on Redisplay

Keep checking for my next post.. Happy Holidays !!!

How to post Payroll Manual Transaction where Gross Amount is Zero.

2009-12-21T18:29:00.000-08:00

1) Goto--> Transaction --> Payroll -->Manual Checks

2) Call back transaction by entering Payment No.

3) Note down Check Date and then Clear Batch ID – Once you clear Batch ID Check date and Post Date will be enable. Make sure to enter correct Post Date and Check Date.

Click on Post button to post transaction.

Dynamics GP Year End Procedure

2009-12-06T16:08:00.000-08:00

Year End Closing for Dynamics GP Module must be done in following order

A) Inventory

B) Receivable

C) Payables

D) Fixed Assets

E) GL Year End

GL Year End Close should be done after you have completed you Year End Closing for all above Module in above order.

Let see go Module wise Year End Close procedure and its affects.

A) Inventory

GOTO-->Tools-->Routines-->Inventory-->Year End Close

Inventory Year End Close affects

i) Transfers all summarized current-Year Quantity, Cost and Sales Amounts to last-year for the Items for which you have been keeping summarized sales history

ii) Updates each item’s beginning Quantity from the Quantity on hand at each site

iii) Zeros the Quantity sold field in the Item Quantities maintenance (Cards-->Inventory-->Quantities/sites) for each site

iv) Give you the Option to: Remove Discontinued Items, remove sold Receipts, Remove Sold Lot Attributes, and update Item’s Standard cost.

Key Points to remember while/before running Inventory Year End Updates

i) Enter and post all PO Processing , Invoicing/sales Order Processing and Inventory Transaction for the current year

ii) Follow KB872713- Describes how to close the year and how to prepare your inventory records for the new fiscal year in Inventory Control in Microsoft Dynamics GP.

iii) Restorable Backups of Production and as well as Dynamics Database

iv) Reconciles SOP and POP and IV Module .. Reconcile SOP,POP and Then Inventory.

Knowledge Base Reference

i) KB872713 Describes how to close the year and how to prepare your inventory records for the new fiscal year in Inventory Control in Microsoft Dynamics GP.

ii) KB855316 Inventory Accidentally Closed Twice

iii) KB872182 Inventory Year End Close Does Not Remove Discontinued Items.

B) Accounts Receivables

GOTO-->Tools-->Routines-->Sales-->Year End Close

Affects of Receivable Management Year End Close

i) Calendar year End Close clears the Calendar Year to Date Finance charges and moves them to the last year Calendar field in Customer Finance Charge summary(Cards-->sales-->Summary-->Finance Charges)

ii) The Fiscal year End close transfer all amounts other than the Calendar YTD Finance charge amount to the Last Year Column in Customer Summary using the Amounts since Last closed view(Cards-->Sales-->Summary)

Key Points to remember

i) Post all transactions for current year

ii) Keep Restorable backup

iii) Follow KB857444- Describes how to perform the year-end closing routine in Receivables Management. Contains preparation steps and troubleshooting information for the year-end closing routine.

iv) Receivable management is not completely date sensitive there are some date sensitive features. It would still be the best option to close the year on time

v) KB851140- Explains the effects of performing the year-end closing procedure in Receivables Management after December 31.

C) Payable Management Year End Close

Goto-->Tools-->Routines-->Purchasing-->Year End

Calendar year End Close Routine should be run at the End of the Calendar year prior to posting transactions in the New Year

The Fiscal Year End close Routine should be run at the end of the fiscal year Prior to posting transactions in the New year

What does not Payable Management Year End Close does

i) The Fiscal year End Close Process transfers all other amounts from the Year to Date column to the Last Year Column in the Amounts since Last Close view.

ii) The Calendar year End Close process transfers the 1099 Amount from the Year to Date Column to the Last Year Column in the Amounts Since Last Close view in the Vendor yearly Summary window (Cards-->Purchasing -->Summary-->Yearly button)

Key Point to Remember

i) Post all transactions for the current year

ii) Make sure transaction for the new year are saved not posted

iii) Make a backup

iv) Follow the KB 875169 -Describes how to perform the year-end closing routine in Payables Management in Microsoft Dynamics GP. This article also lists preparation steps and troubleshooting information for the year-end closing routine.

v) Payable Management is not fully date sensitive , so it sill still recommended that you process your Year End closing routine at the Actual Year End

D) Fixed Assets Year End Close

GOTO-->Tools-->Routines-->Fixed Assets-->Year End

When should the Fixed Assets Year End close to be done?

i) The Fixed Assets Year End close should be run after you close Payable management but before you close General Ledger

ii) You can close each book separately, but you must close all books before you can do any processing in Fixed Assets for the New Year.

What does the Year End Close Process do?

1) In the Asset General information Window (Card-->Fixed Assets--> General)

     a) YTD Maintenance amount is removed

     b) The Quantity is copied to the Begin Quantity field

2) In the Asset book window (Cards-->Fixed Assets-->Book)

    a) The YTD Depreciation Amount is removed

    b) Cost basis is copied to Begin year Cost

    c) Life to Date Depreciation is copied to Begin Reserve

    d) Salvage is copied to Begin salvage

    e) Increase the Current fiscal year by on Year for Each book that is being closed.

Key Points to Remember

1) Print all the reports that you need for the year that you are closing

2) Backup of Production Database

3) KB865653- Describes the year-end closing routine in Fixed Asset Management in Microsoft Dynamics GP. Also lists preparation steps and troubleshooting information.

4) You must take depreciation to the last day of the year that you are closing before you close the year

E) GL Year End

GOTO-->Tools-->Routines-->Financial-->Year End Closing

What does the year End close process do?

1) The Year End close process close all P & L Account out to Retained Earnings, Leaving the P&L Ac with Zero Balance at the beginning of the New year

2) All Balance Sheet Accounts are updated with the Beginning Balance in the New year which will be the same as the Ending balance from the Year you are closing

3) The Retained Earning Account is updated with Amount from All P&L accounts if you close to one Retained Earning Account or with the Amount from P&L Account in that division if you close to divisional Retained Earning Account. The Retained Earning Accounts are the Only Balance sheet Accounts that should have different beginning balance than the Ending Balance from the year that you closing

4) The year End close routine moves all open year transactions from the GL20000 to the GL30000 table

5) The Fiscal Period Table is updated to Mark the year that you are closing as Historical.

Key Points

1) Restorable Backup of Dynamics as well as Production Database.

2) Follow KB888003- Describes the recommended year-end closing procedures for General Ledger in Microsoft Dynamics GP.

3) Make sure you have enough space on SQL Server to allow GL20000 table double in Size.

4) Perform Year End at Server.

5) Have all user out of Dynamics GP when you perform Year End operation.

6) The Year Close Routine does appear to hang at 50% but is still running be patience.

Important KB to follow

1) KB871679 Describes how to set up an adjusting period to record adjustments that are posted to the general ledger after the year-end close process has been performed.

2) KB850615 This article describes how the divisional retained earnings accounts work in General Ledger in Microsoft Dynamics GP.

3) KB864913- Describes how to correct accounts that were set up to use the wrong posting type after the General Ledger year-end closing process is complete in Microsoft Dynamics GP.

4) KB850741- Discusses that you receive a "Retained Earnings account not found" error message when you try to perform the year-end closing process in General Ledger in Microsoft Dynamics GP. Provides steps to troubleshoot the problem.

5) KB857582- Discusses that the balances for all unit accounts roll forward after the General Ledger fiscal year has been closed in Microsoft Dynamics GP. Describes how to delete the beginning balances for the unit accounts.

Understanding Purchase Return in Dynamics GP.

2009-11-19T10:50:00.000-08:00

In Dynamics GP for Purchase Return available 4 options, which option should I select to make Purchase Return?

Let see
1) Return
2) Return with Credit
3) Inventory
4) Inventory With Credit

1) Return
Select “Return” type when you received the Item and it’s not Matched to Invoice. Vendor Credit is not applied with above type.

Distribution:
Inventory A/c Cr $ XXX
Accrued Purchase A/c Dr $ XXX

2) Return With Credit
Select “Return with Credit” option when Item is Received and Matched to Invoice. Vendor Credit is applied.

Distribution:
Inventory A/c Cr $ XXX
Accounts Payable A/c Dr $ XXX

Above Entry will applied to your GL as well as Vendor Balance

3) Inventory
When should user select the above option?
a) When there is No Receipt or Matched Invoiced that means if user enter Inventory Adjustment from Inventory Transaction((Transaction-->Inventory-->Adjustment) and want to make Return Entry against those Adjustment
b) Variance Transaction (Transaction-->Inventory-->Variance)

Again Vendor Credit is not applicable; Inventory On Hand Qty will reduce.

Distribution:
Inventory A/c Cr $ XXX
Accrued Purchase/Wastage A/c Dr $ XXX

4) Inventory w/Credit
On Same “Inventory” scenario for “Inventory w/Credit” option but Vendor Credit are applicable.

Your Distribution will look like:
Inventory A/c Cr XXX
Accounts Payable Dr XXX

Above Entry will affect only your GL balance to get applied against your Vendor Balance
do not forget to apply your Return with Vendor Invoice (Transaction-->Purchasing-->Apply Payable Documents”)

Option 3 and 4 i.e. “Inventory” and Inventory w/Credit can be applied for your Opening Qty return.

Change Default Check No On Remittance for Zero Dollar Check

2009-11-06T08:44:00.000-08:00

Articel from Microsoft about "How to Change the Default Check Number Printed on Remittances for Zero Dollar Checks in Payables Management for Microsoft Dynamics GP"

here is the Partners Link : https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/msdgpremittzero.htm?r=5

Thanks
Sandip

Manually “Closed/Canceled” Purchase Order still shows in Inquiry as Open Purchase Order with "Closed/Canceled" Status.

2009-10-16T13:01:00.000-07:00

When user “Closed or Canceled” the purchase Order from Transaction-->Purchasing-->Edit Purchase Order those Purchase Order still show in Inquiry--->Purchasing--->Purchase Order Documents as Open PO .

Remove the Completed PO from Tools-->Routines--->Purchasing ---> Removed the Completed Purchase Order.

Once the Completed Purchase Order Removed it won’t appear in Inquiry as Open Purchase Orders.

PS: Sometime I saw the fully Received Purchase Order still show in Purchase Order Inquiry as Open PO, Follow the above solution to resolve the issue.

Microsoft Mainstream support for GP

2009-10-10T16:37:00.000-07:00

Microsoft Business Solutions Great Plains 8.0
Support for Microsoft Business Solutions Great Plains 8.0 Ends October 13, 2009

Microsoft Dynamics GP 9.0
Support for Microsoft Dynamics GP 9.0 End 1/11/2011
http://support.microsoft.com/lifecycle/?LN=en-us&p1=10479&x=9&y=8

Microsoft Dynamics GP 10.0
Support for Dynamics GP 10.0 End 10/10/2012 – Extended Support End at 10/10/2017
http://support.microsoft.com/lifecycle/?p1=12629

How to find the Table and Field Information in Dynamics GP

2009-10-02T20:16:00.000-07:00

Following steps can help you to find the Table Information in Dynamics GP.

1) Goto-->Tools-->Resource Description-->Tables

Table Names screen shows all the Table information for the specific series in above example its shows the Display, Technical and Physical Name for the Sales Series

2)Let’s find the Table Information for specific screen say : Customer Maintenance
Open the customer Maintenance screen from (Cards-->Sales -->Customer)
Goto --> Tools -->Integrate -->Table Import

These are the Display Name of Table used for the for Customer Maintenance Screen.
You can use the "First Example" to find the Physical Name for Customer Maintenance Screen

1) User can find the Window specific table information from
GOTO-->Tools-->Resource Description -->Windows

Again it shows the “Display Name“of all tables for “Customer Maintenance”.. you can follow the first step to find the “Physical Name”.

4) Even from Dynamics GP Report user can find the Table information used for that Report
Print the Report on Screen-->Click on “Modify” button.

Select any field from Report Layout and on Right Hand Side “Toolbar” it will show the Table Name like “RM_Customer_MSTR”
Again.. to find the “Physical Name” .. you don’t have to goto Dynamics GP , on Report Window Click on “Tables-->Tables”

Search for “RM_Customer_MSTR” ---> select and click on “Open” and it will show the “Physical Name”.

Lots of screen shot... Hope it will help you to find the table information!!!

Budget with Date Range

2009-10-01T09:44:00.000-07:00

Budgets in Finance (Cards-->Financial-->Budgets) is no longer limited for the specific year now we can span –give the date range.

On Dynamics GP 10.0 new field “Based On” is available which allow the user to decide the New Budget is based on Fiscal year or with Date Range.

When the Date Range is selected it allowed the user to enter the start Date and End Date.

Dynamics GP 9.0

Dynamics GP 10.0

Dynamics GP Class Behavior...

2009-09-29T19:53:00.000-07:00

“Dynamics GP Class Behavior”…. The day when I started working in Dynamics GP I was impress with the “Class” and its “Roll Down” feature just do the simple changes and it will update all Master Record. Unfortunately all these days I was thinking “Roll Down” features will “Roll Down” all the information from “Class” to the Master Data .
Here the issue I face - Imported the Customer Master using eConnect using default Existing “Class”. After importing found that I have to make two changes in Customer Master one in “assigning GL Account” and another is in “Payment Terms”, it’s so easy just update the Class of the customer and it will reflect all changes in all respective customers. Instead of making both changes and saving I mistakenly did first change Assigned the GL A/c and saved without “Roll Down” did the second change in “Payment Terms” and on save, clicked on “Yes” for “Roll Down” expecting system will pick GL A/c which recently assigned and all other Information from “Class” and do the update in Master Data.
But when I checked my customer Master for those “Class” my GL A/c field didn’t get updated. Only the changed happened to the “Payment Terms” field.
It was my assumption that once I made the changes to the one field in “Class” and on “Roll Down” it will update all respective field in Master Record but it won’t it will do the “Roll Down” only for the “Changed” field.
Again only the field you change it will Roll Down in Master Data not all fields

How to Determine Accurate Costing In Inventory In Dynamics GP 9.0 and10.0

2009-09-25T09:58:00.001-07:00

Hello,
Like to share a very nice article from Microsoft which help to udnerstand how the Inventory Costing does in Dynamics GP 9.0 and 10.0 and how we can determine the Inventory Costing .

End User always ask lot of question about how to change the cost and what is the affect .. How can we determine the IV Costing in Dymamics GP... I bet below article will solve your all doubts about the Inventory Costing in Dynamics GP.

https://mbs.microsoft.com/partnersource/documentation/whitepapers/wpmdgp_inventorycosting_90_10.htm?printpage=false&stext=How to determine, maintain, and report in Microsoft Dynamics GP 9.0 and 10.0

Download the PDF and enjoy !!!