Skip to main content
Question

How to enforce correct pairing of expense items with job costing on expense receipts?


Forum|alt.badge.img

Use case: We have some expense items configured to post to job-related GL accounts and others configured to post to G&A GL accounts.  How can we enforce the correct pairing of these expense items with projects on expense receipts?

Scenario 1: A user creates an expense receipt for the purchase of job materials and enters an expense item that posts to a job-related GL account.  How can we make the entry of Project/Project Task/Cost Code required for this scenario and prohibit entering Project X - Non-Project Code?

Scenario 2: A user creates an expense receipt for the purchase of office supplies and enters an expense item that posts to a G&A GL account.  How can we force the entry of Project X - Non-Project Code?

 

 

5 replies

iqraharrison
Captain II
Forum|alt.badge.img+8

@john55 i dont believe the functionality to make certain fields required based off the specific GL account is native to acumatica and would require a customization.

however, there may be some flexibility within the approval maps. in my sales demo i created a project approval map with the following conditions: 

i was trying to limit the maintenance required for this incase GL accounts are added/removed so giving it a range helped however, there were some other options available that you could use that may be better for your needs.

although it won’t prevent them from submitting the expense, it can help correct the errors before the receipt is released


Forum|alt.badge.img
  • Author
  • Freshman I
  • 30 replies
  • March 6, 2025

@iqraharrison Thank you for the suggestion, it’s an interesting alternative!


rfairchild58
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 32 replies
  • March 10, 2025

@iqraharrison Very interesting approach.


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 555 replies
  • March 10, 2025

@rfairchild58 ​@john55 i tend to get creative with what we have available within acumatica 🙂 it beats the alternative of having to customize! Acumatica is always enhancing the product and I see the value in adding controls to minimize errors and extra work.  i used to be a project accountant in a past life and as much as i enjoyed solving the occasional discrepancy between budget and actual, it’s can become overwhelming when it happens frequently!

May be worth posting on the ideas forum as well!


Forum|alt.badge.img
  • Author
  • Freshman I
  • 30 replies
  • March 10, 2025

@joelhoffman Joel, this is the post I mentioned to you last week.  What are your thoughts?  Is it already on your roadmap or shall I post an Idea?


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