The Item shows up twice because we’ve received two different Lot Numbers, 205 and 207. Below we see that we have a Bill for our Red Paint. One way to bring Lot Numbers into QuickBooks is to enter a Bill. Now that we have QuickBooks setup to work with Lot Numbers let’s take a look at how we use them. The image below shows the Advanced Inventory screen under the Items & Inventory Preferences in QuickBooks. This way you’re able to enter the Lot Numbers as they come into the system and when they leave. In order to create an accurate Quantity on Hand by Lot Report we need to make sure Lot Numbers are showing on all forms. Throughout this article we’ll be working with an inventory item called Red Paint. Now that we understand the issue let’s look at how QuickBooks works with Lot Numbers. Again, not a very user-friendly solution and this is why customers have asked for a custom solution. Now we can see we have 75 of Lot 205 and 73 of Lot 207. In the second image below, we see the results of drilling down into the report. That is unless you double-click on the Lot Numbers. Sure, the report shows the Lot Numbers you have in stock but you don’t get to see the Quantities on Hand for those Lots. In the first image below, you can see the Lot Numbers in Stock Report available in QB.
#What is qb sdk serial#
In this situation when Intuit added Lot and Serial tracking to QB they left a rather important piece out of the SDK and that missing piece is the quantity value on Lot Number Adjustments. The SDK is the primary means of accessing QuickBooks Desktop data from outside of QuickBooks. The reason we’ve had such a hard time creating this report is due to an issue with Intuit’s Software Developers Kit (SDK).
In the remainder of this article we’ll cover everything that must be done in order to set your data up so you can produce an accurate Quantity on Hand by Lot Report outside of QuickBooks.
#What is qb sdk driver#
We have in fact created a report using the QODBC driver that is included with your QuickBooks Enterprise purchase however, there is one stipulation that needs to be considered for the report to be accurate.
We’ve set out to tackle this report a couple of times now and this time we believe we have a solution. This isn’t a very user-friendly solution. There is in fact a report in QuickBooks but you have to double-click on each individual item on the report to see the actual Lot Number quantities. On the surface this doesn’t sound like a very difficult request, in fact one might think this report is available inside QuickBooks. We’ve had a number of requests for a report that will easily show users their Quantity on Hand by Lot.
0 kommentar(er)
