Inventory Troubles
I am in the process of building an app to track inventory. The biggest problem that I face is that some items are tracked by serial number, while others are tracked by quantity. I want to be able to u...
Forum Discussion
Katlyn,
On a related note what is your architecture for the Inventory Transaction? What do your tables look like to manage increasing and relieving the Inventory? Does your structure allow you to enter a record with a quantity and serial number at the same time? The downside is that you could have:
Record ID#: 1234
Quantity : 2
Serial Number: 654321
The system would claim that you have two parts with the same serial number. At year end when you have to do Inventory Adjustments after a count, you ability for those offsetting transactions would be very difficult.
Good luck and I hope the design question is helpful now while you are building instead 12 months into operations.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
- Do you have Pipelines yet? During the webinar they said there was going to be a For Next loop. If it really will loop on a field [Quantity] creating child records, this is easy.
- PHP Script. This would be a simple script for someone familiar with the Quick Base API
On a related note what is your architecture for the Inventory Transaction? What do your tables look like to manage increasing and relieving the Inventory? Does your structure allow you to enter a record with a quantity and serial number at the same time? The downside is that you could have:
Record ID#: 1234
Quantity : 2
Serial Number: 654321
The system would claim that you have two parts with the same serial number. At year end when you have to do Inventory Adjustments after a count, you ability for those offsetting transactions would be very difficult.
Good luck and I hope the design question is helpful now while you are building instead 12 months into operations.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
No, I do not. I just learned about Pipelines yesterday, but it's not something we're looking to use yet. I will keep trying, thank you!
------------------------------
Katlyn Allen
------------------------------
------------------------------
Katlyn Allen
------------------------------