Our Purchasing Department has put notes in each line of a test Purchase Order. When using CTRL+Alt the Inspect Element shows that the field is POLine.Transactions, but, in the Report Designer POLine.Transactions does not appear and there are not child alias’ by the same name. I have been through every Note field that the Report Designer has in the tables that come with PO641000 and none of them has the data that was put into the Note fields.
Best answer by Laura03
Hello,
Are you asking which field contains line notes, because you want to add Line Notes to Purchase Order report PO641000.rpx?
Shown above is the Standard Purchase Order report that comes with Acumatica. The standard report does print notes below each item on this PO. I highlighted the Line Notes field and showed the table above.
If I have not guessed your question correctly, then please restate your question. Thank you!
Laura
+19Hello,
Are you asking which field contains line notes, because you want to add Line Notes to Purchase Order report PO641000.rpx?
Shown above is the Standard Purchase Order report that comes with Acumatica. The standard report does print notes below each item on this PO. I highlighted the Line Notes field and showed the table above.
If I have not guessed your question correctly, then please restate your question. Thank you!
Laura
Good morning,
When any record is repeated on a report, the first thing I look at is Relationships (In ACM report designer, File → Build Schema → Relationships tab).
Compare the Relationships in your custom report to the Relationships in Acumatica’s standard report, specifically the Parent - Child Join type in the upper table and the Parent/Child key fields in the bottom table of the Relationships tab.
Good luck!
Laura
Hello,
If you can show a screenshot of your relationships, I can try to help you. Thank you.
Laura
Hi,
Compare your report’s Relationships to the Standard Report’s (Acumatica’s) Relationships tab.
Any relationships that are in your report and not in Acumatica’s, and your relationships that are different from Acumatica’s are suspects - all new or modified relationships in your custom report are the ones to show the community.
Thank you!
Laura
Hello
I recommend that you start a new post and include screenshots of your joins, with difference between standard report and yours highlighted. Include an example of your duplicated records.
When you add to a post that has been solved, only the original poster and others who contributed will be notified of your question. When you start a new post, everyone on Acumatica Community will be notified.
Good luck!
+3Just one thing I noticed
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
