Jump to content

merge starter invoice and inventory solution


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

Recommended Posts

Hello been battling this one for a while. :hmm:

 

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 post
Share on other sites

Fixed the problem should have been. i think. 

 

ITEM ID MATCH FIELD $$CURRENT_Product_ID =  PRODUCTID in the products table

Link to post
Share on other sites

This topic is 2032 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.