You can update the Sales GL or COGS GL on the line with a script during data entry.  Also, if it is based on the Product Line, can't you just set up the Product Line GL correctly in IM>Setup>Product Line Maintenance?

I need to change the A/R Account from the Division Maintenance to the new GL Account.

Product Line doesn't have an A/R GL Account.

Regards,

The AR Control account is automatic, depending on division settings and cannot be overridden.  If an invoice is partially one PL and partially another, how would things be split?  Discounts?  Taxes?  Freight?  It is logically and technically not possible.

The AR Control account is automatic, depending on division settings and cannot be overridden.  If an invoice is partially one PL and partially another, how would things be split?  Discounts?  Taxes?  Freight?  It is logically and technically not possible.

Hi Kevin,

Thanks for the help.  I thought that wasn't doable but i had to give it a try.

Really appreciated.

Regards,

Manuel Roman

While I agree with your statement, and the best practice being that you should setup divisions to control the balance sheet accounts, how about changing the Freight Account, based on a UDF Value, during the SO Sales Journal Update?

By script?  Not possible.

Custom programming by a Master Developer?  Probably possible, but seems like overkill.

/M or /FREIGHT as a misc charge line would easily allow freight amounts to post to a custom account.