Dynamics Community Forum Thread Details

Adding Manufacturing Module changes COGS source

Hi,

When Manufacturing gets installed, where accounts pull from change. Typically when you post in SOP, the system is designed to look at the item for those COGS accounts.

I helped write a white paper that discusses how GP pulls accounts when MFG is installed (Accounts Used for Manufacturing Dynamics Great Plains). It goes through EVERY module (SOP, POP, IV etc) and splits out if you are Perpetual/Actual costing or Periodic/Standard costing. I just asked our team to get it reposted online because I can't find it out there anymore. For now, below is what GP looks and does depending on the option you select. (customer or item). If you want it to do something else, a customization would be needed.

If the COGS accounts are set up to pull from Item (Tools >Setup > Sales > Sales Order Processing) the system looks at the Item card's 9 buckets and pulls the appropriate COGS account.
If the COGS accounts are set up to pull from the customer (Tools > Setup > Sales >Sales Order Processing) there is only 1 COGS account on the Customer Card and not 9 buckets. The material costs will be pulled into the COGS account on the customer card and the rest of the costs (labor and machine) are put into the remaining 8 buckets from the Item card’s COGS accounts.

Standard Cost Item Accounts and Costs used during an Invoicing Transaction

DR/CR	Account	Cost Used
DR	COGS – (Material) (Item Account Maintenance)	Material Cost * Quantity
DR	COGS – Material Fixed Overhead (Item Account Maintenance –Costing)	Material Fixed Overhead Cost * Quantity
DR	COGS – Material Variable Overhead(Item Account Maintenance –Costing)	Material Variable Overhead Cost * Quantity
CR	COGS – Labor (Item Account Maintenance –Costing)	Labor Cost * Quantity
CR	COGS – Labor Fixed Overhead (Item Account Maintenance –Costing)	Labor Fixed Overhead Cost * Quantity
CR	COGS – Labor Variable Overhead (Item Account Maintenance –Costing)	Labor Variable Overhead Cost * Quantity
DR	COGS – Machine (Item Account Maintenance –Costing)	Machine * Quantity
DR	COGS – Machine Fixed Overhead (Item Account Maintenance –Costing)	Machine Fixed Overhead * Quantity
DR	COGS – Machine Variable Overhead (Item Account Maintenance –Costing)	Machine Variable Overhead * Quantity
CR	Inventory (Material) (Item Account Maintenance)	Material Cost * Quantity
CR	Inventory Material Fixed Overhead (Item Account Maintenance –Costing)	Material Fixed Overhead Cost * Quantity
CR	Inventory Material Variable Overhead (Item Account Maintenance –Costing)	Material Variable Overhead Cost * Quantity
DR	Inventory Labor (Item Account Maintenance –Costing)	Labor Cost * Quantity
DR	Inventory Labor Fixed Overhead (Item Account Maintenance –Costing)	Labor Fixed Overhead Cost * Quantity
DR	Inventory Labor Variable Overhead (Item Account Maintenance –Costing)	Labor Variable Overhead Cost * Quantity
CR	Inventory Machine (Item Account Maintenance –Costing)	Machine * Quantity
CR	Inventory Machine Fixed Overhead (Item Account Maintenance –Costing)	Machine Fixed Overhead * Quantity
CR	Inventory Machine Variable Overhead (Item Account Maintenance –Costing)	Machine Variable Overhead * Quantity