Our latest articles are listed below
LATEST STORIES
-
Dynamics GP – All rows mysteriously deleted from SOP Distribution Work\History (SOP10102)
This week I dealt with a very bizarre issue affecting all Sales Order Processing Transactions that I thought was worth documenting. It started with a simple support request explaining that Sales Order Processing Invoice transactions weren’t posting due to missing distributions. See below When I connected to investigate further I found the Sales Order Processing… Read more
-
Dynamics 365 Business Central – Error drilling back to the Purchase Order from a Sales Order drop shipment
I recently ran into an issue drilling back on a Purchase Order from a Sales Order with drop shipment lines. The exact error was “Purchase Order No. must have a value in Sales Line…….It cannot be zero or empty” as shown in the screen shot below: On investigation this only affected the lines on the… Read more
-
Dynamics GP – Error Message Invalid length parameter passed to LEFT or SUBSTRING function in Edit Payables Check Window
I encountered this error when a client was trying to select a vendor in the “Edit Payables Cheque Batch” window. A screen shot of the error is below The error occurred when trying to select a vendor from the list in the left hand pane of the window. To troubleshoot this I created a SQL… Read more
-
Dynamics GP – Error Message PERIOD_KEY_INVALID when submitting VAT Return to HMRC
I had a client report this issue recently which was preventing them submitting the VAT return to HMRC via the government gateway. The exact error is below After some digging it seems the period key is passed down from HMRC when the obligations are retrieved therefore its strange that the error is produced when submitting… Read more
-
Dynamics GP – The remittance reprint is including a remittance for a different vendor
A client reported that when reprinting a remittance via the “Recreate Check Stub” option it was correctly reprinting the remittance however another remittance for a totally different vendor was also printing at the same time? The option being used for the remittance reprint is below To troubleshoot I looked at the main table used on… Read more
-
Dynamics GP – Error “Install Microsoft Word” when emailing a large number of Customer Statements
A client was experiencing the error “Install Microsoft Word” on the exception report for lots of statements when emailing a high volume of customer statements when running Dynamics GP 2013. After searching online I found the following thread in the community forum https://community.dynamics.com/gp/f/32/t/137272 This mentioned the exact same issue and a user named Pam Robertson… Read more
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 