Jump to content

This topic is 7243 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

To get a useful response, you may want to provide a little more detail about this project.

  • Newbies
Posted

3 databases: one with inventory items that are serialized, another db to keep track of the inventory items that appear in a shipping/receiving database.

The shipping/receiving database will log all receipts and shipments of the items. Items may be received, shipped, and received in again, all recorded on individual records. Multiple items can be received at a time.

The items database needs to link to the ship/recv database so a history of each item can be obtained.

A script is then run to print a report of real time inventory (a serialized item that is received is considered in inventory; an item that is shipped has a location field updated as to where it was shipped.)

I'm looking for someone to set up the relationships; the rest of the reporting, scripting, layouts can be done in-house.

Thanks

This topic is 7243 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.