20
Hi,
Here is brief scenario. At PurchReqTable form, I need to show TaxAmount and the calculation is LineAmount * TaxItemGroup.
And my problem here is, when I return the value is 0 means wrong. I used display method here and here is my code.
I hope someone help me with this since I have stuck for a while.
Share
Reportselect firstOnly taxOnItem
where taxOnItem.taxitemgroup == purchReqLine.TaxItemGroup && taxOnItem.TaxCode == taxData.TaxCode;
return taxdata.TaxValue * purchreqTable.TotalAmount(); Hi Sergei,
I need your help.
How I can get Sum from One of my tax amount, while the Tax on Item have 2 Sales tax Code (A + B).
I have Item sales tax group A + B.
on the Line :
1. Item A : tax A + B
2. Item B : tax A + B
How I can get Sum of tax A & Sum of tax B ?
Hi HelioBuenos,
In case if you have a different tax set up for each line, your result will be incorrect if you will use tax combination only from one line and total sum amount to get the total tax amount.
Hi Sergei,
I had sum lineAmount with the same purchreqid.
I think I do not explain it clear enough.
Hi HelioBuenos,
You can get taxValue with the next snippet from the code.
All responses (
Answers (
TaxGroupData taxGroupData;
TaxOnItem taxOnItem;
;
select firstOnly taxGroupData
where taxGroupData.TaxGroup == purchReqLine.TaxGroup
join taxOnItem
where taxOnItem.TaxItemGroup == purchReqLine.TaxItemGroup
&& taxOnItem.TaxCode == taxGroupData.TaxCode;
if (taxOnItem.RecId != 0)
{
taxValue = taxOnItem.showTaxValue();
}
else
{
error("Tax combination was not found");
}
But it's still not clear how you will select a line if there are several lines in requisition?
Hi Sergei,
I need to calculate TaxAmount only for one line in header level.
I cant get the taxValue percentage.
Hi HelioBuenos,
Do you need to calculate total amount or tax amount? Do you need to calculate it for all lines on the header level or only for one line (which one in multiline requisitions)?
Hi all,
I create this method on PurchReqTable table.
The exact requirement is to show a total of line amount on header level.
Hi HelioBuenos,
You are using data from both the PurchRecLine and PurchRecTable. Where did you create this method? Can you share the full method including parameter and variable declarations?
What is the exact requirement? Showing a total on the header level or an amount per line?
Hi HeliioBuenos,
It's not clear where you created the display method, on the form, or on the table.
I would recommend you to create a display method on PurchReqTable table and use PurchReqTotals class
[SysClientCacheDataMethodAttribute(true)]
//BP Deviation documented
public server display TaxAmountCur totalTaxAmount()
{
PurchReqTotals totals = PurchReqTotals::construct(this);
totals.calc();
return totals.totalTaxAmount();
}
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
