IDEA: Different VAT Differences for the Transaction Lines with same VAT Product Posting Group:

For documents such as purchase orders, sales orders, purchase invoices, sales invoices, purchase return order, sales return order, purchase credit memos, and sales credit memos that have a VAT difference, users must have the option to update the VAT amount on the Statistics page—either as a collective amount or individually for each line that shares the same VAT Product Posting Group. This would enable users to allocate the VAT differences using a method other than proportional distribution based on the line amounts.

Scenario: Calculation of VAT difference for the document lines with same VAT Product Posting Group:

If we have multiple lines in a purchase order, sales order, purchase invoice, sales invoice, purchase return order, sales return order, purchase credit memo, or sales credit memo that are assigned with the same VAT Product Posting Group, but the VAT amount differs from the amount calculated based on the VAT Product Posting Groups—often due to some reverse calculations—then additional configuration is required.

The 'Allow VAT Difference' Boolean has to be enabled from the related setups (such as the Sales & Receivables Setup for sales documents), then Business Central allows users to update the calculated VAT amount with the actual VAT amount on the Statistics page of the relevant document. The system then automatically calculates the VAT difference and allocates it proportionally across lines based on their line amounts, which are sharing the same VAT Product Posting Group.

Problem: There are following problems faced by our clients:

• We can only update the actual VAT amount on the statistics page, as a collective amount for the lines with same VAT Product Posting Group.
• Business Central will not support if we have different VAT Amounts for different lines with same VAT Product Posting Group.
• Business Central will not support if we want to allocate the VAT differences based on any other logic instead of allocating the VAT difference in proportionate to the lines' amount with same VAT product posting group.

Tried Solutions: We tried following different customizations to resolve this but got failed:

• We tried by updating the VAT Differences manually, by showing the VAT difference field on the line level of sales invoice document and by making it editable. Status: Failed (The system will recalculate and update the VAT differences in proportionate to the lines amount with same VAT Product Posting Groups)
• We tried to recalculate the VAT amounts, before posting of transactions in the Journal, but we faced the error message "The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error."
• We can update the required VAT Amounts and VAT differences on the posted document, but it will not be aligned with the posted VAT entries, as the primary key is VAT Product Posting Group for calculating and allocating the VAT differences to the lines of related documents (purchase order/ sales order/ purchase invoice/ sales invoice/ purchase return order/ sales return order/ Purchase credit memo/ sales credit memo)