Stephen Smith's Blog

Musings on Machine Learning…

Tables and Data Flow of the Accpac Inventory Control Module – Part 2

with 2 comments

Last week we started to cover the database structure of the Accpac Inventory Control (I/C) module here.

The main types of database tables in I/C can be categorized as:

  • Setup
  • Master Data
  • Data Entry
  • Data Processing
  • Periodic Processing

We covered Setup and Master Data last week. This week we will cover Data Entry, Data Processing and Periodic Processing.

Data Entry

Data Entry consists of:  Receipts, Shipments, Adjustments, Transfers, Assemblies/Disassembles and Internal Usage.

These functions are only used by the I/C forms for entering data into I/C. Although applications can enter documents into these functions and post them, this isn’t the normal way of interacting with I/C. When applications feed data into G/L, A/R, A/P, O/E or P/O they create and post documents just like a user would. So in G/L Journal Entry you can see all the G/L batches created by entry operators plus a large number of batches entered into G/L by other accounting applications. This is a very uniform manner of entry that keeps everything together. However this wouldn’t be practical for I/C, since then there would be huge numbers of I/C Receipts and Shipments for everything that affects inventory and costing levels. Hence applications have protocols to interact with the inventory items directly without creating documents to do it during posting. This whole process is then orchestrated by Day End Processing to keep a unified audit trail so you can accurately track everything that happens.

Receipt Entry

ICREEH (IC0590): Receipt Headers.

ICREED (IC0580): Receipt Details

ICREEDO (IC0585): Receipt Details Optional Fields.

ICREEDS (IC0587): Receipt Detail Serial Numbers.

ICREEDL (IC0582): Receipt Detail Lot Numbers.

ICREEHO (IC0595): Receipt Headers Optional Fields.

ICPSTRE (IC0520): Post Receipts. Superview to post receipts.

ICRCPH (IC0560): Receipt Not Costed Headers. Receipt After Post – uncosted.

ICRCPD (IC0550): Receipt Not Costed Details.

ICRCPDP (IC0555): Receipt Not Costed Detail Optional Fields.

ICRCPDS (IC0558): Receipt Not Costed Detail Serial Numbers.

ICRCPDL (IC0553): Receipt Not Costed Detail Lot Numbers.

ICRCPHP (IC0565): Receipt Not Costed Header Optional Fields.

Shipment Entry

ICSHEH (IC0640): Shipment Header.

ICSHED (IC0630): Shipment Detail.

ICSHEDO (IC0635): Shipment Detail Optional Fields.

ICSHEDL (IC0632): Shipment Detail Lot Numbers.

ICSHEDS (IC0636): Shipment Detail Serial Numbers.

ICSHEHO (IC0645): Shipment Header Optional Fields.

ICPSTSH (IC0530): Post Shipments. Superview to post shipments.

Adjustment Entry

ICADEH (IC0120): Adjustment Headers.

ICADED (IC0110): Adjustment Details.

ICADEDO (IC0115): Adjustment Detail Optional Fields.

ICADEDS (IC0117): Adjustment Detail Serial Numbers.

ICADEDL (IC0113): Adjustment Detail Lot Numbers.

ICADEHO (IC0125): Adjustment Header Optional Fields.

ICPSTAD (IC0500): Post Adjustments. Superview to post adjustments.

Transfers Entry

ICTREH (IC0740): Transfer Header.

ICTRED (IC0730): Transfer Detail.

ICTREDO (IC0735): Transfer Detail Optional Fields.

ICTREDS (IC0738): Transfer Detail Serial Numbers.

ICTREDL (IC0733): Transfer Detail Lot Numbers.

ICTREHO (IC0741): Transfer Header Optional Fields.

ICPSTTR  (IC0540): Post Transfers. Superview to post transfer documents.

Assembly Entry

ICASEN (IC0160): Assemblies.

ICASENO (IC0165): Assembly Optional Fields.

ICASENL (IC0162): Assembly Lot Details.

ICASENS (IC0167): Assembly Serial Details.

ICPSTBM (IC0510): Post Bill of Materials. Superview to post bills of materials.

Internal Usage

ICICEH (IC0288): Internal Usage Headers.

ICICEHO (IC0289): Internal Usage Header Optional Fields.

ICICED (IC0286): Internal Usage Details.

ICICEDO (IC0287): Internal Usage Detail Optional Fields.

ICICEDS (IC0284): Internal  Usage Serial Numbers.

ICICEDA (IC0283): Internal Usage FAS Details.

Data Processing

Day End Processing

For more details on the Day End Processing Process, have a look at this blog post.

How and when Day End Processing is run is heavily controlled by the various options records in the system. For instance whether costing is performed during day end or posting is controlled by I/C options. These settings are there so you can optimize I/C for your business needs and environment.

ICDEND (IC0275): Master Day End Processing.

ICDEP (IC0276): IC Day End Processing

Calls the following superviews and updates the following tables:

ICCSTP (IC0270): Post Item Costs.

ICPOSTR (IC0420): Receipt Posting.

ICITRP (IC0350): Item Receipts Posting.

ICRECPH (IC0570): Receipt Audit List Headers.

ICRECHP (IC0568): Receipt Audit Header Optional Fields.

ICRECPD (IC0575): Receipt Audit List Details.

ICRECDP (IC0567): Receipt Audit Details Optional Fields.

ICPOSTS (IC0430): Shipment Posting.

ICSHIPH (IC0652): Shipment Audit List Headers.

ICSHPHP (IC0657): Shipment Audit Header Optional Fields.

ICSHIPD (IC0650): Shipment Audit List Details.

ICSHPDP (IC0655): Shipment Audit Detail Optional Fields.

ICPOSTA (IC0400): Adjustment Posting .

ICADJP (IC0140): Post Adjustment Details.

ICADJH (IC0132): Adjustment Audit List Headers.

ICADJHP (IC0135): Adjustment Audit List Header Optional Fields.

ICADJD (IC0130): Adjustment Audit List Details.

ICADJDP (IC0131): Adjustment Audit List Detail Optional Fields.

ICPOSTT (IC0440): Transfer Posting.

ICTRANH (IC0716): Transfer Audit List Headers.

ICTRNHP (IC0720): Transfer Audit List Header Optional Fields.

ICTRAND (IC0714): Transfer Audit List Details.

ICTRNDP (IC0718): Transfer Audit List Detail Optional Fields.

ICPOSTB (IC0410): Assembly Posting

ICASSMH (IC0182): Assembly Audit List Headers.

ICASMHP (IC0172): Assembly Audit List Header Optional Fields.

ICASSMD (IC0180): Assembly Audit List Details.

ICASMDP (IC0170): Assembly Audit List Detail Optional Fields.

ICHIST (IC0280): Transaction History.

ICHISTS (IC0285): Transaction History Inquiry summary.

ICSTAT (IC0700): Transaction Statistics.

ICSTATI (IC0710): Sales Statistics.

ICXLHIS (IC0815): Lot Number History.

ICXSHIS (IC0835): Serial Number History.

Periodic Processing

I/C has many processing functions that are run on demand (often infrequently). This section gives a sampling of the main I/C Periodic Processing functions:

ICCLRHI (IC0230): Clear History.

ICCLRIN (IC0240): Delete Inactive Records.

ICPRCC (IC0460): Copy Item Pricing.

ICPRCU (IC0470): Update Item Pricing.

ICWKGEN (IC0760): Generate Inventory Worksheet.

ICWKL (IC0770): Inventory Worksheets.

ICWKLO (IC0775): Worksheet Optional Fields.

ICWKUH (IC0790): Inventory Worksheet Headers.

ICWKUD (IC0780): Inventory Worksheet Details.

ICWKUHO (IC0795): Worksheet Detail Optional Fields.

ICWKUHL (IC0793): Inventory Worksheet Lot Numbers.

ICWKUHS (IC0797): Inventory Worksheet Serial Numbers.

ICPOSTW (IC0450): Inventory Reconciliation Posting.

ICGLTR (IC0278): Generate G/L Batches.

ICINTCK (IC0300): Integrity Checker.

ICUPGD (IC0752): Activation.

ICCTOE (IC0271): Transaction Inquiry for OE.

ICPRJNL (IC0483): Reset Printed Posting Journals.

ICLBLH(IC0365):  Label Headers.

ICDLDN (IC0277): IC Drill Down.

ICADGEN (IC0128): Process Adjustments.


Hopefully this gives a bit of help in understanding the I/C module for when you are producing custom forms, reports or writing VBA macros.



Written by smist08

August 27, 2011 at 7:40 pm

Posted in sage 300

Tagged with , ,

2 Responses

Subscribe to comments with RSS.

  1. […] be continued with data entry, data processing and periodic processing… Advertisement GA_googleAddAttr("AdOpt", "0"); GA_googleAddAttr("Origin", "other"); […]

  2. Hello Sir, Thanks for all data flow details, Can you pl. give explanation on Tables and Data Flow of the Accpac Project & Job Costing Module too.
    That will really great.


    August 5, 2012 at 8:57 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: