troubleshooting dynamics gp and movers suite tracking the path of documents
TRANSCRIPT
![Page 1: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/1.jpg)
Troubleshooting Dynamics GP and Movers Suite
Tracking the path of documents
![Page 2: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/2.jpg)
Generate transaction in Movers Suite
![Page 3: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/3.jpg)
Reports>Revenue Transaction Errors
![Page 4: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/4.jpg)
Movers Suite SQL tables• We store transactions in our billing tables before they
are generated in Movers Suite
• We have another table to hold transactions after they are generated and before they are imported
• A Movers Suite table exists in Dynamics GP company database after importing (Scripts to find transactions if interrupted on import)
![Page 5: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/5.jpg)
Run MSS Import from Sales or Purchasing
![Page 6: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/6.jpg)
MSS Import common errors• Be sure to look at the report and expand it to show the
number in ‘Records Rejected’
![Page 7: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/7.jpg)
Error shows on the far right of the report
![Page 8: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/8.jpg)
Account is not active/Account not found errors• Create/Make the account active on the Financial pane
under Cards
![Page 9: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/9.jpg)
Vendor Inactive/Not a 1099 vendor
<Options> button and change 1099 Tax Type dropdown
![Page 10: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/10.jpg)
AFS document number already exists • This is an error that EWS will need to fix for you when it
is on the MSS Import
• There are also warnings like ‘Apply-to document missing’ that are timing issues and will import
![Page 11: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/11.jpg)
New custom code changes
• GP2013 Movers Suite custom code does not allow an imported Movers Suite batch to be deleted
![Page 12: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/12.jpg)
Reviewing batch transactions• Save-Saves the window (even if no changes made)• Delete-Will delete the transaction completely• Cancel-Will not save any changes and return to the
window
![Page 13: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/13.jpg)
Post the batches in Dynamics GP
RM-, PM- and GL- batches
![Page 14: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/14.jpg)
Inquiry screens
• Work• Open • History• *Voided items have an
asterisk
![Page 15: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/15.jpg)
Expansion buttons
• View MSS fields• Branch• Order Number• Shipper• Item Code
![Page 16: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/16.jpg)
Document number
![Page 17: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/17.jpg)
MSSDOC# • If the order number including the slash and sequential
number at the end exceed 17 characters then a MSSDOC number is used instead• U9900-24015-4/999 Example of largest document size
before MSSDOC number is used
![Page 18: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/18.jpg)
Accounting Tools>Dynamics GP Order Inquiry
Be careful of items applied to this order from a different order number (manually done)
![Page 19: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/19.jpg)
Reports• Order Billing Inquiry
![Page 20: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/20.jpg)
Collections reports showing 0 balance orders• Orders may show a zero balance in A/R credit and
collection or on A/R trial balance reports. Those items need to be APPLIED• Use the MSS Auto Apply or Apply Sales Documents
(manually)• Note that A/R items do not automatically move to
history
![Page 21: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/21.jpg)
Commissionable vendors• Steps to take if the Dynamics GP check does not match
the Movers Suite commission statement
• Do not finalize the commission statement until the check has been built and matches the comm stmt total
• Commission statements cannot be un-finalized
![Page 22: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/22.jpg)
Confirm cut-off dates used
![Page 23: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/23.jpg)
Allow the batch time to build
![Page 24: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/24.jpg)
Process Monitor
![Page 25: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/25.jpg)
Batch total and <Add to Batch>• The Batch Total will change if over zero balance• <Build Batch> changes to <Add to Batch>
![Page 26: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/26.jpg)
Re-Query the commission statement• This builds a new commission statement just like
deleting and creating a new one
![Page 27: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/27.jpg)
Vendor Class ID• Confirm the vendor is in the class ID if using that as a
restriction
![Page 28: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/28.jpg)
Items on hold?• Will not build in Select Checks• Will not show on the Commission Statement
• On hold items do show on the A/P trial balance
![Page 29: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/29.jpg)
Look for future transactions• Run the A/P trial balance and Msuite commission
statements to 12/31/9999 to look for data entry errors
• Future applied credit memos will be found using 9999 date also
![Page 30: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/30.jpg)
Checkbook branches• Invoices will only be
built if under the checkbook’s branches
![Page 31: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/31.jpg)
Are there payment terms on the vendor?• On the vendor card under the <Options> button
• Payment terms could move the invoice out past the cut-off date
![Page 32: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/32.jpg)
Apply problems?• Items may have apply issues; Are there documents in
history that do not have apply records? Documents showing fully applied but still in Open status?
• Disconnections, slow server processing, low disk space, data corruption, special characters
![Page 33: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/33.jpg)
Use the Inquiry screens
As when checking on imported items, view the Inquiry screens to see if invoices are Work, Open or History.
*Voided items have an asterisk
Drill back on the document to view the apply records
Expand to see the branch, order number etc…
![Page 34: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/34.jpg)
Multiple Commission Statements• Movers Suite allows multiple statements with the same
cut-off date and statements prior to the last finalized dates
![Page 35: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/35.jpg)
Export statement to Excel
![Page 36: Troubleshooting Dynamics GP and Movers Suite Tracking the path of documents](https://reader036.vdocuments.us/reader036/viewer/2022062417/551c58ae5503467b488b5666/html5/thumbnails/36.jpg)
Questions?• Thank you for attending!