There are two ways to substitute G/L segments.

The first is based on customer division numbers and the second is based on warehouse codes (they are mutually exclusive).

The setup can be a little involved so you might want to discuss with your Sage Partner.

I do find that it is not uncommon that these two ways of doing things do not always meet the exact needs. Recently I came up with scripting that could modify the g/l accounts based upon a user-defined field on the invoices. In my case, the client wanted inventory items sold from the parts department to go to a different g/l account than those sold via the service department.

Hi Tom
I see, I thought that it may be something in the setup in somewhere, now I know why I have customer under 10- for local branch and 20- for a branch in another location, this two have a GL sales 0000-10 and 0000- 20 assign, the new branch even though I did assign 50-, is the one that I want to give the GL 0000-50 for sales.
Thank you Tom then I will call sage see what happen
Thanks once more.

Yup. You just discovered the one disadvantage of the A/R division method. Multiple accounts for essentially the same customer (which may or may not be what you want).

So essentially you really already have it set up? If it is not already set, go to A/R Division maintenance and set the g/l substitution for division 50.

Tom,
This option was available but the GL sales code is not in this option. any info or steps on how place the code in this table?


(default table)

Accounts rec. 0000-00
Cash sales 0000-00
discount allowed 4200-50
Freight 4100-50
Sales Tax 2100-50
finance charge 9500-50

sales code is missing

So you don't show a section beyond finance charge that says "Post to:"?

If you don't see it,  then you are not set up properly.   If you don't see that I'm not quite sure how you are already getting substitutions for different customer divisions.

Picture above is kind of small.   Click on it to see it bigger.

 

your shows at that bottom some options, for some reason in my does not. I will check on it I will let you know.

Thank you Tom

Tom, I was looking in AR setup and there is an option in there, under the main tab I just change an option in the SEGMENT SUBSTITION and now shows a similar information. Thanks lot for your info.

Be careful. Your earlier posts were suggesting you were getting some sort of substitution from somewhere, but I'm not clear where. If you change the options, watch your postings carefully to make sure you aren't getting any unexpected consequences.

Probably not a bad idea to make a backup company and test it there.