Dynamics GP - Auto Age AR - Automatically Age Receivables

--Set this up as a sql job to run daily

USE TWO
DECLARE @O_iErrorState int, @I_dAgingDate datetime
SELECT @I_dAgingDate = CONVERT(VARCHAR(10), GETDATE(), 102)
EXEC dbo.rmAgeCustomer 0, '', 'þþþþþþþþþþþþþþþ', @I_dAgingDate,
          127, 0, 0, '', @O_iErrorState OUT

SSRS - Value expression error: 'RdlObjectModel' is not a member of 'Reporting Services'

https://stackoverflow.com/questions/25022276/value-expression-error-bc30456-rdlobjectmodel-is-not-a-member-of-reportin

When you copy/paste some functions, the act of pasting resets the name of the function, and adds extra characters.
Go into your formulas, and remove any instances of "Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions."

SQL - Get Time from Datetime or Date field

RIGHT (CAST(dbo.SOP10200.DEX_ROW_TS AS varchar), 7)

Dynamics GP - eOne Smartconnect - GL Transaction

• Do not use a sequence
• Use a column for journal numbers
• Key by journal numbers
• Create Journal - Group by journal numbers
• Tick update existing for add distribution and create journal
• 
  

Dynamics GP - Insert values into Comment Tables. SOP Comment Tables.

insert into sy04200(cmtsries,commntid,cmmttext) values(3,'C6','WRITE OFF')

Tables involved

SOP10106 - Sales Document Comments

SY04200 - Comment ID's

SOP10202 - Sales Line Comments

Dynamics GP - VAT setup for Trinidad

• Setup 4 tax schedules, and corresponding Tax Schedule ID's. Assign each one to itself.
• VATS
• VATP
• NOVATS
• NOVATP
• Company Setup
• Tick Use Shipping Method when selecting default tax schedule
• Set Sales Tax Schedule to VATS
• Set Purchase tax schedule to VATP
• Shipping Methods
• "PICKUP" - Will use tax schedule from SITE
• "DELIVERY" - Will use tax schedule from Ship-To Address ID

If you do not tick "Use Shipping Method"

• Tax is calculated based on Shipping Address and Item, regardless of shipping method

Dynamics NAV-Ls OMNI-Generic Connectors, Web Methods (Not Magento or nopCommerce)

http://mobiledemo.lsretail.com/LSOmniHelp24/html/Methods_T_LSOmni_Service_IeCommerceService.htm