Hi Jay,
We are on ERP LX 8.3.4 and wrote a custom solution which we added to the CEA menu to break out COGS after the fiscal period has been closed. The original COGS entries are extracted and allocated using the cost buckets in the CMF table(each cost bucket as a percentage of the total COGS entry). Another table is used to assign each cost bucket a Major account segment. The allocated COGS entries are then written to the GL batch header (GBH) along with an entry to reverse the original COGS entry. The finance department then reviews and posts the entries using CLD501D.
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Adams, Jay
Sent: Friday, October 7, 2016 8:03 AM
To: 'bpcs-l@xxxxxxxxxxxx' <bpcs-l@xxxxxxxxxxxx>
Subject: [BPCS-L] Splitting Up COGS
BPCS Accounting Experts,
When we do a B transaction (shipment), the Cost of Good Sold (COGS) account is updated. We would like to split up the COGS account into three accounts - material, labor, and overhead. How do I change the model to get the proper amount for materials, labor, and overhead? Or said another way, what macros can I use to update the debit and credit amounts for material, labor, and overhead?
I appreciate any help on this,
Jay Adams
Confidentiality Notice: This email from Qualicaps (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, copying, or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit
http://www.symanteccloud.com ______________________________________________________________________
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.
________________________________
The contents of this message, together with any attachments, are intended only for the use of the individual or entity to which they are addressed and may contain information that is legally privileged, confidential and exempt from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message, or any attachment, is strictly prohibited. If you have received this message in error, please notify the original sender or the AB Mauri/Ohly Help Desk at Tel: 314-392-0800 x 1881 immediately by telephone or by return E-mail and delete this message, along with any attachments, from your computer. Thank you.
________________________________
The views expressed in this e-mail are the views of the individual and may not reflect the views of the organisation. Associated British Foods accepts no liability for any losses or damages arising from reliance on the information contained in this e-mail. The information contained in this e-mail is confidential, may be legally privileged and is intended solely for use by the individual or organisation to whom it is addressed. E-mail information is subject to copyright and must not be used, disseminated, copied or disclosed to third parties without the written consent of Associated British Foods. If you are not the intended recipient you should delete this e-mail, destroy all copies and inform the administrator: admin@xxxxxxxxxxx. Copyright Associated British Foods plc. All Rights Reserved.
Registered Office: Weston Centre, 10 Grosvenor Street, London, W1K 4QY. A limited company registered in England 293262
midrange.com
