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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.