Search found 13 matches

by a1becker
Fri Apr 21, 2017 9:01 am
Forum: How do I?
Topic: count number of Sales orders
Replies: 0
Views: 207

count number of Sales orders

We currently run NAV 2013 R2. I am trying to find the total number of orders entered for a specific period of time. I want a count for each customer and/or each item. My problem is I need to search both orders entered and shipped complete as well as orders that are still open. I cannot find a way to...
by a1becker
Fri Jan 13, 2017 7:52 am
Forum: How do I?
Topic: Excel 2010 & 2016.
Replies: 1
Views: 242

Excel 2010 & 2016.

I have recently added Excel 2016 to my PC. I still have 2010 as well. Am I able to add the Jett Add-in on both 2010 and 2016 or can I only have it in one Excel at a time.

Thanks,
by a1becker
Wed Dec 21, 2016 9:37 am
Forum: How do I?
Topic: Table Builder
Replies: 1
Views: 294

Table Builder

This is probably very easy but I cannot figure it out. I just want to combine two tables in the table builder. I want to list all of the transactions for a specific time period in the Sales Invoice Header and the Sales Cr.Memo Header . I need these to be a table so I can put the info into a pivot ta...
by a1becker
Thu Oct 27, 2016 11:32 am
Forum: How do I?
Topic: Formula in table builder [SOLVED]
Replies: 3
Views: 895

Re: Formula in table builder [SOLVED]

:lol: :lol:

figured it out. I was typing in "=formula" in the table builder. Took that out and it works fine. Thanks for all of your help!
by a1becker
Tue Oct 25, 2016 10:13 am
Forum: How do I?
Topic: Table Builder - Concatenate
Replies: 6
Views: 668

Re: Table Builder - Concatenate

krd1996, thanks for the suggestion but I still get an error message. first I added another set of ("). That did not give me the correct results. Then I copied your formula and popped it into my Table. Still did not get the desired results. jet error.jpg Thanks for any suggestions you may have for me.
by a1becker
Tue Oct 18, 2016 6:53 am
Forum: How do I?
Topic: Table Builder - Concatenate
Replies: 6
Views: 668

Re: Table Builder - Concatenate

Thanks for the link. I did "scour" this site for answers before I posted my question. That is why I copied the exact formula I entered into NAV. I am wondering if I am just missing some "," or ")" and do no see it.

Thanks,
by a1becker
Mon Oct 17, 2016 10:07 am
Forum: How do I?
Topic: Table Builder - Concatenate
Replies: 6
Views: 668

Table Builder - Concatenate

I am trying to Concatenate two Text fields within the Table Builder. Here is my current formula. =NP("Formula","CONCATENATE([@[No.]]," - ",[@[Name]])") The result when I run the Table #VALUE! The result I am looking for is 1000 - Customer ABC I have tried so many variations of this formula and canno...
by a1becker
Thu Mar 17, 2016 9:09 am
Forum: How do I?
Topic: How to Filter
Replies: 1
Views: 335

How to Filter

I am trying to get a list of Assembly Parent items that were sold for a specific date. I have attached my file. When I run the report I get 80 duplicate rows. What am I doing wrong.

thanks,

Amy Becker
Marshall Wolf Automation
by a1becker
Fri Aug 21, 2015 11:36 am
Forum: How do I?
Topic: NL Function based on a formula
Replies: 2
Views: 521

Re: NL Function based on a formula

thanks for the info. this sort of makes sense to me. However, I need to reference info from more than one table. =NL("Rows","item",,"=NF(,""Qty on hand"")+NF(,""Outstanding on PO"")"-NF(,""Outstanding on SO"")-NF(,""Reorder Point""),"NUMBER&<0") Qty on hand and Reorder Point - both from the Item tab...
by a1becker
Thu Aug 13, 2015 8:26 am
Forum: How do I?
Topic: NL Function based on a formula
Replies: 2
Views: 521

NL Function based on a formula

I am trying to look at items that have demand. Then, based on the demand I want to sort them by Vendor. Next, do NL(Rows) to show open Sales orders and open Purchase orders. I want the report to look like this. Vendor A Item 123 Qty on Hand 5 Sales order 123456 outstanding Qty 25 Sales order 234567 ...
by a1becker
Wed Aug 12, 2015 8:57 am
Forum: How do I?
Topic: Hide or Show Lines
Replies: 3
Views: 900

Re: Hide or Show Lines

this part I understand. It is more about I want Row 10 to Hide or show based on the results of row 12. I can get the condition to look at down 2 rows, but how do I handle when sometimes I want it to look down 2 rows and other times down 3 rows? My problem is I am looking at table A. Based on Table A...
by a1becker
Thu Aug 06, 2015 12:47 pm
Forum: How do I?
Topic: Hide or Show Lines
Replies: 3
Views: 900

Hide or Show Lines

I have created a report that pulls quantities from various tables. Based on results of those qtys I perform a calculation. I then want to show or hide the prior lines based on the results. Everything works fine except when I have multiple rows of information. How can I get all prior rows to correctl...
by a1becker
Wed Aug 14, 2013 10:33 am
Forum: How do I?
Topic: Report Formatting
Replies: 1
Views: 750

Report Formatting

I have created a report. It works fine. I have some nested NL functions, have some hidden columns and rows, etc. Now I want to take some of this information and forward it. I trickly want to have a worksheet with values. How do I take some of the info from my report page and put it to a new workshee...

Go to advanced search