Search
-
Gary,
QB requires a value in that field and by leaving it blank it
assigns it a value. In QuickBooks (At least in my case) if I add an item to a
bill it defaults Billable to checked. You could customize the screen and have
it that as soon as you select an Item to fill in Billable?
As NotBillable.
HasBeenBilled ...
-
Blake,
When you refer to orders are you talking about work orders? Based on what criteria do you want these work order created? Specific intervals? Have you taken a look at Method Field Services?
-Michael
-
Birch,
You can try an SQL Override. Something along the lines of:
CASE WHEN [ImportSKU]=' ' Or [ImportSKU] IS NULL THEN 'Subtotal' ELSE [ ImportSku] END
**Note the above code may not won't but its would be the format used, fields names are in [ ], regualr text is in ' '
This may work in your ...
-
TogsTeam,
You could create another table that has the SalesRep intial and the extra details and use actions to pull that information as needed.
-Michael
-
Hi Birch,
Is the Import SKU field a linked field in the InvoiceLine table? If not how is that data populated? Are you exporting the grid using the Export Grid to Excel action?
-Michael
-
TogsTeam,
Have you tried using Linked Fields? You should be able to add Linked fields to the table which can pull data based on the entity(Empolyee/Vendor) that is assigned to the SalesRep.
-Michael
-
Hi TeamTogs,
The QuickBooks SDK does not allow for editing of the SalesRep table, only adding records. Which means Method will not allow you to edit the SalesRep table.
[quote user="TogsTeam"]Error:Failure. The Table does not support edit.[/quote]
Also if you try to create a screen with a SalesRep grid you will see that it does not ...
-
Gary,
That's the correct value. Can you try making a dummy entry in your web form and see if you get the same results, if you do can you forward the error email to me.
-Michael
-
Hi Gary,
Based on the message, the CloseDate field which is a required field in the Opportunity table doesn't have a value. If you edit your existing web form and go to step 8 of 9 do you see Opportunity - CloseDate in the Table - Field column? If so what is listed for it?
-Michael
-
TogsTeam- Try doing another sync and let me know if you get the same errors.
|
|
|