Import G/L Title Accounts Through DTW?

[former_member247972]

Is there a way to import G/L title accounts through the DTW? I do not see the Postable field in the DTW template.

Tom Arnold

[Former Member · Accepted solution]

Hi Tom ,

It is by the same template for other G/L Account. The difference is ActiveAccount should be tNO.

Thanks,

Gordon

[former_member583013]

Hello Tom,

Please take a look at this Wiki Document which explain Step-by-Step the procedure to Import CoA using DTW

https://wiki.sdn.sap.com/wiki/display/B1/SAPBusinessOne...ToGo-10.DataTransfer+Workbench

Suda

[Former Member]

Hi Tom,

you need to use the property called ActiveAccount.

Here is a short extract fom the DI-API Reference:

ChartOfAccounts Object
ActiveAccount Property  
Description
Sets or returns a valid value of BoYesNoEnum type that specifies whether the account is an active account or just a title. title is used to organize and display data in financial reports, and can summarize several active accounts or several active accounts and titles together. 
Field name: Postable.
Property type
Read-write property
Syntax
Visual Basic 
Public Property ActiveAccount() As BoYesNoEnum
Remarks
Set tYES for active account.
Set tNO for title.
You can set up to two levels of titles. The third level must be an active account.

Kind regards,

Marcus Schmalz