Method Community

Michael, Your missing one important part. ChildCode is also a dropdown field in the table Children. Strangley enough, I added a field to the SalesReceiptLine that is called Child, which is from where I am selecting ChildCode in the SalesReceiptLine grid in the SR screen; however, when I look at the SalesReceiptLine table, I cannot delete that ...

Hi cpitts, The best way to figure this out is to edit the table you are trying to import into and take note to see if the columns are checked as having to be unique or required. This should help you determine which fields have to be inserted and which ones cannot be duplicates. -Michael

Hi Hannah, [quote user="Hannah"]First, when I add a subtotal field it calculates correctly except for adding four decimal spaces, even if there is no change there will be four zeros [/quote] You will need to edit the summary properties and set the format string to {0:$0.00}. [quote user="Hannah"]Second, the sales tax percent ...

Andy, Is your packaging list screen based off the invoice table? If it is you should just be able to drag the Sales rep field from the fields on the left and that would display the value from the invoice you saved. How did you add the Sales Rep field? -Michael

Hi Tracy, I would address the entity conflicts anyway because they could be part of the reason for this issue even though the conflicts aren't directly related to the customers that are missing, after addressing the entity conflicts perform a Full Sync. If you want to determine if the customer is actually coming over to Method and maybe just ...

Hi Matt, What browser are you using? Are you by any chance using any on screen load actions that might be overriding the defaults? I created a copy of the Add / Edit Work Orders screen and set default text and it was loading each time. What type of fields are you setting default values for? -Michael

Brett, I tried the following: Created a new table called GeekoidTest and added a text field called ChildCode and checked the unique box. I edited the InvoiceLine table and added ChildCode as a drop down using the GeekoidTest table. I edited the InvoiceLine grid on an Invoice screen and added the ChildCode drop down to the grid. I was ...

Thanks Michael. I've actually seen that webinar a couple times already, but watching it again with what I needed to do in mind really helped. The key for me was as easy as step 1 of the dropdown wizard: Choose from an existing Table. I've created new fields from scratch, but just couldn't find this option to re-use them. I guess I was ...

Hi, Does each inventory item have to have a different Manufacturing part number? Can I have different inventory items with the same manufacturing part number essentially? I'm running into issues importing information on this. 

I am customizing an estimate with the report designer and am having some issues. First, when I add a subtotal field it calculates correctly except for adding four decimal spaces, even if there is no change there will be four zeros. Second, the sales tax percent field does not automatically populate. When I choose a sales tax from the sales tax ...