Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Newb needs help w/ Invoicing Relationships


This topic is 5925 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I'm fairly new to Filemaker. I'm trying to set up a basic sales order & invoicing system. This part I have so far works, 4 tables:

Customers

Products

SalesOrders

OrderLines

SalesOrders relates to OrderLines via a unique SO serial number, and the SO-OrderLines portal works fine. But I'm stuck trying to set up the invoicing. Problem is, each sales order may have multiple line items, and all line items may not ship at the same time. So 1 sales order may link to multiple invoices. I don't understand how to set up the relationships between SalesOrders and Invoices, and Invoices and OrderLines. Do I need a separate InvoiceLines table?

  • Newbies
Posted

I can get by without splitting line items. I'd like to keep it simple and require line items to ship completely.

Posted

Then I see no reason why you couldn't simply "share" the line items between Orders and Invoices. The relationship between Invoices and LineItems would be very much like the one between Orders and LineItems, except you would assign existing LineItems to an Invoice, instead of creating new ones in a portal.

This topic is 5925 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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