By using this website, you agree to our Terms of Use (click here)
Trying to get a GI that shows the difference in days from the Promise date on a POline to the actual receipt date on the POReceiptLine. Tried this formula DateDiff( 'd', [POLine.PromisedDate], [POReceiptLine.ReceiptDate] ) but it returns an error that d is not a field. My guess is that the issue is because the formula has 2 different tables in it and that is why it is not working. Any thoughts on how to get this data?
Hi nheuer,
It works for me:
I'm using Acumatica Build 6.10.0472.
Maybe it's a problem with your Relations tab? This is what I used:
Working now I hade the parent table as PO Line and the child as POReceiptLine after switching it worked. Thanks for the assist
Just curious, I wouldn't think that the Parent/Child tables would matter unless you were doing a Left join. Were you doing a Left join?
I thought the same thing but I just checked and it works either way, I must have had a different field in the relation section, might have hade pONbr in the parent table instead of OrderNbr.
Online Members
