Mark Polino's Blog, page 348
June 21, 2011
Looking for training on Microsoft Forecaster? - Dynamics Corporate Performance Management
Dynamics Corporate Performance Management gives us some ideas if you're Looking for training on Microsoft Forecaster.
Dynamics GP Land: Ch-Ch-Changes...And "Checks on the fly"
Over at Dynamics GP Land, Christina Phillips looks at what can be changed when cutting And "Checks on the fly".
June 20, 2011
SQL Script for Budgets vs. Actuals in Amounts in Analytical Accounting | Interesting Findings & Knowledge Sharing
Weekly Dynamic: DynamicZip and Project Accounting
We ran into an issue with DynamicZip and Project Accounting recently so I thought I would share here.
DynamicZip is a Sales and Use Tax ISV solution for Dynamics GP. We ran into an issue where the account substitution wasn't working the way we wanted it to for Invoice/Matching. In the end it turned out to be a conflict between Project Accounting's ability send the tax expense to the same account as the purchase and DynamicZip's ability to do the same thing. Specifically:
Default GP can use the tax detail account as the tax expense to debit via the Purchase Taxes in Project Costs in Project Accounting. This project accounting setting overrides the tax expense with the PA Purchase account So in a non-DynamicZip environment this would be the behavior we want DynamicZip changes the behavior of the tax detail account to be liability account (a credit) What's happening is that project accounting was overriding the tax account with the purchase account, then Dynamics Zip was swapping it out to be the credit. Since DynamicsZip was already setup to use the purchasing account on these transactions, this PA setting was redundant and it was conflicting with PA .The answer was to uncheck Include Purchase Taxes in Project Costs box.
Unfortunately, unchecking this box with open transactions results in an error and the box does not uncheck. As a result, we had to change this setting via SQL using the command:
update pa41701
set paincprchtxprjcst=0
This will only affect new transactions so we still needed to open the distributions on any unposted Shipment/Invoice or Invoice Matching transactions and use the default button on the distributions window to reset the accounts.
June 16, 2011
Dynamics GP Land: Sustainable Development?
New at Dynamics GP Land, Christina Phillips looks at Sustainable Development and how it applies to well, development
