Project transaction register report showing duplicate record when joined APInvoice table with APtran

Hi ​@pankaj65 

Please check the Report file you attached, it seems to be the standard Report of Acumatica, it is not the same as your screenshot.

Please attach the .rpx file again

Best Regards,

NNT

Hi ​@nhatnghetinh 

Thank you. Yes, I’ve used the standard Acumatica report and customized it by adding the GST amount and a couple of other columns.

I’ve attached the .rpx file again for your reference, packaged in a zip file since I’m unable to attach the .rpx file directly.

Hi ​@pankaj65 

I mean you are still sending the standard Acumatica report PM633000 file. Please resend the report file that you have edited and is having duplicate records.

Best Regards,

NNT

Hi ​@nhatnghetinh ,

I’m not sending the standard Acumatica report PM633000 file.

I have already attached the customized report file in my previous reply.
Please check and let me know if you’re unable to open it on your end, then i’ll resend it.

Thanks 

Hi ​@pankaj65 

The file you sent is .rps. We cannot open .rps files elsewhere.

Please send .rpx files by going to File> Save As in Report Designer

Best Regards,

NNT

Hi ​@nhatnghetinh,

Please find attached file.

Thanks 

Hi ​@pankaj65 

The cause of duplicate record is APInvoice join APTran. I have edited it to PMTran join APTran.

Please check the report I attached.

Best Regards,

NNT

Hi NNT,

Thanks for your help.

I've deployed the report to the site, but the GST amount is showing up blank. Is the GST amount displaying correctly on your end?

Hi ​@pankaj65 

The report you attached does not have the GST column, only the VAT column. I only edited the Relationship section (PMTran join APTran) I did not edit the other sections.

Best Regards,

NNT

Hi NNT,

Yes that’s correct and this field “APtran.TaxAmt” store line level tax amount and now it’s printing blank. before you made this changes, tax amount was printing, however it was showing duplicate lines.

Thanks

Hi ​@pankaj65 

I have just added APTran join APTax
and changed VAT = [APTax.TaxAmt]
Please try again.

Best Regards,

NNT

Hi ​@nhatnghetinh ,

No APtax.TaxAmt field didn’t work and it’s not showing any value and printing blank.

Thanks 

Hi ​@pankaj65 

Please try

VAT = ([APTax.TaxRate]*[APTax.CuryTaxableAmt])/100

Best Regards,

NNT

Hi ​@nhatnghetinh,

No this formula also didn’t work either and i’ve also tried to print APTax.TaxRate and it’s printing blank.

I guess there is still something wrong with join.

Thanks