Skip to main content
Solved

WIP Reversal for WT Material


ctaylor56
Hero (Partner)
Forum|alt.badge.img+14

I have setup work task cost codes and rules to reverse WIP at CO Line Invoiced and I am only doing this for material.  When I issue material on a work task I see the cost code.  I then transfer inventory and update the GL.  I then proceed to invoice the Work Task and post the customer invoice.  I then re-run the transfer inventory (and reposting job) but I am not see the WIP getting reversed.  If I manually release WIP and Check and Update accounting, this works, but I need the automatic to work.  Has anyone had this issue with Work Task Material (M50)

Best answer by Thommy

I had a chat with a collegue of mine on this. It could be that the non-invoiceable can effect this (even though it shoudn’t).

What I would suggest is to create a support issue on this, so we can do a proper investigation to see what is stopping these material lines from being reversed from WIP.

That would be the best way forward.

View original

11 replies

Thommy
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 199 replies
  • September 28, 2022

Hi @ctaylor56,

Since manually release WIP and Check and Update accounting is working, the setup is correct.

My guess that why it isn’t working is that the WIP condition isn’t met.

WIP Reversal Condition - CO Line Invoiced : WIP will be reposted and transferred to final accounts when the customer order line is invoiced

Are you certain that the CO is in status Invoiced?

Your question is tagged with App10 - what update are you on?


ctaylor56
Hero (Partner)
Forum|alt.badge.img+14
  • Author
  • Hero (Partner)
  • 163 replies
  • September 28, 2022
Thommy wrote:

Hi @ctaylor56,

Since manually release WIP and Check and Update accounting is working, the setup is correct.

My guess that why it isn’t working is that the WIP condition isn’t met.

WIP Reversal Condition - CO Line Invoiced : WIP will be reposted and transferred to final accounts when the customer order line is invoiced

Are you certain that the CO is in status Invoiced?

Your question is tagged with App10 - what update are you on?

UPD 14 is the update.  But you had me thinking, these material lines are set as non-invoiceable.  Would that be the issue the condition is “not being met” and not auto reversing? 


Thommy
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 199 replies
  • Answer
  • September 29, 2022

I had a chat with a collegue of mine on this. It could be that the non-invoiceable can effect this (even though it shoudn’t).

What I would suggest is to create a support issue on this, so we can do a proper investigation to see what is stopping these material lines from being reversed from WIP.

That would be the best way forward.


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 36 replies
  • June 24, 2024

Was this ever resolved? We have noticed the same on our UPD17 install.


Thommy
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 199 replies
  • June 25, 2024

This have been handled by case G2248239-E.

Fix applied on App10 Upd14 and 22R1 and onwards.


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 36 replies
  • June 25, 2024

Do you mean there was a fix for UPD 14, but not again until 22R1?


Thommy
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 199 replies
  • June 25, 2024

The fix for App10 UPD14 is carried through to all futher UPD in App10.

But for Cloud this isn’t working the same until 22R1 and onwards.


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 36 replies
  • June 25, 2024

K, as far as I can tell this is happening with labor transactions but on a UPD17 install. 


Thommy
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 199 replies
  • June 25, 2024

Have you set Revenue % to zero with the “No Revenue” command?

The underlying problem in the above process was that the state on the Sales line was set to Not Invoicable and by that they were not transferred over to CO and by that the WIP reversal condition wasn’t achived.

What was done was that the option of manually setting Revenue% to zero was introduced and by keeping the state as Invoicable the sales line will be transferred over to CO and WIP reversal condition will be achived.


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 36 replies
  • June 25, 2024

Yes, but in this case we would prefer the item not being transferred at all, and still the line being reposted. That option you showed does work, I confirmed that yesterday in my tests. 

 

Another option I was considering was to make another code code maybe? But, not sure that is much better and it will require changes to the flow the users might need to adapt to.

 

Thanks for the help BTW. Appreciate it.

 


Thommy
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 199 replies
  • June 25, 2024

Ok, I see. With WIP Reversal Condition set as “Transferred To CO” or “CO Line Invoiced” the lines needs to be tranferred over to CO in order to hit the condition.

Perhaps “Task Finished” or “Task Completed” would work better in your case.

Happy to try to help.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings