We are excited to announce that we have partnered with DesignRush. This partnership will help companies looking for on-demand, off-shore, on-shore software development assistance, and outsourced customer support find the desired help they need.
Excel Import for Dynamics GP
The Accounts Payable (AP) Import is an add-on for Dynamics GP’s Account Payable module. It allows an user to browse an Excel spreadsheet and import AP transaction into an unposted AP batch – all from within the AP Transaction Entry screen.
Positive amounts are imported in as Invoice type transactions. Negative amounts are automatically imported as Credit Memo transactions. Since these are all imported into unposted batches, they can be further edited within the transaction entry screens. The vendors’ default Accounts Payable and Purchasing accounts are used to create transaction distributions. It is recommended that these are setup with the GP vendor master prior to importing.
All the GP validation for vendors, account numbers, duplicate invoice numbers are also performed here. A preview window displays any errors in red even before they are imported in.
Traditionally, Dynamics GP users that needed to do such an import from a spreadsheet, had to key them in manually or ‘ jump through a few hoops’ and use Integration Manager or other custom tools to accomplish this. This Excel import add-in provides a simple and affordable end-user solution to accomplish this- all within the GP interface.
The Accounts Payable (AP) import navigates and behaves like Dynamics GP screens and can be launched from within the additional menu selection of the AP Transaction Entry screen within Accounts Payable. This once again simplifies training and the use of the AP Excel Import.
Select your product version
Dynamics GP AP Import
The Accounts Payable (AP) Import is an add-on for Dynamics GP’s Account Payable module. It allows an user to browse an Excel spreadsheet and import AP transaction into an unposted AP batch – all from within the AP Transaction Entry screen.
Positive amounts are imported in as Invoice type transactions. Negative amounts are automatically imported as Credit Memo transactions. Since these are all imported into unposted batches, they can be further edited within the transaction entry screens. The vendors’ default Accounts Payable and Purchasing accounts are used to create transaction distributions. It is recommended that these are setup with the GP vendor master prior to importing.
All the GP validation for vendors, account numbers, duplicate invoice numbers are also performed here. A preview window displays any errors in red even before they are imported in.
Traditionally, Dynamics GP users that needed to do such an import from a spreadsheet, had to key them in manually or ‘ jump through a few hoops’ and use Integration Manager or other custom tools to accomplish this. This Excel import add-in provides a simple and affordable end-user solution to accomplish this- all within the GP interface.
The Accounts Payable (AP) import navigates and behaves like Dynamics GP screens and can be launched from within the additional menu selection of the AP Transaction Entry screen within Accounts Payable. This once again simplifies training and the use of the AP Excel Import.
Additional Resources
Select your product version
Dynamics GP Bill Of Lading
Bill of Lading (BOL) behaves as a natural extension of Microsoft Dynamics GP and creates a shipping document to the freight carrier, combining orders/invoices from Sales Order Processing. It provides standardiziation to ensure that the shipper, the the freight carrier, and the customer (consignee) are all getting the information they need to process goods through the supply chain. Its is VICS (Voluntary Inter-Industry Commerce Standards) format compatible and adheres to its basic guidelines.
Traditionally, The BOL navigates and behaves like Dynamics GP and can be launched from withing the additional menu selection of the Sales Order Entry screen. This greatly simplifies training users on this add-on as they are already familiar with the Dynamics GP interface. The BOL from the BizTechnologies provides an easy-to-add, affordable solution..
Once shipments are prepared for the carrier, they can be easily printed as Microsoft Word documents. This additional flexibility allows the BOL to be further edited once the BOL is populated with data from GP.
Seamless integration into Dynamics GP
Include Pallet weights in shipment weights
Create BOL from either Invoice/ Sales Order
Print VICS compatible BOL in Microsoft Word
Prints 3 of 9 barcodes for BOL numbers
Compute shipment weights for carrier
Print VICS compatible BOL in Microsoft Word
Combine shipments and palletize
Additional Resources
Select your product version
Customer Community
Please provide any product or customer service feedback via our contact us page. We continue to constantly enrich our product with enhancements funneled in via customer feedback and conversations.
Gallery
Please provide your product and customer service feedback through our contact and support requests. We are constantly enriching our products and features based on customer feedback and conversations.
Quote to Sales Order to Invoice
This tutorial guides you to creating a quote within BizSight 365, on customer acceptance, converting this to either a Sales Order or take it directly through to an invoice. BizSight 365 is a Small Business Financial Accounting software, that was also designed as a replacement for Microsoft Office Accounting.
BizSight 365 Navigation
Intuitive and snappy navigationSHOW LESS
Invoice Customers and Receive Payments
This tutorial guides you to creating a quote within BizSight 365, on customer acceptance, converting this to either a Sales Order or take it directly through to an invoice. BizSight 365 is a Small Business Financial Accounting software, that was also designed as a replacement for Microsoft Office Accounting.
Bill of Lading for Dynamics GP
Bill of Lading (BOL) behaves as a natural extension of Microsoft Dynamics GP and creates a shipping document to your freight carrier, combining orders/invoices from Sales Order Processing. It provides a standard to ensure that the shipper, the freight carrier, and the customer (consignee) are all getting the information they need to process goods through the supply chain. It is VICS compatible, adheres to its basic guidelines, and provides a customizable template in Microsoft word. It navigates and behaves like Dynamics GP and can be launched from within the additional menu selection of the Sales Order Entry screen. This greatly simplifies training users on this add-on as they are already familiar with the Dynamics GP interface. The BOL from the BizTechnologies provides an easy-to-add, affordable solution