Posts

Showing posts from July, 2011

How to Enter Analytical Accounting Negative beginning balances

In Analytical Accounting, the dimensions and corresponding codes are always linked to the General ledger accounts. Analytical transaction are triggered only when a GL distribution is being made in any of the modules of GP which is supported by AA. Hence, We cannot post to AA without actually posting to GL Accounts. What if we have a situation to enter AA negative balances? We know that AA does not support entering negative balances. In this post we will see in which scenarios we will encounter the possibility of entering negative balances and how we can achieve this functionality through a workaround while respecting the business logic of AA. Scenario A client is migrating their balances to GP and as part of the migration, the account framework is changed to a new structure. As part of the new structure, they would like to maintain their employee loan balances in AA linked to 1 main GL Account for Employee Loans & Advances. In their old system on the contrary, each of the emplo

Top 100 Most Influential People in Microsoft Dynamics: My Take

I haven’t talked about the Dynamics world Most influential Top 100 list until now. I have seen so much talk around Microsoft dynamics blogosphere earlier in terms of seeking votes for their nominations put up on the list. Seriously, I do not know the tools and techniques deployed to measure the influence of these nominations. First, I’d give full credit to the Dynamics world team. I was interested in looking at their selection criteria for a moment because the final list in itself made me think deeply on it. The selection criteria, to quote from the Dynamics world website “ We base our selections on a number of criteria including: Number of nominations received; Number of Microsoft Dynamics employees employed; Number of clients your ISV/VAR has; As an end user how many user licenses taken; Social Media Followers (bloggers/twitter/ LinkedIn) (bonuses for group owners); Number of years experience of Microsoft Dynamics; MVP Recipients; Developers of Add-Ons and new verticals; Speaker

Dynamics blogger Video channel on You tube

Image
I remember those days past a year or so when I created Twitter account where I started syndicating the GP blog posts and later did a lot experiments like Facebook group, MSdynamicswire.com website and network creation.  dynamics blogger.com is another new addition that is created recently quarter ago. Although not all experiments are successful, yet, I derive some learning out of each experiment and I enjoy it. Now comes another experiment that is Dynamics Blogger YouTube video channel. I realized presenting your thoughts in a video format is much easier than writing long sentences. However, I must say I also realized how tough it is to create a video of your own but I’m confident I’ll learn it the hard way in due course of time. Here comes the latest videos on the channel. Dynamics GP 2010 Auto Login – This video shows few steps to activate this feature Excel And Dynamics GP Export Solutions in Smart list – This video shows how to use export solutions in smart list with

Dynamics GP MVPs’– Missing the List

The current MVPs’ of Dynamics GP are definitely the most deserving professionals and credits shall be given to the MVP selection committee. However, I feel there are other deserving professionals left out of the list. The people that comes to my mind who should be on this list but left out are 1. Steve Chapman from Rose Business Solutions 2. Christina Philips from BKD Technologies I find the videos of Steve Chapman on You Tube to be an invaluable contribution to the dynamics GP community as a whole. I like his presentation of those videos and the amount of knowledge that is hidden in his videos. Till date, Only two people I’d say are the most active contributors to You Tube videos for Dynamics GP. One is Steve Chapman on Rose Business Solutions Channel and the other is Mark Polino. I don’t need to say anything much about Mark other than that he is just great and outstanding in his contribution to Dynamics GP community. Personally, I’m influenced by the videos of Steve and in fact

Analytical Accounting: Dimension Code Macro

Macro to enter new dimension codes in Analytical accounting module is provided below. TypeTo field aaTrxDimCode , ' CODE '   MoveTo field Inactive  # 'FALSE'   MoveTo field aaTrxDimCodeDescr   TypeTo field aaTrxDimCodeDescr , ' CODE DESCRIPTION1 '   MoveTo field aaTrxDimCodeDescr2   TypeTo field aaTrxDimCodeDescr2 , ' CODE DESCRIPTION2 '   MoveTo field aaNode   MoveTo field 'Lookup Button 3'   ClickHit field 'Lookup Button 3' NewActiveWin dictionary 'Analytical Accounting'  form aaTreeNodeLookup window Main   DblClickHit field '(L) TreeView' item 1  # ' NODE ' 1 NewActiveWin dictionary 'Analytical Accounting'  form aaTrxDimensionCodeMnt window Main ActivateWindow dictionary 'Analytical Accounting'  form aaTrxDimensionCodeMnt window Main   MoveTo field 'Save Button'   ClickHit field 'Save Button'

Integration Manager crashes

Sometimes we might not be that lucky to get through with our imports through Integration Manager remotely. A remote session will kill the ongoing Integration and leave the Dynamics GP running despite the crash. I’ve made interesting observations that will save your time next time you encounter the same for some reason. 1. Integration Manager crashes while doing the integrations using terminal server or Citrix like environment. Or for that matter applications like Team viewer, LogmeIn so on. 2. It will crash only when we try to do the integrations using Integration Manager standard destination adapter that requires Dynamics GP session to be on. This doesn’t happen for IM eConnect adapter. 3. This happens when the integration tries to open another GP window during the course of Integration. Troubleshooting 1.There is no proven solution to the above problem. 2. However when it happens, the first thing to do is to go to Task Manager and kill Dynamics.exe process that keeps runn

Sales Orders Import: Location ID does not exist

While importing sales documents in Dynamics GP through Integration Manager or eConnect, We encounter the following error message. Microsoft.Dynamics.GP.eConnect:  Number = 287  Stored Procedure taIVTransactionLineInsert  :  Description = Location ID/Site ID (TRXLOCTN) does not exist in Site/Location Setup - IV40700 When we see this error, Our immediate focus would be on Quantities/Sites window where the Item number should be assigned to the relevant site ID in import. However, In some cases the integration fails despite assigning the site to the item number. Reason for this error would be due to the presence of Kits. If any of the line items contain Kits and we receive this error, We shall go to the Kit components and check if the components are assigned to the respective sites in import. In one of my imports earlier, I’ve struggled for 4 hours struggling to find which item was not assigned to the site. After constant trials, I found the problem lies in the kit components. Specia

Import Kits

Image
Importing Kits is another exercise that is difficult to integrate with Integration Manager as there is no such adapter available. What if we have thousands of Kits to be created in GP. In such cases, Using Table import is a wise option to import thousands of kits in split of seconds. Kits Import is a straight import in GP as the Kit Master is the only table tat we should be looking at. Follow the steps below to import the kits. Make sure Kits are defined with the item type Kit and the Kit components as items with Sales Inventory types in Item master as a prerequisite for Kits Import. Prepare the CSV file with the following fields. Make sure to remove the label Headers in the file after preparation of fields. Item Number – Fill this field with Kit parent code. Sequence Number – Fill this field with Sequence number 16384, 32768 so on for each component line item. Component Item Number – Fill this field with the

Import Inventory BOM FAQs

In my earlier post I’ve covered how to import Inventory BOMs. In this post, I’ll publish a couple of FAQs’ which are very critical for the import. 1. I’ve successfully imported the Inventory BOM into both BOM Header as well as Component Tables. When I go and check the BOM Master record in GP, I could only see my Header record but no components are visible? A. Make sure You’ve assigned constant value of 5 for all your components BM Comp state field. Value 5 stands for Saved status. 2. I’ve successfully imported the BOM into the relevant tables. When I go and check the BOM Card in GP, I could see the header as well as components below it. But when I lookup for Bill Number in Bills and Items lookup, I could not see any of Bill numbers imported? A. Make sure you’ve provided the date values in creation date and modified date fields. If these fields are left blank, the BOM will not be visible in Lookups. 3. I’ve successfully imported the BOM into the relevant tables. When I go and

Import Inventory BOM

Image
Integration Manager for Dynamics GP doesn’t provide the ability to import the Inventory Bill of Materials (BOM). To overcome this limitation and to import Inventory BOMs’ into GP, We can make use of table import method instead. Importing Bill of Materials requires two tables BOM00101, BOM00111. To import the BOMs’ (Cards | Inventory | Bill of materials) using Table Import, Follow the steps below Prepare 2 CSV Files for the import. One is BOM Header and the other file is BOM Components. BOM Header must have the following fields. Item Number – This is the parent code and must be an inventory item existing in the inventory. This is called Bill Number Bill Status – Status of the Bill. Set it to 1 as constant. Status of 1 accord Active status for the BOM Status Ord – Assign constant value of  1 for active bills. BM Stock method – Assign 1 for Build if necessary, 2 for stock,