HITB Reset Tool - Data Validation - Account does not exist

CAUSE
The item may have quantities in one of the quantity type columns, and has no associated account with that quantity type.

select QTYTYPE, * from SEE99998 where qtytype <> 1

Review the Quantity Type field to see which "bucket" this item has receipt layers in. Here are the possibilities:
1 – On Hand
2 – Returned
3 – In Use
4 – In Service
5 – Damaged

Each of these quantity types maps to a different account type that would need to be populated.
1 – On Hand -- Inventory
2 – Returned -- Inventory Returns
3 – In Use -- In Use
4 – In Service -- In Service
5 – Damaged -- Damaged

Verify that you have accounts entered for the quantity types that exist for this item(and the others as needed) to resolve this warning message.


RESOLUTION
To Resolve this, set default posting accounts for the different quantity types in your posting setup, or on each item.

On the item card for each item, set a value for the account required for "Inventory Returns"

--This script can be used to update items with an account number
update iv00101 set IVRETIDX = x where ITEMNMBR = 'y'

--Where x is your account index, and y is your item number.

Scripts
--Copy Inventory Account to Return Account for item classes
select * from iv40400 where ivretidx = 0

update iv40400 set ivretidx = ivivindx where ivretidx = 0

GRNI - Goods Received not Invoiced does not match Trial Balance

• Run the GL Trial Balance for the AP Clearing account as at today
• Run the Vendor Amt. Rcd. Not Invoiced as at today, compare the figures
• Differences are due to Exchange Rate currency rounding and value entries that affect previous transactions. Depending on when the reports are run, it may or may not include the adjusting value entries that would affect the GL balance.

Batch File - How to copy files over a certain size from one folder structure into the exact same folder structure

https://superuser.com/questions/877976/windows-command-line-to-move-files-over-a-certain-size

robocopy "C:\My Source" "C:\My Destination" /s /max:10000000 /mir /R:1 /W:1

/s - copy subdirectories
/max - limit filesize in bytes
/mir - mirror structure (mirrors deletes)
/R - max retries if file is open
/W - max wait time in seconds when retrying

Dynamics GP 2016 R2 upgrade from GP2015R2 - Could not find stored procedure 'DYNAMICS.dbo.zDP_ASIEXP81F_1'

[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'DYNAMICS.dbo.zDP_ASIEXP81F_1'.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'ASI_Start_Account_Number_1_9'.

This was resolved by running the Grant.sql script first

Dynamics GP - Latest Version

Latest GP Versions
https://victoriayudin.com/2010/09/11/dynamics-gp-version-numbers-and-service-packs/


Upgrade Paths for GP 2016
https://mbs.microsoft.com/customersource/northamerica/GP/support/hot-topics/HOT_TOPIC_MDGP2016Upgrade


Latest SQL versions
https://technet.microsoft.com/en-us/library/ff803383.aspx


Latest Management Reporter Versions
https://victoriayudin.com/2011/07/04/management-reporter-versions/

ReqLogic - Update GP PO Requisition Date with Reqlogic Requisition Date

UPDATE       POP10100
SET                REQTNDT = XW_ReqHdr.ReqDate
FROM            POP10110 INNER JOIN
                         POP10100 ON POP10110.PONUMBER = POP10100.PONUMBER LEFT OUTER JOIN
                         XW_ReqHdr ON POP10110.Source_Document_Number = XW_ReqHdr.ReqNbr
WHERE        XW_ReqHdr.ReqDate > '1900-01-01'

LS Retail - AR Charge, Tender to customer Account and Credit Limits and Payment Terms

• Tender type under store setup must be ticked for "Card/Account" to identify the tender type as a customer account to know it has to check credit limits
• Customer Credit Limit must not be 0. 0 is treated as unlimited credit.
• If the Sales and Receivables Setup is set to "Both Warnings"
• The POS should give a warning about the transaction being over the customer's credit limit, and prevent you from moving forward
• If your tender type under the store setup is ticked for "Manager Key Control" 
• and your staff account permission is Manager it will allow you to use the customer account tender type
• If it is not ticked, anyone can use this tender type
• If Customer is Blocked on customer Card, Transaction will stop with error
• 
  
• C99001570 - POS Transaction - Handles Credit Check when Customer Account Tender type is selected
• Function - TenderCharge
• Text806 - Customer %1 is over creditlimit or blocked. Want to continue?
• C99008900 - POS functions
• Function - ValidateCustomer
•