![]() ![]() Then, Accpac will store optional field values for each item in “ICITEMO” table with respective item numbers. Now at the time of creating new item we attach already created optional field with the new item and assign optional field value to it. ![]() Further when we link it to inventory control module this information save into “ICOFD” table. Optional fields and there values will be stored in the optional field table “CSOPTFH” and “CSOPTFD” table. Now if we want to attach optional fields with the inventory then first we have to create optional fields from the Common Services “Optional Fields” form. Let’s take Inventory control there is the master table “ICITEM” where all items will be saved. When we create any optional field, Accpac create a new entry in the optional field table. Ok, now lets see how Accpac maintaining the optional fields and how we can easily filter it into our reports. It is may be because the way Accpac keeping the entries in the Database. Recently I came to know that some of my colleagues and crystal report writers are facing issues at the time of fetching the optional fields form the Accpac database and showing it on the reports. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |