Share
ReportDoes anyone know if it is possible to add the retainer balance to a project invoice?
Categories:
You’re offline. This is a read only version of the page.
Does anyone know if it is possible to add the retainer balance to a project invoice?
Hello,
I have not personally tested this, but I would assume that you could use the On Account Amount from the Project Card which would be the remaining balance of the retainer fee that has not been applied to billings yet.
This would be in the PA Project Master File also known as the PA_Project_MSTR or the PA01201 table.
select ACCTAMNT,* from PA01201 where PAPROJNUMBER = 'XXXXXXX'
I would see if that field is available to select on your Project Invoice format, and if not, you could potentially create table relationship in Report Writer to be able to pull that field as well.
Thanks!
Isaac Olson
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (