Hello friends, Let me ask a question for a change ;)
In essence, I am using an item to bill a fee within a project, a dirty trick as old as Axapta.
I have an item, which is essentially a service, but it represents a limited internal resource: a capacity of a team of photovoltaics montage workers. They are a limiting factor, and I want them to be included into the CTP (capable-to-promise) calculation. Therefore my service item became a stock-able Product (!) with a physical negative quantity, and it is a production route with a limited capacity.
OK, the CTP calculation works flawlessly. Now I need a margin on this service. I do not want to repeat the service as a Project fee, because
1) A Fee has no cost price, but my service has one;
2) The margin calculation in the Project quotation is broken and does not take the sales unit conversion into account, while the margin calculation in a Sales quotation is correct.
3) The Project quotation printed layout is cr*p, you cannot show it to a customer.
The margin calculation is ok now. The service has a cost price which is compared to the sales price (bulk sum, all included, DE: Pauschalpreis) on the quotation. The Quotation printout is beautiful too.
Now my project is complete, and I bill (T&M project) all items delivered to the customer, including the service. I get my revenues posted, but aside of the revenues I also become a "cost" of the service in my project ledger. This was actually expected and afraid of, however the real cost comes from intercompany project timesheets.
Here is my dilemma: I need the service item costs in the margin calculation, but I don't want them posted - doubled - in my inventory and the project ledgers.
Any fresh ideas?
