G/L Accounts not auto populating in A/P Bills and Adjustments for Construction Projects
I have a question that was brought up by a client. When we setup a project and it’s linked to a Task Code and Cost Code, why does it not auto populate the Account under Bills & Adjustments after a project, project task and cost code are selected? Is there a setting I need to do to make this happen or would we need a customization? Here is a screenshot. On the Project Level under Defaults, I defaulted the Task to the account code. That didn’t work either. Any suggestions would be great.
Thanks,
Frances
Page 1 / 1
In your Project Cost Budget check if you have entered Account Group for this Project/Task/CostCode. If yes then check to see if the associated AccountGroup is Active and any GL Account is linked to the this AccountGroup and is set as default. It is the only reason.
When you enter AP Bill you also MUST enter Project/Task/CostCode/AccountGroup to system populate the associated GL.
If you have row level security that could cause issue as well but first check the above
@aaghaei
Hi,
I checked the Account Group and it’s active and marked as Default. There is no row level security. Is there any other options or will the user have to select an Account manually when entering an A/P Bill for a project?
Thanks,
Frances
Did you check your cost budget Account Group associated to the Cost Code in question? Are you entering the Account Group in your bill? I do not see it in your screenshot.
Sorry my bad. It is opposite. You enter the GL Account in Bills and system posts to the associated Account Group.
The reason system doesn’t pickup the AG is there could be many AG associated to any given Cost Code.
You must enter the GL Account in AP Bills. If you do not like it and want to enter Account Group in AP Bills and system populate the GL Account for you, then you will need a Customization
Reza,
Thanks this makes sense. I know on the A/R side it does auto populate. Maybe we should submit as an enhancement?
Frances
Sure you can create an idea and let see how people will vote on it. It has a huge undertaking for Acumatica I believe because all Financial Modules work the way you see now and that will require a decent overhaul and implementation for this functionality across the platform. Good luck
@fpantelidakis65 Thanks for the question. This is on our roadmap but there is not version assigned to this yet. I will check in our team meeting tomorrow and get back to you.
The Expense Account and Expense Sub. can be set for a vendor (on the Vendors form). So, they can be used as defaults in bill lines for this vendor:
Account group (for a corresponding project transaction) will be defined by the account mapping (to the account group).
As of now, there is no option to specify project-specific default expense account/subaccount for bill lines.
Thank you!
cc @Heidi Dempsey
@AdelinaBasyrova75@Heidi Dempsey if this feature is not going to be implemented, can the language around existing settings be updated to be coherent at least? Why is their a field labeled “default cost account” when it doesn’t function as a default cost account and Projects has no ability to dictate a default account to AP transactions??
