Sometimes I get confused with Table Occurrences. I have a table of billing transactions, Table: BilledTrans. I have created a second TO, SOPItems. These table names are to match to the names in Great Plains. The goal is to export from FileMaker to Great Plains to bill with our catalog billing.
Parent table: SOPHeader
My confusion is limiting the scope of records. I go to a search layout for SOPItems to pull just the records for the current month. 64/818, but on the Invoice layout I have the full 818. And both layouts are based on SOPItems. There are only 26 invoices for me to create import files.
Any insight to what I am overlooking?