Ronald L McVicar Jr
Forum Replies Created
-
<div>Alan I asked the new Bing AI and ChatGPT and for the most part they agreed with you.
Again, thank you very much Alan.
———————————</div>Hello, this is Bing. Iām happy to help you with your question about Microsoft Dynamics NAV 2016 sales tax functionality.š
According to the sources I found, you can set up tax groups, tax areas, tax jurisdictions, and tax details to manage your sales taxes in Dynamics NAV 2016<sup>1</sup>. Tax jurisdictions represent taxing entities (state, county, city, etc.), while tax areas are regions on a map with unique taxability<sup>2</sup>. Tax groups are assigned to items, resources or G/L accounts, while tax areas are assigned to customers or vendors<sup>2</sup>. Tax details allow you to assign tax rates to each combination of tax jurisdiction and tax group<sup>2</sup>.
To disable or discontinue a specific tax jurisdiction, you may need to edit the tax details table and set the tax rate to zero for that jurisdiction<sup>2</sup>. This way, the existing transactions will not be affected, but the new or existing customers who belong to that tax area will not have sales tax calculated.
However, Iām not sure if this is the best practice or if there are any implications for doing this. You may want to consult with a Dynamics NAV expert or a tax professional before making any changes.
May I ask why you want to disable or discontinue a specific tax jurisdiction? Is it because the tax rate has changed, or the jurisdiction is no longer valid?
-
Alan, thank you for the reply, really appreciate. I was thinking this would be the direction but was not sure. Might add a new Jurisdiction layer with zero and a new affective date. However, don’t want zero tax calculation on future Sales Invoices. This way history is not affected but moving forward from the new affective date if zero is the rate then no calculation for both new customer invoices and existing customer who previously were calculated for sales tax but now from the new date would have zero calculated.
-
I think the USPS has a validation API portal: Web Tools APIs | USPS
Also internally using SQL and Management Studio or Power BI Reports with dataset similar to the following you can do some of this validation and evaluate some of the efforts.
————————————————-
/****** Script for Contact: estimate effort for data validation for E-mail Addresses ******/
SELECT COUNT(*) AS [TotalContacts], COUNT(CASE WHEN [E-Mail] IS NULL THEN 1 END) AS [NullEmailCount], COUNT(CASE WHEN [E-Mail] NOT LIKE ‘%@%._%’ THEN 1 END) AS [InvalidEmailCount], COUNT(CASE WHEN [E-Mail] IS NOT NULL AND [E-Mail] LIKE ‘%@%._%’ THEN 1 END) AS [ValidEmailCount], COUNT(CASE WHEN [E-Mail 2] IS NULL THEN 1 END) AS [NullEmail2Count],
COUNT(CASE WHEN [E-Mail 2] NOT LIKE ‘%@%._%’ THEN 1 END) AS [InvalidEmail2Count],
COUNT(CASE WHEN [E-Mail 2] IS NOT NULL AND [E-Mail 2] LIKE ‘%@%._%’ THEN 1 END) AS [ValidEmail2Count]
FROM [NAV16].[dbo].[nvdbcompany$Contact]
WHERE ([E-Mail] IS NOT NULL OR [E-Mail 2] IS NOT NULL)
AND ([E-Mail] NOT LIKE ‘%@%._%’ OR [E-Mail 2] NOT LIKE ‘%@%._%’)
————————————————-
/****** Script for Contact: estimate effort for data validation other than e-mail addresses ******/
SELECT COUNT(*) AS [TotalContacts], COUNT(CASE WHEN [Address] = ” THEN 1 END) AS [BlankAddressCount], COUNT(CASE WHEN [City] = ” THEN 1 END) AS [BlankCityCount],
COUNT(CASE WHEN [Country_Region Code] = ” THEN 1 END) AS [BlankCountryCodeCount],
COUNT(CASE WHEN [Post Code] = ” THEN 1 END) AS [BlankPostalCodeCount],
COUNT(CASE WHEN [Address] IS NULL THEN 1 END) AS [NullAddressCount],
COUNT(CASE WHEN [City] IS NULL THEN 1 END) AS [NullCityCount],
COUNT(CASE WHEN [Country_Region Code] IS NULL THEN 1 END) AS [NullCountryCodeCount],
COUNT(CASE WHEN [Post Code] IS NULL THEN 1 END) AS [NullPostalCodeCount]
FROM [NAV16].[dbo].[nvdbcompany$Contact]
————————————————-
/****** Script for Contact: names, addresses, and phone/mobile numbers ******/
SELECT [Name], [Address], [Phone No_], [Mobile Phone No_], COUNT(*) AS [DuplicateCount]
FROM [NAV16].[dbo].[nvdbcompany$Contact]
WHERE [Name] IS NOT NULL
AND [Address] IS NOT NULL
AND ([Phone No_] IS NOT NULL OR [Mobile Phone No_] IS NOT NULL)
GROUP BY [Name], [Address], [Phone No_], [Mobile Phone No_]
HAVING COUNT(*) > 1
ORDER BY [DuplicateCount] DESC
————————————————-
usps.com
USPS Web Tools APIs let ecommerce website and shipping software developers access USPS data and features free of charge. Check shipping rates, verify addresses, track packages, schedule package pickups, and more through USPS Web Tools.
-
This is really an experiment and I used ChatGPT and by setting the context from the original question and that the base ERP system is Microosft Dynamics 365 Business Central.
Request to ChatGPT:
regarding Microsoft Dynamics 365 Business Central “…a way for the Shipment Document Number to appear on a Lanham Bill of Lading (without a modification)”?
ChatGPT Response:
In Microsoft Dynamics 365 Business Central, the Shipment Document Number can be displayed on a Lanham Bill of Lading without making modifications to the system by utilizing the available customization options. Here’s a general approach to achieving this:-
Open the Lanham Bill of Lading report layout in the Business Central development environment (AL Language).
-
Locate the section of the report layout where you want to display the Shipment Document Number. This can typically be found in the header or footer sections of the report.
-
Add a new field or text box in the desired location.
-
Set the data source of the new field to the Shipment Document table (typically, the table is called “Shipment”).
-
Bind the field to the Shipment Document Number field in the data source.
-
Adjust the formatting and positioning of the field as per your requirements.
-
Save and publish the modified report layout.
Once these changes are implemented, the Shipment Document Number will appear on the Lanham Bill of Lading report whenever it is generated.
Please note that these instructions assume a basic understanding of report customization in Business Central using AL Language. It’s always recommended to consult with a developer or an experienced Business Central consultant for specific guidance related to your system and version.
I hope this is helpful and if not please forgive this experiment.
-
-
Is this default NAV or BC or some-other EDI like a 3rd party Lanham, etc.? I know or think I recall for the 850 for the inbound in the setup for the Purchase Order inbound to be the Sales Order, that in the setup option that allows you to include or exclude comments when importing purchase orders through the EDI functionality.Not sure but this might affect the subsequent 855 (acknowledgement.). I hope this is not a bother. good day
-
How is the Item card setup for one of the representative items you are producing? Specific for Item Tracking Codes on the Item Card? Two links below might help and excuse if already reviewed. Is it in the Production Order process you are doing this assignment for WIP or are you doing back-flushing and on posting doing this? Lastly, This is stock BC or do you have enhancement specific to manufacturing?
Automatic creation of lot and serial number information cards
or check
-
One industry suggestion indicated that workspace could have sub folders by assigning groups and folders however I could not find these setting at all. On further research though Power BI features are expanding often seem right now to indicated that this is not a current feature and has numerous entries as requested feature. Folders would be used for multiple departments and with sub folders for each parent folder one could have a development plan such as for development, testing and parent (or one of the top folders for the specified department) for production.
