Dynamics Blogger

Historical Inventory Trial Balance is available in Inventory  > Reports > Activity > Historical IV Trial Balance Report. This report will run into several hundred pages most times based on the size of Inventory. To have this report in excel is always a good choice and easy to work on the report for reconciliation purposes if you have it nice formatted excel worksheet. Smartlist by making use of smartlist builder makes it an easy task. All you have to do is build a custom smartlist builder report using SEE30303 Table (Termed as Inventory Transaction History Detail Table in GP). I am providing a link to download the smartlist that gives the Inventory Historical Trial balance. Please note that I’ve used Item Master table also along with Inventory Transaction History Detail table in order to pull Item description from the former because Item description is not stored in the latter. Download the smartlist and import it into Smartlist Builder using smartlist builder Import fu...

There are two Bill of Materials available in Dynamics GP where Manufacturing module is installed. One Bill of Materials (BOM) is available in the Inventory module, Which I’d call it as Inventory BOM or Core BOM. The other BOM is from Manufacturing module where it is more detailed and extensive functionality. The Inventory BOM works best with companies having a very simple production process so as to just assemble materials into a finished product. Here production is recorded after the fact. The Manufacturing BOM makes use of both Inventory and Manufacturing order processing modules where the production of finished goods is recorded. In addition to Material costs, Labor costs are also tracked. INVENTORY BOM MANUFACTURING BOM WIP is not tracked Tracks WIP for Materials, Labor and Machine Time Enter standard and Design QTY Enter Fixed and variable QTY Link to associate Lot and serial numbered items with Lot and serial numbers of FG Link with the BOM item to a particular ...

Do you know how distributions in Manual Payment entry of Payables management are defaulted? In this example post we will see how the distributions are defaulted in Manual Payment entry. Example: Vendor ABC is mapped to Accounts Payable Account 000-2100-00 and Purchases Account 000-1300-00 in vendor Accounts under Vendor Maintenance. I. When you create a manual payment entry for this vendor, the default distributions should be as follows ACCOUNT DIST TYPE DEBIT CREDIT 000-1100-00 CASH - $1000 000-2100-00 PAY $1000 - Note that in this scenario the payment is created without applying an invoice. II. In this second scenario, We will first create a vendor Invoice with the following distributions. Instead of the default Accounts Payable, let us select a different account 000-2100-01 under the distribution type PAY. ACCOUNT DIST TYPE DEBIT CREDIT 000-1300-00 PURCH $1000 - 000-2100-01 PAY - $1000 Now Let us create a manual payment entry for the above invo...

Allow Account Entry is an option in Account Maintenance screen. Account Maintenance is used to maintain (create) the Posting account. Allow Account entry is marked by default in the Account Maintenance screen. When it is unmarked, It prevents an user from manually entering or choosing this account in transaction or distribution entry windows irrespective of the module. However, this account can be used as the default posting account. This feature works well with accounts like Inventory, Accounts Payable, Accounts Receivable which minimize balances mismatch between subsidiary ledgers and General ledger as it does not allow direct posting into GL. There is an exception to this feature. This functionality fails to work in Purchase order entry. In Purchasing Item detail entry, this account can be selected manually despite the selection in Account Maintenance. This might be a possible bug.