Dynamics NAV/BC - Columbus Foods - Receive must be equal to "no" in bin type code=REC. Current value is YES

The receive bin is not set to ship or pick.
To allow picking from this bin, the stock must be in a container.
Create a container and put the stock into it.
you can now pick from that container

Dynamics NAV/BC - How to send Electronic Remittances to Vendors whenever a payment is made

https://docs.microsoft.com/en-ca/dynamics365/business-central/ui-extensions-send-remittance-advice

https://docs.microsoft.com/en-us/archive/blogs/dyn365finsupport/using-eft-in-dynamics-365-for-financials

• Pre-requisites
• Bank Account must have Blank Currency
• On the Bank Account Card make sure the following items are setup:
• - 'Country Export Format' should be CA, MX or US depending on your bank. 'Other' indicates you are using AMC banking with the 'Bank Data Conversion' service.
• - Specify your bank 'Transit No.'
• - Specify your 'Payment Export Format'
• - Specify a 'Last Remittance Advice No.'


• The Vendor Bank Account must be setup correctly. Select the Vendor > Navigate: Bank Accounts
• - The vendors bank should be setup here
• - 'Use for Electronic Payments' must be checked
• - Specify the 'Bank Branch No.', 'Bank Account No.', and 'Transit No.'


• On the 'Payment Journals' page, make sure the batch has the 'Allow Payment Export' box checked
• Vendor Card
• Define Document Sending Profile
• Navigate>Vendor>Document Layouts
• Choose Report 11383,Enter Vendor E-mail, Use as Body
• SMTP Mail Setup
• Configure
• In the Payment Journal page, choose Navigate, Payments, Send Remittance Advice to email remittance advice for one or multiple payment journal lines
• In the Vendor Ledger Entries page, choose Actions, Functions, Send Remittance Advice to email remittance advice after posting of vendor payments, for one or multiple vendor ledger entries

Dynamics NAV/BC - How to post cash to the bank in a lump so it displays in the bank rec as a single value

• What does not work
• If you use balancing accounts on the cash receipt screen, it will come in as multiple lines in the bank rec
• The deposit screen details will come in as multiple lines in the bank rec UNLESS 
1. you untick the General Ledger Setup>Bank Recon. With Auto Match 
2. OR You untick the General journal Templates>Deposits>Force Doc Balance 
• (This puts a balancing entry on each journal line, disabling it puts a summary journal line which results in a single bank entry
• What works - There are 5 ways to do this
1. Payment Registration
1. Select invoices to receive payment for
2. Post as Lump
2. Cash Receipt Entry
1. Do not use balancing accounts
2. Enter all cash receipts on single lines
3. Enter single line for the bank entry that is the total of all cash entries to register the entire transaction as a single journal
4. Post
5. This will allow you to apply each line separately, but show up in the bank rec as a single entry
3. Use a suspense account to collect payments, then manually journal deposit values into the bank from that account
4. Deposit with Force Doc Balance Disabled
1. General Journal Templates>Deposits>Untick Force Doc Balance 
2. Use Deposit Screen as normal
3. When deposit is posted, it will come into the bank as a single entry
5. Disable Bank Recon. with Auto Match (NA Only)
1. This gives you a completely different bank rec screen and bank rec report which is more conventional than the default bank rec screen and report
2. The only drawback of this option is you do not enter the bank statement for auto-matching, but otherwise, this is the most conventional method of bank reconciliation
3. Process>Suggest lines>Both
1. Manually mark each entry as cleared
2. Enter total for bank statement on top
3. Post

Business Central - Necessary Powershell Scripts

New-NAVServerUser BC160 -WindowsAccount DESKTOP\Test

New-NAVServerUserPermissionSet BC160 –WindowsAccount DESKTOP\Test -PermissionSetId SUPER

Import-NAVServerLicense BC160 -LicenseData ([Byte[]]$(Get-Content -Path "C:\Admin\BC16\license.flf" -Encoding Byte))

Restart-NAVServerInstance -ServerInstance BC160 -Verbose

NAV/BC - Copy / Paste Rows in Sales Orders, Purchase Orders, General Ledgers, and other transactions in Web Client

• Select transaction to copy from
• Ctrl+A to select all rows
• If it selects the text on the screen, try selecting a different field so the cursor goes into the actual record, then press Ctrl+A
• All records will tick
• Ctrl+C to copy all rows
• Go to your new transaction or excel
• Ctrl+V to Paste Rows
• If you select specific rows, it will try to overwrite your selection with the exact row size
• However, if you delete all rows, and paste on the first row, it will paste all rows
• From Excel, you can update the data
• Select entire Row
• Ctrl+C
• Go to Transaction line in Web Client
• Ensure you are in a regular field (not an option dropdown)
• Ctrl+V to paste the rows
• If you select the exact same number of rows in the Web Client, it will attempt to update the existing selected rows in the Web Client

NAV/BC - Direct unit cost excl. tax must be 0 when the prepayment invoice has already been posted

You get this error when trying to post a receipt for a prepaid vendor invoice.

The Direct unit Cost excl. Tax is changing on receipt and the item is not a service item.
Most likely, something has changed on the item uofm between purchasing and receiving.
Cancel the receipt
Delete and redo the PO

SQL - Convert a delimited string to records - STRING_SPLIT

select value from string_split((
SELECT        [TheFilter] FROM            dbo.[MyFilter] AS Config),'|')

will convert A|B|C|D

into

A
B
C
D

If you try to do this in the query designer, it will throw an error, you have to set this using the create or alter view commands

Dynamics GP - smgrantaccessonaccountmstr error during upgade

There is a table with an unexpected name, or a copy of an existing table with an unexpected name.
Review all custom tables that may have been created in SQL. You may need to remove or rename them.