Overview At the end of every month, we will inevitably get some questions on why their inventory valuation figures does not match the G/L inventory account. We would investigate and find out why and provide solutions on how to fix them. Some of the reasons are pretty common so I’d thought I compile a listRead more
Author Archives: Alex Chow
The Problem I hate beating a dead horse to death, but there are a couple of incidences that prompted me to write this article. Navision 1.0 has been out since 1996, yet it always astounds me when I walk into a company claiming that their inventory costing and cost of goods sold is incorrect becauseRead more
Overview With recent tariff announcements constantly evolving, importers face increased pressure to properly allocate duty and tariff costs into their inventory valuation. For example, if an item costs $6.00 per piece and is imported from a country like China, your final landed cost per piece could jump to $14.70 due to a 145% tariff (asRead more
Overview A few years into doing remote implementations, I’ve come to realize that this shift hasn’t been as seamless or efficient as people like to believe. I had a recent project where a customer on the East Coast wanted me to help them implement warehousing and shipping for their Dynamics 365 Business Central. From theRead more
Overview In standard Dynamics 365 Business Central, there’s an Over Receipt functionality that allows the warehouse to receive more than what was actually ordered on a purchase order. This is helpful in scenarios where a vendor sends a little extra, whether on purpose or by mistake. Microsoft provides a nice overview of this here: https://learn.microsoft.com/en-us/previous-versions/dynamics365-release-plan/2020wave1/dynamics365-business-central/receive-more-items-than-orderedRead more
Overview Since our last video, Microsoft has updated the Account Schedule to be called Financial Reports. In addition, they’ve made minor changes to how the Row definitions and the Column definitions are defined. Here’s the updated video on how to create your financial statements using the Financial Reports (formerly Account Schedule) functionality. The Video
Exciting News! We are excited to share some news with you! As part of our ongoing efforts to better represent our mission and the solutions we provide, we have decided to change our company name from AP Commerce to APC Dynamics. While our name is changing, our goal to providing exceptional service and support remainsRead more
Overview The standard Business Central has two aging reports dealing with inventory. They are: Item Age Composition – Qty. Item Age Composition – Value Why the Value and the Quantity report needed to be separate reports is beyond me. When we run these reports, we see that you can define an Ending Date. When youRead more
Overview Fixed assets in Dynamics 365 Business Central is a pretty simple area to setup and use. In most cases, here are the 3 main things that needs to be done: Setup a fixed asset Post initial book value (or acquisition cost) Run depreciations Assumptions It’s assumed that your Dynamics 365 Business Central, in particular,Read more
Overview The progress payment functionality allows you to post multiple deposits against a sales or purchase order. The amount of the deposit payment can be any amount you want instead of a percentage. When the invoices are posted, you can choose whatever dollar amount to be applied to each posting of the order. This meansRead more