GL Account Issue invoicing/items

[boston_george]

Default Sales Account

--------------------------------------------------------------------------------

How do you make the sales general ledger account in the customer master override the sales account in the item master when selling product?
I am selling the same inventory item to several customers. I want to track sales and profit by customer so I have set up separate gl accounts for each customer. When I invoice customers the system reports the transaction using the gl account that is in the item record. What do I do to have the customer gl account override the item gl account?

[rick Prindivill]

How do you make the sales general ledger account in the customer master override the sales account in the item master when selling product?

This feature is functioning as designed. You can manually adjust on a per Invoice / Line basis but you cannot automate the change that you are asking for. It is impractical to have one GL Sales Account for each Customer.

You would be best off to allow the program to function as designed and to then create a custom report to provide you the Sales Analysis desired.

[Markr1306]

wouldn't the canned report of Items sold to customers give you the info you need, or else you could set up" job numbers for each customer and charge sales tranactions to those job numbers. But I would first look at the items sold to customer canned report.

[bfoxwell]

How do you make the sales general ledger account in the customer master override the sales account in the item master when selling product?

This feature is functioning as designed. You can manually adjust on a per Invoice / Line basis but you cannot automate the change that you are asking for. It is impractical to have one GL Sales Account for each Customer.

You would be best off to allow the program to function as designed and to then create a custom report to provide you the Sales Analysis desired.

Thats the most stupid thing I've read on this forum. It's much more impractical to go into journal mode on every invoice and reciept screen and manually enter the sales account you want each line item to go to. In my business, when I look at an income statement I want to see my sales broken down by customer category not by inventory item categories. I think the guy who opened this thread hit the nail on the head for a lot of businesses and peachtree should let us choose how to determine the gl sales account an invoice goes to. Is a ton of extra work if you care more about where your sales are going than what your selling. Theres lots of better reports for that in the inventory module.

[Dolores]

I have a client that tracks sales by state rather than inventory G/L account and we have done this in Sage BusinessWorks. BW allows you to post from inventory or customer default. People have different reasons for posting to various g/l accounts. I know I have other clients that want the posting to come from the client also so that is not unusual.

Dolores

Dolores Ricci-Norcott, CPA
Business Technologies of New England, Inc.
drn@btne.com