Our latest articles are listed below
LATEST STORIES
-
Dynamics NAV – The Warehouse Request does not exist when posting an Inventory Pick
I recently came across the following error when trying to post an Inventory Pick in Dynamics NAV 2018 On investigation this is being caused because although the Inventory Pick had been created from the Sales Order, the Sales Order had subsequently been shipped and invoiced directly from the Sales Order screen rather than via the… Read more
-
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
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 