The process of running payroll creates numerous liabilities, paying a variety of vendors for garnishments, medical insurance premiums and taxes. And, as many folks have over the years, you may have developed a manual process to ensure these get paid: Giving the posting journals to payables, who rekey the information as an invoice Possibly having someone review the general ledger after posting to pull the liability amounts Making the payments yourself to ensure there is no mixup Wouldn’t it be nice if you could simply post your payroll and the vendor invoices would be created automatically for inclusion in the next check or electronic funds transfer (EFT) run? Payroll Integration to Payables (PIP) allows just that.
As a part of the inventory reset utility you might get an issue with “Run Data Checks” step, that the Average Item Receipt Quantity On Hand (Table IV10200) does not equal Inventory Quantity On Hand (Table IV00102), this is really confusing specially after doing a full inventory reconcile as a part of the inventory reset process. While investigating this I found indeed that Quantity at IV00102 does not match the IV10200 quantity and the Inventory Reconcile Process does not cover this part, where I had to find an alternative method to proceed. On of the community users did face this issue and posted this question on one of the community portal and got an answer from WAQAS who went through the stored procedures of the reset tool and extracted a query that detects variances between IV10200 and IV00102, I have used this query to create the below cursor to collect and fix differences automatically: DECLARE @ITEMNUMBER VARCHAR (500) DECLARE @DEXROWID BIGINT DECLARE QTYFIX CURSOR FOR SELECT A.DEX_ROW_ID, A.ITEMNMBR FROM IV10200 A INNER JOIN IV00101 B ON A.ITEMNMBR = B.ITEMNMBR INNER JOIN IV00102 C ON A.ITEMNMBR = C.ITEMNMBR WHERE B.VCTNMTHD = 3 AND A.QTYTYPE = 1 AND C.LOCNCODE = ” AND A.QTYONHND C.QTYONHND AND EXISTS ( SELECT 1 FROM IV10200 WHERE QTYTYPE = 1 AND ITEMNMBR = B.ITEMNMBR AND VCTNMTHD 0 GROUP BY ITEMNMBR HAVING MAX (DATERECD) = A.DATERECD) AND EXISTS ( SELECT 1 FROM IV10200 WHERE QTYTYPE = 1 AND ITEMNMBR =B.ITEMNMBR AND DATERECD = A.DATERECD AND VCTNMTHD 0 GROUP BY ITEMNMBR, DATERECD HAVING MAX (RCTSEQNM) = A.RCTSEQNM) AND EXISTS ( SELECT 1 FROM IV10200 WHERE QTYTYPE = 1 AND ITEMNMBR = B.ITEMNMBR AND DATERECD = A.DATERECD AND RCTSEQNM = A.RCTSEQNM AND VCTNMTHD 0 GROUP BY ITEMNMBR, DATERECD, RCTSEQNM HAVING MAX (DEX_ROW_ID) = A.DEX_ROW_ID) OPEN QTYFIX FETCH NEXT FROM QTYFIX INTO @DEXROWID, @ITEMNUMBER WHILE @@FETCH_STATUS = 0 BEGIN UPDATE IV10200 SET QTYONHND=( SELECT QTYONHND FROM IV00102 WHERE ITEMNMBR=@ITEMNUMBER AND RCRDTYPE= ’1′ ) WHERE DEX_ROW_ID= @DEXROWID FETCH NEXT FROM QTYFIX INTO @DEXROWID, @ITEMNUMBER END CLOSE QTYFIX DEALLOCATE QTYFIX Enjoy! Regards, — Mohammad R
Occasionally, you may have to re-enter a payroll check using the Manual Check window in Payroll. Transactions | Payroll | Manual Checks Payroll Manual Check Adjustment Entry Window This window can be used to enter three transaction types: Beginning Balances – Recorded as checks with a gross and net amounts, but do not post to the general ledger or bank reconciliation Manual Check – Recorded as checks with a gross and net amounts, do update general ledger and bank reconciliation Adjustment – The gross and net must be zero; this type is used to move amounts between codes
Date: August 18, 2011 SQL Server Reporting Services (SSRS) gives your users a powerful and flexible solution for creating and deploying reports.
New Article on MSDynamicsWorld: When It’s Time to Upgrade an Outdated, Customized Microsoft Dynamics GP System…Who You Gonna Call?
It’s been a couple months since I’ve written a business-driven column over at MSDynamicsWorld .
One of our clients recently reported the following error while the user tries to open the Project Card. “ The Project Is Being edited By another User, please select another project/contract number ” We checked all the users and no one was accessing this project. Then we found there are invalid entries under “PA Proj Contr Activity Master table”.
Please let me know with your comments if any of the above recommendations by the Remote Desktop Services team worked for you. Until next post ! MG.- Mariano Gomez, MVP IntellPartners, LLC http ://www.IntellPartners.com …