This question popped up on the Microsoft Dynamics Community today so I thought I’d share the answer here. The new functionality in GP2010 that edits the original PO for a purchase return (or creates a new one if the original is closed) is awesome. Not sure why it took this long to add that functionality but it is what it is. However, there is no facility in the Returns Transaction to reverse the Landed Cost on the original receipt, so GP writes the value of the Landed Cost to Purchase Price Variance . Not the ideal way to handle it but at least it doesn’t leave that cost sitting in inventory, if the return is an inventory item. *click image to enlarge P.S
one of my clients is a constructions firm whose not interested to activate the project accounting and wanted to distribute their project management over analytical accounting dimensions. Therefore we have implemented Dynamics GP and created dimension for projects to distribute all expenses accounts of analytical accounting codes. One of their requirements been to have a vendor statement per project which is reasonable for such a line of business, therefore I have created the below view that extracts the information including from AP, GL and AA and wanted to share the idea to avoid reinventing the weel for people who works with the same situation, below is the script I used: DECLARE @FROMDATE DATETIME DECLARE @TODATE DATETIME DECLARE @FROMVENDOR VARCHAR ( MAX ) DECLARE @TOVENDOR VARCHAR ( MAX ) SET @FROMDATE = ’1900-01-01′ SET @TODATE = ’2017-04-17′ SET @FROMVENDOR = ‘ACETRAVE0001′ SET @TOVENDOR = ‘BLOOMING0001′ SELECT ‘Beginning Balance’ AS TRXSOURCE , @FROMDATE AS DOCDATE , ‘Beginning Balance’ AS DOCNUMBER , VENDORID , SUM ( CREDIT ) AS CREDIT , SUM ( DEBIT ) AS DEBIT , VENDNAME , ‘Beginning Balance’ AS VCHRNMBR , ‘Beginning Balance’ AS TRXDESC , 0 AS JRNENTRY , 0 AS aaGLHdrID , aaTrxDimCode , aaTrxDimCodeDescr , ” AS LOCNCODE FROM ( SELECT DISTINCT VENDORTRANSACTION .
For those who are still thinking about when to purchase Dynamics ERP’s, I wanted to remind you that the give me 5 promotion which will allow you to purchase 5 users for 3,000$ is around to expire, and you have less than 22 days to take the decision! Below what quoted from Microsoft Dynamics Website: Get 5 users for one low price To renew or not renew, that is the question. Your annual maintenance agreement is right around the corner. You know that the money you spend year after year provides little value and keeps you tied to software that hinders your business growth.
Round 1 of the 2012 tax tables have been re-released to reflect the changes made by congress to extend the 2% tax holiday. Make sure you have the new tables or you will be buying yourself a lot of heartache. Get the new tax tables from PartnerSource: 2012 Tax Tables from PartnerSource Until next post! Leslie