Programmer:Item Group: Difference between revisions

From AutoCount Resource Center
Content added Content deleted
mNo edit summary
No edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:


==Technical Specification==
==Rules in Item Group==
# Default Size = 8
# Default ItemGroup size = 8
# Not allow to delete Item Group when it is being referred by Stock Item.
# Not allow to delete Item Group when it is being referred in Stock Item.

==References of AutoCount Accounting version 1.8, 1.9==
{{BaseReferenceAC18}}
'''BCE.AutoCount.StockMaint.dll'''


==Assemblies in AutoCount Accounting version 1.8==
<pre>
BCE.AutoCount.dll
BCE.AutoCount.CommonAccounting.dll
BCE.AutoCount.MainEntry.dll
BCE.Utils.dll
BCE.Utils.UI.dll
BCE.AutoCount.StockMaint.dll
</pre>


==Item Group API Usage==
==Item Group API Usage==
Line 46: Line 41:
BCE.AutoCount.Stock.ItemGroup.ItemGroupEntity itemGroup = cmd.GetItemGroup("FINISHED");
BCE.AutoCount.Stock.ItemGroup.ItemGroupEntity itemGroup = cmd.GetItemGroup("FINISHED");


itemGroup.ItemGroup = "FINISHED";
//ItemGroup allows rename using ItemGroupCommand
//ItemCode that is referring to this ItemGroup will be updated to the new ItemGroup
itemGroup.ItemGroup = "FINISH1";
itemGroup.Description = "Finished Goods";
itemGroup.Description = "Finished Goods";


Line 74: Line 71:
==Default Accounts==
==Default Accounts==
* Default accounts are maintained in Tools | Options, under G/L | Default Accounts, where Default Sale Account, Purchase Account and etc are maintained.
* Default accounts are maintained in Tools | Options, under G/L | Default Accounts, where Default Sale Account, Purchase Account and etc are maintained.
* Below codes show how to obtain default accounts value.
* Below methods are to obtain default accounts value.
<syntaxhighlight lang="csharp">
<syntaxhighlight lang="csharp">
//Default Sale Account Code
//Default Sale Account Code
Line 80: Line 77:
private string GetDefaultSalesCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultSalesCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.SaleAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.SaleAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Cash Sale Code
//Default Cash Sale Code
Line 87: Line 85:
private string GetDefaultCashSaleCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultCashSaleCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.CashSaleAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.CashSaleAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Sales Discount Code
//Default Sales Discount Code
Line 94: Line 93:
private string GetDefaultSalesDiscountCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultSalesDiscountCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.DiscountAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.DiscountAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Sales Return Code
//Default Sales Return Code
Line 101: Line 101:
private string GetDefaultSalesReturnCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultSalesReturnCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.SalesReturnAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.SalesReturnAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Purchase Code
//Default Purchase Code
Line 108: Line 109:
private string GetDefaultPurchaseCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultPurchaseCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Purchase Discount Code
//Default Purchase Discount Code
Line 115: Line 117:
private string GetDefaultPurchaseDiscountCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultPurchaseDiscountCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseDiscountAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseDiscountAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Purchase Return Code
//Default Purchase Return Code
Line 122: Line 125:
private string GetDefaultPurchaseReturnCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultPurchaseReturnCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseReturnAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseReturnAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
//Default Stock Balance Code
//Default Stock Balance Code
Line 129: Line 133:
private string GetDefaultBalanceStockCode(BCE.Data.DBSetting dbSetting)
private string GetDefaultBalanceStockCode(BCE.Data.DBSetting dbSetting)
{
{
return BCE.Data.DBRegistry.Create(dbSetting)
string str = BCE.Data.DBRegistry.Create(dbSetting)
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.BalanceStockAccountID());
.GetString(new BCE.AutoCount.RegistryID.DefaultAccount.BalanceStockAccountID());
return string.IsNullOrEmpty(str) ? null : str;
}
}
</syntaxhighlight>
</syntaxhighlight>




{{SeeAlsoStock}}
{{SeeAlsoStock}}

Latest revision as of 08:14, 7 June 2018

Technical Specification

  1. Default ItemGroup size = 8
  2. Not allow to delete Item Group when it is being referred in Stock Item.

References of AutoCount Accounting version 1.8, 1.9

BCE.AutoCount.dll
BCE.AutoCount.CommonAccounting.dll
BCE.AutoCount.MainEntry.dll
BCE.Utils.dll
BCE.Utils.UI.dll
BCE.AutoCount.StockMaint.dll


Item Group API Usage

New

public void NewItemGroup(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Stock.ItemGroup.ItemGroupCommand cmd = BCE.AutoCount.Stock.ItemGroup.ItemGroupCommand.Create(dbSetting);
    BCE.AutoCount.Stock.ItemGroup.ItemGroupEntity itemGroup = cmd.NewItemGroup();

    itemGroup.ItemGroup = "FINISHED";
    itemGroup.Description = "Finished Goods";
            
    //Assign account code with default account code respectively
    itemGroup.SalesCode = GetDefaultSalesCode(dbSetting);
    itemGroup.CashSalesCode = GetDefaultCashSaleCode(dbSetting);
    itemGroup.SalesDiscountCode = GetDefaultSalesDiscountCode(dbSetting);
    itemGroup.SalesReturnCode = GetDefaultSalesReturnCode(dbSetting);
    itemGroup.PurchaseCode = GetDefaultPurchaseCode(dbSetting);
    itemGroup.PurchaseDiscountCode = GetDefaultPurchaseDiscountCode(dbSetting);
    itemGroup.PurchaseReturnCode = GetDefaultPurchaseReturnCode(dbSetting);
    itemGroup.BalanceStockCode = GetDefaultBalanceStockCode(dbSetting);

    cmd.SaveItemGroup(itemGroup);
}

Edit

public void EditItemGroup(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Stock.ItemGroup.ItemGroupCommand cmd = BCE.AutoCount.Stock.ItemGroup.ItemGroupCommand.Create(dbSetting);
    BCE.AutoCount.Stock.ItemGroup.ItemGroupEntity itemGroup = cmd.GetItemGroup("FINISHED");

    //ItemGroup allows rename using ItemGroupCommand
    //ItemCode that is referring to this ItemGroup will be updated to the new ItemGroup
    itemGroup.ItemGroup = "FINISH1";
    itemGroup.Description = "Finished Goods";

    //Assign account code with default account code respectively
    itemGroup.SalesCode = GetDefaultSalesCode(dbSetting);
    itemGroup.CashSalesCode = GetDefaultCashSaleCode(dbSetting);
    itemGroup.SalesDiscountCode = GetDefaultSalesDiscountCode(dbSetting);
    itemGroup.SalesReturnCode = GetDefaultSalesReturnCode(dbSetting);
    itemGroup.PurchaseCode = GetDefaultPurchaseCode(dbSetting);
    itemGroup.PurchaseDiscountCode = GetDefaultPurchaseDiscountCode(dbSetting);
    itemGroup.PurchaseReturnCode = GetDefaultPurchaseReturnCode(dbSetting);
    itemGroup.BalanceStockCode = GetDefaultBalanceStockCode(dbSetting);

    cmd.SaveItemGroup(itemGroup);
}

Delete

public void DeleteItemGroup(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Stock.ItemGroup.ItemGroupCommand cmd = BCE.AutoCount.Stock.ItemGroup.ItemGroupCommand.Create(dbSetting);
    cmd.DeleteItemGroup("FINISHED");
}

Default Accounts

  • Default accounts are maintained in Tools | Options, under G/L | Default Accounts, where Default Sale Account, Purchase Account and etc are maintained.
  • Below methods are to obtain default accounts value.
//Default Sale Account Code
//Implement in Sale Invoice
private string GetDefaultSalesCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.SaleAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Cash Sale Code
//Implement in Cash Sale
private string GetDefaultCashSaleCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.CashSaleAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Sales Discount Code
//Implement in Sale Credit Note, Sale Invoice, Cash Sale
private string GetDefaultSalesDiscountCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.DiscountAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Sales Return Code
//Implement in Sale Credit Note
private string GetDefaultSalesReturnCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.SalesReturnAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Purchase Code
//Implement in Purchase Invoice and Cash Purchase
private string GetDefaultPurchaseCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Purchase Discount Code
//Implemnt in Purchase Return document
private string GetDefaultPurchaseDiscountCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseDiscountAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Purchase Return Code
//Implement in Purchase Return document
private string GetDefaultPurchaseReturnCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.PurchaseReturnAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}
//Default Stock Balance Code
//Implement in "Live Stock Update" for Financial Reports
private string GetDefaultBalanceStockCode(BCE.Data.DBSetting dbSetting)
{
    string str = BCE.Data.DBRegistry.Create(dbSetting)
        .GetString(new BCE.AutoCount.RegistryID.DefaultAccount.BalanceStockAccountID());
    return string.IsNullOrEmpty(str) ? null : str;
}

See Also

Go to menu

Go to top
Resources For AutoCount Software Developers