lrice Newbie

Hi Thanks for the reply. Within Netsuite.... Cheers

thanks mphearn. Your last reply gave me a clue and I managed to get the required info using the following: [PHP]echo "Account Name: " . $record->customSearchJoin[0]->searchRowBasic->companyName[0]->searchValue . "";[/PHP] Cheers!

Thanks again for the response... The output is rather large so I have extracted the reference to the custom field: SEARCH SUCCESS, records found: 3 Array (.......... [customFieldList] => SearchColumnCustomFieldList Object ( [customField] => Array ( [0] => SearchColumnSelectCustomField Object ( [searchValue] =>…

Thanks for the response. I seem to be making some progress but am now getting the following error: Catchable fatal error: Object of class ListOrRecordRef could not be converted to string in which refers to the line [PHP]foreach($record->basic->customFieldList->customField as $customField){…

Ok. If you have only one custom date entry per customer then I think it would work. Grouping by the custom date and the customer name for example would return only one row per customer. Unfortunately you would have to display the custom date in the results. If this is not the case then I guess I have misunderstood your…

I don't have your custom field so I replaced it with {customer.datecreated}.... Internal ID - Count Formula (Numeric) - Sum - TRUNC(MONTHS_BETWEEN({today},{customer.datecreated})) Formula (Numeric) - Sum - count({internalid}) - TRUNC(MONTHS_BETWEEN({today},{customer.datecreated}))-1 The above returns an unexpected error.…

I had a requirement to do this so I created a workflow. It basically grabs the fulfillment No, removes some unwanted text and adds it to the invoice. We only ever have one fulfillment per order...... Create a custom field e.g DeliveryNoteNo Create Workflow: Basic Info: SubTypes: Invoice, ItemFulfillment Initiation:…

Thanks David I was hoping to use the standard Netsuite reports but I guess you have just confirmed this will not be possible! Maybe I could import them as Cash Sales AND Closed Sales Orders to ensure they appear on both reports! An example of a Saved Search you used would be useful. I think it would give me an idea of the…

I had the same issue. I reported it to NetSuite and it turns out it is a BUG! For me, the workaround was to add the transaction sales order status to the criteria and filter it with Pending Fulfillment.May not apply to you though.

Thanks Nick The vardump sent me on my way. I just followed the same logic and came up with: [PHP] echo "Account Ref: " . $record->customSearchJoin[0]->searchRowBasic->entityId[0]->searchValue . ""; echo "<br>"; echo "Account Name: " . $record->customSearchJoin[0]->searchRowBasic->companyName[0]->searchValue . ""; echo…

Thanks for the response. I seem to be making some progress but am now getting the following error: Catchable fatal error: Object of class ListOrRecordRef could not be converted to string in which refers to the line [PHP]echo "Customer: " . $record->basic->customFieldList->customField[0]->searchValue . "\n"; [/PHP] The…

All my Dashboard saved searches are based on ShipDate. I create a transaction saved search Criteria: Item: is any of Inventory Item, non-Inventory Item (Excludes Tax lines etc.) ShipDate: is within Today Status: is none of Sales Order: Cancelled, Sales Order: Pending Approval Results: [Any field for Grouping here] GROUP…

Hi George Thanks for the reply. I know it can't be done straight out of the box, hence my post.... I was referring to the custom form as a possible filter criteria for the eventual solution. Cheers

We have started getting that $%£@ message every time we amend an existing Inventory Adjustment. It has only started happening since the upgrade. Was anybody getting these on a regular basis before the upgrade?