DTW. ItemGroups. Link between fields in template and in groups.

[Former Member]

Hi

I tried to import through DTW ItemGroups to a base. But encounered a problem with linking fields in Group to fields in DTW-template. I've found the appropriate accounts for most of fields(I suppose), but I can't link five of them. What will be the fields in DTW-template where I should put the values of accounts of group? They are empty in scheme (with interrogative sigh).

Here are my scheme of linking:

Group DTW

Allocation Account - ???

Cost of Goods Sold Account CostAccount

Exchange Rate Differences Account ExchangeRateDifferencesAccount

Expense Account ExpensesAccount

Expense Account - Foreign ExpensesAccount

G/L Decrease Account DecreaseGLAccount

G/L Increase Account IncreaseGLAccount

Price Difference Account PriceDifferencesAccount

Purchase Credit Account PurchaseCreditAcc

Revenue Account RevenuesAccount

Revenue Account - EU RevenuesAccount

Revenue Account - Foreign RevenuesAccount

Sales Credit Account RevenuesAccount

Sales Returns Account InventoryAccount

Shipped Goods Account ShippedGoodsAccount

Stock Account InventoryAccount

Stock Offset - Decrease Account - ???

Stock Offset - Increase Account - ???

Variance Account VarianceAccount

VAT in Revenue Account VATInRevenueAccount

WIP Stock Account - ???

WIP Stock Variance Account - ???

With regards

Maxim

[Former Member]

Hi Maxim,

Here is the field name and what we use it for:

Allocation Account - TransferAc We use it as an AP Accruals

Stock Offset - Decrease Account - DecreasAc It can be the same with below account as Shortage/Overages

Stock Offset - Increase Account - IncreasAc It can be the same with above account as Shortage/Overages

WIP Stock Account - WipAcct Work-in-Process account for the material in process

WIP Stock Variance Account - WipVarAcct Work-in-Process variance account for the material in process variance.

Thanks,

Gordom

[Former Member]

Thanks, Gordon.

One more question:

What must be the fields in DTW-file for

such fields in ItemGroups in SBO as

1. Sales Returns Account

2. Stock in Transit Account

3. Purchase Credit Account

Probably I've done some mistakes in linking so now they don't filled by DTW

With regards

Maxim

[Former Member]

1. Sales Returns Account - ARCMAct We use as the same as Inventory Account

2. Stock in Transit Account - WipAcct as above mentioned

3. Purchase Credit Account - APCMAct We never use this account and it is still blank.

[Former Member]

Hi, Gordon.

I can't found any of them in list of fields in template. WIP... doesn't fill values in SBO-base.

Here are the list of fields in template, pick up from it, please, the names of fields

Number

Alert

CostAccount

CostInflationAccount

CostInflationOffsetAccount

CycleCode

DecreaseGLAccount

DecreasingAccount

EUExpensesAccount

EUPurchaseCreditAcc

EURevenuesAccount

ExchangeRateDifferencesAccount

ExemptRevenuesAccount

ExemptedCredits

ExpenseClearingAct

ExpenseOffsetAccount

ExpensesAccount

ForeignExpensesAccount

ForeignPurchaseCreditAcc

ForeignRevenuesAccount

GoodsClearingAccount

GroupName

IncreaseGLAccount

IncreasingAccount

InventoryAccount

InventorySystem

LeadTime

MinimumOrderQuantity

OrderInterval

OrderMultiple

PAReturnAccount

PlanningSystem

PriceDifferencesAccount

ProcurementMethod

PurchaseAccount

PurchaseCreditAcc

PurchaseOffsetAccount

ReturningAccount

RevenuesAccount

SalesCreditAcc

SalesCreditEUAcc

SalesCreditForeignAcc

ShippedGoodsAccount

StockInflationAdjustAccount

StockInflationOffsetAccount

TransfersAccount

VATInRevenueAccount

VarianceAccount

WIPMaterialAccount

WIPMaterialVarianceAccount