Here's an example of what you can get from F1:
Item Table
The Item table manages the inventory.
The table contains information about items in your inventory. For each item there is a card, on which you enter basic information, such as name, units of measure, inventory location and unit price. Quantity changes in inventory are stored in the Item Ledger Entry table, and changes in inventory value are stored in the Value Entry table.
Each item must have a number for identification purposes. When you enter the number in Item No. fields elsewhere in the program (on a sales quote, for example), the program automatically uses the information associated with the number.
Before you can post purchases, sales and inventory adjustments, you must set up links from the item card to the general ledger. This is done through inventory posting groups, general product posting groups and the general posting setup.
Customer Table
The Customer table is used to record all information about all your customers.
Managing customers is an important part of managing the total finances of the company. In Navision Attain, you use the Customer table to do this. The table contains information used by a range of facilities that can help minimize customer costs. For example, credit limit, balance amount and payment term facilities make it possible for the program to issue a credit and an overdue balance warning when you enter a sales order. Furthermore, reminder term and finance charge term facilities allow you to invoice interest and/or additional fees.
The Customer table contains a card for each customer, on which you enter basic information such as name, address, and discount possibilities. Each customer must also have an identifying number. When you enter the customer number elsewhere in the program (on a sales quote, for example), the program will automatically use information from the Customer table for that particular customer.
Before you can post to a customer, you must set up a connection from the customer card to a balance sheet account in the chart of accounts. You must set up a connection to an income statement account. You do this with posting groups, which you must enter in the Gen. Bus. Posting Group and Customer Posting Group fields. The posting groups are set up in the Gen. Business Posting Group and Customer Posting Group tables.
Once you have set up posting groups, you can enter them in the Gen. Bus. Posting Group and the Customer Posting Group fields on customer cards. Then when you post to a customer account, corresponding entries will automatically be created in the associated G/L accounts. The general ledger will therefore always agree with the customer's balance.
You can post to a customer in an unlimited number of currencies. The resulting customer ledger entries will show the currency of each entry.
The program can display the customers in two different windows:
The Customer Card window has a card for each customer, containing all the fields you have selected. You can therefore see many fields for each customer. The program automatically displays the Customer Card window when you select Main Menu, Sales & Receivables, Customers.
The Customer List window displays all the customers, with a line for each; therefore, fewer fields are displayed for each customer. To see the Customer List window, select Main Menu, Sales & Receivables, Customers, and then click the Customer button and select List.
To see all the ledger entries for a customer, select Main Menu, Sales & Receivables, Customers. Then click the Customer button, and select Ledger Entries. In the window that appears, you can apply open entries, change due dates, and so on. You can see the sales statistics for a customer by clicking the Customer button and then select Statistics.
All customers must be set up in this table.
Item Ledger Entry Table
List of Fields in the TableItem ledger entries are created every time you post a change to your inventory quantity. This change could be a result of a receipt or shipment of goods, because you post a negative or positive adjustment of quantity or consumption or output due to production.
These inventory records also carry the items item tracking numbers - serial and/or lot number - if assigned.
Note
The Item Ledger Entry table only holds information about quantity - all amounts are listed in the Value Entry table.
Item ledger entries are created by the following: the posting of an item journal line; the posting of a sales order, return order, invoice or credit memo; and the posting of a purchase order, return order, invoice or credit memo.
Item ledger entries also result from the production of a BOM (bill of materials) in a BOM journal. Before you can create an item entry for the BOM you have produced, the program automatically creates an item entry for each of the component items that comprise the BOM.
For example, if a BOM is a table that consists of four legs and a table top, three item entries will be created: one for the BOM itself, the table (the entry is a positive adjustment because the inventory is increased by one table), and one for each of the items that comprise the table, that is, the table top and the legs (the entries are negative adjustments because the inventory is decreased by one table top and four legs). All three item entries have the same document number.
Finally, the Applied Entry to Adjust field is updated by the Adjust Cost - Item Entries batch job.
Value Entry Table
This table contains all value postings, that is changes in the inventory value.
Changes in quantity on inventory are stored as quantity postings in the Item Ledger Entry table.
Value entries may also originate in capacity ledger entries, where the work done on the item in the WIP-inventory adds value to the item. These are found in the Capacity Ledger Entry table.
One or more value entries can exist per item ledger entry and per capacity ledger entry.
When the inventory is reconciled with the general ledger, G/L entries are created on the basis of value entries. The amount to be posted to general ledger is calculated from the value entry as:
Cost Amount (Actual)- Cost Posted to G/L. This is done by running the Post Inventory Cost to G/L batch job.
