Vistas Cloud

  • Home
  • Create Multiple Purchase Orders in One Click – Apps for Business Central
Create Multiple Purchase Orders in One Click
Michael Pido October 20, 2022 0 Comments

Bulk Purchase Order Creation for Microsoft Dynamics 365 Business Central

Bulk Purchase Order Creation | Microsoft AppSource

The fastest way to create multiple purchase orders in one click is to use the Bulk Purchase Order Creation App. This App can be prepared in Excel by copying the template from Business Central. Fill out the necessary fields and copy them back to Business Central before clicking the Create Order button. This tool is also helpful to set up a new Business Central production environment.

Supported Editions:

    • Microsoft Dynamics 365 Business Central Essentials
    • Microsoft Dynamics 365 Business Central Premium

Supported Countries:

    • All countries where Business Central is available.

Supported Language:

    • English

Note:

    • Any questions or need assistance with the setup please feel free to contact VISTAS CLOUD.

The following steps to make the Bulk Purchase Order Creation work:

  1. Copying VISTAS Header and Line templates from Business Central to Excel.
  2. Filling out the fields in Excel for Purchase Headers and Lines.
  3. Copying Excel – Purchase Headers and Lines to Business Central – VISTAS Headers and Lines.
  4. Generating bulk purchaser orders by clicking the Create Orders action button from the VISTAS Headers page.

Copying VISTAS Header and Line templates from Business Central to Excel

To copy and paste the templates, search for VISTAS Headers in the Tell Me window and select the related link. Create Multiple Purchase Orders in One Click 1

Select Edit List action and copy the row as a template by pressing control-c from your keyboard.

Create Multiple Purchase Orders in One Click 2

Paste the row to Excel by pressing control-v from your keyboard.

Create Multiple Purchase Orders in One Click 3

Open VISTAS Purchase Lines.

Create Multiple Purchase Orders in One Click 4

Copy the VISTAS Purchase Lines – row.

Create Multiple Purchase Orders in One Click 5

Paste the row to Excel.

Create Multiple Purchase Orders in One Click 6

Filling out the fields in Excel for Purchase Headers and Lines

Create Multiple Purchase Orders in One Click 7

Fill out fields for Purchase Headers in Excel.

Create Multiple Purchase Orders in One Click 8

Fill out fields for Purchase Lines in Excel. Please note that if the Direct Unit Cost is zero it will pull the cost from the Item Card during the Bulk Purchase Order Creation.

Create Multiple Purchase Orders in One Click 9

Copying Excel – Purchase Headers and Lines to Business Central – VISTAS Headers and Lines

Copy the purchase header table to VISTAS Purchase Headers.

Create Multiple Purchase Orders in One Click 9

Create Multiple Purchase Orders in One Click 10

 

Copy the purchase line table to VISTAS Purchase Lines.

Create Multiple Purchase Orders in One Click 11 Create Multiple Purchase Orders in One Click 12

Generating bulk purchaser order by clicking the Create Orders action button from VISTAS Headers page

To generate Bulk Purchase Order Creation, select Create Orders action button.

Create Multiple Purchase Orders in One Click 13

A bulk purchase order has been created.Create Multiple Purchase Orders in One Click 14

Microsoft Dynamics 365 Business Central