It’s time to replace your ERP… or is it? Updating for the wrong reasons.
It’s time to replace your ERP… or is it? Updating for the wrong reasons. A while back, I asked a CFO how he reported to the street certain numbers within a very small margin. He replied with “If I don’t know how we are going to perform, it will make the investors uneasy, it could …
It’s time to replace your ERP… or is it? Updating for the wrong reasons. Read More »
How to Bulk Update Open Sales Orders in Microsoft Dynamics GP
How to Bulk Update Open Sales Orders in Microsoft Dynamics GP Why it Matters Traditionally, updating sales orders (or any open sales document really) in Microsoft Dynamics GP requires the user to manually open and perform changes to all detail lines in an order series, one after the other. While this is doable for very …
How to Bulk Update Open Sales Orders in Microsoft Dynamics GP Read More »
He asked me: Who removed a hold for a customer card because a 100K order left the warehouse this morning?
TitaniumGP Blogs – Helpdesk Series I received a call from the controller of a TitaniumGP customer a bit concerned. He asked if I could tell him who removed a hold for a customer card because a 100K order left the warehouse that morning. Fortunately, TGP Remember was activated a few months earlier, so I instructed …
How I found $14,535 of (phantom) inventory!
"...you have inventory allocated and cannot be sold because it is in an order that got stranded, cannot be opened in GP or deleted and your customer service cannot sell it, then is a terrible issue..." Having inventory allocated must be a very good thing, you are going to sell and will be in …
How to Copy and Paste Multiple Journal Entries from Excel to Microsoft Dynamics GP
A recurring question from Dynamics GP users has been: “How do I copy and paste journal entries from Excel and into Dynamics GP?” Traditionally, this wasn’t an option with GP out of the box until Microsoft added the copy/paste functionality with the Dynamics GP 2013 R2 roll out. With this version (and later ones), users …
How to Copy and Paste Multiple Journal Entries from Excel to Microsoft Dynamics GP Read More »
How to Close windows or GP sessions remotely, with a press of a button!
"How to close Dynamics GP sessions from remote using TGP Remote Control" Suppose you send an email to all users: Please log out of GP before you go home since we need to run Inventory Reconciliation tonight. Sincerely, GP Admin You know the results. Certain processes in Dynamics GP require exclusive access to some functions, …
How to Close windows or GP sessions remotely, with a press of a button! Read More »
2 Easy Steps to Copy and Paste Sales Orders from Excel to Microsoft Dynamics GP
Copy Paste from Excel to Dynamics GP The Hassle Manually entering sales orders into Microsoft Dynamics GP can be a tedious and time consuming process, prone to errors. In a typical scenario, a customer places an order by emailing an Excel file containing order details such as item number, product SKU, UPC (Universal Product Code), …
2 Easy Steps to Copy and Paste Sales Orders from Excel to Microsoft Dynamics GP Read More »
Enter the description of items for export including images, then an SSRS report including this description in English, Japanese and product images in the packing slips.
Packing List in Japanese with Pictures A medical device company sends a shipment to Japan. In this particular case, the customs officer questioned if the documentation matched the contents of the box and stopped the import process. The question was simple, how can I be sure that the descriptions match the products being imported? …
=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time.
=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. At times we need the ability to bring a value from GP into excel, primarily because it could change or to verify if a key is valid. This is a very simple way to provide the much-needed functionality …
Dealing with foreign customs officers (A story about Dynamics GP users and TitaniumGP)
Dealing with foreign customs officers The packing list in Japanese with pictures a story by TitaniumGP (Available in Sway) A medical device company was sending shipments to Japan very often. For them, it was critical to deliver every product in time. Every second was money. To type everything into the packing list was critical in order to pass through the …
Dealing with foreign customs officers (A story about Dynamics GP users and TitaniumGP) Read More »
