Hello everyone,
I have created three advance invoices (Prepayment Invoices) for the following invoice, two of which have already been paid and one is still outstanding. What do I need to change so that all advance invoices—both paid and unpaid—appear on the final invoice?
Thanks in advance.
Best answer by nhatnghetinh
Hi
I can't open your Report yet because there are some DAC Customizations and subReports that I don't have.
The data you need to display is "Payments / Memos" in Subreport (SO643010.rpx) > Please edit "Relationships" to get the Prepayments that have not been Released (you may have to delete the join line with ARRegister ...)
Best Regards,
NNT
+11Hi
I think on the Prepayment Invoices screen > You need to do Apply with Invoices.
Then go to Invoice Form Report (Report Designer) > You create conditions to get all Prepayment Invoices that have not been Released (Status: Balanced)
Best Regards,
NNT
+11Hi
Open your Report using Report Designer > File > Save As > .rpx
Please attach the .rpx file
Best Regards,
NNT
Hi
These are invoice document and the prepayment subreport.
Unfortunately, I can only upload it as a ZIP file.
Best regards
+11Hi
I can't open your Report yet because there are some DAC Customizations and subReports that I don't have.
The data you need to display is "Payments / Memos" in Subreport (SO643010.rpx) > Please edit "Relationships" to get the Prepayments that have not been Released (you may have to delete the join line with ARRegister ...)
Best Regards,
NNT
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
