Sounds like something changed in the value list. If you can post a .zip file of your solution, that would help.
You could do several things. Have your company listed as a customer and do an internal sales order. Then you simply fill out a SALESORDER and SALESORDERLINE. If you don't want to list your company as a customer, you could create two tables such as TRANSFER and TRANSFERLINE that would work the same way as SALESORDER and SALESORDERLINE (or INVOICE and INVOICELINE for that matter).
Some potential fields:
TRANSFER::preparedBy (employee who filled out the transfer)
The TRANSFERLINE would have pretty much the same fields as an INVOICELINE:
TRANSFERLINE::lineTotal (qty * cost)
It can get more complex than this. You could also have a RECEPTION and RECEPTIONLINE table for receiving goods (you may already have this for receiving POs). You may also want to track DISTRIBUTION, which can be helpful if you want to fill back orders before putting items on the shelf.
Does your INVENTORY table have a quantity field or fields (e.g. onHand, available, allocated, onBackOrder, onOrder)? If the available quantity is 0 or NULL then use script triggers (e.g. onObjectSave) to prevent that item from becoming an INVOICELINE or SALESORDERLINE.
Thank you for answer.
I woud like to add all the fields you say on issu two, but i dont know how.
I attache the zip file so you can se the relations, but I dont know how to add it here so I'll send you by private mail.
Thank you again
Here I attache the file .
Thank you again
2014-05-19 21:08 GMT-05:00 DanielShanahan <firstname.lastname@example.org>:
Discussion* - Visualizza la discussione completa<https://fmdev.filemaker.com/message/148253#148253>
Thanks for the file. I think you could probably get by with something simple such as the Stock Transfer table on the Inventory starter solution. With few modifications, you could keep a simple transfer log for each item. Attached is a screenshot and the fmp12 file.