VAT-Registation No. + VAT Bus. Posting Group in Ship-to Address (Table 222)
Shipment to a customer address may need a different VAT-ID to the one which is normally used. Table 222 (Ship-to Address) should have own fields for the VAT-ID (VAT-Registration No.) and VAT Bus. Posting Group. Example: A company in Germany has a Customer in France. Shipping to that customer is I...
Adress from EU VAT Registration No. Validation Service
So, picture this: a brand-new customer strolls into our system, and we're all excited. But here's the catch - they might have this fancy VAT Registration No, and we've got this EU Validation Service that's basically our VIP portal to snagging their name an...
Function to Void EFT Electronic Payment Journal Lines After Generate File Process
Data validation conditions do not catch all issues prior to generating the EFT/Electronic Payment File and/or posting the payment journal. Would be advantages to accommodate for the VOID of electronic payment records after the Generate of the file is completed and before the journal is posted. ...
Create Balanced ACH Transaction
Some banks require a balanced transaction for NACHA payment export file.
BC has no way to do this without programing.
We need Microsoft to create the Data Exchange Definition for the NACHA balanced payment export.
We have multiple clients that their bank re...
Package tax calculation
It is quite common requirement in EU countries, that companies selling or consuming goods on the local market are obliged to prepare a package tax declaration for the Tax Office and pay package tax. If differs from country to country if tax is paid on sales/consumption or rather on purchase of su...
Name validation with EU VAT Registration No. Validation Service independent of font size
When using the EU VAT Registration No. Validation Service Setup to validate the VAT no. of a customer the Validation Details check is invalid because the customer name is in lower case letters and the VIES is checking the name only with upper case letters.
When the customer name is total...
Bring back "Edit in Excel" in Intrastat Journal
After installing the new Intrastat Functionality the "Edit in Excel" possibility is removed. This was a very useful function for customers with a lot of Shipments and Receipts each month that generated a big Intrastat Journal. Often there is multiple manually adjustment that needs to be done, ...
VAT Return - mark entries which have been used for a VAT Return
Tracing and clarifying differences between the VAT Return (preview) and the figures reported in the VAT Return is difficult.
Usually you should rely on the "Open" flag in the VAT Entries and the Entry No. which actually closed the VAT Entries.
But the problem with this is that the ...
Real-time data access to BC (SaaS) Data (mirror SQL Server Database Access for reporting)
With native NAV SQL Server installations the client had access via SQL to build there own SQL Queries etc, and a lot of the time interrogate data in real-time as required. With the implementation of BC in the Cloud this level of access to Data is being lost, while the are options to use the Web ...
Administrator