Multiple Sales and COGS GL Accounts one Inventory Item

Question

Hey folks,Got a question:Let’s say a customer is selling a stock item in 2-3 different contexts:     a. Over-the-counter item sold at the store (has it’s own account for COGS and Sales).     b. Same item sold in the context of a service call to a customer  (has it’s own account for COGS and Sales).         c.  Item provided as a warranty item or according to a contract (has it’s own account for COGS and Sales).As far as revenue and cogs go, how does the system know where to allocate those two transactions for the same part in inventory in different scenarios?  Can you have just a single inventory item that can be used in different contexts without having to manually change the GL entries each time?

lbarker · Accepted Answer

You can use Reason codes. The sales account can come from the reason code.

Maybe have multiple sales order types too maybe to help identify reason codes. There is a customisation on Github to make a default by type

https://github.com/Acumatica/SalesOrderTypeDefaultReasonCode

OR

Perhaps consider using e customer location. You can have locations on every customer for WARRANTY / COUNTER / SERVICE which you can auto add using a business event when a customer is added, but this is for all items sold on the sales order. Just depends on if its related to the item or the entire order

Is subaccounts not rather a solution than using different GL codes? They can report on the subaccount or even branches which could be warranty / counter /service rather

jaymarzian · Answer

@lbarkerWanted to say thank you for your response. I was able to implement a solution using Reason Codes for Sales Accounts for my customer. I would love for them to utilize subaccounts for both sales and cogs, but they do not want to do that. Anyway, they were pleased with the Sales account solution. Thanks again!

Multiple Sales and COGS GL Accounts one Inventory Item

2 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded