Jump to content
  • 0

Inventory Management


JohnnyAG
 Share

Question

Hi Guys,

I'm a bit confused her,
I'm Trying to create an Inventory App but a few things are not lining up for me:

1. I'm trying to create an Automation that each time I create a new invoice the container in the Pi description copulates Automatically to the container Table
(I'm Sharing a screenshot of the PI Table )
2. I have creates a Product List and I'm trying to sync some how the product list with the PI and container Tables, what I had in mind is that in the PI I enter the containers info and each container has a "unit" cell that you choose the Product and Quantity (like if it there was a table within the Cell)
all the Product units under in the Container tables should be counted so it will appear in the Inventory on hand View or table I'm Creating 

3. I'm Trying to create a view that holds 4 Entire Tables, but couldn't understand how to do it (It's a view that shows all the units I have in 3-4  Warehouses)
 

Screen Shot 2021-09-02 at 15.16.28.png

Screen Shot 2021-09-02 at 15.17.12.png

Screen Shot 2021-09-02 at 15.17.28.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

1.) This can only be done through Triggered Action. On Insert in PIs Table > Insert Container field to Container Table.

I dont quite understand the other two, but I believe 2 is possible as long as you have a field that connects all the related records, say Product Name across all 3 tables.

For View, what is this for? Do you want to join all records regardless of data? IF so, just use OUTER JOIN, if you want to Join them, say, based on Product Name, then use Inner Join Product Name

Not sure if this can help you, but you can check this out 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...