ArcherPoint Dynamics NAV Developer Digest - vol 206
The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
5 Debugging Tricks for Visual Studio Developers
Debugging is a necessary component of creating solid code. In the article 5 Debugging Tricks Every Visual Studio Developer Should Master, NetCom Learning Blogs shares the importance of getting debugging right, and the five tricks you should master.
Transferring Large Database Files
Sara is looking for some help moving large database files. “I would like some insight as to all the methods ArcherPoint uses to transfer large database files over the Internet. I have run into issues and would like to know if there is any method or licensed third-party option currently being used that I am not aware of. This is more of a poll than anything else. Please let me know what you use (if anything) to move large files (over 20 GB) across the Internet.”
Kyle responds, “20GB? Use a tool like 7zip to compress and break it into chunks of 1GB. Then use FTP and move it to our FTP server. FTP is very tolerant of network interruptions. I use NcFTP (a File Transfer Protocol server) if I am on a customer server, Filezilla on my own system.
If you get too much larger than 20GB, keep in mind that FedEx has more bandwidth than the Internet. Go buy a USB disk, ship it to the customer, copy, and have them ship it back.
Oftentimes it is easier to have the customer make a copy of Production to use as Development.”
Jon adds, “SQL Server Manager has a way to backup to split files. The restore process for split files is transparent. We've had to do that with DBs that are up to 350GB. That's the largest I've transferred that way. We used FTP.”
Adding Tariff Charges to a Microsoft Dynamics NAV Invoice
Todd T has a question about tariff charges. “One of our customers gets quite a bit of product from China. They recently began receiving tariff charges on those items, and they want to pass it on to the customer. The request is to calculate the pass-through charge by multiplying the sales order line item amount by a percentage. The percentage will be according to the item's ‘Tariff No.’. This charge amount is then included on the resulting invoice, showing up on a separate line on the printed document as ‘Tariff Charge’.
Has anyone made a similar modification?”
Trish replies, “If the percentage varies by tariff, you could probably add a field to Table 260, Tariff Number, to store the percentage (the Tariff No. is assigned on the Item Card).
As far as the calculation, perhaps the release logic could be modified to sweep through the lines, determine if a tariff percentage exists for each, and do the math to determine the total tariff amount for the document. A resource line could be added to the document with this amount. You'd need to add a setup field to identify the Resource Card to be used for this purpose (maybe Sales & Receivables Setup). The Resource Ledger entries for this resource could potentially help with any related reporting.
With this approach you'd also need to deal with the user releasing/re-opening the document.
There are a lot of assumptions here, but this is one idea. Hopefully there's already a solution that's been implemented for another client.”
Scott observes, “This sounds like a good use of an item charge on a sales order to me.”
Tom H agrees, “I am with Scott. You can do this as an item charge. Possibly even an automated adding of item charges during order release. You could also do it as a resource or G/L line if the item charges weren't feasible for some reason.”
Kyle asks, “Do you care about generating a payable to the authorities for the tariff charges?”
Todd replies, “Right now they are using the Item Charges via a manual process. They want to automate it and also break it out on the printed invoice per line item. With Resources would I have to do one Resource line per order line? I am trying to avoid maintaining a bunch of ‘linked’ lines. I suppose this could be done in such a way that only one tariff item charge line exists per order, created/updated at Release as Trish and Tom suggest. The Value Entries would store the amounts per line for extraction at invoice printing...OK. I will move down this path a little further. Not sure how it will handle partially shipped/invoiced lines, but will test it.
Luckily, and little surprisingly, they do not want any sort of accrual or payable to the authorities – at least for now. Thank you all.”
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.