Joining Sales to Stock Reordering

[Matt Jones]

Hi there,

I'm a beginner using FMPro, but as the only one in our small company that knows how to use a computer I have been assigned this mission! We sell T shirts in London very successfully, but at present everything is written in books and at the end of the week the data collected and sent to our supplier who prints what we order. I have had some success making the database - there are a number of popups, and a running total of takings works, but I am having real difficulty linking this to a new table that we could send to our suppliers. Ideally I'd like it that when T shirt X is sold in size Y, that is put in a table, so that at the end of the week we could refer to this table and see what sizes of T shirt X we have sold. I'd appreciate any help you guys have for me

TEES.fp7.zip

[stanley]

Matt:

Welcome to the Forums.

What you're looking for is a sales report with summaries. I've modified your file & added a sales report layout and a script which sorts the fields and goes to the report. The one thing you'd want to add is a Find[] in order to get the right items on the layout - say, items for the month, or since your last order. Note that I also added a Quantity (which auto-enters "1") and a summary field for Total Quantity, which is needed for the report.

Hope that helps, and good luck.

-Stanley

TEES.zip

[Matt Jones]

Thanks for your reply Stanley, it's much appreciated. I'm going to test drive it this week. I'll let you know how I get on. Thanks once again

Matt

[Matt Jones]

Stanley,

Used the database over the weekend and it worked great. There were a couple of issues that came up though. Firstly, if someone ordered say 3 ACDC tees of the same size, the running total of cost only counts one t shirt, i.e instead of 30 it says 10. The other thing that I was asked if it was possible to do was to have the database check against what stock we have in our back room. A dialogue box saying "you have X number of T shirt Y in size Z, do you wish to reorder?" would be perfect. Is this possible with FM Pro?