Method Community

I'm adding a series of records to the Activity table and only some of them are getting assigned the correct CustomerRecordID. The others are getting a CustomerRecordID that doesn't have any matches in the Customer table. Example data below. Is there somethiing wrong with the data I'm passing or are there other fields I should be including to make sure these records are assigned to the correct customer?

This is the list of fields I’m inserting into the [Activity] table: ActivityType,Comments,WorkOrderInstructions,Contacts,ActivityStatus,Entity,DueDateStart,DueDateEnd,ActualStartDate,AssignedTo,ActivityPriority

The correct CustomerRecordID is 53434. Only 4 of 11 records inserted got assigned that value, the others got a value of either 43755 or 14475. List of values inserted are included below. The [Contacts] and [Entity] field values are bolded, those are the only fields I’m passing that map the activity to a customer and they’re the same for all.

1. 03/14/2013        

Method RecordID: 274264

ValueList: Work Order,Barrier Spray,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,03/14/2013 01:30 PM,14-Mar-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 43755

 

2. 04/04/2013        

Method RecordID: 274265

ValueList: Work Order,Barrier Spray & Ticks,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,04/04/2013 01:30 PM,04-Apr-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 43755

 

3. 04/25/2013

Method RecordID: 274266

ValueList: Work Order,Barrier Spray,Date specific note: Marc's birthday party, don't miss this spray!!! Outdoor Items: Dogs Sales Rep: PL Property Size: 1/2 Acre or Less ,107423,Not Started,Mataya, Marc,04/25/2013 01:30 PM,25-Apr-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 53434

 

4. 05/16/2013        

Method RecordID: 274267

ValueList: Work Order,Barrier Spray & Ticks,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,05/16/2013 01:30 PM,16-May-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 53434

 

5. 06/06/2013        

Method RecordID: 274268

ValueList: Work Order,Barrier Spray,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,06/06/2013 01:30 PM,06-Jun-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 53434

 

6. 06/27/2013        

Method RecordID: 274269

ValueList: Work Order,Barrier Spray & Ticks,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,06/27/2013 01:30 PM,27-Jun-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 14475

 

7. 07/18/2013        

Method RecordID: 274270

ValueList: Work Order,Barrier Spray,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,07/18/2013 01:30 PM,18-Jul-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 43755

 

8. 08/08/2013        

Method RecordID: 274271

ValueList: Work Order,Barrier Spray & Ticks,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,08/08/2013 01:30 PM,08-Aug-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 14475

 

9. 08/29/2013        

Method RecordID: 274272

ValueList: Work Order,Barrier Spray,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,08/29/2013 01:30 PM,29-Aug-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 14475

 

10. 09/19/2013        

Method RecordID: 274273

ValueList: Work Order,Barrier Spray & Ticks,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,09/19/2013 01:30 PM,19-Sep-13 09:00 PM,03/01/2013 07:45 PM,Phillip,2-Medium

Method [CustomerRecordID]: 43755

 

11. 10/10/2013        

Method RecordID: 274274

ValueList: Work Order,Barrier Spray,Date specific note:   Outdoor Items: Dogs  Sales Rep: PL          Property Size: 1/2 Acre or Less  ,107423,Not Started,Mataya, Marc,10/10/2013 01:30 PM,10-Oct-13 09:00 PM,03/01/2013 07:46 PM,Phillip,2-Medium

Method [CustomerRecordID]: 53434

Also, I'm having the same issue creating records in the Invoice table and the ReceivePayment table. For example, both of these should also have a Customer_RecordID of 53434...

[Invoice] table

Field List: RefNumber,Customer,Memo,DueDate,TxnDate,ARAccount

Value List: 030113-0251,Mataya, Marc,,03/16/2013 12:00 PM,03/01/2013 01:00 PM,Accounts Receivable

Method [Customer_RecordID]: 43755

[ReceivePayment] table

Field List: ARAccount,Customer,TotalAmount,IsAutoApply,Memo,TxnDate,PaymentMethod,CreditCardAddress,CreditCardPostalCode,CreditCardNumber,NameOnCard,RefNumber

Value List: Accounts Receivable,Mataya, Marc,545.0000,false,,03/01/2013 01:47 PM,Check,,,,,888

Method [Customer_RecordID]: 14475

Hi rgatton,

I'm just gonna post the results of our offline discussion. The problem is this case is that you have a multitenant account, and you were not passing the tenantid in.

Dave