Dynamic Account Sets AP

[praneelm]

Hi, I am looking for an add on for AP that will allow dynamic account sets for AP (the ability to change a segment for the control account). The goal is to have a sigle vendor that serves multiple regions and have this info going to the correct GL segment. Any assistance will be appreciated.Thanks.

 

[ettienne]

There is no such product. Accounting wise it is a stupid idea, your reports and control accounts will not agree.

 

[praneelm]

Scenario:

National vendor list utilised by regional offices.

Requirement: Balance sheet by office as each office is a seperate entity with interco purchases.

Creditors Control Account: 5000
Regional sub accounts: 10, 20, etc

Account Range: 5000-10, 5000-20, etc

Solution (not ideal): Account set to read 5000 as the control account and manual allocation via report using optional fields that roll up to ledger and manual split with report to balance. You could do a view (VB) and auto allocation to create GL journal to facilitate.

 

[ettienne]

Separate vendors for each office assigned to separate account sets and GL control accounts. Write something to produce a consolidated check for a single payment.