Splitting Up COGS
"Umed Sethia" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.bpcs |
|---|---|
| Message-ID | <000001d22640$27f07c40$77d174c0$@com> |
In ERP Lx 8.3.5, new functionality of G/L cost type is added to handle the same. Umed Sethia -----Original Message----- From: BPCS-L [mailto:bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of bpcs-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Friday, October 14, 2016 10:30 PM To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: BPCS-L Digest, Vol 14, Issue 38 Send BPCS-L mailing list submissions to bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/bpcs-l or, via email, send a message with subject or body 'help' to bpcs-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at bpcs-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of BPCS-L digest..." *** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful. Today's Topics: 1. Re: BPCS-L Digest, Vol 14, Issue 37 (Bonnie Bryant) 2. Re: Splitting Up COGS (Adams, Jay) 3. Re: Splitting Up COGS (Rob Berendt) ---------------------------------------------------------------------- message: 1 date: Thu, 13 Oct 2016 12:30:04 -0500 (EST) from: Bonnie Bryant <bonniebryant-e+I43eZs+O0g9ELcbhaJlAC/[email protected]> subject: Re: [BPCS-L] BPCS-L Digest, Vol 14, Issue 37 ver 8.3.5 will value inventory transactions by bucket. On October 13, 2016 at 12:00 PM bpcs-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] wrote: Send BPCS-L mailing list submissions to bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/bpcs-l or, via email, send a message with subject or body 'help' to bpcs-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at bpcs-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of BPCS-L digest..." *** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful. Today's Topics: 1. Re: Splitting Up COGS (Wynn, Christopher P.) 2. Fw: Splitting Up COGS (David Rapacz) ---------------------------------------------------------------------- message: 1 date: Wed, 12 Oct 2016 17:38:29 +0000 from: "Wynn, Christopher P." <[email protected]> subject: Re: [BPCS-L] Splitting Up COGS 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-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Adams, Jay Sent: Friday, October 7, 2016 8:03 AM To: 'bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]' <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]> 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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: [email protected] 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 ------------------------------ message: 2 date: Wed, 12 Oct 2016 20:19:54 +0000 (UTC) from: David Rapacz <[email protected]> subject: [BPCS-L] Fw: Splitting Up COGS This functionality was added to the 8.3.5 release of LX. Details regarding this new functionality can be found in our release notes available on Infor Xtreme at: https://www.inforxtreme.com/esknowbase/root/DLPublic/40843/Release_Notes_835 .zip? If you are interested in learning more about recent Infor LX functional and technology?advancements?or upcoming releases, please contact me at david.rapacz-wzDqe+/[email protected] | ? | ? | | | David J. Rapacz| Infor LX (BPCS) Product Manager office +1 312 258 6070 | mobile +1 312 927 1726 | david.rapacz-wzDqe+/[email protected] | www.infor.com | ???????Infor LXCustomer Community | Connect,collaborate, and discuss | www.inforcommunities.com? On Wednesday, October 12, 2016 12:58 PM, "Wynn, Christopher P." <[email protected]> wrote: 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-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Adams, Jay Sent: Friday, October 7, 2016 8:03 AM To: 'bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]' <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]> 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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: [email protected] 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 -- This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. ------------------------------ Subject: Digest Footer -- This is the BPCS ERP System (BPCS-L) digest list To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. ------------------------------ End of BPCS-L Digest, Vol 14, Issue 37 ************************************** ------------------------------ message: 2 date: Thu, 13 Oct 2016 21:00:02 +0000 from: "Adams, Jay" <JAdams-jpWk/[email protected]> subject: Re: [BPCS-L] Splitting Up COGS Christopher and David thank you for your response. We are on version 6.00.2 of BPCS so I now know this is not possible on our version unless we write some programs. We already do some things with Batch Transaction Processing, so I will take a look at that. Thanks, Jay from: "Wynn, Christopher P." <[email protected]> subject: Re: [BPCS-L] Splitting Up COGS 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. from: David Rapacz <[email protected]> subject: [BPCS-L] Fw: Splitting Up COGS This functionality was added to the 8.3.5 release of LX. Details regarding this new functionality can be found in our release notes available on Infor Xtreme at: https://www.inforxtreme.com/esknowbase/root/DLPublic/40843/Release_Notes_835 .zip? If you are interested in learning more about recent Infor LX functional and technology?advancements?or upcoming releases, please contact me at david.rapacz-wzDqe+/[email protected] 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 ______________________________________________________________________ ------------------------------ message: 3 date: Fri, 14 Oct 2016 07:25:45 -0400 from: Rob Berendt <[email protected]> subject: Re: [BPCS-L] Splitting Up COGS I know that upgrading ERP is rather a big thing, probably why Infor gave so much notice, but they are ending support for that version March of 2018 https://community.inforxtreme.com/infor-erp-lx--bpcs-product-group/f/infor-e rp-lx-bpcs-product-group---discussion/7946/change-in-support-for-infor-bpcs- 6-002-and-6-004 Rob Berendt -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: "Adams, Jay" <JAdams-jpWk/[email protected]> To: "'bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]'" <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 10/13/2016 04:59 PM Subject: Re: [BPCS-L] Splitting Up COGS Sent by: "BPCS-L" <bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]> Christopher and David thank you for your response. We are on version 6.00.2 of BPCS so I now know this is not possible on our version unless we write some programs. We already do some things with Batch Transaction Processing, so I will take a look at that. Thanks, Jay from: "Wynn, Christopher P." <[email protected]> subject: Re: [BPCS-L] Splitting Up COGS 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. from: David Rapacz <[email protected]> subject: [BPCS-L] Fw: Splitting Up COGS This functionality was added to the 8.3.5 release of LX. Details regarding this new functionality can be found in our release notes available on Infor Xtreme at: https://www.inforxtreme.com/esknowbase/root/DLPublic/40843/Release_Notes_835 .zip? If you are interested in learning more about recent Infor LX functional and technology?advancements?or upcoming releases, please contact me at david.rapacz-wzDqe+/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. ------------------------------ Subject: Digest Footer -- This is the BPCS ERP System (BPCS-L) digest list To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. ------------------------------ End of BPCS-L Digest, Vol 14, Issue 38 ************************************** -- This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.