ãããŒãèšèšãã
åŠç¿ã®ç®ç
ãã®åå ãå®äºãããšã次ã®ããšãã§ããããã«ãªããŸãã
- ãããŒã®èšèšã®æºåãããã
- Salesforce ã§æ°èŠäœæãŸãã¯æŽæ°ãããååã NetSuite ã®åšåº«åç®ãã¢ã»ã³ããªåç®ãšèªåçã«åæãããããŒãèšå®ããã
ãããŒã®èšèšã®æºåããã
ãMuleSoft Composer ã®åºæ¬ãã§èª¬æããããã«ããããŒã¯ã·ã¹ãã ãšããŒã¿ãçµ±åããããã«çµã¿åãããŠèšå®ããäžé£ã®ã¹ãããã§ãããããŒãèšèšããåã«ããããŒã§å®è¡ããå¿ èŠãããã¿ã¹ã¯ãããããŒã³ã³ããŒãã³ã圢åŒã«ããé©åãªã¹ãããã«ãããããå¿ èŠããããŸããäžé£ã®æµããçŽã«æãåºããšãã©ã®ãããªãããŒã«ãªããææ¡ãããããªããŸãã
以äžã¯ãåã®åå ã§èª¬æãã NTO ã®ãŠãŒã¹ã±ãŒã¹ã®ãããã³ã°ã®äžäŸã§ããÂ
ã¿ã¹ã¯ |
ãããŒã³ã³ããŒãã³ã |
|---|---|
æ°èŠäœæãŸãã¯æŽæ°ãããååãèŠã€ããã |
ååã®æ°èŠäœæãŸãã¯æŽæ°æã« Sales Cloud ããå®è¡ãããããªã¬ãŒ |
é¢é£ä»ããããŠããäŸ¡æ Œè¡šãååŸããã |
Sales Cloud ã§ããªã¬ãŒååã«é¢é£ä»ããããŠãããã®ãšäŸ¡æ Œè¡š ID ãåãäŸ¡æ Œè¡šããã¹ãŠååŸããã¢ã¯ã·ã§ã³ã¹ããã |
é¢é£ä»ããããŠããäŸ¡æ Œè¡šãšã³ããªãååŸããã |
Sales Cloud ã§ããªã¬ãŒååã«é¢é£ä»ããããŠãããã®ãšäŸ¡æ Œè¡š ID ãšåå ID ãåãäŸ¡æ Œè¡šãšã³ããªããã¹ãŠååŸããã¢ã¯ã·ã§ã³ã¹ããã |
äŸ¡æ Œè¡šãšã³ããªããšã«å埩åŠçããã |
äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ããå ¥åãªã¹ããšããŠäœ¿çšãã For Eachãããã¯ããããŒã®åŸç¶ã®ã¹ãããã¯ããã® For Each ãããã¯å ã§å®è¡ãããŸãã |
察å¿ããåšåº«åç® (ããå Žå) ãååŸããã |
NetSuite ã§ãããªã¬ãŒååã®ãã®ãšåå ID ãåãåšåº«åç®ããã¹ãŠååŸããã¢ã¯ã·ã§ã³ã¹ããã |
ããªã¬ãŒååã«å¯Ÿå¿ããåšåº«åç®ããããã©ããã倿ããã |
åšåº«åç®ã®ãªã¹ãã空 (ã€ãŸããNetSuite ã«åšåº«åç®ãååšããªã) ãã©ãããè©äŸ¡ãã If/Else ãããã¯Â |
察å¿ããåšåº«åç®ãååšããªãå Žå |
If ãããã¯å :
|
察å¿ããåšåº«åç®ãååšããå Žå |
If/Else ãããã¯ã® Else ãã©ã³ãå : NetSuite ã§ãé©åãªååã®è©³çްã䜿çšããŠåšåº«åç®ãæŽæ°ããã |
察å¿ããåšåº«åç®ãååŸããã |
NetSuite ã§ãããªã¬ãŒååã®ãã®ãšåå ID ãåãåšåº«åç®ããã¹ãŠååŸããã¢ã¯ã·ã§ã³ã¹ããã |
é¢é£ä»ããããã¢ã»ã³ããªåç®ãäœæããã |
NetSuite ã§ãåšåº«åç®ãå«ãã¢ã»ã³ããªåç®ãäœæããã¢ã¯ã·ã§ã³ã¹ããããã¢ã»ã³ããªåç®ããåšåº«åç®ã«é¢é£ä»ããããŠãããã®ãšåãé¢é£åäŒç€Ÿã®å éš ID ã䜿çšããŠããããšã確èªããŸãã |
MuleSoft Composer ã§ã¯ããã©ã«ãã§äœæ¥ãæ€èšŒãããæé ã®åã¹ãããã«ã¢ããªã±ãŒã·ã§ã³å ã³ã³ããã¹ããã«ãã衚瀺ãããŸããããšãã°ãã·ã¹ãã ã«æ¥ç¶ã远å ãããšãMuleSoft Composer ã§æ¥ç¶ããã¹ãããããããæ£åžžã«æ©èœããããšã確èªããããã§æ¬¡ã®ã¹ãããã«é²ãããšãã§ããŸãããŸãããããŒãäœæããããããããã«ãåã¹ãããã«å¿ é é ç®ãžã®å ¥åãæ±ããããã³ããã衚瀺ãããŸãã
ãããŒã®äœæã®ãã¹ããã©ã¯ãã£ã¹ã¯ãæ°ã¹ãããããšã«ãã¹ããç¹°ãè¿ããªãããããŒã宿ãããããšã§ããÂ
ãããŒãèšèšãã
Salesforce ã§æ°èŠäœæãŸãã¯æŽæ°ãããååã NetSuite ã®åšåº«åç®ãã¢ã»ã³ããªåç®ãšåæããã€ã³ãã°ã¬ãŒã·ã§ã³ãããŒãèšèšããæºåãæŽããŸãããÂ
æ¬¡ã®æé ã«åŸã£ãŠãããŒãèšèšããŸãã
NTO çµç¹ãã MuleSoft Composer ãèµ·åããŸãã
- ãŠãŒã¶ãŒåãšãã¹ã¯ãŒãã䜿çšã㊠NTO çµç¹ã«ãã°ã€ã³ããŸãã
- ã¢ããªã±ãŒã·ã§ã³ã©ã³ãã£ãŒã«
Composerãšå ¥åã㊠[MuleSoft Composer] ãéžæããŸãã
æ°ãããããŒãäœæããŸãã
-
[Create New Flow (æ°èŠãããŒã®äœæ)] ãã¯ãªãã¯ããŸãã
- ããã©ã«ãã®ãããŒåã®æšªã«ããéçã¢ã€ã³ã³ãã¯ãªãã¯ããŸãã
- ãããŒã«
Sync Salesforce Products to NetSuite Inventory and Assembly Items(Salesforce ã®ååã NetSuite ã®åšåº«åç®ãã¢ã»ã³ããªåç®ãšåæ) ãšååãä»ããŠã[Save (ä¿å)] ãã¯ãªãã¯ããŸãã
NTO çµç¹ã䜿çšããŠãããŒã®ããªã¬ãŒãäœæããŸãã
-
[Salesforce] ãã¯ãªãã¯ããŸãã
-
[Add new Salesforce connection (æ°ãã Salesforce æ¥ç¶ã远å )] ãã¯ãªãã¯ããNTO Sandbox çµç¹ãžã®æ¥ç¶ãäœæããŸãã
ã¡ã¢: åããŠã® Salesforce æ¥ç¶ã®å Žåããã®ãªãã·ã§ã³ã¯è¡šç€ºãããŸãããæ¬¡ã®ã¹ãããã«é²ã¿ãŸãã
- æ¥ç¶ã«
NTO sandbox org(NTO Sandbox çµç¹) ãšååãä»ããŸãã
-
[This is a sandbox organization (ãã㯠Sandbox çµç¹ã§ã)] ãã§ãã¯ããã¯ã¹ããªã³ã«ããŠã[Create (äœæ)] ãã¯ãªãã¯ããŸãã
ã¡ã¢: éçºè çµç¹ã䜿çšããå Žåã¯ããã®ãã§ãã¯ããã¯ã¹ã®éžæãã¹ãããããŠã[Create (äœæ)] ãã¯ãªãã¯ããŸãã
- NTO Sandbox çµç¹ã®ãŠãŒã¶ãŒåãšãã¹ã¯ãŒããå
¥åããŠã[Log In to Sandbox (Sandbox ã«ãã°ã€ã³)] ãã¯ãªãã¯ããŸãã
-
[Allow (èš±å¯)] ãã¯ãªãã¯ããŠãMuleSoft Composer ã«ãID URL ãµãŒãã¹ã«ã¢ã¯ã»ã¹ããAPI ã䜿çšããŠãŠãŒã¶ãŒããŒã¿ã管çãããã€ã§ãèŠæ±ãå®è¡ãæš©éãä»äžããŸããMuleSoft Composer ã§æ¥ç¶ãèªåçã«ãã¹ããããŸãããšã©ãŒã¡ãã»ãŒãžã衚瀺ãããŠããªãå Žåã¯æ¥ç¶ã確ç«ããããããŒã®æåã®ã¹ããã (ããªã¬ãŒ) ã衚瀺ãããŸãã
NTO çµç¹ã§ååãäœæãŸãã¯æŽæ°ããããã³ã«ãããŒãéå§ããããªã¬ãŒãèšå®ããŸãã
- [Choose an event that starts this flow (ãã®ãããŒãéå§ããã€ãã³ããéžæ)] é
ç®ãã¯ãªãã¯ããŠã[New or updated record (ã¬ã³ãŒãã®æ°èŠäœæãŸãã¯æŽæ°)] ãéžæããŸãã
- [Object Type (ãªããžã§ã¯ãçš®å¥)] é
ç®ã«ã
Product(åå) ãšå ¥åããŸãã
- [Sample Output (ãµã³ãã«åºå)] ã»ã¯ã·ã§ã³ãèŠããšãNTO çµç¹ã®ååã®é
ç®ãšé¢é£ä»ããããŠãããµã³ãã«å€ã衚瀺ãããŠããŸãããã®æ
å ±ãããæ£ããçµç¹ã«æ¥ç¶ãããŠããããšãšããããŒã®ä»åŸã®ã¹ãããã§äœ¿çšå¯èœãªããŒã¿ã®æ§é ãããããŸãã
![ããªã¬ãŒã€ãã³ãããªããžã§ã¯ãçš®å¥ã®é
ç®ãš [Select Fields (é
ç®ãéžæ)] ãã¿ã³ã衚瀺ãããŠãããããŒã®ã¹ããã 1](https://res.cloudinary.com/hy4kyit2a/f_auto,fl_lossy,q_70/learn/modules/product-to-inventory-and-assembly-item-data-sync-with-mulesoft-composer/design-a-flow-17/images/ja-JP/8713a9f95085ccc2d3244e1a7d575166_kix.3jwp98cyj5xz.png)
-
[Save (ä¿å)] ãã¯ãªãã¯ããŠãããŒãä¿åããŸãã
Sales Cloud ã§ããªã¬ãŒååã«é¢é£ä»ããããŠãããã®ãšäŸ¡æ Œè¡š ID ãåãäŸ¡æ Œè¡šããã¹ãŠååŸããããããŒã® 2 ã€ç®ã®ã¹ããããäœæããŸããÂ
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ããŠã¹ãããã远å ããŸãã
-
[Salesforce] ãã¯ãªãã¯ããŠã[NTO sandbox org (NTO Sandbox çµç¹)] ãã¯ãªãã¯ããŸãã
Sales Cloud ã§ããªã¬ãŒååã«é¢é£ä»ããããŠãããã®ãšäŸ¡æ Œè¡š ID ãåãäŸ¡æ Œè¡šããã¹ãŠååŸãã 2 ã€ç®ã®ã¹ããããèšå®ããŸããÂ
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ããŠã[Get records (ã¬ã³ãŒããååŸ)] ãéžæããŸãã
- [Object Type (ãªããžã§ã¯ãçš®å¥)] é
ç®ã«ã
Price Book(äŸ¡æ Œè¡š) ãšå ¥åããŸãã
- [Conditions to filter the objects (ãªããžã§ã¯ããçµãèŸŒãæ¡ä»¶)] éžæãªã¹ãã§ã[All conditions must be met (AND) (ãã¹ãŠã®æ¡ä»¶ãæºããå¿
èŠããã (AND))] ãéžæããŸãã
- é
ç®ã« [Price Book ID (äŸ¡æ Œè¡š ID)]ãæŒç®åã« [Equals (次ã®å€ãšäžèŽãã)] ãéžæããŠãåå
1 ã§ååŸããæšæºäŸ¡æ Œè¡šã®äŸ¡æ Œè¡š ID ãæå®ããŸãããã®ãããŒã®äŸã§ã¯ 01s1U000005mSpYQAU ã§ãã
Sales Cloud ã§ããªã¬ãŒååã«é¢é£ä»ããããŠãããã®ãšäŸ¡æ Œè¡š ID ãšåå D ãåãäŸ¡æ Œè¡šãšã³ããªããã¹ãŠååŸããããããŒã® 3 ã€ç®ã®ã¹ããããäœæããŸããÂ
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ããŠã¹ãããã远å ããŸãã
-
[Salesforce] ãã¯ãªãã¯ããŠã[NTO sandbox org (NTO Sandbox çµç¹)] ãã¯ãªãã¯ããŸãã
Sales Cloud ã§ããªã¬ãŒååã«é¢é£ä»ããããŠãããã®ãšäŸ¡æ Œè¡š ID ãšåå D ãåãäŸ¡æ Œè¡šãšã³ããªããã¹ãŠååŸãã 3 ã€ç®ã®ã¹ããããèšå®ããŸããÂ
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ããŠã[Get records (ã¬ã³ãŒããååŸ)] ãéžæããŸãã
- [Object Type (ãªããžã§ã¯ãçš®å¥)] é
ç®ã«ã
Price Book Entry(äŸ¡æ Œè¡šãšã³ããª) ãšå ¥åããŸãã
- [Conditions to filter the objects (ãªããžã§ã¯ããçµãèŸŒãæ¡ä»¶)] éžæãªã¹ãã§ã[All conditions must be met (AND) (ãã¹ãŠã®æ¡ä»¶ãæºããå¿
èŠããã (AND))] ãéžæããŸãã
- é
ç®ã« [Pricebook2Id]ãæŒç®åã« [Equals (次ã®å€ãšäžèŽãã)] ãéžæããŠãåå
1 ã§ååŸããæšæºäŸ¡æ Œè¡šã®äŸ¡æ Œè¡š ID ãå
¥åããŸãããã®ãããŒã®äŸã§ã¯ 01s1U000005mSpYQAU ã§ãã
-
[Add a condition (æ¡ä»¶ã远å )] ãã¯ãªãã¯ããŸãã
- é
ç®ã« [Product2Id]ãæŒç®åã« [Equals (次ã®å€ãšäžèŽãã)] ãéžæãããããŒã®ã¹ããã 1 ã®åå ID ãæå®ããŸãã
ãããŒã®ã¹ããã 3 ã®äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ãããååŸããäŸ¡æ Œè¡šãšã³ããªããšã«å埩åŠçãã For Each ãããã¯ãäœæããŠèšå®ããŸãããããŒã®åŸç¶ã®ã¹ãããã¯ããã® For Each ãããã¯å ã§å®è¡ãããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ããŠã¹ãããã远å ããŸãã
- ã¹ã¯ããŒã«ããŠã³ã㊠[For Each] ãéžæããŸãã
- [Input list (å
¥åãªã¹ã)] é
ç®ã§ããããŒã®ã¹ããã 3 ã® [List of Price Book Entry (äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ã)] ãéžæããŸãã
NetSuite ã§ããªã¬ãŒååã®ãã®ãšåå ID ãåãåšåº«åç®ããã¹ãŠååŸããããããŒã® 4 ã€ç®ã®ã¹ããããäœæããŸããÂ
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ããŠã¹ãããã远å ããŸãã
-
[NetSuite] ãã¯ãªãã¯ããŸãã
-
[Add new NetSuite connection (æ°ãã NetSuite æ¥ç¶ã远å )] ãã¯ãªãã¯ããŸãã
ã¡ã¢: ä»ååããŠæ¥ç¶ããå Žåã¯ãã®ãªãã·ã§ã³ã衚瀺ãããŸãããæ¬¡ã®ã¹ãããã«é²ã¿ãŸãã
- NetSuite ã®æ¥ç¶ãã©ã¡ãŒã¿ãŒå€ãèšèŒãããããã¹ããã¡ã€ã«ãåç
§ããŠãå¿
é ã®å€ãå
¥åããæ¥ç¶è¡šç€ºåã
NTO NetSuiteã«ããŠã[Create (äœæ)] ãã¯ãªãã¯ããŸããMuleSoft Composer ã§æ¥ç¶ãèªåçã«ãã¹ããããŸãããšã©ãŒã¡ãã»ãŒãžã衚瀺ãããŠããªãå Žåã¯æ¥ç¶ã確ç«ããããããŒã® 4 ã€ç®ã®ã¹ãããã衚瀺ãããŸãã
NetSuite ã§ããªã¬ãŒååã®ãã®ãšåå ID ãåãåšåº«åç®ããã¹ãŠååŸãã 4 ã€ç®ã®ã¹ããããèšå®ããŸãã
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ããŠã[Get Records (ã¬ã³ãŒããååŸ)] ãéžæããŸãã
- [Record Type (ã¬ã³ãŒãã¿ã€ã)] é
ç®ã«ã
INVENTORY_ITEMãšå ¥åããŸãã
- [Conditions to filter the objects (ãªããžã§ã¯ããçµãèŸŒãæ¡ä»¶)] éžæãªã¹ãã§ã[All conditions must be met (AND) (ãã¹ãŠã®æ¡ä»¶ãæºããå¿
èŠããã (AND))] ãéžæããŸãã
- é
ç®ã« [Salesforce Product ID (Salesforce åå ID)]ãæŒç®åã« [Is (次ã®å€ãšçãã)] ãéžæãããããŒã®ã¹ããã 1 ã®åå ID ãæå®ããŸãã
ããªã¬ãŒååã«å¯Ÿå¿ããåšåº«åç®ããããã©ããã倿ãã If/Else ãããã¯ãäœæããŠèšå®ããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ããŠã¹ãããã远å ããŸãã
- ã¹ã¯ããŒã«ããŠã³ã㊠[If/Else Block (If/Else ãããã¯)] ãã¯ãªãã¯ããŸããããã©ã«ãã§ [All conditions must be met (AND) (ãã¹ãŠã®æ¡ä»¶ãæºããå¿
èŠããã (AND))] ãéžæãããŠããŸãã
- é
ç®ã«ãããŒã®ã¹ããã 4 ã® [List of INVENTORY_ITEM (INVENTORY_ITEM ã®ãªã¹ã)]ãæŒç®åã« [Is empty (空)] ãéžæããŸãããã®æ¡ä»¶ãæºãããå Žåã¯ãååã«å¯Ÿå¿ããåšåº«åç®ããªãããšã«ãªããŸãããã®å Žåã¯ãIf ãã©ã³ãã®åŸç¶ã® 2 ã€ã®ã¹ããã (NetSuite ã§ã®åšåº«åç®ã®äœæãSalesforce ã§ã®ååã®æŽæ°) ãå®è¡ãããŸãã
NetSuite ã§é¢é£ä»ããããåå ID ã䜿çšããŠåšåº«åç®ãäœæããããããŒã® 4 ã€ç®ã®ã¹ãããã If/Else ãããã¯ã® If ãã©ã³ãå ã«äœæããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ã㊠If ãã©ã³ãã«ã¹ãããã远å ããŸãã
-
[NetSuite] ãã¯ãªãã¯ããŠã[NTO NetSuite] ãã¯ãªãã¯ããŸãã
NetSuite ã§é¢é£ä»ããããåå ID ã䜿çšããŠåšåº«åç®ãäœæãã 5 ã€ç®ã®ã¹ãããã If ãã©ã³ãå ã«èšå®ããŸãã
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ãã[Create Record (ã¬ã³ãŒããäœæ)] ãéžæããŸãã
- [Type of Record (ã¬ã³ãŒãã¿ã€ã)] é
ç®ã«ã
INVENTORY_ITEMãšå ¥åããŸãã
-
[Add Fields (é
ç®ã远å )] ãã¯ãªãã¯ããŸãã
- æ€çŽ¢é
ç®ã䜿çšããŠã次ã®é
ç®ãèŠã€ããŠéžæãã[Add (远å )] ãã¯ãªãã¯ããŸãã
ãã³ã: æ€çŽ¢ããé ç®ã®ããŒã¯ãŒããå ¥åãã衚瀺ãããé ç®ã®äžããé©åãªãã®ãéžæããŸããããŒã¯ãŒããã¯ãªã¢ããŠã次ã®é ç®ã§ãã®ããã»ã¹ãç¹°ãè¿ããŸãããã¹ãŠã®é ç®ãéžæãããã[Add (远å )] ãã¯ãªãã¯ããŸãã
ãã®çµæã[Record Ref List (ã¬ã³ãŒãåç §ãªã¹ã)] ãšããå¥ã®é ç®ãèªåçã«è¿œå ãããŸãã[Record Ref List (ã¬ã³ãŒãåç §ãªã¹ã)] ãæ¬¡ã®äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ãã«ãããããŸãã
- Display Name (衚瀺å)
- Item Id (åç® ID)
- Purchase Description (賌å
¥èª¬æ)
- Record (ã¬ã³ãŒã) > Custom Field List (ã«ã¹ã¿ã é
ç®ãªã¹ã) > Salesforce Product ID (Salesforce åå ID)
- Record (ã¬ã³ãŒã) > Subsidiary List (é¢é£åäŒç€Ÿãªã¹ã) > Record Ref List (ã¬ã³ãŒãåç
§ãªã¹ã) > InternalId
- Record (ã¬ã³ãŒã) > Tax Schedule (çšé¡è¡š) > InternalId
- INVENTORY_ITEM é
ç®ãããããŒã®å
è¡ããã¹ãããã§ãã£ããã£ãã察å¿ããé
ç®ã«æ¬¡ã®ããã«ãããããŸãã
- Display Name (衚瀺å) = ã¹ããã 1 ã® [Product Name (ååå)]
- Item Id (åç® ID) = ã¹ããã 1 ã® [Product Code (ååã³ãŒã)]
- Purchase Description (賌å
¥èª¬æ) = ã¹ããã 1 ã® [Product Description (åå説æ)]
- Record (ã¬ã³ãŒã) > Custom Field List (ã«ã¹ã¿ã é
ç®ãªã¹ã) > Salesforce Product ID (Salesforce åå ID) = ã¹ããã 1 ã® [Product ID (åå ID)]
- Record (ã¬ã³ãŒã) > Subsidiary List (é¢é£åäŒç€Ÿãªã¹ã) > Record Ref (ã¬ã³ãŒãåç
§) = ã¹ããã 3 ã® [List of Price Book Entry (äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ã)]
- Record (ã¬ã³ãŒã) > Subsidiary List (é¢é£åäŒç€Ÿãªã¹ã) > Record Ref (ã¬ã³ãŒãåç
§) > InternalId =
1ããã®å€ã¯ Honeycomb Mfg é¢é£åäŒç€Ÿã衚ããŸãã
- Record (ã¬ã³ãŒã) > Tax Schedule (çšé¡è¡š) > InternalId =
1ããã®å€ã¯ S1 çšé¡è¡šã衚ããŸãã
Sales Cloud ã§é¢é£ä»ããããåšåº«åç®ã®å éš ID ã䜿çšããŠããªã¬ãŒååãæŽæ°ããããããŒã® 6 ã€ç®ã®ã¹ãããã If/Else ãããã¯ã® If ãã©ã³ãå ã«äœæããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ã㊠If ãã©ã³ãå
ã«ã¹ãããã远å ããŸãã
-
[Salesforce] ãã¯ãªãã¯ããŠã[NTO sandbox org (NTO Sandbox çµç¹)] ãã¯ãªãã¯ããŸãã
Sales Cloud ã§é¢é£ä»ããããåšåº«åç®ã®å éš ID ã䜿çšããŠããªã¬ãŒååãæŽæ°ãã 6 ã€ç®ã®ã¹ãããã If ãã©ã³ãå ã«èšå®ããŸãã
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ããŠã[Update record (ã¬ã³ãŒããæŽæ°)] ãéžæããŸãã
- [Object Type (ãªããžã§ã¯ãçš®å¥)] é
ç®ã«ã
Product(åå) ãšå ¥åããŸãã[Product ID (åå ID)] ã¯å¿ é é ç®ã®ãããèªåçã«éžæãããŸãã
-
[Add Fields (é
ç®ã远å )] ãã¯ãªãã¯ããŸãã
- æ€çŽ¢ããŒã«ã䜿çšã㊠[NetSuite Item ID (NetSuite åç® ID)] ãéžæãã[Add (远å )] ãã¯ãªãã¯ããŸãã
- ååé
ç®ãããããŒã®å
è¡ããã¹ãããã§ãã£ããã£ãã察å¿ããé
ç®ã«æ¬¡ã®ããã«ãããããŸãã
- Product ID (åå ID) = ã¹ããã 1 ã® [Product ID (åå ID)]
- NetSuite Item ID (NetSuite åç® ID) = ã¹ããã 5 ã® [InternalId]
ããªã¬ãŒååã«å¯Ÿå¿ããåšåº«åç®ãæŽæ°ãã Else ãã©ã³ãã If/Else ãããã¯å ã«äœæããŸãã
- If/Else ãããã¯ã®äžéšã«ãã [Add Else (Else ã远å )] ãã¯ãªãã¯ããŸãã
NetSuite ã§é©åãªååã®è©³çްã䜿çšããŠåšåº«åç®ãæŽæ°ãã 7 ã€ç®ã®ã¹ãããã If/Else ãããã¯ã® Else ãã©ã³ãå ã«äœæããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ã㊠Else ãã©ã³ãå
ã«ã¹ãããã远å ããŸãã
-
[NetSuite] ãã¯ãªãã¯ããŠã[NTO NetSuite] ãã¯ãªãã¯ããŸãã
NetSuite ã§é©åãªååã®è©³çްã䜿çšããŠåšåº«åç®ãæŽæ°ãã 7 ã€ç®ã®ã¹ããããèšå®ããŸãã
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ããŠã[Update Record (ã¬ã³ãŒããæŽæ°)] ãéžæããŸãã
- [Type of Record (ã¬ã³ãŒãã¿ã€ã)] é
ç®ã«ã
INVENTORY_ITEMãšå ¥åããŸãã
- [ID Type (ID çš®å¥)] é
ç®ã§ã
INTERNAL(å éš) ãéžæããŸãã[Record Id (ã¬ã³ãŒã ID)] ã¯å¿ é é ç®ã®ãããèªåçã«éžæãããŸãã
-
[Add Fields (é
ç®ã远å )] ãã¯ãªãã¯ããŸãã
- æ€çŽ¢é
ç®ã䜿çšããŠã次ã®é
ç®ãèŠã€ããŠéžæãã[Add (远å )] ãã¯ãªãã¯ããŸãã
- Display Name (衚瀺å)
- Purchase Description (賌å
¥èª¬æ)
- INVENTORY_ITEM é
ç®ãããããŒã®å
è¡ããã¹ãããã§ãã£ããã£ãã察å¿ããé
ç®ã«æ¬¡ã®ããã«ãããããŸãã
- Record Id (ã¬ã³ãŒã ID) = ã¹ããã 1 ã® [NetSuite Item ID (NetSuite åç® ID)]
- Display Name (衚瀺å) = ã¹ããã 1 ã® [Product Name (ååå)]
- Purchase Description (賌å
¥èª¬æ) = ã¹ããã 1 ã® [Product Description (åå説æ)]
NetSuite ã§ããªã¬ãŒååã®ãã®ãšåå ID ãåãåšåº«åç®ããã¹ãŠååŸããããããŒã® 8 ã€ç®ã®ã¹ããããäœæããŸãããã®ã¹ããã㯠If/Else ãããã¯å€ã«ãããŸããããã®å€åŽã® For Each ãããã¯å ã«ååšããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ããŠã¹ãããã远å ããŸãã
-
[NetSuite] ãã¯ãªãã¯ããŠã[NTO NetSuite] ãã¯ãªãã¯ããŸãã
NetSuite ã§ããªã¬ãŒååã®ãã®ãšåå ID ãåãåšåº«åç®ããã¹ãŠååŸãã 8 ã€ç®ã®ã¹ããããèšå®ããŸãããã®æ å ±ã䜿çšããŠã次ã®ã¢ã»ã³ããªåç®ã«å ¥åããŸãã
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ããŠã[Get Records (ã¬ã³ãŒããååŸ)] ãéžæããŸãã
- [Record Type (ã¬ã³ãŒãã¿ã€ã)] é
ç®ã«ã
INVENTORY_ITEMãšå ¥åããŸãã
- [Conditions to filter the objects (ãªããžã§ã¯ããçµãèŸŒãæ¡ä»¶)] éžæãªã¹ãã§ã[All conditions must be met (AND) (ãã¹ãŠã®æ¡ä»¶ãæºããå¿
èŠããã (AND))] ãéžæããŸãã
- é
ç®ã« [Salesforce Product ID (Salesforce åå ID)]ãæŒç®åã« [Is (次ã®å€ãšçãã)] ãéžæãããããŒã®ã¹ããã 1 ã®åå ID ãæå®ããŸãã
NetSuite ã§é©åãªååãšåšåº«åç®ã®è©³çްã䜿çšããŠãé¢é£ä»ããããåšåº«åç®ãå«ãæ°ããã¢ã»ã³ããªåç®ãäœæããããããŒã® 9 ã€ç®ã®ã¹ããããäœæããŸãã
- ãã©ã¹ã¢ã€ã³ã³ãã¯ãªãã¯ã㊠If ãã©ã³ãã«ã¹ãããã远å ããŸãã
-
[NetSuite] ãã¯ãªãã¯ããŠã[NTO NetSuite] ãã¯ãªãã¯ããŸãã
NetSuite ã§é©åãªååãšåšåº«åç®ã®è©³çްã䜿çšããŠãé¢é£ä»ããããåšåº«åç®ãå«ãæ°ããã¢ã»ã³ããªåç®ãäœæãã 9 ã€ç®ã®ã¹ããããäœæããŠèšå®ããŸããã¢ã»ã³ããªåç®ããåšåº«åç®ã«é¢é£ä»ããããŠãããã®ãšåãé¢é£åäŒç€Ÿã®å éš ID ã䜿çšããŠããããšã確èªããŸãã
- [Action (ã¢ã¯ã·ã§ã³)] é
ç®ãã¯ãªãã¯ãã[Create Record (ã¬ã³ãŒããäœæ)] ãéžæããŸãã
- [Type of Record (ã¬ã³ãŒãã¿ã€ã)] é
ç®ã«ã
ASSEMBLY_ITEMãšå ¥åããŸãã
-
[Add Fields (é
ç®ã远å )] ãã¯ãªãã¯ããŸãã
- æ€çŽ¢é
ç®ã䜿çšããŠã次ã®é
ç®ãèŠã€ããŠéžæãã[Add (远å )] ãã¯ãªãã¯ããŸãã
ãã®çµæã[Item Member List (åç®ã¡ã³ããŒãªã¹ã)] ãš 2 ã€ã® [Pricing List (äŸ¡æ Œèšå®ãªã¹ã)] ã®èš 3 ã€ã®é ç®ãèªåçã«è¿œå ãããŸãããã® 3 ã€ã®é ç®ã次ã®é¢é£ããé ç®ã«ãããããŸãã
- Description (説æ)
- Display Name (衚瀺å)
- Item Id (åç® ID)
- Use Component Yield (éšåã®æ©çãŸãã®äœ¿çš)
- Record (ã¬ã³ãŒã) > Member List (ã¡ã³ããŒãªã¹ã) > Item Member (åç®ã¡ã³ããŒ) > Bom Quantity (BOM æ°é)
- Record (ã¬ã³ãŒã) > Member List (ã¡ã³ããŒãªã¹ã) > Item Member (åç®ã¡ã³ããŒ) > Item (åç®) > InternalId
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Currency (é貚) > InternalID
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Price Level (äŸ¡æ Œã¬ãã«)
- InternalID
- Name (åå)
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Price Level (äŸ¡æ Œãªã¹ã)
- Quantity (æ°é)
- Value (å€)
- Record (ã¬ã³ãŒã) > Subsidiary List (é¢é£åäŒç€Ÿãªã¹ã) > Record Ref List (ã¬ã³ãŒãåç
§ãªã¹ã) > InternalId
- Record (ã¬ã³ãŒã) > Tax Schedule (çšé¡è¡š) > InternalId
- ASSEMBLY_ITEM é
ç®ãããããŒã®å
è¡ããã¹ãããã§ãã£ããã£ãã察å¿ããé
ç®ã«æ¬¡ã®ããã«ãããããŸãã
ã¡ã¢: é ç®ãè€æ°ã®å€ã«ãããããå¿ èŠãããå Žåã¯ããã®é ç®ãã¯ãªãã¯ããŠã[Custom Expression (ã«ã¹ã¿ã åŒ)] ãã¯ãªãã¯ããŸããã«ã¹ã¿ã åŒãšãã£ã¿ãŒãéããŸãããã®ã«ã¹ã¿ã åŒãšãã£ã¿ãŒã䜿çšããŠããããŒã®å è¡ããã¹ãããããåã蟌ãåçãªé ç®å€ãšãŠãŒã¶ãŒãå ¥åããéçãªããã¹ããçµã¿åãããé ç®ãèšå®ããŸãã
- Description (説æ) = ã¹ããã 1 ã® [Product Description (åå説æ)]
assembly item(ã¢ã»ã³ããªåç®) (ã¢ã»ã³ããªã®åã«ã¹ããŒã¹ãæ¿å ¥)
- Display Name (衚瀺å) = ã¹ããã 1 ã® [Product Name (ååå)] ã¹ããã 1 ã® [Last Modified Date (æçµæŽæ°æ¥)] ([Last Modified Date (æçµæŽæ°æ¥)] ã®åã«ã¹ããŒã¹ãæ¿å
¥)
- Item Id (åç® ID) = ã¹ããã 1 ã® [Product Code (ååã³ãŒã)] ã¹ããã 1 ã® [Last Modified Date (æçµæŽæ°æ¥)] ([Last Modified Date (æçµæŽæ°æ¥)] ã®åã«ã¹ããŒã¹ãæ¿å
¥)
- Use Component Yield (éšåã®æ©çãŸãã®äœ¿çš) =
trueããã®é ç®ã¯ã補é éçšã«ãããåææã®æå€±ã«å¯Ÿãã BOM æ°éãèªåçã«èšç®ããããã«äœ¿çšããŸãã
- Record (ã¬ã³ãŒã) > Member List (ã¡ã³ããŒãªã¹ã) > Item Member (åç®ã¡ã³ããŒ) > Item Member List (åç®ã¡ã³ããŒãªã¹ã) = ã¹ããã 8 ã® [List of INVENTORY_ITEM (INVENTORY_ITEM ã®ãªã¹ã)]
- Record (ã¬ã³ãŒã) > Member List (ã¡ã³ããŒãªã¹ã) > Item Member (åç®ã¡ã³ããŒ) > Bom Quantity (BOM æ°é) =
10 - Record (ã¬ã³ãŒã) > Member List (ã¡ã³ããŒãªã¹ã) > Item Member (åç®ã¡ã³ããŒ) > Item (åç®) > InternalId = ã¹ããã 8 ã® [Record (ã¬ã³ãŒã)] > [InternalId]
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Pricing List (äŸ¡æ Œèšå®ãªã¹ã) = ã¹ããã 3 ã® [List of Price Book Entry (äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ã)]
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Currency (é貚) > InternalID =
1ããã®å€ã¯ç±³ãã«ã衚ããŸãã
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Price Level (äŸ¡æ Œã¬ãã«):
- InternalID =
1ããã®å€ã¯ç±³ãã«ãµããªã¹ãã®ãªã¹ãäŸ¡æ Œã¬ãã«ã衚ããŸãã
- Name (åå) =
List Price(ãªã¹ãäŸ¡æ Œ)ããã®å€ã¯ç±³ãã«ãµããªã¹ãã®ãªã¹ãäŸ¡æ Œã¬ãã«ã®ååã§ãã
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Price Level (äŸ¡æ Œã¬ãã«) > Price (äŸ¡æ Œ) > Price List (äŸ¡æ Œã¬ãã«) = ã¹ããã 3 ã® [List of Price Book Entry (äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ã)]
- Record (ã¬ã³ãŒã) > Pricing Matrix (äŸ¡æ Œèšå®ãããªãã¯ã¹) > Pricing (äŸ¡æ Œèšå®) > Price List (äŸ¡æ Œãªã¹ã):
- Quantity (æ°é) =
0ããã®å€ã¯ç±³ãã«ãµããªã¹ãã®æ°é 0 åã衚ããŸãã
- Value (å€) = ã¹ããã 3 ã® [List Price (ãªã¹ãäŸ¡æ Œ)]
- Record (ã¬ã³ãŒã) > Subsidiary List (é¢é£åäŒç€Ÿãªã¹ã) > Record Ref (ã¬ã³ãŒãåç
§) = ã¹ããã 3 ã® [List of Price Book Entry (äŸ¡æ Œè¡šãšã³ããªã®ãªã¹ã)]
- Record (ã¬ã³ãŒã) > Subsidiary List (é¢é£åäŒç€Ÿãªã¹ã) > Record Ref (ã¬ã³ãŒãåç
§) > InternalId =
1ããã®å€ã¯ Honeycomb Mfg é¢é£åäŒç€Ÿã衚ããŸãããããŒã®ã¹ããã 5 ã§åšåº«åç®ã®äœæã«äœ¿çšãããã®ãšåãã§ãã
- Record (ã¬ã³ãŒã) > Tax Schedule (çšé¡è¡š) > InternalId =
1ããã®å€ã¯ S1 çšé¡è¡šã衚ããŸãã
- ãããŒãä¿åããŸãããããŒå
šäœã¯æ¬¡ã®ããã«ãªããŸãã














é 調ã§ã! 次ã®åå ã§ã¯ããããŒããã¹ãããŠæ£åžžã«æ©èœããããšã確èªããæ¹æ³ãåŠç¿ããŸãã
