D365 Business Central - Increase the column/field width

Send default attachments in emails from Business Central

D365 Business Central - BigInteger's small trick

DockerDo : a Windows version 10.0.20348-based image is incompatible with a 10.0.19045 host

 

One of my colleagues tried to create a new docker container using the regular script that we used to execute but she got the below error.

 

DockerDo : a Windows version 10.0.20348-based image is incompatible with a 10.0.19045 host

 

We tried to install/update the BCContainerHelper but didn’t help

We also tried to manually download it and install but still no luck.

 

We were getting the below error

 

Unable to find module providers (PowerShellGet)

 

We tried to install/update the PowerShellGet using the below commands but still didn’t work.

 

Install-Module -Name PowerShellGet -Force

Update-Module -Name PowerShellGet

 

The final solution we found was to Navigate to the below folder and delete the folder “Modules”.

Documents\WindowsPowerShell which included a module for "PackageManagement.

Deleting the “Modules” folder resolved the issue and able to create the Docker Container.

 

Delete and try to execute the docker container script in case you face the same issue with the new laptop also.

Synchronize and fulfill Business Central Sales Orders with Shopify – Part 4

 Creating Shopify development stores – Part 3

 

When an order is imported from Shopify, the information about the customer is essential for further processing the document in Business Central. There are two main options and their combinations:

·        Use a special customer for all orders.

·        Import the actual customer information from Shopify.

 

How the connector chooses which customer to use?

 The Import order from the Shopify function tries to select the customer in the following order:

1.     If the Default Customer No. field is defined in the Shopify Customer Template for the corresponding country, then the Default Customer No. is used, regardless of the settings in the Customer Import From Shopify and Customer Mapping Type fields.

 

2.     If the Customer Import From Shopify is set to None and the Default Customer No. is defined in the Shopify Shop Card, then the Default Customer No. is used.

The next steps depend on the Customer Mapping Type.

·        Always take the default customer, then the connector uses the customer defined in the Default Customer No. field in the Shopify Shop Card page.

 

·        By EMail/Phone, the connector tries to find the existing customer by ID first, then by email, and then by phone. If the customer isn't found - the connector creates a new customer.

·        By Info, the connector tries to find the existing customer by ID first and then by the address information. If not found - the connector creates a new customer.

 

 

I am going to use the below settings to map customer by Email/Phone and Auto create customer if not found.

 

Set the import of orders on the Shopify Shop Card

A regular Shopify order can have extra amounts on top, such as shipping charges or, if enabled, tips. These amounts will be posted directly to the G/L accounts. Choose the G/L account that should be used for specific transactions:

·        Shipping Cost Account

·        Sold Gift Card Account

·        Tip account

Enable Auto Create Orders to automatically create sales documents in Business Central once the Shopify order is imported. The sales document in Business Central contains a link to the Shopify order. If you select Shopify Order No. on Doc. Line field, then this information will be repeated in the sales lines of type Comment.

In Shopify online store, open the product catalog.

Choose any product that can be sold, for example ANTWERP Conference Table. Notice that the description contains item attributes.

Choose the Buy it now button and proceed to checkout.

1.     In the Email or mobile phone number field, enter admin@CRMbc534738.onmicrosoft.com (or email where you want to receive order and shipping confirmations).

2.     Enter the First name and Last name

3.     Enter the local address.

4.     Enable the Save this information for next time checkbox.

5.     Choose the Continue to shipping button.

6.     Keep Standard as the shipping method and then choose the Continue to payment button.

7.     In the Credit Card field, enter 1 if you use (for testing) Bogus Gateway, if you use Shopify payments in test mode, enter 5555 5555 5555 4444 in the Credit Card field.

8.     Fill in the Name on card field.

9.     In the Expiration date field, enter the current month/year.

10. In the Security code, enter 111.

11. Choose the Pay now button.

12. Email confirmation received

13. Shopify Order created

In Business Central, do the next steps:

1.     Go to the search icon, enter Shopify Orders, and then choose the related link.

2.     Choose the Sync Orders From Shopify action.

3.     Select the Shopify Code.

4.     Click OK.

The imported order is ready for processing.

1.     Select the imported order to open the Shopify Order window.

2.     Notice that the new customer and sales order is created.

3.     Choose the Sales Order action to open the Sales Order window.

4.     Choose the Reopen action.

5.     In the Agent field, enter DHL.

6.     In Package Tracking No., enter 123456789.

7.     Choose the Post action, keep Ship and Invoice option, and then choose the OK button.

Now physical and financial data is registered in Business Central. It’s time to notify Shopify about the changes.

1.     Go to the search icon, enter Sync Shipments to Shopify, and choose the related link.

2.     Choose OK.

In Shopify Admin notice that the order is now marked as Fulfilled. You can also review Shipment details and see the Tracking URL there. If you run Sync Orders From Shopify again, the order will be archived in both systems.

 

Transactions

The payment transactions that took place at Shopify are synchronized together with the orders and can be viewed from the Shopify Orders page.

Creating Shopify development stores – Part 3

Integrating D365 Business Central with Shopify - Part 1

SynchronizeBusiness Central Items, Prices, Images and Inventory to Shopify - Part 2

 

Start selling the products online

Open Shopify’s online store and open the product catalog.

Choose any product that can be sold, for example, ANTWERP Conference Table. Notice that the description contains item attributes.

Choose the Buy it now button.

Oh Noo, this is not what I wanted ☹

 

Let’s check the Orders section in the Shopify admin portal

 

We cannot create orders as we are using the trial version of Shopify

 

We have 3 options

1.     Choose a plan temporarily and deactivate the plan before you get billed

2.     Create an app development to send the order details via APIs

3.     Create a Shopify Partner Account

 

As a Shopify Partner, you can create an unlimited number of development stores. A development store is a free Shopify account that comes with a few limitations. You can use a development store to test any themes or apps that you create, or to set up a Shopify account for a client.

 

Navigate to https://www.shopify.com/partners

Enter the email address and click Join Now

Enter the Account Information

Click View your dashboard

Click on Create store

 

Save the store information

 

Let’s Activate test payments

From your Shopify admin, go to Settings > Payments.

Click on Activate the test payment provider link on the top of the screen

   Click Activate (for testing) Bogus Gateway.

 

Follow the Steps of to sync Business Central and Shopify

Integrating D365 Business Central with Shopify - Part 1

Synchronize Business Central Items, Prices, Images and Inventory to Shopify - Part 2

 

Now, repeat the above steps again

Open Shopify’s online store and open the product catalog.

Choose any product that can be sold, for example, ANTWERP Conference Table. Notice that the description contains item attributes.

Choose the Buy it now button.

 

Yay!!! Now, we can buy the products.

I will show the full sync with Business Central in next blog