Company has four departments, each representing a physical store front. Inventory is setup to the main revenue, cogs, asset and accounts. The department can only be determined at the time of sale. So the invoice is generated, revenue department is chosen. The cogs department is picked up from the default department on the customer ledger. However customers can and do buy from more than one department. So we end up with sales to dpt 1 and cogs to dpt 2. A journal entry is easy enough to fix the cogs department. But, I need a report to ensure I am capturing all of these mis-matched sales/cogs transactions. Analyzing the sales & cogs GLs, line by line is onerous - I need a better way. Any suggestions?
78
166