Integrated Stock Ledger

 View PDF

The document below is not the latest version. To see the latest version, please click here.

Automatically update the Nominal Ledger whenever a stock movement occurs.

This optional module changes the way in which stock valuations are reflected in the Nominal Ledger.

In axis diplomat systems with this module, transactions are posted to the Nominal Ledger whenever a stock movement occurs in place of making periodic adjustments (typically at period end) based on a valuation of the stock on hand.

This means that the stock valuation within the draft accounts is updated in real-time whenever the Nominal Ledger is in the current period.

With the Integrated Stock Ledger module, you are able to:

  • eliminate the need for a Period End Stock Adjustment
  • obtain more detailed cost analysis within the Nominal Ledger, including breakdown by Department and Cost Centre
  • match the Cost of Sale in the Nominal Ledger to the Cost of Sale on each Sales Invoice

How it Works

Stock movement transactions are posted to the Nominal Ledger, in real time once the nominal period end for the previous period has been run, so that receipts increase and issues decrease the value of the Balance Sheet Stock Ledger Control Account (Stock on Hand), whilst the double-entry for each transaction is posted to the appropriate nominal account for the type of movement. For example:

  • The cost value of receipts of goods from purchase orders will increase the liability on the Goods Received not Invoiced account: the liability is reduced when the purchase invoice is booked to that account
  • The cost value (from the receipt being issued) on a sales issue transaction will increase the Cost of Sale account specified for that stock item
  • For users of the Compact MRP module, the Work-in-Progress account will be increased by the cost value of components issued to works and when the Works Order is completed the Finished Goods account will be increased by the cost value of the finished item received from works, while the cost value of the components used will be transferred from the Work-in-Progress account to the Finished Goods account, reducing the value of both the Work-in-Progress account and the Finished Goods account
  • Stock transfer transactions are not posted to the Nominal Ledger as they do not affect the stock valuation
  • Other non-specific stock movement transactions will be posted to designated stock adjustment accounts for investigation and write-off if appropriate
 

Who can make use of the Integrated Stock Ledger?

The Integrated Stock Ledger module is not suitable if you

  • allow negative stock
  • use provisional costs on goods received
  • have the Hire Management or Stock Depreciation modules

 View PDF

Call Back
This site uses cookies. By continuing to access this site you are accepting the use of cookies by this site.
Read more about cookies...
OK

Cookies are small text files stored on your device when you access most websites on the internet.

This Website uses cookies in order to make the Website easier to use, to support the provision of information and functionality to you, as well as to provide us with information about how the Website is used so that we can make sure it is as up to date, relevant and error free as far as we can. Further information about the types of cookies that are used on this Website is set out in the box below.

By using this Website you agree to our use of cookies. You can choose to restrict or block cookies set on the Website through your browser settings at any time. For more information about how to do this, and about cookies in general, you can visit www.allaboutcookies.org. Please note that certain cookies may be set as soon as you visit the Website, but you can remove them using your browser settings.

However, please be aware that restricting or blocking cookies set on the Website may impact the functionality or performance of the Website, or prevent you from using certain services provided through the Website. It will also affect our ability to update the Website to cater for user preferences and improve performance.

We don’t sell the information collected by cookies, nor do we disclose the information to third parties, except where required by law (for example to law enforcement agencies).

We may sometimes embed content from 3rd party websites such as YouTube. As a result, when you visit a page containing such content, you may be presented with cookies from these websites. We do not control the dissemination of these cookies and you should check the relevant third party's website for more information.

Cookies We Use

Cookie Description
CookieConfirm The presence of this cookie is used to remember the fact that you have confirmed that you are happy to accept cookies
ASPSESSIONIDxxxxxxxx This is a Session Cookie (session cookies are temporary and are erased when you close your browser). It identifies you from one page to the next and is used, for example, to keep track of your logged-in status.
UserID, account, password These cookies are used to remember your login credentials for when you next visit our website. They are only created if you choose the “Remember Me” option on the login page.
_utma, _utmb, _utmc, _utmz These are cookies created by Google Analytics and are used to provide us information on which web pages are the most popular, and the most popular search terms used by visitors arriving at our site.