How do we get the COGS to pull from the customer?
Did the White Paper you mention ever get re-posted? Please could you email to me
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.
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 |
Hope this helps explain what you are seeing.
Warmest Regards,
Angela
SR Technical Advisor
Microsoft Dynamics GP support
Are talking about a sales order or a manufacturing order? Look for a similar option under manufacturing setup.
Thanks, but that didn't work. We are using Manufacturing Standard Costing.
Tools->Setup->Sales->Sales Order Processing pick the option to pull posting accounts from customer.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148