Method Community

 

Adding records to Activity table, records getting incorrect CustomerRecordID

Last post 03-06-2013 10:35 AM by Method_David. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-04-2013 2:11 PM

    Adding records to Activity table, records getting incorrect CustomerRecordID

    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

  • 03-04-2013 2:18 PM In reply to

    Re: Adding records to Activity table, records getting incorrect CustomerRecordID

    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


  • 03-06-2013 10:35 AM In reply to

    Re: Adding records to Activity table, records getting incorrect CustomerRecordID

    Answer


    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

Page 1 of 1 (3 items)