Simplifying Payroll Liability Payments
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.
August 24, 2011 · 
Christina Phillips · 
No Comments
Tags: Accounts Payables, article, connected, David Musgrave, dynamics, featured, integration, sterling-adventures · Posted in: Blogs I Follow Total Views: 16
How to enter check received from a vendor(refund) in GP
I recently had written a post about the entering refund for customers . Today I am going to discuss various scenarios about entering refund from vendor in Microsoft Dynamics GP Refund from a vendor with credit balance(over payment) Refund from vendor with no existing balance for the vendor in the GP Â Case 1: There is credit balance probably from an overpayment or credit memo for the vendor. It means vendor owes you and you want to clear it by entering payment you received from vendor Open the Payables Transaction Entry window (Transactions > > Purchasing > > Transaction Entry), select Misc.
August 1, 2011 · Rubal · No Comments
Tags: Accounts Payables, dynamics, dynamics-gp-problems, payables return, refund vendor, vendor check · Posted in: Blogs I Follow Total Views: 51
SQL Script to Reconcile GL vs. AA Balances for Accounts Payable
Hi all Some time back, I had posted an article to reconcile between GL and AA tables. This article can be found here. Today I had decided to write up a simple SQL script to reconcile the balances for every account currency combination between the General Ledger tables and the Analytical Accounting tables specifically to [...]
January 17, 2011 · veeyeskay · One Comment
Tags: Account Balances, Accounts Payables, Analytical Accounting, Reconciliation · Posted in: Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 635
GL Reconciliation SQL Script – Payables
Hi all This script can be used as a base to reconcile the receivables sub-ledger balances as of a certain date. DECLARE @ASOFDATE AS DATETIME SET @ASOFDATE = ’2017-04-12′ SELECT Z.* FROM ( SELECT A.[OPENYEAR] TRXYEAR, A.[ORTRXSRC] AS APAUDITTRAIL, A.[ORMSTRID] AS APCUSTOMERNO, A.[ORCTRNUM] AS APDOCU Read the rest of this entry
November 7, 2010 · veeyeskay · 6 Comments
Tags: Accounts Payables, General Ledger, Payables Reconciliation · Posted in: Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 Total Views: 769
Maintaining Data Integrity between Sub Ledgers and General Ledger
Hi all I have been involved in the process of reconciliation between the sub ledgers and the general ledger at various clients and there has been various scenarios in which there has been a break between the sub ledgers and the general ledger balances. A few key scenarios are quoted below A transaction posted in [...]
May 16, 2010 · veeyeskay · No Comments
Tags: Accounts Payables, Accounts Receivables, General Ledger, Inventory, Reconciliation · Posted in: Accounts Payables, Accounts Receivables, Dynamics, General Ledger, Great Plains, Inventory Total Views: 2,017