Skip to main content

We are migrating from APP9 to Cloud. In APP9 we use prepare work order quotation and create the work order. When these migrate to Cloud, a work order is created with an attached service quotation. Migration also creates 1 work task per tool line on tools and facilities tab and a final work task which has all planning, materials, time reports lines. When I add new planning, materials or time reports line, go to Conclude Work Order, and create invoice preview I do not see any of the new sales or cost lines in the preview. This is an issue because our process will be to transfer all cost and sales lines (they are invoiceable on work task sales tab) to the customer order eventually so they can be recognized in financials. Does anyone have suggestions? This problem doesn’t exist when I create a new work order and work task. Creation of a new work task to overcome the issue will come with a lot of additional work because those planning, time report and materials lines will be needed on the working work task for certain reporting. 

This sounds similar to a challenge I’ve ran into. Double checking with my migration team. 

What tool are you utilizing for migration?


@CSheprutterkey  Work orders were migrated by the main upgrade script during installation. We did noticed that while I cancel the Service Quotation which seems to disconnect the link from the Work Order, the Work Task still has a link to Service Quotation. It cannot be deleted and we’re looking at doing so in the background to break that link and see if that could be an issue as well. Any info you can share is greatly appreciated.  Thank you!


@CSheprutterkey  just checking if you’ve been able to get any further information from your migration team or if you did not have this same / similar issue? Thanks much!

 


Hi ​@jenjen0510,

I appreciate the grace in getting back to you. We didn’t encounter the issue during an upgrade but seems the script mapping is incomplete maybe?

The logic for work task is all transactions (reported time, issued materials) will create cost lines, cost lines would match to sales lines on the sales tab. 

When reviewing the sales tab on work tasks do you have sales parts listed? 


@CSheprutterkey this issue is not with migrated transactions, but with all newly reported transactions not being available in invoice preview screen despite being seen on sales tab on work task and sales tab on conclude work order. We did not encounter this with newly created work orders / work tasks so that is why it’s a mystery. 


@jenjen0510,

That is interesting. 

If I’m understanding this only happens for new transactions added to migrated work orders?

 

@RutPattyG , could those records be getting locked? 


@CSheprutterkey it seems the issue lies with the service quotation. While the service quotation was cancelled which disconnects from the work order, it’s still really connected in the background to the work task. So any of the new transactions are basically “not allowed” but also do not through an error message. We’re doing background fixes to remove those links and doing some further testing.

 


Reply