Integration Manager - Common VBA code snippits

It seems that I'm always using the same VBA snippits in Ingetration Manager. And I always have to look them up in help, because I don't do it that often and I have .NET and SQL code in my head; VBA is a distant cousin.

Here are a few of the snippets that I use... so I can find them quicker when I need them.

 

Related Articles

... and you 'll find more on the Integration Manager Menu

GL Transaction

Transaction Type: 

if SourceFields("JE Import Header.ReversingYesNo") = "Yes" then
    CurrentField = 2
else
    CurrentField = 1
end if

 Switching a Debit/Credit column

if SourceFields("JE Import Det.Amount") > 0 then
    CurrentField = SourceFields("JE Import Det.Amount")
else
    CurrentField = 0
end if
SetVariable "SeqNo", 16384

Formatting a date for a Batch Number

CurrentField = "AMAZON" + FormatDateTime(Date, 2)

 

 

 

 

 

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences