Differerent Control Accounts for Different Divisions

1

We have a sales and a service division. ARs are currently booked to different control accounts (AR from sales and AR from services). However, we do have customers that fall into both categories and it seems that

  1. you can either set no control account for a customer, in which case ARs will be booked to “accounts receivable”; or
  2. choose either one of the control accounts, in which case all ARs will be booked to the chosen account (either sales or services).

Is there any way to chose to which AR account ARs will be booked other than setting a control account?

The only idea I could come up with was creating two customer masters (one for sales and one for services and assigning the respective control account) but this is cumbersome and prone to mistakes/errors.

I am thankful for any help/ideas.

2

Having two customer accounts is the only way to separate the Accounts Receivable balance by type of Sale

3

Ideally, this should be handled by Advanced Queries on Sales Invoices - Lines, however, this feature isn’t mature enough yet because:

  1. Group by still doesn’t summaries Qty and Amount field.

  2. You cannot get merged data from Sales Invoices into Sales Invoices - Lines, which would be a great buff to Advanced Queries.

Meanwhile, though what you and @Joe91 propose is possible, however, I don’t see any net benefit in duplicating your work over multiple accounts per customer.

Personally, I would rather Copy to Clipboard both:

  1. Sales invoice Advanced Query --> where: Balance due is more than 0

  2. Sales Invoice - Lines tab with Division field showing

From there you can paste in a spreadsheet, calculate the % outstanding, then look that up into the lines sheet and apply this to line amounts.

If you save this as a template, this will give you the report you are after.

5

Thank you @Joe91 and @Ealfardan. The reason to split our ARs in the first place was so they can be easily seen and distinguished in the Summary and BS. It’s a pity that this isn’t working.

While extracting the information from a report is probably possible, this is far more cumbersome than looking at the BS.

Nonetheless, thank you for your input and your detailed suggestions. It seems to be the only workable solution for now.