I am having an issue getting the report to run. I can verify the first line is correct by the totaling in the customer ledger entry. Can someone assist me with this? It has been a while I work with Jet on a continuous basis.
| Item by Customer | |
| Customer No. | 22478 |
| Date Range: | 01/01/16..12/31/16 |
=NL("rows","item ledger entry",,"posting date",$E6,"source no.",$E5)
=IF(H9="","",-NL("sum","item ledger entry","quantity","posting date",H2,"source no.",E5,"item no.",D9))
My dates are as such.
Hi -
Just a few questions, first:
- what issue are you experiencing?
- In what cell is your NL(Rows) function
- in what cell is your IF function?
Hi Harry, thanks for replying.
My NL function is in C9
I had put the IF Function in with H9 but that is not working either. When I run the report, I am only getting values from the row 10 on.
Here are some pictures. I do not see where to upload the report.
How about with this function in C9?
=NL("rows","item ledger entry",,"posting date",$E$6,"source no.",$E$5)
and this change:
=IF(H9="","",-NL("sum","item ledger entry","quantity","posting date",$H$2,"source no.",$E$5,"item no.",D9))