web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Update VAT/GST amount ...
Small and medium business | Business Central, N...
Suggested answer

Update VAT/GST amount using oData Web Service

(0) ShareShare
ReportReport
Posted on by Lillian Du 40

Hi all,

We are working on the integration for Sales/Purchase Invoice to BC. Managed to find the pages and push the necessary fields to the Invoice Header and Lines. But having problem to find the 'Entrance' for updating the VAT/GST amount, which is available from BC user interface. Anyone can help please? Thank you in advance.

 Sales-Invoice-Statistics.jpg

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 408 on at
    RE: Update VAT/GST amount using oData Web Service

    Hi,

    I can understand your issue. VAT % or GST % is actually taken by system from the setup that is done in the VAT Posting Setup. It is controlled by system so you cannot update it manually even in user interface.

    If you want to update it then you need to change the field property Editable of GST % in the Sales Line table to Yes.

    Let me know if it helps you. Please verify if this answers your query. Otherwise provide more info,

    Regards,

    Bilal Haider

  • Lillian Du Profile Picture
    Lillian Du 40 on at
    RE: Update VAT/GST amount using oData Web Service

    Hi Bilal,

    Thank you for your reply.

    You can see from my screenshot that user is able to update the GST amount field from the Sales Invoice statistic page. I can do the same for Purchase invoice. Just need to turn on the ‘allow GST difference’ in S&R setup/P&P setup and set the allowed GST difference amount in GL setup. What I understand is  that BC does some calculation to apply the difference back to the line level once you update the total GST amount by GST%. I would expect to find the entry to update that particular field which is editable through user interface to use the oData Web Service. No luck until now. :(

    Cheers

    Lillian

  • Bilal Haider Profile Picture
    Bilal Haider 408 on at
    RE: Update VAT/GST amount using oData Web Service

    What is the exact problem/error you get while to try to update this field using WS.

  • Lillian Du Profile Picture
    Lillian Du 40 on at
    RE: Update VAT/GST amount using oData Web Service

    We didn’t find the right editable field in oData. We found the page for Sales/purchase invoice statistics. But there is no line level GST amount available for updating. Maybe we went to the wrong direction.

  • Bilal Haider Profile Picture
    Bilal Haider 408 on at
    RE: Update VAT/GST amount using oData Web Service

    Which pages have you exposed to push data. And is this a localized Indian version.

  • Lillian Du Profile Picture
    Lillian Du 40 on at
    RE: Update VAT/GST amount using oData Web Service

    Page 402 filter on Document_Type and No in NZ version. But doesn't have editable line level GST amount.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans