If you are distribution company that deals with perishable items you need to focus on moving your inventory fast. But what if you are stocking inventory that is close to its expiration date?
If you are using
To track this you would simply create a SalesPad Quick Report that pulls information from the Microsoft Dynamics GP SQL tables.
You would track:
Item #, Serial or Lot #, Expiration Date, Warehouse/Location, Quantities, Unit Cost (so you know exactly what margin or loss you’re taking)
This custom report can easily be built once, and then accessed over and over again with the click of a button.
One of our distribution clients using Microsoft Dynamics with Salespad will run their “Low Expiration Inventory” report with unit cost and send it to select customers. Depending on the items, customer, and quantities to be moved they could get it at cost or cost +/- a few percent.
Read about another distribution client that uses lot tracking for targeted customer communication:
Read more at
Does your ERP system allow you to track serial numbers and expiration dates? If not, you need Microsoft Dynamics GP with SalesPad. Contact CAL Business Solutions at 860-485-0910 x4 or [email protected]
By CAL Business Solutions,