GL sales postings using item class AND customer group

Hi @McAuley ,

Please check “Posting Class” in Acumatica. There you can define both Sales account and Cost of Sales Account. You can attach the Posting class to an Item Class.

You can define Sales account on the Customer Class (customer group) level too but not COGS account.

Regards,

Umesh

Hi Umesh

Thanks for your reply.  I have looked but creating the combination logic didn’t appear possible.  My example would be:

Item class 1 sold to customer group A needs sales to go to GL 1000

Item class 2 sold to customer group A needs sales to go to GL 1200

Item class 1 sold to customer group B needs sales to go to GL 1300

Item class 2 sold to customer group B needs sales to go to GL 1400

Hope that explains what I am needing to do

thanks again

Peter

@McAuley 

You can accomplish this by driving G/L accounts from Customer location. You can define a specific sales account by Customer location and specify the system to take the Sales account from Customer location on the sales order type. Please see below -

Hi

Unfortunately that does not appear to recognize the different item classes the customer buys.    I'm looking for customer group and item class to determine GL account.

Thanks

Peter 

Thanks, I’ll cross my fingers that Acumatic builds into standard functionality.