Search the Community
Showing results for tags 'purchaseorders'.
Found 1 result
Assistance Needed - Creating the right relationships based on the information below. Being in the print, packaging, promotional and apparel industry, I am trying to build a "One Click" solution for processing client's print JOBS and invoicing them out accordingly. Each JOB requires the following: JOB NUMBER (JOB). Maintain the same job number from initial JOB SPECIFICATION through INVOICING, and versioning of JOB NUMBER based on changes. For example: If I create a new JOB and it's number is 1001 and then I modify it at some point, I would like to capture the initial JOB number 1001 and then have a revised JOB number that reads something like, "1001r2". This gives me the ability to know the historical changes along the way. I am not sure this is possible, but any input would be great.JOB SPECIFICATIONS. Build out unique specifications tied to the JOB (JOB Name, Description, No. of components that make up JOB, what are all of their specifications - Component Name, Page Count, Flat Size, Finish Size, No of Colors, What Finishing is needed, etc. Each estimate may have different specification requirements (a brochure, an envelope, t-shirts, and a display stand require some of the same specs, but many different ones too). FORMAL QUOTATIONS to Suppliers. Once specifications are created in filemaker and verified by the client, I will need to confidentially send a formal quotation out to multiple suppliers to BID on the JOB. These suppliers may bid the whole JOB, or just components of it. For instance, we may have a direct mail campaign with multiple print components in it. As a result, one supplier cannot fulfill the whole JOB. Therefore, we will need to send portions of the Formal Quotation out to suppliers that can complete certain aspects. On the other hand, we may just have a brochure that needs to be completed and this Formal Quotation goes to just one type of supplier. FORMAL QUOTATION to Client. Once, all bids are received into our office, then we will create a Formal Quotation to the Client. We would like to send via email.PURCHASE ORDERS (POs). Upon acceptance of the Formal Quotation by Client, then we need to pick and choose the right suppliers to run the JOB. At this point we will need to produce one or more POs to send out to those chosen suppliers to produce the component. SUPPLIER INVOICES. I would like to capture all of the suppliers invoices and tie them to the JOB. Do I need to create an entity to store the supplier invoices to this JOB? In essence, I would like to scan and track all of the hard copy cost of goods (cogs) and tie them to every JOB.INVOICING. This is pretty self explanatory. After a JOB is completed by the vendors, we will invoice the JOB to the client.CONSOLIDATED DETAILED INVOICES. Just like above, we may need to Invoice a client once a month for all of the JOBS we did over the past 30 days.I hope I spelled this out clearly. With this said, I am asking for input on how to create the most efficient Entities/Table Occurences within the FM Relationship Diagram to have this work successfully. I have read the Basics and part of the Advanced FM Training Series, but I still cannot get my head around the scenario I listed above. I think I am making this more difficult than it appears within my industry. Any insight would be greatly appreciated. JFC70