RT Posted January 13, 2015 Share Posted January 13, 2015 Hello been battling this one for a while. i have the standard starter invoice solution and have copied the stock transactions table from the "inventory solution" so i can get the stock number to decrease when i create an invoice. this did work. see product details layout for the portal. the problem is that i have to create a dummy invoice add the product then i can update the product stock in the portal. otherwise i get This operation cannot be performed because one or more required related records are not available and cannot be created. i have a problem with the relationship i am guessing the only way i can update the value in the portal is if i add every product (500 products) to a dummy invoice. please help with the file or recommend a better way of achieving the result of tracking the product stock as always thanks RT Invoices.fmp12.zip Link to comment Share on other sites More sharing options...
RT Posted January 13, 2015 Author Share Posted January 13, 2015 Fixed the problem should have been. i think. ITEM ID MATCH FIELD $$CURRENT_Product_ID = PRODUCTID in the products table Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3391 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 accountSign in
Already have an account? Sign in here.
Sign In Now