Skip to main content
Solved

How to run automatic Reversal Allocation?


Forum|alt.badge.img+3

hello all,

I am looking for ways to let Acumatica run the Reverse Allocation automatically whenever an AR Invoice is generated or released. I setup the following allocation rule, but I am not able to see if any reversal trxn has been generated anywhere.
 

I would like to run the reversal automatically like it does to create an allocation Project trxn.

Best answer by meganfriesen37

Shoot… sorry, I missed that this was progress billing.  Have you populated your WIP account on the Project Tasks screen?

From the help documentation: https://help.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=c17cd111-2aab-4e6e-a687-f13aa1bb1e16

Configuring Fixed-Price Projects for Allocation

On the Projects (PM301000) form, for a fixed-price project to be allocated, you assign the created allocation rule to the project tasks on the Tasks tab.

You bill a fixed-price project with a billing rule with a Progress Billing step that does not use project transactions, including allocation transactions, for billing. To make the system automatically reverse created allocation transactions, which prevents the allocation transactions from affecting the project balance after you bill the project, you select the WIP account group to which you allocate the project costs in the Non-Billable WIP Account Group box on the Summary tab (Billing and Allocation Settings section) of the Project Tasks (PM302000) form.

 

 

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

5 replies

meganfriesen37
Captain II
Forum|alt.badge.img+11

The reversal is when the AR invoice is released, so if your Invoice is generated but not released, you won’t see the reversal entries yet.

Once the invoice is released, in project transactions, you should see two transactions

  1. One for the invoice release
  2. One for the allocation reversal

Both of these will also create journal entries.  Do you have Automatically Release Allocations turned on in your Project Preferences and Automatically Post on Release on your AR Preferences?  The AR invoice needs to be posted all the way through to the GL.


Forum|alt.badge.img+3
  • Author
  • Captain II
  • 317 replies
  • June 21, 2024
meganfriesen37 wrote:

The reversal is when the AR invoice is released, so if your Invoice is generated but not released, you won’t see the reversal entries yet.

Once the invoice is released, in project transactions, you should see two transactions

  1. One for the invoice release
  2. One for the allocation reversal

Both of these will also create journal entries.  Do you have Automatically Release Allocations turned on in your Project Preferences and Automatically Post on Release on your AR Preferences?  The AR invoice needs to be posted all the way through to the GL.

Hey @meganfriesen37 , the allocation rule is set to run automatically once a payable bill is released. So once the Allocation is released, I ran the project billing which created an AR Invoice, I released it manually but no project transaction was created.


meganfriesen37
Captain II
Forum|alt.badge.img+11

Does your billing rule use a GL revenue account that has an Account Group on it so that it can post to the project?


Forum|alt.badge.img+3
  • Author
  • Captain II
  • 317 replies
  • June 21, 2024
meganfriesen37 wrote:

Does your billing rule use a GL revenue account that has an Account Group on it so that it can post to the project?

I have not setup any billing rules. Its just I run the project billing & I have defined a default sales account for the task under Tasks tab that belongs to a revenue A/c group.
Whereas I tried to run the same using a billing rule as shown below:
 

So in order to test the reversal allocation, I manually filled in the COmpleted% under Revenue Budget tab and then ran the project billing.


meganfriesen37
Captain II
Forum|alt.badge.img+11

Shoot… sorry, I missed that this was progress billing.  Have you populated your WIP account on the Project Tasks screen?

From the help documentation: https://help.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=c17cd111-2aab-4e6e-a687-f13aa1bb1e16

Configuring Fixed-Price Projects for Allocation

On the Projects (PM301000) form, for a fixed-price project to be allocated, you assign the created allocation rule to the project tasks on the Tasks tab.

You bill a fixed-price project with a billing rule with a Progress Billing step that does not use project transactions, including allocation transactions, for billing. To make the system automatically reverse created allocation transactions, which prevents the allocation transactions from affecting the project balance after you bill the project, you select the WIP account group to which you allocate the project costs in the Non-Billable WIP Account Group box on the Summary tab (Billing and Allocation Settings section) of the Project Tasks (PM302000) form.

 

 


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