Jump to content

Search the Community

Showing results for tags 'purchaseorders'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 1 result

  1. 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
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.