On the Inventory Reconciliation (create) form, you can provide general information about stocktaking in the selected warehouse.


The "Inventory Reconciliation (create)" form

In the Warehouse field, select a warehouse where the count will be performed.

<Cell> in the adjacent field indicates that you can select a particular bin location in the warehouse or a certain level in the storage hierarchy. The Cell field is available if the Enable Bin Locations option is selected on the Administration > Settings > Purchasing and Warehouses form and if the Use Bin Locations option is selected for the particular warehouse.

<Auto> in the Number field indicates that a number for this document is assigned automatically when you save the document. The From field is populated automatically with the current business date. You can select another date, if necessary.

In the Entity field, select the legal entity of your organization which is responsible for this transaction. The Entity field is available if the Multi-Company Accounting option is selected on the Administration > Settings > General Settings form. The default entity for all users can be selected on the General Settings form. Also, you can specify your personal default entity, for details refer to Personal Settings.

In the Comment text box, you can enter any additional information about this document.

The document totals and other information

At the bottom of the form, the following fields are available:

  • Total Quantity (Fact): Shows the total actual quantity of all items listed on the Inventory tab.
  • Total Quantity (Accounting): Shows the total quantity of all items (listed on the Inventory tab) according to the accounting data.
  • Total Amount (Fact): Shows the total amount calculated on all items (listed on the Inventory tab) based on actual quantities and selected price type.
  • Total Amount (Accounting): Shows the total amount calculated on all items (listed on the Inventory tab) based on their book quantities and selected price type.

Also, at the bottom of the form, you can view who created this document and the current status of the document; it can be one of the following:

  • New (document was created, but not recorded to the database)
  • Not Posted (document was recorded, but not posted)
  • Posted (document was posted)
  • Marked for Deletion (document was marked to be deleted)

The toolbar buttons

After filling out the tab, click the Save button to save your work. After filling out all the tabs, click Post to save and post the document without closing it or Post and close to save, post, and close the document.

If you need to print the document, first save the document, click the Print button and then, Inventory Reconciliation. To print count sheets for stocktaking, click Print > Merchandise Filling Form. Review the printable form, edit it if needed, specify the number of copies and click Print to actually print the document. 

Use the Generate button to create a document based on this inventory reconciliation:

  • Goods Receipt Note: To account for the goods on hand that are not included in the accounting data.
  • Goods Dispatch Note: To account for the goods that are in the accounting data, but not available in the warehouse due to various reasons: damaged, stolen, lost, or are passed their expiration dates.
  • Opening Balance Entry:

For other button descriptions, see Document Toolbar.





  • No labels