Results 1 to 3 of 3
  1. #1
    mcgarr423 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2016
    Posts
    10

    Invoicing created from Orders (purchase orders), and report showing non-invoiced Orders

    Picking up where someone else left off with this database.



    Fabrication company calls orders "Jobs". There is a Job table with overall details pertaining to an order, with a linked table Job Lines having the specifics for each line item of a Job/order. There can be different delivery dates for each line item of an order so there can also be multiple invoices per Job.

    There are corresponding tables Invoices (containing the overall details) and a linked table Invoice Lines. The Invoice Lines table columns are InvoiceLine# (Invoice#.1, Invoice#.2... Invoice#.10 etc), Invoice#, JobLine#, and a True/False "Invoiced". The True/False defaults to True for all values entered into the table. All data entry happens in an Invoice Form, that contains a subform for InvoiceLines and a similar form for Jobs and JobLines (JobLines has the same number system = Job#.1, Job#.2.... Job#.10 etc).

    I am trying to identify JobLines that do not have a linked InvoiceLine to show JobLines that have yet to be invoiced.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,990
    I have flags on my Invoice record,
    SentDate
    PaidDate

    filled when the action is complete.

  3. #3
    mcgarr423 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2016
    Posts
    10
    Looks like a bad relationship was my issue ( was 1 to 1, should have been "1 to many external")

    Hooray!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-26-2015, 09:11 AM
  2. Replies: 5
    Last Post: 11-10-2014, 09:31 AM
  3. Forms to generate Purchase Orders(PO)
    By 555Rage in forum Access
    Replies: 21
    Last Post: 09-13-2012, 05:00 AM
  4. Only display pending orders in report?
    By AThomas in forum Reports
    Replies: 5
    Last Post: 01-24-2012, 08:45 AM
  5. Purchase orders 2 in 1
    By jordanturner in forum Forms
    Replies: 1
    Last Post: 09-09-2010, 03:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums