In purchase order VAT 5% should be calculated on net disc...

27/01/2019 10:14 PM

In purchase order VAT 5% should be calculated on net discounted amount

In the purchase order we want vat to be calculated after discount amount

total amount 21260.00
special discount: 260.00
vat 5 pc 1050.00
total 22050.00

the error is vat is calculate on the total amount example 21260*5pc=1063

for reference the purchase order # SAF23647 

Riya Sood
27/01/2019 10:50 PM

VAT is calculated on net discounted amount for all purchase as well as sales transactions, except for one case and that is when discount has been added as an amount on total invoice value. This is deliberate, there is a reason for that and there is a way out.

Tuhund ERP allows you to add discounts in following ways:

  1. Item level as percentage
  2. Item level as discount on price of the article or service
  3. Item level as discount on item total for the article or service
  4. Record level as percentage where record means quotation, proforma invoice, commercial invoice (tax invoice), sales order, RFQ, RFP, purchase order, purchase invoice or any other instrument used for purchase or sale.
  5. Record level as discount on total amount
  6. As a separate line item as discount

Discount in percentage on item level or on invoice level are the most straight forward ways to give discount and leave no ambiguity. Any discount on item level is also fine. 

However, when you are adding discount as amount on record level, you could actually mean two things, or in other words two distinct requirements. In your case (this example) vendor has given you a discount of SAR 260 on the total invoice vale of 21260. It could mean:

  1. It is an actual discount per say and VAT should be calculated on only 21,000 Saudi Riyal
  2. 260 SAR is not actually a discount but are written off as round off

In first case, VAT should be calculated on 21,000 SAR. This will happen if you add discount of 260 SAR as line item. Please visualize a paper bill for this. Vendor writes all items line by line and in the end adds one more line for discount. Tuhund handles it same way.

In second case, an amount is written off after calculation of taxes.

Discount on record level as percentage is perfect but discount on record level as amount is discouraged. This method has a basic problem that the only thing system can do is to assume uniform distribution of this discount. This, more often than not, might not be the case. It affects analytics and several reports. It might also affect your VAT compliance reports. 

 

User Community Home

ERP Interest Groups

Topics : 12|Last Topic : 04/03/2019 09:34 AM
Questions and queries about Accounting a Finance module. Working with cost centers. General Ledger, Accounts receivable, Accounts payable, financial statements, expense claims management, commission payables and receivable claims, Forex, Currency, Assets, Depreciation, Taxes and TDS, etc.
Topics : 7|Last Topic : 07/03/2019 09:44 AM
Information about Tuhund. Tuhund has moved far beyond and is much larger for just being called an ERP.
Topics : 4|Last Topic : 10/04/2019 11:32 AM
Point of sales software, Andriod and IOS applications and other software linked with Tuhund. API for connecting with Tuhund and building applications on top of Tuhund backbone.
Topics : 0|Last Topic : Never
Discussions on ERP in general and comparison of various ERP, their features, working, issues and workarounds
Topics : 2|Last Topic : 11/05/2019 12:03 PM
Questions and queries about Human Resource Management Module
Topics : 6|Last Topic : 08/06/2019 10:48 AM
Questions and queries about Inventory and Procurement Modules. Products and product categorization. Vendors Price Lists, Quotations & Invoices, Requests For Purchase, Requests for Quotes, Purchase Orders, Purchase Invoices, Tenders, Store Management, Locations, Stock. Inventory reports, margin analysis, ageing analysis.
Topics : 2|Last Topic : 26/12/2018 01:46 PM
Questions related to GST, GSTR1, GSTR3B. Issues and problems faced in GST Portal.
Topics : 2|Last Topic : 29/12/2018 11:34 PM
Knowledge sharing, support and help with Project Management Module; Project Schedule Management, Project Scope Management, Project Resource Management, Material Management, Expense Management, Deliverable, Billing and Invoicing.
Topics : 11|Last Topic : 03/06/2019 11:44 PM
All about Sales and Customer Relationship Module. Tasks, reminders and events. Inquiries, opportunities and business leads. Different types of sales targets and key performance indicators.
Topics : 1|Last Topic : 12/12/2018 12:57 PM
We welcome suggestions from our customers, third party users as well as from general public. Our aim is continual improvement of Tuhund. We are not going to stop or slow down development of Tuhund. Please let us know what you are looking for in Tuhund and we will make sure it is added.
Topics : 3|Last Topic : 10/04/2019 12:27 PM

Keywords

#access #accounting #accounts #activity #adapter #admin #ageing #agent #aging #amount #analysis #android #app #application #attendance #backup #balance #balancesheet #bank account #bank #boe #bonded #bounce #branch #business development #calculation #cash #change #chat #claims #clearing #commission #companies #company #compliance #configure #consumption pattern #control #conveyance #cost #costcenter #courier #credit #crm #currency #custom duty #customer #customization #dashboard #data #database #date #default #delivery charges #delivery #depreciation #discount #disk #download #drill down #drive #email address #email client #email message #email #employee #entries #epf #evidence #excel #exchange #expense #failure #filters #finance #financial year #forwarding #function #group #gst rate #gst returns #gst #import #indent order #indent sale #install #instructions #integration #inventory #invoice #journal #kilometer #ledger balance #ledger #license #limit #loading #location #locking #login #logout #logs #macbook #machine #management #maps #margin #marketing #mass mail #mobile #module #newsletter #odometer #online #outbox #payable #payment #performance #petty cash #picture #pnl #point of sales #pos #price list #price #process #procurement #product #products #profit #proforma invoice #project #promotional #purchase invoice #purchase order #purchase #quotation #rate #reading #receivable #recipient #reconciliation #register #report #requirement #resource #retail #revenue #saas #sales return #sales #salesmen #schedule #scope #search #selection #sensors #server #services #settings #share #software #space #statement #stock #storage #stuck #subledger #synchronize #system #target #tasks #tax invoice #tax liability #tax #topics #transaction #user #vat #vendor #vouchers #warehouse #wbs
Tuhund Logo
TUHUND®
Home About us Modules CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers Community Blog
Home Schedule Demo About us Community Blog
CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers
Request Demo