HomeRecommended LinksLatest LinksTop HitsWhere's that GP Window?Contact
Home » Listing Details
Top Websites
  1. Mark Polino's DynamicAccounting.net
    Over 3700 resources listed.
  2. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 700 resources listed.
  3. Mariano Gomez at The Dynamics GP Blogster
    Over 600 resources listed.
  4. Mohammad Daoud's Dynamics GP Blog
    Over 400 resources listed.
  5. Microsoft Dynamics Partner Community Blog
    Over 400 resources listed.
  6. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 400 resources listed.
  7. Dynamics GP Help
    Over 400 resources listed.
  8. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 300 resources listed.
  9. Frank Hamelly at GP2theMax
    Over 200 resources listed.
  10. About Dynamics, Development and Life
    Over 200 resources listed.
  11. eOne Business Solutions Blog
    Over 200 resources listed.
  12. Inside Microsoft Dynamics GP Official Blog
    Over 200 resources listed.
  13. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  14. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  15. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  16. Victoria Yudin's Dynamics GP Website
    Over 100 resources listed.
    Victoria Yudin
  17. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  18. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  19. Dynamics CPM
    Over 100 resources listed.
  20. Dynamics Small Business
    Over 100 resources listed.
  21. Belinda, The GP CSI
    Over 100 resources listed.
  22. Rose Business Solutions Blog New
    Over 100 resources listed.
  23. Microsoft Dynamics GP UK Blog
    Over 100 resources listed.
  24. Leslie Vail at Dynamics Confessor Blogspot
    99 resources listed.
  25. Michael Johnson at MBS Guru
    96 resources listed.
Useful Dynamics GP Links
  1. Dynamics GP Add-On Products and ISV Solutions
  2. Dynamics GP Community Homepage - Blogs, Product Forums and Newsgroups

ID:13768
Title:Microsoft Dynamics GP Manufacturing – Accounting Transactions Part II
URL:http://waqasb.blogspot.com/2009/12/microsoft-dynamics-gp-manufacturing_27.html
Description:

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:

Category:TIPS AND TRICKS BY MODULES: Manufacturing
Link Owner:
Date Added:June 28, 2010 12:01:00 PM
Number Hits:9
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.

 
Latest links
GPWindow.com

Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.

www.saci.com
PHP Link Directory