Skip to main content
Solved

Create multiple project allocations and reverse only one.


bryanb39
Pro II
Forum|alt.badge.img+6

I’m looking for a two step allocation where the first step posts a correction the sub account, then the second step would allocate to WIP. 

Then when the invoice is release have it auto release the WIP allocation, but not reverse the first step where the sub account was corrected.  

I can get it to do multiple steps and post the first correction, then the second WIP Entry, but it’s combining them into a single Allocation and Journal Entry.

I have it set to never reserve the first step, only the second step, which seems like should tell Acumatica those need to be 2 separate Project Allocation transactions.

Best answer by Heidi Dempsey

@bryanb39  

The only way an allocation rule can be reversed is if the new transaction being created is included in the billing rule. 

Example:  The second step on your allocation rule will debit WIP and credit expense.  The WIP account group needs to be on the billing rule. 

If you are using progress billing, then on the task you need to list the non-billable WIP account group and upon billing the amount in the WIP account will be reversed.

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

3 replies

Heidi Dempsey
Community Manager
Forum|alt.badge.img+2
  • Community Manager
  • 269 replies
  • Answer
  • August 20, 2024

@bryanb39  

The only way an allocation rule can be reversed is if the new transaction being created is included in the billing rule. 

Example:  The second step on your allocation rule will debit WIP and credit expense.  The WIP account group needs to be on the billing rule. 

If you are using progress billing, then on the task you need to list the non-billable WIP account group and upon billing the amount in the WIP account will be reversed.


bryanb39
Pro II
Forum|alt.badge.img+6
  • Author
  • Pro II
  • 177 replies
  • August 20, 2024

@Heidi Dempsey I have the auto reversals working, but I don’t want to reverse everything in the transaction, only the 2nd step of the allocation rule.  

So ideally if it can create two transactions, but only reverse the 2nd transaction.


bryanb39
Pro II
Forum|alt.badge.img+6
  • Author
  • Pro II
  • 177 replies
  • August 20, 2024

@Heidi Dempsey Thanks so much for the help.  

She showed me a couple things I was missing:

 

I can I set the Non-Billable WIP Account since I was using progress billing and it would use this to reverse at billing.  

Or

I can use the Reverse Unbilled Transactions process to reverse just the line items of the project transactions I want reversed.  

 


Thanks again @Heidi Dempsey for untangling my Project Allocation rule mess. 

Bryan


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