Pre-requisites
| Table of Contents | ||
|---|---|---|
|
Config: Flock Id or Flock Code for AP/JE to Aeros LIVE Expense
ERP Journal Entry
Make sure that in the comment in the Journal Entry header you include the flock number this expense is supposed to go to if this is a DIRECT expense. You must put an ‘F’ in front of the flock number so the system knows this is a flock number and not just a regular comment. In the CONNECT batch you will be able to enter the flock number in the batch if you miss it in this step.
...
| Code Block | ||
|---|---|---|
| ||
declare @temp table
(
sKey varchar(100) not null
, sData varbinary(50) not null
);
-- pick one or the other
--insert into @temp(sKey,sData) select 'APAndJE_IsUseFlockCode', convert(varbinary(50), 0x01); -- treat as flock code
insert into @temp(sKey,sData) select 'APAndJE_IsUseFlockCode', convert(varbinary(50), 0x010x00); -- treat as flock Id
merge dbo.ConfigSystem t
using @temp s
on t.ConfigKey = s.sKey
when not matched by target
then insert (ConfigKey,[Value])
values (sKey,sData)
when matched
then update
set [Value] = sdata;
select *, cast([value] as varchar(max)) from dbo.ConfigSystem;
|
...