Skip to Content
0
Jul 20, 2016 at 02:58 PM

B1if: Automatically change sales order date when ativity date changes and vice versa

251 Views

Hi,

I hope this is the right spot to ask this question...

One of our customers wants the following situation:

Change 'Start Date' in Activity => Automatically change 'Delivery Date' in the Sales Order.

Drag activity in calendar to another date (thus changing 'Start Date') => Automatically change 'Delivery Date' in the Sales Order.

We want to do this with B1if.

I tried the following 2 scenarios (i thought i needed the first, but that did not seem to work thus i tried 2nd):

- Inbound - Channel: SAP Business One / Asynchronous / B1Event / B1 Event / 33 (Contacts)

Inbound - Retrieval: JDBC / SQL (query: SELECT ClgCode, Recontact, DocNum FROM OCLG WHERE ClgCode = '$Key')

- Inbound - Channel: SAP Business One / Asynchronous / B1Event / B1 Event / 33 (Contacts)

Inbound - Retrieval: DI API / Object / All with Field Names (AllNodes) (i believe i could leave last one empty)

After i bound one of the administrations to it, i activated the scenario, then i went into SAP (using the same administration) and went through the following steps:

- selected a 'sales order'

- right click 'add activity'

- CTRL + F => select existing activity

- Change Start Time (=> Recontact)

- Update and Ok

Then i deactivated the scenario and went into 'Processing - Test' and selected the same administration for 'Test Sender System' and 'B1 System for Test User'. I then expected to be able to select a 'rectest.xml' in the 'Test Inbound Message', but i could not.

Since i could not recall whether or not i should have selected these last 2 values before hand, i activated the scenarios again and did the same things in SAP. Still no data available.

I have the option 'MAINTENANCE - Cfg Dev Env. - Record Test Message at Runtime' on (hence why i am expecting a test message).

I am using SAP Business One 9.2 (9.20.003) PL: 00 (64 bit)

Anybody any idea why the trigger doesn't seem to be working?

With kind regards,

Ruben