Skip to main content

Auto Post GL Stock Value by Project

caution

Auto Maintain Stock Value with Project required SQL Account version 839 and above.

Setup​

1. Turn on Auto Post GL Stock Value Option​

  1. Click on Tools

  2. Click on Option

    1

  3. Click on Miscellaneous

  4. Tick on Auto Post GL Stock Value

    2

2. Map Balance Sheet Stock Account in Maintain Stock Group​

  1. Click on Stock

  2. Click on Maintain Stock Group

    3

  3. Click on Edit

  4. Choose the Account Code for your Stock Value Posting

  5. Click on Save

    4

    note

    Ensure that all Stock Groups are mapped to the Balance Sheet Account Code (A)

    5

3. Map Project Code in Maintain Location​

  1. Click on Stock

  2. Click on Maintain Location

    6

  3. Click on Edit

  4. You can set your stock project for each location

  5. Save

    7

    info

    Ensure that all Location are mapped to the Project Code (A)

    8

    info

    Note : May ignore this step if you have only 1 Project.

4. Maintain Stock Month End, to show the total Stock Value for default project and P1​

Example A

Project Code : ----

Closing Stock : 308534.22

9

Example B

Project Code : P1

Closing Stock : 3560.00

10

5. Apply Financial Report will auto update Stock value​

note

When you apply Profit & Loss Statement, Balance Sheet or Trial Balance Report, system will automatically retrieve the Stock value from Stock Month End Balance and present it in financial report. Additionally, the system will update closing Stock value to Maintain Stock Value.

  1. This is a sample of a Balance Sheet Statement report to show a Closing Stock Value.

    11

info

Note : When Fall Outside Maintain Acceptable Trans Date range, the system will no longer retrieve the Stock Value from the Stock Month End Balance and will silently bypass the update.