Any ideas on how to achieve this?
The situation: We have two companies that are running from the same premises with the same staff covering both sides f the company. One of the companies is a supply company and the other is a service providing company .Most of the materials bought by the service company comes from the supply company (however not all). This is resulting in intercompany transactions back and forth. Our idea is to have one warehouse(in the system and in real life) for both companies. This will result in an Amount ‘Due to’ and ‘Due from’ for each transaction between the two companies( we have this configuration working and set up already). However we do not have the capability to recognize a Sale, COGS, the Profits for the intercompany sale when stock from the supply company is sold by the service company directly from the supply companies warehouse in Acumatica. Essentially we would like to set up that all goods purchased by either company are stored in 1 warehouse( in the system), the supply company. Then when sales are made ,all sales of stock will derive from this single warehouse. However we would like there to be an automatic journal / GL entry for the "sale" between the service company and the supply company at a 10% markup as the service company is selling the supply companies stock.(for items that the services company originally purchased and are sitting in the warehouse. The sale will simply reverse the ‘due to’ and ‘due from’ originally created , and the sale and Cost of sales will be recognized in BH). Is there a way that we can have this performed for every transaction where the service company sells an item that’s in the supply companies warehouse and the system automatically creates the intercompany GL entries for a intercompany sale. Then we would no longer require the PO, SO, bill, invoice, PO receipts, shipment etc for each intercompany transaction.
