ContributionsMost RecentMost LikesSolutionsGeneric inquiry pivot table help to show revenue & expense Hi, I've created a below generic inquiry, and I would like to setup a pivot table using the concatenation formula. To illustrate, if you examine the screenshot provided, you'll notice that "VLDD80" represents the product code, and there's a corresponding project ID configured in the setup. My objective is to establish a new pivot table that relies on a combination of both the product code and project ID. how can i achieve this? I want the pivot table output as shown in below screenshot. I've attached GI for reference Thanks . Re: One rentention bill for all the AR invoice under project Hi Kevin, Thank you so much. I'll post myenquiry to the Partner Forum. Thanks. Pankaj soni One rentention bill for all the AR invoice under project Hi, Currently when we process billing from project and release the AR invoice generated from billing process, then system is prodcuting one retainage invoice for each monthly project invoice.is there a way to get one retention bill ? I've also found a related post on Acumatica forum for this issue, but it;s mentioned that combining released retainage into 1 invoice is planned for further version of Acumatica. AIA retention billing | Community (acumatica.com) Thanks Pankaj Re: How to add supplier bank account no in same format based on the supplier master--> Payment instruction HiLeneth_A, Thanks, yes it has now been solved. Regards, Pankaj Soni. Re: How to add supplier bank account no in same format based on the supplier master--> Payment instruction Hi Will_H, Thanks a lot. I really appreciate your help. now it's been solved and working pefectly. Have a nice day :-) Pankaj Soni How to add supplier bank account no in same format based on the supplier master--> Payment instruction Hi, I’ve added supplier bank details in the supplier master GI, but bank account number is not displaying in the same format as per the supplier master payment instruction. so how we can solve this. I would really appreciate, if someone can help me on this. Attached vendor master GI for reference. Thanks, Pankaj