Left the TV off for a few hours
Changed the batteries in the remote
It came back on all by itself
Not sure if it was trying to update itself, it says it has firmware 2207.
I'm not sure what the latest version is supposed to be, but it also says the last time it checked for updated was 2015
Sunday, October 8, 2017
Friday, October 6, 2017
Dynamics GP - Purchase Receipt does not post correctly, causes PO to think it's received, but there is no stock
Situation: PO has been created, PO receipt is done and posted, but posting fails. The PO line says it's completely received, the receipt transaction is corrupted, and there is no inventory available from the receipt.
Solution:In this case, the PO receipt actually did not post, and we just have to recover the corrupt transaction and delete it.
--Get the Receipt number for the PO
select * from pop10310 where ponumber = 'PO000000000022484'
--Get the Receipt Header
select * from pop10300 where poprctnm = 'GSR00000000068562'
--Update the VENDORID and POPTYPE = 1 if they are blank to allow you to access the transaction in the receiving work screen
--Get the vendor id
select vendorid from pop10100 where ponumber = 'PO000000000022484'
update pop10300 set VENDORID = 'APAS01', POPTYPE = 1 where POPRCTNM = 'GSR00000000068562'
After running the scripts, pull up the transaction in the purchase receipt screen and delete it.
This should free up the PO and allow you to receive the lines properly.
Solution:In this case, the PO receipt actually did not post, and we just have to recover the corrupt transaction and delete it.
--Get the Receipt number for the PO
select * from pop10310 where ponumber = 'PO000000000022484'
--Get the Receipt Header
select * from pop10300 where poprctnm = 'GSR00000000068562'
--Update the VENDORID and POPTYPE = 1 if they are blank to allow you to access the transaction in the receiving work screen
--Get the vendor id
select vendorid from pop10100 where ponumber = 'PO000000000022484'
update pop10300 set VENDORID = 'APAS01', POPTYPE = 1 where POPRCTNM = 'GSR00000000068562'
After running the scripts, pull up the transaction in the purchase receipt screen and delete it.
This should free up the PO and allow you to receive the lines properly.
Thursday, October 5, 2017
Check Network Traffic and Connectivity issues - Microsoft Nework Monitor, Microsoft Message Analyzer
https://www.microsoft.com/en-us/download/details.aspx?id=4865
Use Filters
https://blogs.technet.microsoft.com/rmilne/2016/08/11/network-monitor-filter-examples/
Property.Source >= "MYPC" and Property.Source <= "MYPD"
A Newer version of this program with better message reporting is available here
https://www.microsoft.com/en-us/download/details.aspx?id=44226
Or you can also use Wireshark
https://www.wireshark.org/download.html
Use Filters
https://blogs.technet.microsoft.com/rmilne/2016/08/11/network-monitor-filter-examples/
Property.Source >= "MYPC" and Property.Source <= "MYPD"
A Newer version of this program with better message reporting is available here
https://www.microsoft.com/en-us/download/details.aspx?id=44226
Or you can also use Wireshark
https://www.wireshark.org/download.html
Dynamics GP - You cannot receive this purchase order line item because it hasn't been encumbered by encumbrance management. Please encumber the purchase in the purchase order entry window.
There is nowhere on the purchase order entry window to physically encumber this.
- Encumbrance occurs when any one of the following occurs
- Workflow approves PO line
- PO approval Approves PO line
- Mass Encumbrance processes PO line
Problem: The ENC10110.ENCBSTAT is set to 4, and is waiting for Approval or workflow, but neither of these are enabled, so the line can never be encumbered.
Solution:Set the ENC10110.ENCBSTAT to 2 to enable it in the Mass purchasing>transaction>Mass Encumbrance screen to complete the approval before it can be received.
--Use this to get the dex_row_id's for the lines that cannot be received
select * from enc10110 where ponumber = ' PO00293'
--Use this to update the lines to enable them in the Mass Encumbrance window for processing
--Change the dex_row id's to match the lines that cannot be received
update ENC10110 set ENCBSTAT = 2 where DEX_ROW_ID in (298800,298811)
Monday, October 2, 2017
Dynamics GP - Encumbrance Tables
https://dyndeveloper.com/DynTable.aspx?ModuleID=ENC
- ENC10110 - Encumbrance - PO Lines
- ENCBSTAT
- 1-Pre-Encumbered - After approved or mass encumbered
- 2-Invalid - Default setting. Displays trx in Mass encumbrance for encumbrance.
- 3-Blanket Control - Used for blanket control lines
- 4-Pre-Budget - Default setting before approval if approvals in use
- ENC10500 - Encumbrance Received Trx
Dynamics NAV - LS Retail - How to setup Object Transfer
- Ensure your object is compiled
- Search for Object Transfer
- Create a new object transfer for your objects
- Confirm it
- Search for Jobs
- Create a Job
- with type "Object Replication"
- using codeunit 99001475
- set your location destinations
- Under object replication fasttab, add your object job
- set a schedule, or click run
- If you have multiple versions of NAV installed, you may get the error:
- [22924070] The database on the server cannot be opened by this version of the Microsoft Dynamics NAV Development Environment. The database has already been converted by a newer version.
- You must upgrade the Microsoft Dynamics NAV Development Environment to the latest version to open the database.
Subscribe to:
Posts (Atom)