Thursday, December 8, 2011

Professional Services Tools – Import Button

Got request from user that they want to modified Item Numbers, we already have Professional Service Tools license but problem was it not just one item I have to modify where I will enter starting number and ending and it’s done.

There were 100 + items need to modify!!! I was trying to use Import button to update Item Number using excel à created excel file with header “Starting Item Number” , “New Item Number” to match what I see in PSTL Item Modifier screen and then converted Excel file into CSV , validate but it didn’t work it was giving me error “Source Item not found”  to find answer searched in Partnersource,  Google didn’t help much as Integration Manager support CSV file even Sql Profiler and DexSQL Log file was not showing any logical error which help me to import these Items.  Other options I was thinking to create Mail Merge Macros to import these Items to avoid manual entry.

Just to check I converted Excel file into Tab Delimited without Tab header information Validated Walla!!! It works no more error!!! Imported all items using Tab Delimited file instead of going each items or creating mail merge macro.

Until Next post!!!


Sandip Jadhav

Tuesday, November 22, 2011

Refund Cash to Customer

Refund Cash to customer

In Dynamics GP have option for "Refund to Customer" (Transactions-->Sales-->Refund Checks) but  in small scale company it is not possible to make payment through checks for every customers.

When we create Refund from Dynamics GP it transfer Receivable balance to Payables Management creating checks for customer.


1) Received access payment from customer through credit card and need to return cash back to him.

2) Access Payment Received from customer and need to pay back cash.

Make Debit Memo from Transaction-->Sales-->Receivable Transaction-->Debit Memo and apply to Invoice.


Debit : Accounts Receivable (Refund Amount)
Credit : Accounts Receivable Misc

With above distribution your Receivable will be get zero.

To Bank:

Transaction-->Financial -->Bank Transactions

Change entry to "Decrease Adjustment" and enter the amount for Refund.


Debit: Accounts Receivable Misc (Refund Amount)

Credit: Cash A/c

Simple Cash Refund entry without Checks(Cheques)

Sandip Jadhav

Tuesday, August 23, 2011

How to get beginning account balance when past year not closed yet?

If previous year is not closed Microsoft Dynamics GP does not displaying account balances for Balance Sheet accounts for New Year. This can give wrong account information to Financial users.


1)   If you know your previous year balance i.e. Closing Balance pass one GL Entry for opening entry i.e.  on 01/01/2011 and then reverse it before you close the Year

This way you will see opening Balance for new year and once you ready to close previous year reverse the same entry.

2)  There is no issue to close Fiscal Year because transactions still be posted to closed Fiscal Year. With this solution no need to pass and reverse dummy entry to get opening balance.

I will recommend to go for second suggestion if you can close Fiscal Year.