x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Business Object Interface GL Account change in SO Daily Sales Updates

GL Account change in SO Daily Sales Updates

Posted By mroman over 5 years ago

Hi Forum,

Is there a way to write a script to change a GL account based on a Product Line during the Daily Sales Update process?..

I cannot find a module to add a script to. When i right click to select the User-Define script option is not available.

Any inout will be greatly appreciated.

Regards,

Manuel Roman

Parents

hyanaga over 5 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
mroman over 5 years ago in reply to hyanaga

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,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

mroman over 5 years ago in reply to hyanaga

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,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Kevin M over 5 years ago in reply to mroman

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
mroman over 5 years ago in reply to Kevin M

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
jonwes over 4 years ago in reply to Kevin M

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Kevin M over 4 years ago in reply to jonwes

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel