Does anyone have any recommendations on how to set up product groups to allow intercompany transactions to post to different revenue and COS accounts than sales to third-party customers. One thought I had was to add UD field to Part Maintenance to hold Intercompany Product Group for each part, assign the product group with the proper GL Control Code, and then use a BPM to assign the correct product group on Sales Orders/AR Invoices based on whether the customer is an IC trader or not. The issue I have with this is that my list of product groups now balloons to twice whatever my original list was. I just don’t think it’s logical to divide product groups based on customer type. A wheel is a wheel no matter who I sell it to. I don’t want to have WHEELSIC and WHEELSEX as product groups. Is there another way to accomplish what I’m asking besides modifying the posting rules? Or is my best bet just to create an intercompany and external customer product group for every natural product group that I have?
Look at the GL Control on the Customer / Billing / GL Controls. We use this successfully for Revenue reporting. Have not tried changing the COS GL Accounts associated with the GL Control, but you could test it. As you probably already know, these are set via GL Control Maintenance / Account / List.