Solved

Why Prepayment of AP Check & Payment dont show on Project Transaction?


HI All,

All transactions linked with the project seem to show on Project Transaction PM3040PL but don’t know why recording Prepayment on AP Check & Payment does not.

For the business case, we record deposits from customers for the specific project. We use Prepayment on AP Check & Payment for that purpose. Even though we have linked this transaction with the project, this transaction doesn't show on Project Transaction.

So when we want to check all transactions related to 1 project to calculate how much the customer own us on the specific project, it will go wrong.

Is it somethings wrong on my setting or the transaction Prepayment on AP Check & Payment dont link to Project Transaction as default?

icon

Best answer by aaghaei 29 January 2023, 21:26

View original

10 replies

Userlevel 7
Badge +8

It should not show because if you look at the nature of the transaction it is not cost or revenue and has not hit any GL account which it’s Account Group is tied to projects.

@aaghaei are there any solutions that we can record the deposit for specific project?

Userlevel 7
Badge +8

Not by playing with out of the box settings but you have a few customizations options I sorted by least to most preferred from my perspective:

  1. Oerride the releases action/method to create a record in PMTran and update the related summary tables and later in subsequent transactions post the offsetting entry. I do not suggest this without code review by Acumatica because of the wide range of side effects. (Least preferred)
  2. Create a new screen with a view delegate that combines the PMTran with the Prepayment Doc and shows the result.
  3. Create a SQL Union View to do the above merging in DB side then have a normal/projection DAC and GI from the created custom DAC and display the result to the end user 
Userlevel 4
Badge

@chidao An item that can be used as a workaround are the below steps.

  1. Create another line item on commitment records that you assign 0 dollars towards but assign towards the Job/Task/Cost code needed. 
  2. Don’t enter a prepayment request or prepayment transaction, instead enter an AP bill and ‘over bill’ the deposit line item. This would utilize the expense account utilized either at a vendor or non stock item, provided the expense account is assigned towards an account group
  3. Pay the bill
  4. As subsequent bills come in, enter a negative billing line item against the deposit line item on the commitment taking the billed value down to 0.

This is very much a workaround as you are simply entering an additional invoice and are exiting use of the prepayment feature, but it’ll cost the job all the same. 

 

Userlevel 7
Badge +8

@jsheehan56

This is a cash transaction not cost/revenue. Also it is a negative to project balance not additional cost. The suggested workaround will mess up all accounting trial balances costs and liabilities in an attempt to show the transaction in JC

Userlevel 4
Badge

@aaghaei agreed, the core issue is that cash transactions of any kind are unable to be Job costed by themselves, that includes Invoice payments as well as prepayments.

 

as a result, a Bill, or customized PM tran as you are starting are really your only vessels to get that transaction value to the project. 

Userlevel 2
Badge

A potential solution is to post the payment as a prepayment on the customer account and note the project name/number in the description. Then you could build a GI or report to show open prepayments and reference back to it when needed. 

Userlevel 7
Badge +8

@mschmidt07 yes but not reliable. It will take only ONE character data entry error to mess up the reports. In addition, still will require a UNION select on project transactions and the prepayment transactions which is not possible without writing a view delegate meaning quite a bit of work.

Userlevel 2
Badge

@aaghaei  - I wasn’t suggested they rope it into the PM Transaction report. They’d still have to pull up the GI report to see who has prepayments on file. But, it would at least give the PM’s & other a staff a view of PM Transactions vs. the Prepayment on file. 

There is a posted idea has been raised to Acumatica. Following the link below to vote for solving this issue.

Prepayments to show on a project | Community (acumatica.com)

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