pochonerd Posted March 13, 2005 Share Posted March 13, 2005 How can I relate two files to another via portal? If I have two invoice files, from different companies but they affect just one inventory, HOW DO I RELATE THEM, knowing that both invoice files have a consecutive number and by this field I relate them to my LINE ITEMS file. is there any way to do it and not having problems with their relationships? Appreciate any help! Link to comment Share on other sites More sharing options...
Ender Posted March 13, 2005 Share Posted March 13, 2005 A portal can only show related records from one file. You can avoid this and other problems by combining your invoice data into one file, distinguishing them by something like a Company field. Link to comment Share on other sites More sharing options...
aaa Posted March 14, 2005 Share Posted March 14, 2005 Current invoice opening import lineitems for this invoice to one workfile, and have relationship to this file. But why you have two set of lineitems for one invoice. is this good? Link to comment Share on other sites More sharing options...
pochonerd Posted March 14, 2005 Author Share Posted March 14, 2005 I have 2 invoice files that refer to 1 line item file, THAT IS WHY I CAN REFER TO 2 FILES, So I can add records to this line item from 2 files. Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted March 14, 2005 Share Posted March 14, 2005 Understood. But the question is: why do you have two invoice files? It seems that if you have two companies from which you issues invoices, it would be more logical to issues the invoices from one file, using different layouts for the invoice. Reports can also be segregated through use of an ID marker for each company's invoices. The final result would be one file which acts exactly as if it was two files, but without the overhead and the inventory reduction problem. But then, I could be wrong . . . Be well . . . Tom Link to comment Share on other sites More sharing options...
Ender Posted March 14, 2005 Share Posted March 14, 2005 [ QUOTE ] But then, I could be wrong . . . [/ QUOTE ] Not this time, Tom. Like data should be consolidated when possible, unless there is a compelling reason not to. In this case, I don't see why they should be separate. Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted March 15, 2005 Share Posted March 15, 2005 However, you CAN achieve this by setting the the "Sold" and "Received" fields to add and deduct the like amounts in each Invoice file. As each invoice file and PO file must have a separate and distinct Line Items intermediary file whose sum is deducted from the beginning inventory based on the Item Number, simply create your Sold and Received fields in the Inventory file as follows: Currentstock = number calculation field = BeginningQty-(Sum(Invoices1::QtySold) + Sum(Invoices2::QtySold)) which will deduct the total of that item sold from both files. Simply change the "-" sign to "+" to add from purchase orders received count. Be well . . Tom Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.