+4in my parent table (Bank account) debits are coming from Bill Payment Table and credits are coming from Invoices payments receive table.
Currently i am getting two separate reports for debits and credits. I am willing to get single report from both the tables sorted by date wise.
Is there any way to do this?
Regards,
Ravi Siddana
+24In that situation, it's not possible to have a single report of records from two tables.
what I would do is make a third table, which will combine the first two. I would create a custom Keyfield, which would be a text field in the format.
Debit-123
Which would be a concatenation of either of the word, debit or credit, depending on the source table, and then I end, and then the record ID number of the source record. That way the key field will remain unique in the target table.
Then I would create two saved table to table imports, which would copy the records from each of the two Source tables into the combined table, merging on that Key Field.
then the question is, how would these two saved table to table imports be run. One option would be to create a formula URL button that would run the two imports and Land the user on the combined page. Or else there could be a pipeline set to run every hour.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
