Skip to main content

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.

@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.

@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.

@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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved