Skip to main content
Question

Financials by Sales Channel and Product Line - Sub Accounts or Branches?


We are new to Acumatica and trying to wrap our heads around how branches and subaccounts work. Our use case is this:

One company, one warehouse with inventory. We sell B2B, B2C - Shopify, B2C - Amazon. We would like the ability to run a P&L based on sales channel and by product line. For example: P&L for B2B channel for product line X. 

From what I understand, only one subaccount can be used per line so we would have to choose whether we want to classify the line as a channel or a product line. I think if we create combined subaccounts, where channel and product line are combined, it would create major difficulty in data entry, along with preventing us from running a P&L based on just product line or just channel. 

Would adding a branch for each sales channel make sense? Then each transaction would have a branch and then a subaccount for the product line? Again, we would only have 1 warehouse shared across the company, so I’m not sure if this method would work. Happy to hear some best practices or opinions on this. Thank you in advanced! 

2 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 531 replies
  • March 19, 2025

  • Freshman I
  • 4 replies
  • March 19, 2025

@jkelleycpa 

You can get the desired ARM reports by either using Branch/Subaccount or Segmented subaccounts. That is true that you can have one subaccount “Key” but the segmentation will serve the purpose. In setting up your posting also you can chose which segment of a subaccount is coming from where.

As for the data entry by pressing F3 key on each segment of the subaccount you will get the list of available values of the segments (if you don’t know top of your head) by setting the Lookup Mode of the Subaccount in Segment Keys screen to By Segment.

As for the ARM Reporting, in Unit Set definitions you can use ? wildecard. So assuming your first segment is channel and second is the product line, for channel you can enter 111???? and ZZZ???? in the Subaccount from/to fields and swap the ? for product line.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings