How to define No. Series in Business Central
Association of entities to specific No. Series makes their identification easier and plays an important role in data structuring. This is why every company prefers to assign unique identification codes to their data like customers, vendors, items, invoices, etc.
Defining No. Series in Business Central
Mostly things are referred to, through their specific numbers, and records are maintained accordingly in Business Central. To define No. Series in Business Central search “No. Series” through the search option and open the related link.

No. Series in Business Central
The list of all the existing number series in the system will appear. We can define the new series using the “New” option and also modify the existing one.
Click on “New” and an empty line will appear as shown below
Fill in the code and description for the series you want to define and then click on the starting no.
The following window will appear. Fill in the details according to your requirements like its Starting date, Starting No., Ending No. The warning no. means at which point it notifies that the defined number series is about to end, and you can define the new one then. Moreover, define the increment between numbers as per your choice. In the considered series the next number automatically generated, will be incremented by 5 as it is mentioned in the Increment by No. tab.
After filling in the details, close the window. Checkmark on Default Numbers if you want to generate numbers automatically and, checkmark on the manual if you want to enter numbers manually while working with that particular entity like item, vendor, etc. If it is on both, it means that the numbers can come automatically, and we can change/enter the number manually also.
To edit any existing No. Series, click on starting no. the related window will open, make appropriate changes, and close the window. As this no. series is already in use so the last used number and last used date are also coming as shown below.
accsoft has years of experience in implementing Microsoft ERPs. For further assistance and to make us your implementation partner reach us at info@accsoft.com
- Published in Dynamics 365 BC
Batches Part 3: Posting a Batch in Microsoft Dynamics GP
Batches are groups of transactions, identified by a name or a number that you can use for identification purposes, and to make the process easier. You can use batches to group similar transactions during data entry and review them before posting at a later time. Similarly, you can identify batches as a group of transactions entered by a specific employee or on a particular date.
Batch posting allows you to post a group of transactions simultaneously. The benefits of batch posting include easier usage and efficiency for entering large quantities of transactions and tracking transactions for audit purposes. Also, for consistency of process, we can even enter and post single transactions by batch.
To get the most benefit from batches, it is experts recommend to always print and review the Batch Edit Lists. You can avoid many posting interruptions simply by printing the Batch Edit List prior to posting and checking for errors. Most importantly, the Batch Edit List can be printed from any module’s Batch Entry window from the printer icon on the top right of the window.
Posting a batch
Use the Payables Batch Entry window to post a batch. Click Purchasing →Transaction →Batches
- Select Batch ID by clicking the lookup or magnifying glass.
- Check the posting date and currency ID.
- Verify the batch total under Actual.
- Click ‘Post’.
Posting makes transactions part of your company’s permanent records. Until they’re posted, transactions can be modified, voided, or deleted. Once we post it, they are not alterable, though you can enter correcting transactions.
Want to know more about batches in Microsoft Dynamics GP? Then visit us at Microsoft Dynamics GP – Great Plains.
No need to worry, AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266 to get a free demo of 1 hour.
- Published in Add-on, Dynamics GP, Technology
Batches Part 4: Posting batches by series in Microsoft Dynamics GP
Batches are groups of transactions, identified by a name or a number that you can use for identification purposes, and to make the posting process easier. You can use batches to group similar transactions during data entry and review them before posting at a later time. Similarly, you can identify batches as a group of transactions entered by a specific employee or on a particular date. The Series Posting window can save a lot of time because it allows you to post multiple batches for the series (ie: Financial, Sales, Purchasing, Inventory, etc.) you have selected.
Posting batches by series
Use the Purchasing Series Posting window to post Payables batches by series. In other words, series posting lets you post any batch that’s been entered in the Purchasing series. This makes posting easier and less time-consuming. Click Purchasing → Transaction→Series Post
- Click ‘All’ to view all the batches.
- Check the box next to the batches you would like to post or click ‘Mark All’ to mark all the batches.
- To verify what you have marked, click the radio button ‘Marked’ in the Display Batches section.
- Click ‘Post‘ and the batches will post.
The transactions in the batches update vendor summary information, tax records, and distribution accounts, and become part of the company’s permanent records. Your checkbook also is updated if you’re using Bank Reconciliation. Posting journals and distribution breakdown registers might appear for printing, depending on the options you selected in the Posting Setup window.
Want to know more about batches in Microsoft Dynamics GP? Then visit us at Microsoft Dynamics GP – Great Plains.
No need to worry, AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266 to get a free demo of 1 hour.
- Published in Add-on, Dynamics GP, Technology
Fashion Inventory Matrix in Microsoft Dynamics GP
Fashion Inventory Matrix provides a powerful solution for wholesale and distribution companies dealing with multi-dimensional inventory items. The Fashion Inventory Matrix helps companies provide top-of-line customer service, better manage inventories and improve the purchase ordering process.
If you have ever worked in apparel, footwear, luggage, or any industry that has complicated dimensions, then you’ll know how frustrating it is to create purchase and sales orders.
For example, a footwear wholesaler will need a specific item number for each item that specifies its style, size, and color. A brown hiking boots size 11 will have a different item number than a size 12; or from a black hiking boot of the same size; or even brown dress or shoes of the same size. In short, a change in each dimension will create a distinctly independent item number.
As you can see this means a simple order has become a frantic scavenger hunt for the item numbers needed to fill an order. Luckily, we have a solution that renders this tedious process obsolete: The Inventory Matrix for Microsoft Dynamics GP.
Fashion Inventory Matrix Features
- Create unlimited dimensions – E.g. brand, style, color, size, texture, thickness, etc.
- Create unlimited dimensions members– E.g. black. Brown, blue, green, etc.
- Create unlimited Product Lines – E.g. apparel, footwear, accessories, jackets, etc.
- Assign dimensions to product lines – E.g. type, brand, and style can be assigned to the apparel product line.
- Assign dimension members to product lines – E.g. members of the ‘Brand’ dimension can be assigned to the ‘Apparel’ product line.
Purchase Order Processing Features
- Enhanced Visibility – Visibility of all the available colors, sizes, and quantities assist the buying manager to determine which items need to be ordered.
- Optimum Inventory Levels – Inventory Matrix helps organizations significantly reduce their inventory holding and carrying costs. The 360-degree view available to buying managers and staff through Inventory Matrix enables them to see the quantities available, quantities on the sales order, or on a purchase order for every dimension. It also gives them the added ability to drill down to see which documents make up those quantities.
- Ease of Data Entry and Review – Buying staff can enter the quantities to be ordered in respective cells without the need to remember specific item numbers. After entering the quantities, they can conveniently move back and forth between pages. And review the order and modify quantities, if required, while in Matrix view.
- Matrix Invoicing – Print purchase orders in standard GP format or in standard Matrix format generally used in the industry.
- Analytical Reports – Includes comprehensive analytical purchase and inventory reports. It provides a detailed analysis of quantities in inventory and on purchase orders by different dimensions.
Sales Order Processing Features
- Improved Customer Service – Increased customer satisfaction, when customer questions were immediately answered.
- Enhanced Visibility – Visibility of all the available colors and sizes and available quantities, enable CSRs to up-sell and cross-sell. They can tell customer about a new color or style that is available. The customer may be interested in it.
- Ease of Data Entry and Review – CSRs can enter the order quantities required by the customer in respective cells. That too, without the need to remember the item numbers. They can review the order with the customer by moving back and forth between different pages and modifying the quantities.
- Matrix Invoicing – Print orders and invoices in standard GP format or in standard Matrix format, generally used in the industry
- Analytical Reports – Include comprehensive analytical sales reports which allow the analysis of sales by different dimensions.
For more information, please visit us at Microsoft Dynamics GP – Great Plains.
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.
Understanding Vendor Cards in Microsoft Dynamics GP
Use Vendor Cards to track the status of vendors and to print reports. Moreover, it’s important to keep this information up to date to reflect your company’s current activity. So, use the Vendor Maintenance window to create new vendor cards. Before you begin entering the first vendors, consider how to arrange the current and future vendor records. The minimum to set up a vendor is the Vendor ID, Name, and Class ID. You might want to assign specified groups of IDs to different types of vendors. You also might want to assign them to different vendor classes.
Start Microsoft Dynamics GP and click ‘Purchasing’ → click ‘Vendors’ under ‘Cards’ and the following window will appear:
Some fields in the window will have default values. Some default values are the same for all vendor information, but others come from the vendor class information entered in the Vendor Class Setup window.
Steps to set up Vendor Cards
- Select or enter Vendor ID. It is advisable to use similar IDs for all the vendors. Any alphanumeric set of characters is acceptable. Likewise, the maximum length of this field is 15 characters, be sure that all the IDs have the same number of characters. Use the system consistently for the best results when printing reports and using other windows.
- Enter or modify the Name of the vendor. The Short Name can be used in circumstances when the vendor name is too long. Also, the name printed on checks is the Check Name.
- Use status for categorizing your vendors according to their business practices. Vendors can be active, inactive, or temporary. As a result, each of these statuses limits the data entered or posted and places restrictions on deleting or modifying a vendor card.
- Assign the vendor to a class. Once a Class ID is entered, much of the information in this window, the Vendor Maintenance Options window, and Vendor Account Maintenance windows will appear as default values, which can be changed on a per-vendor basis.
- Enter Address ID.
- Click to enter or modify the internet address for a vendor.
- Enter or modify Address, Contact Information, Phone, and Fax Numbers.
- Modify the Tax Schedule and Shipping Method or accept the default.
- Enter or modify Comments for reference purposes. (Optional)
- Click ‘Options’ to open the vendor maintenance window.
- Enter vendor options, or change vendor options from those that are provided as default values from the class. When you’re satisfied with the entries, choose OK.
- Click ‘Accounts’ to open the vendor account maintenance window.
- Enter the Account number for the vendor or change from those that are provided as default account numbers from the class. Finally, when satisfied with the entries, choose OK.
- If the vendor has multiple addresses, click ‘Address’ to enter a different address for the same vendor.
- Click the printer button to print the contact card or click ‘Save’ to save the vendor card.
- If you want to delete any vendor card, select vendor ID and click ‘Delete’.
More Info
For more information, please visit us at Microsoft Dynamics GP – Great Plains
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.
- Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Mobile, Technology
Scheduled Payments in Microsoft Dynamics GP
Scheduled Payments in Microsoft Dynamics GP enables greater automation and better accuracy in any company’s Accounts Payable (AP) Management.
You can choose the interest rate, payment frequency, and other information when you create a payment schedule, and you can create a payment schedule using any posted document. Payment schedules are created from documents. However, payment schedules may vary based on the vendor or the kind of goods or services that are being purchased. You can edit any information on unposted payment schedules, as well as the interest and number of payments for posted payment schedules.
When you create payment schedules, you select specific accounts to distribute the interest and principal portions between. The following chart shows what accounts to use and how they are debited and credited. Use the Payables Scheduled Payments Entry window to enter payment schedules. When you are creating a payment schedule, the information from the original invoice will appear in several fields in the window.
STEPS TO CREATE SCHEDULED PAYMENTS
- First, Open the Payables Scheduled Payments Entry window. (Transactions → Purchasing → Scheduled Payments)
- Enter a schedule number and description.
- Select the original document number. Default entries will appear in multiple fields in this window after you have selected a document.
- Verify the date in the Schedule Document Date field. The default entry comes from the original invoice and is the general ledger posting date.
- Enter the scheduled amount. The default entry in this field is the total schedule amount, and it is equal to the amount remaining on the original invoice.
- Mark either compound or simple interest. Enter the rate in the Schedule Interest Rate field. If you enter 1, the interest rate will be 1%. (Calculate simple interest from the first payment rather than the scheduled date. If the payment schedule is from an existing invoice, then calculate the interest from the date of the original invoice.)
- Enter the number of payments for the payment schedule.
- Enter or select the payment frequency. This field is to define how often the payments will be made.
- Select the dates, and verify and enter the accounts for the payment schedule. The default entries are from the original document.
- Choose Calculate to update the amount displayed in the Calculated Payment Amount field.
- Finally, Save to save the payment schedule or Post to post it.
If you are using vendor approval workflow, the vendor must have the workflow status of Approved or No Approval Needed before you can post.
If you post the transaction, the Payables Scheduled Payments Posting Journal, Payables Posting Journal, Distribution Breakdown Register – Detail, and Distribution Breakdown Register – Summary will print when you close the window.
For more information, please visit us at Microsoft Dynamics GP – Great Plains.
- Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Technology
Microsoft Dynamics CRM Customization: Add custom Field
Microsoft Dynamics CRM Online is a customization-friendly Customer Relationship and marketing automation platform that allows for increased productivity and efficiency when dealing with prospects and existing clients. Above all, the main advantage of Microsoft Dynamics CRM is its extensive level of customization. It varies from simply changing the label of a single field, to completely custom-developed add-ons. In short, this enhances and extends the functionality of the system.
It is important to know what level of customization is required to achieve the required task. It is not feasible to heavily invest in a Custom-developed, fully-integrated add-on. As only a few customized fields and workflows from within CRM can do the job just as well.
In this example that I’m about to show you will demonstrate how to add a simple custom field to your Microsoft Dynamics CRM online environment. I will be adding a “Follow-up date” field to the Lead entity and will change the view to sort by the newly created field.
As we are making irreversible changes to the CRM system, we would need to create a backup of the system as it is now. Customizing the system will not compromise the data itself, however, modifications and changes to the forms and fields will be affected. Therefore, it is prudent to export the solution.
Please refer to our earlier blog post about exporting customizations in Microsoft Dynamics CRM. You can find it here.
Customization of fields
The following steps describe the process for creating a custom field and placing that field on a form.
- Open the personalization toolbar by selecting Options, and then Personalize this form.
- Click Insert and then Field.
- Select the region of the form where you want to expose the new field. As a result, the Insert fields dialog box will display a list of existing fields that can be inserted into the selected region of the form.
- Ensure that the field you are interested in does not already exist in the list. If it does, you can simply select that field in the list and click Insert.
- Click the Create new field button above the list to initiate the process of creating a custom field. Consequently, this will open the Create new field dialog box. If you do not see the Create new field button, you do not have the necessary permissions to use this feature.
- In the Create new field dialog box, enter the required information.
- If this is the only field that you need to create for this form, click Save. If you need to create additional fields, click Save and new and go back to step 7. Note that there is currently a limit of 20 custom fields per table.
- Leaving the Create new field dialog box will return you to the Insert fields dialog box. Any custom fields that were just added will be automatically marked in the field list to be inserted into the form.
- Click Insert to insert the marked fields into the selected region of the form.
For more information, please visit us at Microsoft Dynamics GP – Great Plains
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
- Published in Add-on, Dynamics 365 BC, Microsoft 365, Technology
Microsoft Dynamics CRM: Export Customizations
It’s a good idea to have a backup of your CRM system’s “Solution”. A Solution is a repository of all customizations and modifications to all components within your organization. Components include entities, fields, relationships, forms, reports, processes, and other elements as well.
The Solutions feature can be used to export all unmanaged solution customizations such as modified forms, views, and mappings. Later, the solution customization can be imported to the same organization or a different organization.
For example, you can export a solution from an on-premises deployment of Dynamics 365 for Customer Engagement and then import it into a Dynamics 365 for Customer Engagement organization.
The Solutions feature is located in the Customization area of the Settings area in the Dynamics 365 for Customer Engagement web application. It is a good practice to export your customizations before you make changes. If there is any unexpected behavior, they should be imported back by the user.
Steps to Export Customizations
In order to export customizations in Microsoft Dynamics CRM, you need to export them from under Settings → Customization →Customize the System:
In order to export the solution, all customizations must be published first.
After that, there is an option to export system settings along with the solution. When you import the solution later, the settings are automatically applied to the system.
And there you are! The exported solution will appear as a .zip file. If you import it, you can easily restore the previous customizations. This will give you the chance to play around more freely.
Dynamics 365 is highly customizable. You can use its online tools to modify or create fields, entities, business processes, and more. Usually, you’ll do your customization work on a sandbox environment, test them, and then transfer the final customizations to your production environments when they’re ready. Best practices recommend that you proceed as follows:
- Create a copy of your current production environment onto a sandbox environment where you can work without affecting your ongoing operations.
- Create a new managed solution on the sandbox and implement your customizations there. This lets you add customizations without affecting the underlying system, and you can revert your customizations at any time by removing the solution.
- Test the customized solution on your sandbox until you’ve confirmed it’s working correctly.
- Export the custom solution from your sandbox and then Import it into your production environment.
For more information, please visit us at Microsoft Dynamics GP – Great Plains
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.
- Published in Add-on, Dynamics 365 BC, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Technology
How to Create Payment Methods in Magento and Map them with Dynamics GP
A payment gateway is a key to securing an E-commerce business. So, selecting payment methods that are suitable for your business type deserves proper attention. In short, a wrong choice is going to be a disaster for your payment system. Moreover, a customer’s trust and loyalty depend on the payment processing system you offer.
Magento is a robust and powerful eCommerce solution. Being the market leader, Magento strives to remain at the top by adapting to the new development in the eCommerce sphere. In addition, the ability to interface with a variety of payment methods including credit and debit cards, bank transfers, etc. is one of the strengths of Magento.
CREATE PAYMENT METHODS IN MAGENTO
Go to Magento Admin Panel and to Configuration→Sales → Payment Methods. As a result, the system will display all the enabled payment methods on your Magento website. Select the payment methods that you want to use and configure them. However, if the payment method that you want to use doesn’t exist in the list, you may need to find the plugins developed by your payment service provider that interface with Magento eCommerce.
Steps to add a Custom Payment Method in Magento:
- Register Payment Module in Magento
- Declare Payment Module Name
- Add Payment Method Configuration Settings
- Add Default System Configuration Values
- Create Payment Method Model
- Configure Dependency Injection
- Add Payment Method Renderer
- Declare Payment Method Renderer
- Create Payment Method Template
- Show Payment Method in Checkout
MAPPING MAGENTO PAYMENT METHOD WITH DYNAMICS GP
Open the Payment Mapping window to see all the payment methods in Magento on this screen (see below) before the last time the automatic scheduler has updated the Magento data into GP. However, if you do not see the payment method that you are looking for, click on ‘Synchronize Default Values’ and ‘Start’. In conclusion, this will bring all the values defined in Magento to GP.
Select the Magento Payment method in the list and use the browser to select the corresponding GP Payment type. As a result, this will map the shipping method in Magento with the payment method in GP. You can also mark the create receipt button to generate the cash receipt for selected Payment types.
For more information, please visit us at Microsoft Dynamics GP – Great Plains.
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.
- Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Magento, Technology
Uploading inventory items from Microsoft Dynamics GP to Magento eCommerce
Export Inventory from GP
It is easy to upload inventory items from GP to Magento. Items to be uploaded to Magento e-commerce are marked in GP. They should include quantities, multi-tier price levels, attributes, and meta information.
If the item is modified manually in GP, the data is updated as soon as the changes are saved. If the items are modified in bulk, for example, through export and import features, they can be updated when the next scheduled data transmission takes place. You can also use the procedure below to update it.
Step-1: Log on to Microsoft Dynamics GP.
Step-2: Click on the E-commerce button in the left navigation bar.
Step-3: Click on the Data Synchronize link in the utility Section.
Step-4: Select items module from the drop-down menu.
Step-5: Hit the process button and the items will start uploading to Magento instantly.
Importing and Exporting Inventory in Magento
For catalogs with a large number of products, use the native Import and Export features. Use it along with expanded Inventory Management options to update sources and quantities by SKU. So, you can add new sources and update inventory quantities for all or a specific source.
- Commerce automatically assigns the Default Source to your products when upgrading Commerce or importing new products. If you import products with a custom source assigned, the Default Source will still be added with a quantity of 0. To update sources and quantities, use these import instructions.
- Single Source merchants use import to update only product quantities. In short, all existing and added products are assigned to the Default Source.
- Multi-Source merchants use import to add multiple sources and quantities per row per SKU.
To import updates, firstly, export a CSV file for specific or all sources. Then, edit the CSV file and add a row per SKU for each source and quantity. You need the source’s code when adding a new source and adding quantities of stock. However, you cannot add or update stocks using import-export features.
Export product data for all sources
- On the Admin sidebar, go to System > Data Transfer > Export.
- For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
- Click Continue. The file generates and downloads to open and edit.
After updating inventory amounts and product data, import the file back into Commerce.
Export product data for a specific source
- On the Admin sidebar, go to System > Data Transfer > Export.
- For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
- Use the Entity Attributes to filter the exported products for a specific source. For source_code, enter the code for the source in the filter field.
- Click Continue. Consequently, the file generates and downloads to open and edit.
Finally, after updating inventory amounts and product data, import the file back into Commerce.
Import product data
- On the Admin sidebar, go to System > Data Transfer > Import.
- For the Entity Type menu, choose Stock Sources. As a result, the export only extracts data for products with an SKU.
- Select configurations for the Import Behavior.
- Select the .csv file to import.
- Finally, click Check Data and complete the import.
For more information, please visit us at Microsoft Dynamics GP – Great Plains
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.