Additional Purchases Accounts for Vendors in Dynamics GP

(Post Courtesy Sivakumar Venkataraman) Sometimes, when we book invoices in payables, we might need to distribute the expenses into multiple GL accounts based on business requirements. In most of the situations, a specific purchases account gets defaulted from the vendor (or) from the company posting account setup and the users manually add additional expense lines…


Creating Smartlists with Sub Query Restriction using Smartlist Builder in Dynamics GP

This post explains how to create custom smartlists with subquery restrictions using Smartlist Builder, without using SQL queries (i.e.) using Dynamics GP Tables and Joins inside Smartlist Builder (Post Courtesy Sivakumar Venkataraman) Smartlist Builder is a great tool to create custom smartlists. We can create smartlists using Dynamics GP tables (or) using SQL objects. However,…