Need to post to 2 different AR accounts for each customer

A prospect's current AR system receives imported transactions from two external systems, one for Transportation, one for Warehousing.  We plan to replicate this by using a VI job.

Transportation and Warehousing are "divisions" in their terminology.  They post to different AR control accounts, sales accounts, etc.   AR reports, particularly the AR aging reports and trial balance must be able to be produced by these "divisions".  Any customer can be both a Transportation and Warehousing customer.   The distinction is which external system originated the trasnaction.  There are no overlapping "items" (everything will be a non-stock item) for each type of business (i.e., FREIGHT will belong to Transportation invoices, PALLETS to Warehouse, etc), and every invoice will be for only one division.

So far, the only way to resolve this that I have thought of is to use National Accounts and set up two customers (e.g., 01-ABC and 02-ABC) but they're not thrilled by this option.  They have 10,000 customer records as it is.

Is there another/better way to approach this?

Parents
  • 0

    Reports are relatively easy to sort / group with report customization, but the GL transactions routing to different accounts is based on certain rules.  Sales / cost accounts can be overridden in the data entry tables (via script if necessary) but your limiting consideration will be the AR Control accounts.  AFAIK, these are linked to the Division, set during the posting process, without the possibility to override.

    It's possible there may be an enhancement to do what you want, but I know of none. 

Reply
  • 0

    Reports are relatively easy to sort / group with report customization, but the GL transactions routing to different accounts is based on certain rules.  Sales / cost accounts can be overridden in the data entry tables (via script if necessary) but your limiting consideration will be the AR Control accounts.  AFAIK, these are linked to the Division, set during the posting process, without the possibility to override.

    It's possible there may be an enhancement to do what you want, but I know of none. 

Children
No Data