Before posting, ensure your BSM setup has been properly configured, such as mapping the accounting directory, setting account codes, and defining financial periods. This ensures smooth posting into the Accounting system. There are two posting methods available:
Export to DBF Method (Traditional Method)
Direct Posting Method (Enhanced Method)
1. Export to DBF Method
Use this method when you want to manually export a DBF file (glpost9.dbf) from BSM and then import it into Access Accounting.
Step 1: Configure Common Settings
Go to Housekeeping, General Setup.
Click the Common Settings tab.
Under Sub-dir. for vendor & chart of A/C, click Get Directory.
Select the Accounting data directory and confirm.
Step 2: Assign Account Codes
Go to Housekeeping, General Setup.
Click the Account tab.
Assign the appropriate Account Codes to all required fields.
Step 3: Set Financial Period
Go to Housekeeping, General Setup.
Click the Financial Period tab.
Enter the Closing Date for the last accounting year.
Set the Number of Periods for the current year.
Step 4: Post Transactions to Accounting (Export to DBF)
Go to Housekeeping, Post to Daccount.
Choose 'Let me select it myself'.
Select the transaction type(s) to post.
To post everything, choose All types of transactions.
Set the Period based on the Accounting System period.
Select the Date Range of transactions.
Click Next.
Review the list of transactions.
Click Next again.
Choose the destination folder for generating glpost9.dbf (click the folder icon).
Click Export.
Click Yes, then OK to complete the export.
Step 5: Import into UBS Accounting
Launch the UBS Accounting System.
Import the generated glpost9.dbf file to complete the posting.
2. Direct Posting Method
This enhanced method posts transactions directly from Access BSM to Access Accounting without exporting a DBF file.
Important Notes
Ensure that you have correctly mapped the Accounting folder before using Direct Posting.
Transactions posted via Export to DBF cannot be reposted using the Direct Posting method.
If you need to reverse a knock-off, it must be carried out at the source (Access BSM).
Any changes to posted transactions should be made in BSM and then reposted.
What Direct Posting Includes
Offset / Knock-Off details are automatically updated in Access UBS Accounting once both Invoice and Payment/Credit Note are posted.
If an invoice and payment were knocked off in BSM and then posted, reversing must be done back in BSM—changes will sync to Accounting.
Directly posted transactions can be viewed in Access Accounting by ticking the checkbox [Show Access BSM Transaction only].
This option is available in the Open Item Menu – Knock Off and Reverse.
For detailed editing, always update the transaction in Access BSM, then repost.