I am still exploring the option of moving all my invoicing from a third party billing system to order entry. I have solved a number of items but have two questions I thought I could throw out.

1. It seems to me that the Category code drives the posting account number in the GL. Can that be split to multiple GL revenue accounts? I have items (services that we sell, not really products but I am setting them up as inventory items) that should be broken up to 2 or 3 seperate GL revenue accounts and not just one (as we are doing now). I am unsure how to achieve that same objective in OE when it pushes to GL.

2. We often have seperate "bill to" contacts and address in our current billing system. It does not appear that OE (or actually receivables) has the option to create multiple "bill to" contacts. My thoughts were to use the "ship to codes" as the bill to if I need an override from the base "bill to". I can many ship to codes. I thought I would be able to set the invoices specification file to pull the "ship to" instead of the "bill to" to accomplish this. Not every customer would need this, but we have one market segment (engineering consultants) that demand invoices get routed to seperate project managers (often different locations and of course, different names). Would that work for us? Or maybe someone has a different thought on it?

Thanks for the imput!

1. You can have separate lines on an invoice with the same item number and select different categories.

2. You need to set up each "Bill to" as a separate customer. If you will be receiving payments for multiple "customers" from one source, investigate Dakota Software's National Accounts that integrates with Adagio Receivables.

Thanks for the reply, Ralph.

1. That is helpful as far as invoicing goes. However, I would say not exactly what I was hoping for. I will be importing orders from my third party software which will basically say 3 of "X" item. I am hopeful to lower the amount of manual manipulation of the line items so I would prefer to have the 3 x "X" show up as one line on the invoice. I was further hoping that the category can be pointed to multiple GL revenue codes. It sounds like it can't.

2. I would also prefer to not set up multiple customers to solve a "Bill To" issue as that would make my life more difficult since I would have to mirror the new customers in my third party software that would feed the order importing. Plus, I don't like that idea since all of my sales data would give me seperate customers on a report instead of consolidating the data to show me the overall picture of the single entity. In the instance that I was discussing, we "Bill to" many locations and project managers, but we receive one check for the entire organization. (customer)

I guess I will keep scratching my head on how to make this work.

Hi Jim,

1) If a category pointed to multiple g/l accounts, how would the program "know" how much to send to each account? A change was made in version 8.1C of OrderEntry. From the release note:

This might help you solve the problem. If your LMS can send over a separate line for each item, but use different price lists, then you can pick up a different categroy and hence a different revenue account.

2) Have an AR account for each organization that sends you payments. Set up an Adagio "ship to" address for each place you bill. Create an invoice specification that showns the "Ship to" address in the "Bill to" section. Wouldn't that work? (Adagio SalesAnalysis allows you to do analysis by ship to code if necessary.)

1. If the revenue distribution is consistent, you could handle it in Ledger. Set up the Revenue account on the Category so that in Ledger, it is 'Reallocated' to other Ledger accounts.

I haven't considered that since I have never utilized that function in GL. I think that would work. The allocations are indeed fixed by percentages (30% to a prep department and 70% for an analysis department as an example) I will take a look at it. Thanks for the tip!

Andrew, I would agree, I think utilizing the "ship to codes" as "bill to" for the multiple "bill to's" that I need would work as long as the invoice spec file is setup that way. That is what I thought I would have to do, but wanted to see if there was an alternative.

I think the project is starting to come to focus where I can actually move away from the theory of the "how" to giving some things a try now that the plan is coming together in how things would work.

I appreciate all the feedback. You guys are great.

The revenue distribution will work wonderfully. Thank you for directing me to it!