Method Community

 James, It appears you've set the ActivityNo to only accept unique values in the PoolServiceLog. All you have to do is make the ActivityNo field in the PoolServiceLog table to not unique. Perform the following steps. 1. In Method Go to Customize > Table and Fields 2. Select the PoolServiceLog table. 3. Find the ActivityNo ...

Hello! I've created a new report (took an old report and selected save as - new name / new report) but for some reason it is printing a blank additional page. The header and footer are set to print on all pages and neither print on this mysterious additional page. So I'm not sure what would be causing it. Any ideas? Thanks!!

That got it! THANKS!!

Here's an error I get when I use your Master Tables. Failed at Context=138.  The Master table (Entity) Cannot make a relationship to a child table (CartInfo) because the tables are joined by a field (CompanyName) that does not contain a unique value.    

I'm trying to print out a "one sheet" customer info page and I'd like to pull information from multiple screens.  I was unable to link the Customer Master Table with our CART INFO table.  Is there a way to add a second "dataSet".  We have dataSet1 with cart info and customer but I need our custom customer ...

 Hi Phillip, Cases where any table that has a balance that is calculated by other records. For example, a customer has a balance.  That balance is affected by payments, invoices, credit memos and sales receipts. So for instance, if the credit memo is updated and QB is closed then the customer balance wouldn't be updated until ...

  OK.. i think that answers my question...I was getting portal users mixed up with the paid users. Let see if i get this correct...In an example if I have a Starter edition there is just one user that can logon and is paid for, but I can have x number of portal users viewing their account and this is billed based on the rate you said. The ...

  Hey Keith, First I'd like to clear up something, The Customer Portal does come with the Starter Edition. Ok, so to break down the 3rd Party Portal. When a User logs into the portal, they are billed 15 cents per 5 minutes. The portal is a great way for your clients to be able to log in and check on Company Account information. To give ...

Hi Phillip, In that case, you can change the BeforePrint script on the CheckCents object to: Private Sub OnBeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)                 dim intCents as ...

  Ok.. that helps.. not sure I fully understand this reply for a question. Does this mean you bill for any time in a 3rd party portal. if so can you give me an idea of how much and when is this billed. Thanks Reply was: Your Portal Users are billed based upon amount of time spent in the Portal. Portal users do not sign in the same way. A ...