HELP! ADOBE LIVECYCLE TEMPLATE FOR WITHHOLDING TAX COMPUTATION | Community
Skip to main content
G
Gaddiel_11
Level 2
August 1, 2023

HELP! ADOBE LIVECYCLE TEMPLATE FOR WITHHOLDING TAX COMPUTATION

  • August 1, 2023
  • 2 replies
  • 1743 views

Hello, I have a problem with my withholding tax formula. What's happening is that it seems to be sorting the amount of withholding tax, and all those not liable for withholding tax are placed at the bottom part, which distorts the breakdown of the computation.


it supposed to be like this.






But the output become like this.





This is the default script under Withholding Tax Row





this my Data Binding under withholding tax field
"$.PaymentAdvice.PaymentExplanation.Item[*].WithholdingTaxAmount"




This the default script & Data Binding under Payment Amount

"$.PaymentAdvice.PaymentExplanation.Item[*].NetAmount"

 



 

 

 

 




 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Vijay_Katoch
Community Advisor
Vijay_KatochCommunity Advisor
Community Advisor
August 1, 2023

Have you found any sorting scripts for the mentioned column? Share the form if you can (vkatoch07@gmail.com) will have a look.

    G
    Gaddiel_11Author
    Level 2
    August 1, 2023

    Hi Sir, I already sent the form. Thank you!

     

      Vijay_Katoch
      Community Advisor
      Vijay_KatochCommunity Advisor
      Community Advisor
      August 1, 2023

      There is no sorting script in the form. I tested with some test data and the issue is not replicated.

      Can you please check your data if it is coming correctly? There is simple mapping in the form.

        Vijay_Katoch
        Community Advisor
        Vijay_KatochCommunity Advisor
        Community Advisor
        August 1, 2023

        Send sample data and schema too.

          G
          Gaddiel_11Author
          Level 2
          August 1, 2023

          Hi Sir, the Data Source being used is coming from SAP, so basically, the Withholding Tax Amount is already computed in SAP. In other words, the plan was to extract the details using Data Binding from Adobe LiveCycle Form. However, what happened is that the withholding tax amount did not sync properly based on the expected invoice. It seems that it sorted the amounts in ascending order and placed all zero withholding taxes at the bottom. This makes me wonder why, despite having data binding from the data source, the data is still not correctly synchronized.

           
           
           
            Vijay_Katoch
            Community Advisor
            Vijay_KatochCommunity Advisor
            Community Advisor
            August 1, 2023

            $.PaymentAdvice.PaymentExplanation.Item[*].WithholdingTaxAmount

             

            Isn't all your node inside the "PaymentAdvice.PaymentExplanation", 

            what is Item[*]?

            I think the issue is in the schema structuring.

              Terms & ConditionsAccessibility statement

              Loading footer...