Inventory Reorder Check

This program checks your sales order history to determine which inventory items are running out of stock and need to be reordered. It also checks the inventory "Minimum Stock" level for each inventory item. A simple web page is then created and automatically opened with your default browser.

The first column is the inventory item id. The second, third and forth columns are the quantity on hand, quantity on sales orders, and quantity on purchase orders. These numbers come directly from the inventory, and can be viewed under Peachtree's "Maintain Inventory Items" screen. The fifth column is the average monthly use of the item which is determined by looking at past sales orders. The last column is the number of months left, determined by dividing the quantity on hand by the average monthly use. It does not take into consideration the quantity on sales orders/purchase orders.

If you run the program using the .bat file instead of the .exe file, you are able to modify several variables that the program uses. Edit the .bat file to tune these variables. The first is "MONTHS_CRITICAL". This affects the "Months Left" column and any entry below this number will be displayed in bold. The next is "MONTHS_WARNING". Inventory with "Months Left" above this number will not be displayed. The last variable is "QTY_MINIMUM". Items with both quantity on hand and total quantity on past sales orders below this number will not be displayed. This allows for trifle inventory items to be ignored.

Item ids displayed with an underline are below the "Minimum Stock" level set in Peachtree's Maintain Inventory Items screen.

Because Peachtree's export mechanism is deeply flawed, this program will take at least 5 minutes to run. During that time, Peachtree will appear frozen. There is no way to cancel the program aside from killing Peachtree. If you run the program a second time, it will use reuse exported data for up to one hour. After this, you will have to wait for it to reexport the data.

Currenly this program will (likely) only work with Peachtree 2010. If you would like to use it with a different version, contact me. If you need help with this program, please contact me.

Scott Hammond
sehammond@gmail.com