Skip to main content
Solved

How to allocate project transactions multiple time?

  • February 15, 2022
  • 4 replies
  • 641 views

I have a client with the following requirement:

When they process a proforma invoice there can be a delay of 2 to 3 weeks before the customer agrees on what they are going to accept on the bill, and they can process the AR bill, which may be over a period end. They want to be able to record a type of WIP entry, debit WIP and credit Accrued Revenue, for the value of the Proforma invoice so that the revenue is recognised in the period in which the proforma invoice is raised.

I have looked at how this could be achieved and cannot see how to achieve this. The Allocation Rules essentially cover the posting of WIP when project transactions are created and are then reversed when the when the AR bill is generated/released.


I tried to create two tasks:
On one task, I create an allocation rule to allocate Cost to WIP.
On the second task, I created an allocation rule to allocate WIP to Unbilled/Accrued Revenue, and Billing Rule to select from Unbilled Revenue and post to Revenue.

But it seems that when I run allocation once, it works fine. when I ran allocation the second time to move from WIP to Unbilled, no allocation transaction is generated.

How can we allocate project transactions multiple times, or is there any cleaner way to achieve the above scenario?

Best answer by Laura02

There is an option on the second tab of Allocation Rules, “Can be used as source in another transaction.” Do  you have this option checked ON?  I expect with this option checked on, the same transaction just allocated can be re-allocated using a different allocation method, later.

View original
Did this topic help you find an answer to your question?

4 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • February 15, 2022

There is an option on the second tab of Allocation Rules, “Can be used as source in another transaction.” Do  you have this option checked ON?  I expect with this option checked on, the same transaction just allocated can be re-allocated using a different allocation method, later.


  • Author
  • Freshman I
  • 5 replies
  • February 15, 2022

Hi @laura01 , yes, I did tick that option. when I tried to run the allocation the second time, the system says “no allocation transaction is created”.

I’m not sure if that tick allows reusing the allocation transaction within the same rule (just different steps), or that allocation transaction can then be used for another allocation rule. How do you normally use that tick?


Heidi Dempsey
Community Manager
Forum|alt.badge.img+2
  • Community Manager
  • 269 replies
  • February 16, 2022

@leonchau80  Allocation rules can be pretty complicated.  Please feel free to reach out to me to discuss different options heidi.dempsey@acumatica.com


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2751 replies
  • March 7, 2022

Hi @leonchau80 were you able to figure this one out? Thank you!


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