Total For Each Tax Rate

[Former Member]

Hello,

A local requirement we have is that bottom of the invoice that has the totals contains a Total column for each different rate of sales tax.

Presumably this would involve creating a second repetitive area, but in terms of where to put the logic to create these totals I have no idea.

Would something like this be acheivable with PLD? (8.8)

Thank you.

[Former Member · Accepted solution]

To try and be a bit clearer, ideally I would like a field that performs a conditional sum on a column = e.g. total of TaxAmount column where TaxRate = 10%.

The put a condition on this field to make it visible only if above zero.

Creating a field like the one above for each tax rate in the system would solve my issue, but I not very familiar with PLD and whether what I want can be done.

Regards.

[Former Member · Accepted solution]

I have found what appears to be a similar scenario implemented in Invoice_Item Type and Details (System).

Hopefully I can get the information I need from there.

[Former Member · Accepted solution]

Hi

As mentioned earlier, "Invoice_Item Type and Details (System)" has exactly the implementation I need - totals for each tax group at the repetitive footer.

The only problem is I cannot see how these fields are dragging the revelant information in. They are just Free Text fields.

If anyone is familiar with this form, an explanation of how F_206 (a blank free text field) is populated at run time would be greatly appreciated.

Regards.

[Former Member · Accepted solution]

All those Blank Free Text fields are hard coded fields. Even if you could breakdown the background application coding. There are nothing we can do.

[Former Member · Accepted solution]

Hardcoded? That sucks.

I assumed the templates were made using native PLD capabilities and could therefore be reproduced.

Should I take it from this that given they used code rather than PLD functions, that this outcome can't be attained with PLD in its standard form?

[Former Member · Accepted solution]

That is true. Not only this PLD, there are dozens of them.

[Former Member · Accepted solution]

Does PLD allow me to inject my own code to set text fields - or to set fields based on custom SQL queries?

I cannot see where code/logic lives in PLD.

Regards

[Former Member · Accepted solution]

No. PLD is a very basic tool for report. It does not accept SQL queries or other codes.

[Former Member · Accepted solution]

Ok, thanks for the responses, they have helped me understand PLD much better.

I have been through the system documents and think I should be able to modify the "VAT Only" version sufficiently to get the result I want.

Best regards.

[Former Member]

Hi,

Is this similar with your question?

Thanks,

Gordon