Page 1 of 512345

Archive for December, 2009

MBS Guru: Publishing User Specific Data from Dynamics GP using …

to make the @WINLOGIN parameter Hidden, so users cannot change this value when running the report, and Default the value to the Global User!UserID. Now, when running the report Users will be prompted to select or 

More:
MBS Guru: Publishing User Specific Data from Dynamics GP using …

December 29, 2009 · Michael D. Johnson II · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 65

Account Rollup, Summaries Group of Account

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 !!!



See more here:
Account Rollup, Summaries Group of Account

December 29, 2009 · Sandip Jadhav · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 489

GP 10 Keyboard Shortcuts

Superb and very useful post by Jivtesh on the GP 10 Short cut keys.

http://www.jivtesh.com/2007/10/great-plains-keyboard-shortcuts.html

Cheers.

See more here:
GP 10 Keyboard Shortcuts

December 27, 2009 · Mohammed Feradh Zain · No Comments
Tags: , ,  · Posted in: Blogs I Follow Total Views: 528

Im BACK…!!

Sorry guys for long silence in my blogsphere..There had been too many action packed events that kept me off the active Dynamics World..

See the rest here:
Im BACK…!!

December 27, 2009 · Mohammed Feradh Zain · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 320

GP 11 Launch in January 2010..

Great News from the Microsoft to kick start the year 2010!!

Cant wait till January 13th for the launch as per the below video..
http://www.youtube.com/watch?v=caaKXQWIwhM

Feradh..

The rest is here:
GP 11 Launch in January 2010..

December 27, 2009 · Mohammed Feradh Zain · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 386

Microsoft Dynamics GP Manufacturing – Accounting Transactions Part II

In my previous post on Dynamics GP Manufacturing Accounting Transactions, I have explained about standard accounting entries generated from  Dynamics GP Manufacturing for Average Perpetual items.
Now I will extend the same exercise by some other setup options
Background/Setups:
The setup option considered for the accounting transactions example consists the followings

1.    Machine & Labor Marked Auto Back flush
2.    Inventory Items using “Periodic Valuation Method” ( FIFO OR LIFO )
-      Standard costing ( Periodic Valuation) values inventory at a cost based on the standard cost assigned to an item, plus eight other factors:
-      Inventory – Material Fixed Over Head ( FOH )
-      Inventory – Material Variable Over Head ( VOH )
-      Labor Cost
-      Labor Fixed Over Head ( FOH )
-      Labor Variable Over Head ( VOH )
-      Machine Cost
-      Machine Fixed Over Head (FOH )
-      Machine Variable Over Head( VOH )

Summary:
There are three Main Transactions from manufacturing

1.    Component Transaction Entry ( Issuance Of Material )
2.    MO Receipts ( WIP )
3.    MO Receipts ( FG )

And One Additional Transaction

4.    MO Closing ( In Case Of Variance )

Details:
Here is the details about the above transaction types with respect to a standard process of MO

Step 1:   Bill Of Material Setup
a.    No Accounting Transaction
Step 2:   Manufacturing Order Creation
b.    No accounting transaction
Step 3:   Component Transaction Entry ( Issuance Of Material )
a)    Issuance Entry
Account
Debit
Credit
Inventory           
Inventory- Material FOH
Inventory- Material VOH
WIP- Material              
WIP- Material – FOH
WIP- Material – VOH 
b)    Reverse Issuance
Account
Debit
Credit
Inventory           
Inventory- Material FOH
Inventory- Material VOH
WIP- Material              
WIP- Material – FOH
WIP- Material – VOH 
Step 3:   MO Receipt
a)    WIP For Machine & Labor
Account
Debit
Credit
WIP-Labor                    
WIP-Labor-FOH           
WIP-Labor-VOH           
Applied-Labor
Applied-Labor-FOH
Applied-Labor-VOH
WIP-Machine               
WIP-Machine-FOH      
WIP-Machine-VOH     
Applied-Machine
Applied-Machine – FOH
Applied-Machine – VOH
b)    FG Entry
Account
Debit
Credit
WIP-Labor          
WIP-Labor-FOH
WIP-Labor-VOH
Inventory-Labor
Inventory-Labor-FOH
Inventory-Labor-VOH
WIP-Machine          
WIP-Machine-FOH    
WIP-Machine-VOH
Inventory-Machine
Inventory-Machine-FOH
Inventory-Machine-VOH
WIP – Material
WIP – Material FOH
WIP – Material VOH
FG-Inventory
FG-Inventory FOH
FG-Inventory VOH
Step 4:   MO Close ( In Case Of Variance & its depend the type of variance as well)
Account
Debit
Credit
WIP-Labor          
WIP-Labor-FOH
WIP-Labor-VOH
Variance -Labor
Variance -Labor-FOH
Variance -Labor-VOH
WIP-Machine          
WIP-Machine-FOH    
WIP-Machine-VOH
Variance -Machine
Variance -Machine-FOH
Variance -Machine-VOH
WIP – Material
WIP – Material FOH
WIP – Material VOH
Variance – Material
Variance – Material FOH
Variance – Material VOH
Inventory Cost & Sales For Periodic Valued Items:
For Periodic Valued items, system maintain inventory cost in nine main buckets
-      Inventory – FG
-      Inventory – FG FOH
-      Inventory – FG VOH
-      Inventory – Labor
-      Inventory – Labor FOH
-      Inventory – Labor VOH
-      Inventory – Machine
-      Inventory – Machine FOH
-      Inventory – Machine VOH
-       
So when you prepare sales for Periodic valuation method finished goods, system will record the sales (COGS) in the following detailed manner
Account
Debit
Credit
Sales
Accounts Receivables
Inventory
Inventory – FOH
Inventory – VOH
Inventory Labor
Inventory – Labor- FOH
Inventory – Labor- VOH
Inventory Machine
Inventory – Machine- FOH
Inventory – Machine- VOH
COGS-Material
COGS-Material – FOH
COGS-Material – VOH
COGS-Labor
COGS-Labor – FOH
COGS-Labor – VOH
COGS-Machine
COGS-Machine – FOH
COGS-Machine – VOH

I hope this gives a detailed idea about manufacturing transactions with respect to periodic valuation.

Related Reference Links:
Dynamics GP – Manufacturing Accounts
Dynamics GP Manufacturing – Accounting Transaction Part I

Read the original here:
Microsoft Dynamics GP Manufacturing – Accounting Transactions Part II

December 27, 2009 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,060

Dynamics GP Manufacturing Bill Of Material( BOM ) Setup Guidelines

Just recently one of my friend had query regarding the manufacturing.
” I am trying to add a component to a BOM, but it is not allowing. Is there any perquisites?”
The issue in his case was, The parent item in the BOM was standard cost where as he was trying to add actual cost item as a component, so any one out there planning for Manufacturing implementation just have a look on this guidelines before you finalize the requirements mapping
Remember, not all items can be components of all bills of materials. Refer to the following guidelines.
-      You can add a standard cost component to the bill of materials for an actual cost finished good.
-      You can’t add an actual cost component to a bill of materials for a standard cost finished good.
-      You can’t add an item with the Kit type to a bill of materials.
-      If you add an item with the Services, Miscellaneous, or Flat Fee type to a bill of materials, those items must be back flushed.
-      Average cost valuation methods can be used for finished goods or components.
-      If you’re working in an average cost environment, however, you should be sure that system settings prevent you from allowing your inventory to be negative.
-      The same item number can be listed multiple times as a component on a bill of materials, but it must have a different position number for each time it is listed.
-      An item only can exist once on a super bill of materials, regardless of the position number

Originally posted here:
Dynamics GP Manufacturing Bill Of Material( BOM ) Setup Guidelines

December 24, 2009 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,167