Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Due Date Calculation

I am looking for help in generating a due date for an invoice. I have two tables: 1. Terms Table 2. AP Register Table Terms table is connected to the AP register table with a 1 to many r...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Anonymous ,

    Is the test column in your screenshot the result of using RELATED?

    I would check whether all your Vendor Nº in your 'AP register table' exist in your 'Terms table'.

    Consider sharing your data or a sample of it for further troubleshooting. 

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi Anonymous ,

To return a value from another table use RELATED.
E.g.: RELATED('Terms Table' [Your Column])

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much, that helped a lot. I did not know about the RELATED function and have been struggling for a day or so. But now for some reason, I have another issue, where not every Invoice, received a new date. I have several that are blank. I had the same issue when I created a merged table of AP Register and Terms.  Here is an example:

Thank you!

Olga

  • Payeras_BI's avatar
    Payeras_BI
    Solution Sage
    5 years ago

    Hi Anonymous ,

    Is the test column in your screenshot the result of using RELATED?

    I would check whether all your Vendor Nº in your 'AP register table' exist in your 'Terms table'.

    Consider sharing your data or a sample of it for further troubleshooting.