Hello All,
I tried adding this to a current thread relating to the same topic but perhaps I should just create a new thread.
I'm trying to figure out how to run a report on 1 spreadsheet with 2 different companies and I do not have a clue on where/how to do this. I know its been mentioned that it can be done. Any guidance on where/how to do this? Same data source, 2 different companies, 1 report. Here's an example of what the current formulas look like:
Inventory:=CEILING(NL("SUM","ITEM LEDGER ENTRY","REMAINING QUANTITY","OPEN","TRUE","LOCATION CODE",$F$5,"Lot Blocked / Hold","FALSE","ITEM NO.",$B11)/$C10,1)+((NL("Sum","Reservation Entry","Quantity (Base)","Source Type","37","Source Subtype","1","Location Code",$F$5,"Item No.",$B11)/$C10))
In transit:=CEILING(NL("SUM","PURCHASE LINE","QUANTITY","LOCATION CODE",$F$5,"ON WATER","TRUE","NO.",$B11),1)
I've had success running 2 separate reports for each different company but am having a difficult time trying to get them to run on the same report at the same time.
Version US Dynamics NAV 5.0
Thanks in advance!
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Figured it out.
=(CEILING(NL("SUM","ITEM LEDGER ENTRY","REMAINING QUANTITY","OPEN","TRUE","LOCATION CODE",$F$5,"Lot Blocked / Hold","FALSE","ITEM NO.",$B11)/$C10,1)+((NL("Sum","Reservation Entry","Quantity (Base)","Source Type","37","Source Subtype","1","Location Code",$F$5,"Item No.",$B11)/$C10)))+(CEILING(NL("SUM","ITEM LEDGER ENTRY","REMAINING QUANTITY","Company=","Company Name","OPEN","TRUE","LOCATION CODE",$F$5,"Lot Blocked / Hold","FALSE","ITEM NO.",$B11)/$C10,1)+((NL("Sum","Reservation Entry","Quantity (Base)","Company=","Company Name","Source Type","37","Source Subtype","1","Location Code",$F$5,"Item No.",$B11)/$C10)))
I just entered "Company=" for FieldFilter1 and "Company Name" for Filter1 (where "Company Name" is the actual company name). I have the spreadsheet pulling info for 1 company and the formulas bringing in information from the other company on the same report.
This gave me exactly what I needed and I hope it can help others. :D
Thanks!
Please sign in to leave a comment.