I want to use the Unit Rate to allocate billable expenses to a COGS account but the Unit Rate does not get pushed to the Project Transaction. I can’t find a “Known Issue”. Is this standard Acumatica?
I want to use the Unit Rate to allocate billable expenses to a COGS account but the Unit Rate does not get pushed to the Project Transaction. I can’t find a “Known Issue”. Is this standard Acumatica?
Hello
Can you try looking at a couple of places first:
Here’s a couple of help articles that goes into more depth about Unit Rates and configuring them:
https://help.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fce5bf02-bdfc-46d6-96cc-3d7ad15f9820
https://help.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=c12cd234-2ac9-2147-a687-fa3ccdaa1e29
Let me know if this helps, thanks!
Hello
As a work-around, please try calculating the Rate in the Allocation Rule, using a formula like ePMTran.Amount] / /PMTran.Qty].
I looked at a Sandbox 2024 R1 site and saw blank Unit Rate on manufacturing PM transactions. I can’t say whether different configuration options in various modules could change the Unit Rates.
Laura
Thank you for the suggestions. The configuration settings are correct. The Unit Rates cannot be standardized for the nonstock expense items because they will all be different. For example, if the expense is an airfare, one consultant will pay one price and another a different price, etc. There is a Unit Cost on an Expense Claim. I am questioning why that Unit Cost does not show in the Project Transaction automatically created by releasing the Expense Claim. This is a screenshot of the Expense Claim that created the Project Transaction (an AP PM). The Unit Cost is pushed to the AP Bill, but not to the PM Transaction.
Here’s the AP Bill:
I think this may be a data or a mapping issue within Acumatica.
OMT (One more thing). I try using a formula but is billable quantity is different from quantity, that will probably cause a lot of fractions that will skew the numbers. I do want to use PMTran.UnitRate in my Billing Rule and in the Allocation Rule. The projects are all T&M projects.
You have made a good point. When considering Billable Quantity may be different from the Quantity on the transaction, the formula to calculate billable amount might look like this:
=((PMTran.Amount] / PMTran.Qty]) * PMTran.BillableQty]
What if the transaction has Zero quantity and only contains amount? We may need an IF statement too, to avoid Divide by 0 error, something like:
If (fPMTran.Qty] <> 0,(0PMTran.Amount] / PMTran.Qty]) * PMTran.BillableQty], ]PMTran.Amount])
Laura
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.