Search results by user ID 7027

My Company Address

Rick — Fri, 16 Sep 2016 10:13:14 GMT

We have rcently moved offices and have updated our address in QB... However all the invoices we are producing in method are still showing the old address. I have done numerous full syncs, is there another way of updating the address?

Thanks
Rick

Re: No Child Rows in Report Designer

Rick — Wed, 16 Mar 2016 22:30:35 GMT

Hi Mike

Imagine I was looking at customers and their sales orders. I have 3 customers, 2 of which have ordered off me. My data would look like:

Customer SalesOrderNo Amount

Customer 1

Customer 2 1 $50

Customer 3 2 $100

My master table in the report is the customer with the detail table of the Sales Order.

I only want a row to be returned where a sales order exists.

I have looked at setting the filter in the generate report action on my button, to filter where the SalesOrderNo is blank, but I am getting the following error:

Error^Action Sequence Order:1^ERROR:You have specified that a filter should be applied to your report, however no filter criteria was sent. For security purposes, this report cannot be shown.

Any help appreciated!

Thanks

Rick

Re: Statement from Method

Rick — Wed, 16 Mar 2016 22:08:19 GMT

Hi Yashpreet

I want to create a statement to send to the customer whilst in method. We don't use statement charges, it's just about providing the info to the customers from the sales team.

Thanks

Rick

Statement from Method

Rick — Mon, 14 Mar 2016 09:38:36 GMT

Is it possible to produce a statement from within Method - our sales team sometimes get these requests and we'd like to action them without involving the accounts team.

Kind Regards
Rick

Re: Report Page Sizing

Rick — Thu, 10 Mar 2016 11:32:03 GMT

After a bit of jiggery pokery I have worked this out.

Change the Page Break behaviour setting on the first Detail section of the report to: Before The Band.

This ensure only one band and band detail per page.

Re: No Child Rows in Report Designer

Rick — Thu, 10 Mar 2016 11:01:31 GMT

Please can anyone shed any light on this. I have a hack which is to add my required fields from the SalesOrder as linked fields on my child table, but it doesn't seem a very elegant solution!

Any guidance/pointers appreciated.

Rick

Re: How do I paste a screenshot in a post on here?

Rick — Thu, 10 Mar 2016 08:09:54 GMT

Hi Mike

If you upload the pic to tinypic.com you can paste the URL for anyone to follow.

Hope that helps
Rick

No Child Rows in Report Designer

Rick — Mon, 07 Mar 2016 17:08:14 GMT

I have created a new object called SalesOrderPackage to store details of the shipping packages sent to customers to fulfill orders.

I now want a report which shows all sales orders where a SalesOrderPackage exists. I have created a report on the SalesOrder table with the SalesOrderPackage linked as a child to it, however my report is listing all orders with or without any packages associated. How do I change the report so it only returns rows where there is a SalesOrderPackage

Thanks!

Rick

Re: Product Group Invoice Error

Rick — Sun, 06 Mar 2016 22:17:18 GMT

Hi John

Very strange, all working now. Thanks for getting in touch!

Cheers

Rick

Re: Report Page Sizing

Rick — Sun, 06 Mar 2016 22:01:18 GMT

Hi John

Thanks for the message.

Choice #1 I think. On each page I will have the customer name, shipping address, then a list showing the order e.g.

2 apples

4 strawberries

Does this make sense?

Thanks
Rick