Solved

Last Cost Transaction Date on a Project

  • 7 September 2022
  • 5 replies
  • 92 views

Userlevel 1
Badge

Hi

Created a GI showing lots of details on projects and their cost and revenue budgets.    I can pick up the last invoice date ok but now looking for the date of the last cost transaction on the project anyone managed to populate this date?

icon

Best answer by DConcannon 8 September 2022, 00:11

View original

5 replies

Badge +18

Hello,

Are you asking where to find the latest project cost transaction?  I think your source is PMTran.  Perhaps filter using Account Group, to identify the Cost transactions vs. Revenue.

Yes, cost will be more complicated than Revenue because there are several sources that funnel into PMTran: Gl entries, AP Bills, PO Receipts, Direct Entries to Project Transactions, Time Entry for Labor, Expense entries, etc.

Also look at the Sign on the Amounts. We don’t have separate debit/credit amounts in PMTran, we have Positive/negative sign on amounts.

Userlevel 1
Badge

Agree it will be in there but adding this table to my GI will cause complications on the GI no doubt

Userlevel 1
Badge

Thanks agree it is going to be more complicated.   Just thought there might be somewhere where this date was held against the project

 

Userlevel 6
Badge +2

If you or your partner do not have access to create a SQL view and/or you don’t want to create a customization, you could go down the Business Event route and load/update a project attribute every time a cost transaction is created with a later date. 😫

Userlevel 1
Badge

Thanks for this suggestion will look into this

Reply


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