Our chart of account structure contains 4 segments: natural, division, department and product line. We segment general ledger accounts related to gross margin (e.g. sales, sales discounts, sales returns, COS, cost of returns, etc.) by product line. This is accomplished via assigning each part to a product group, each product group to a product group GL control code, and then properly specifying each account context for the GL control codes by product line. This works real well for standard customers, but not so well for intercompany customers. When selling to an intercompany customer, we would like to “flex” the natural account segment values for these transactions while still segmenting by product line. The native posting rules appear to let you post to different GL accounts for intercompany customers by ignoring the typical hierarchy and take the GL accounts from the account contexts on the AR Account GL Control Type GL Control Code attached to the intercompany customers, but this prevents you from segmenting by product line. Sales to Intercompany Customer ABC for Product Line 1 and Product Line 2 would post to the same account as opposed to 2 separate accounts like they would for sales to standard customers. Is anyone aware of a way to achieve this without modifying the posting rules? I would prefer not to create a intercompany product groups and standard product groups because 1.) it’s just not logical to me to divide product groups by customer type (a wheel is a wheel no matter who I sell it to) and 2.) it would require the user to be very attentive to product group when entering sales orders and AR invoices or it would require some amount of customization.
Hi Daniel, If you resolved how to do this I would be interested as we want to do exactly the same thing.
Hi Jason,
Haven’t changed it yet but our plan is to just modify the posting rules.
@Daniel_Price
In the GL control code assigned to the intercompany customer remove the GL account in the sales context, it might work.