How to: Work with GST on Sales and Purchases

Article
12/01/2017

If your country or region requires you to calculate value-added tax (VAT) on sales and purchase transactions so that you can report the amounts to a tax authority, you can set up Dynamics NAV to calculate VAT automatically on sales and purchase documents. For more information, see [Setting Up to Calculations and Posting Methods for Value-Added Tax] (finance-setup-vat.md).

There are, however, some GST-related tasks that you can do manually. For example, you might need to correct a posted amount if you discover that a vendor uses a different rounding method.

Calculating and Displaying GST Amounts in Sales and Purchase Documents

You can calculate and display GST amounts in sales and purchase documents differently, depending on the type of customer or vendor that you are dealing with. You can also override the calculated GST amount to match the GST amount calculated by your vendor on a given transaction.

Unit Price and Line Amount Including/Excluding GST on sales documents

When you choose an item number in the No. field on a sales document, Dynamics NAV fills in the Unit Price field. The unit price comes from either the Item card or the item prices allowed for the item and customer. Dynamics NAVcalculates the Line Amount when you enter a quantity for the line.

If you are selling to retail consumers, you may want prices on sales documents to include GST. To do this, choose the Prices Including GST check box on the document.

Including or excluding GST on prices

If the Prices Including GST check box is chosen on a sales document, the Unit Price and Line Amount fields include GST, and the field names will also reflect this. By default, GST is not included in these fields.

If the field is not selected, the program will fill in the Unit Price and Line Amount field excluding GST and the field names will reflect this.

You can set up the default setting of the Prices Including GST for all sales documents for a customer in the Prices Including GST field on the Customer card. You can also set up item prices to include or exclude GST. Normally, item prices contained in the Item Card will be the price excluding GST. The program uses the information from the Price Includes GST field on the Item card to determine the unit price amount for sales documents.

The following table provides an overview of how the program calculates the unit price amounts for a sales document when you have not set up prices in the Sales Prices window:

Price Includes GST field on Item Card	Prices Including GST field in Sales Header	Action Performed
No check mark	No check mark	The Unit Price on the Item Card is copied to Unit Price Excl. GST field on the sales lines.
No check mark	Check mark	The program calculates the GST amount per unit and adds to the Unit Price on the Item Card. This total Unit Price is then entered in the Unit Price Incl. GST field on the sales lines.
Check mark	No check mark	The program calculates the GST amount included in the Unit Price on the Item Card using the GST% related to the GST Bus. Posting Gr. (Price) and the GST Prod. Posting Group combination. The Unit Price on the Item Card, reduced by the GST amount, is then entered in the Unit Price Excl. GST field in the sales lines.
Check mark	Check mark	The Unit Price on the Item Card is copied to Unit Price Incl. GST field on the sales lines.

Correcting GST Amounts Manually in Sales and Purchase Documents

You can make corrections to posted GST entries. This allows you to change the total sales or purchase GST amounts without changing the GST base. You may need to do this, for example, if you receive an invoice from a vendor that has calculated GST incorrectly.

Although you may have set up one or more combinations to handle import GST, you must set up at least one GST product posting group. For example, you can name it CORRECT for correction purposes, unless you can use the same general ledger account in the Input Tax Credit Account field on the GST posting setup line. For more information, see Setting Up to Calculations and Posting Methods for Value-Added Tax.

If a payment discount has been calculated on the basis of an invoice amount that includes GST, you revert the payment discount part of the GST amount when the payment discount is granted. Note that you must activate the Adjust for Payments Disc. field in both the general ledger setup in general and the GST posting setup for specific combinations of a GST business posting group and a GST product posting group.

To manually enter GST in sales documents

On the General Ledger Setup page, specify a Max. GST Difference Allowed between the amount calculated by the program and the manual amount.
On the Sales & Receivables Setup page, place a check mark in the Allow Vat Difference field.

To adjust GST for a sales document

Open the relevant sales order.
Choose the Statistics action.
Choose the Invoicing FastTab.

Note

The total GST amount for the invoice, grouped by GST identifier, is displayed in the lines. You can manually adjust the amount in the GST Amount field on the lines for each GST identifier. When you modify the GST Amount field, the program checks to ensure that you have not changed the GST by more than the amount you have specified as the maximum difference allowed. If the amount is outside the range of the Max. GST Difference Allowed, a warning will be displayed stating the maximum allowed difference. You will be unable to proceed until the amount is adjusted to within the acceptable parameters. Choose OK and enter another GST Amount that is within the allowed range. If the GST difference is equal to or lower than the maximum allowed, the GST will be divided proportionally among the document lines that have the same GST identifier.

Calculating GST Manually Using Journals

You can also adjust GST amounts in general, sales, and purchase journals. For example, you might need to do this when you enter a vendor invoice in your journal and there is a difference between the GST amount that Dynamics NAV calculated and the GST amount on the vendor's invoice.

Before you manually enter GST on a general journal

On the General Ledger Setup page, specify a Max. GST Difference Allowed between the amount calculated by the program and the manual amount.
On the General Journal Templates page, choose the Allow GST Difference check box for the relevant journal.

Before you manually enter GST on sales and purchase journals

On the Purchases & Payables Setup page, choose the Allow VAT Difference check box.
After you complete the setup described above, you can adjust the GST Amount field on the general journal line, or the Bal. GST Amount field on the sales or purchase journal line. Dynamics NAV will check that the difference is not greater than the specified maximum.

Note

If the difference is greater, a warning will be displayed stating the maximum allowed difference. To continue, you must adjust the amount. Choose OK and then enter an amount that is within the allowed range. If the GST difference is equal to or lower than the maximum allowed, Dynamics NAV will show the difference in the GST Difference field.

To post import GST with purchase invoices

Instead of using a general journal to post an import GST invoice, you can use a purchase invoice.

To set up purchasing for posting import GST invoices

Set up a vendor card for the import authority that sends you the import GST invoice. The Gen. Bus. Posting Group and GST Bus. Posting Group must be set up in the same way as the general ledger account for the import GST.
Create a Gen. Product Posting Group for the import GST and set up an import GST Def. GST Product Posting Group for the related Gen. Product Posting Group.
Choose the icon, enter Chart of Accounts, and then choose the related link.
Select the import GST general ledger account, and then on the Home tab, in the Manage group, choose Edit.
On the Posting FastTab, select the Gen. Prod. Posting Group setup for import GST. Dynamics NAV automatically fills in the GST Prod. Posting Group field.
Choose the icon, enter General Posting Setup, and then choose the related link.
Create a combination of the Gen. Bus. Posting Group for the GST authority and the Gen. Prod. Posting Group for import GST. For this new combination, in the Purchase Account field, choose the import GST general ledger account.

To create a new invoice for the import authority vendor once you have completed the setup

Choose the icon, enter Purchase Invoices, and then choose the related link.
Create a new purchase invoice.
In the Buy-from Vendor No. field, choose the import authority vendor, and then choose the OK button.
In the purchase line, in the Type field, choose G/L Account, and in the No. field, choose the import GST general ledger account.
In the Quantity field, type 1.
In the Direct Unit Cost Excl. GST field, specify the GST amount.
Post the invoice.

To process certificates of supply

When you sell goods to a customer in another EU country/region, you must send the customer a certificate of supply that the customer must sign and return to you. The following procedures are for processing certificates of supply for sales shipments, but the same steps apply for service shipments of items, and return shipments to vendors.

To view certificate of supply details

Choose the icon, enter Posted Sales Shipments, and then choose the related link.
Choose the relevant sales shipment to a customer in another EU country/region.
Choose Certificate of Supply Details.
By default, if the Certificate of Supply Required check box is selected for GST Posting Group setup for the customer, the Status field is set to Required. You can update the field to indicate whether the customer has returned the certificate.

Note

If the GST Posting Group setup does not have the Certificate of Supply Required check box selected, then a record is created and the Status field is set to Not Applicable. You can update the field to reflect the correct status information. You can manually change the status from Not Applicable to Required, and from Required to Not Applicable as needed.

When you update the Status field to Required, Received, or Not Received, a certificate is created.

Tip

You can use the Certificates of Supply window to get a view of the status of all posted shipments for which a certificate of supply has been created.
Choose Print Certificate of Supply.

Note

You can preview or print the document. When you choose Print Certificate of Supply and print the document, the Printed check box is automatically selected. In addition, if not already specified, the status of the certificate is updated to Required. If needed, you include the printed certificate with the shipment.

To print a certificate of supply

Choose the icon, enter Posted Sales Shipments, and then choose the related link.
Choose the relevant sales shipment to a customer in another EU country/region.
Choose the Print Certificate of Supply action.

Note

Alternatively, you can print a certificate from the Certificate of Supply page.
To include information from the lines on the shipment document in the certificate, select the Print Line Details check box.
Choose the Create Certificates of Supply if Not Already Created check box to have Dynamics NAV create certificates for posted shipments that do not have one at the moment of execution. When you choose the check box, new certificates will be created for all posted shipments that do not have certificates within the selected range.
By default, the filter settings are for the shipment document that you have selected. Fill in the filter information to select a specific certificate of supply that you want to print.
On the Certificate of Supply page, choose the Print action to print the report, or choose the Preview action to view it on the screen.

Note

The Certificate of Supply Status field and the Printed field are updated for the shipment in the Certificates of Supply page.
Send the printed certificate of supply to the customer for signature.

To update the status of a certificate of supply for a shipment

Choose the icon, enter Posted Sales Shipments, and then choose the related link.
Choose the relevant sales shipment to a customer in another EU country/region.
In the Status field, choose the relevant option.

If the customer has returned the signed certificate of supply, choose Received. The Receipt Date field is updated. By default, the receipt date is set to the current work date.

You can modify the date to reflect the date that you received the customer's signed certificate of supply. You can also add a link to the signed certificate using standard Dynamics NAV linking.

If the customer does not return the signed certificate of supply, choose Not Received. You must then send the customer a new invoice that includes GST, because the original invoice will not be accepted by the tax authority.

To view a group of certificates, you start from the Certificates of Supply window, and then update the information about the status of outstanding certificates as you receive them back from your customers. This can be useful when you want to search for all certificates that have a certain status, for example, Required, for which you want to update their status to Not Received.

To update the status of a group of certificates of supply

Choose the icon, enter Certificates of Supply, and choose the related link.
Filter the Status field to the value that you want in order to create the list of certificates that you want to manage.
To update the status information, choose Edit List.
In the Status field, choose the relevant option.

If the customer has returned the signed certificate of supply, choose Received. The Receipt Date field is updated. By default, the receipt date is set to the current work date.

You can modify the date to reflect the date that you received the signed the certificate of supply. You can also add a link to the signed certificate using standard Dynamics NAV document linking.
Note

You cannot create a new certificate of supply in the Certificate of Supply window when you navigate to it using this procedure. To create a certificate for a shipment that was not set up to require one, open the posted sales shipment, and use either of two procedures described above:
- To manually create a certificate of supply certificate
- To print a certificate of supply.

Share via