This functionality enables the user to import external bank statements into SAP Business One (for reconciliation). The capabilities include the import of the following file types.
Cashfocus (ABSA .csv & .txt format)
Absa Internet Banking (.csv format)
SAPMT940 (Citibank .txt format)
BankIt (First National Bank .csv format)
CAMS (First National Bank .cdl & .exp format)
Lloyds Of London (.csv format)
Netbank (.csv format)
Netbank Multi Statement (.csv format)
NedInform (.txt spreadsheet format)
Nedbank Lesotho (.csv format)
Business Online (Standard Bank .csv & .dat format)
Standard Bank Lesotho (.txt format)
Supplier Statement (.csv format)
External bank statement account posting functionality
This functionality allows the user to post the Imported Bank Statement Transactions to either Incoming or Outgoing payments. The postings will be semi automated with a rich configuration that will require minimal alteration from the user.
Easy payment functionality
The purpose of this section is to enable the user to create an EFT (Electronic Funds Transfer) document when creating a payment or a collection through the payment software tool. The created document can then be sent to the Bank for EFT purposes. This functionality applies to outgoing and incoming bank transfer payments. The capabilities include the import of the following EFT file types
NedInform Free-Format (Payments and Collections)
NedExec (Payments Only)
FNB PACS (Payments and Collections)
Standard Bank BUSINESS ONLINE Dated & SSVS file formats (Payments and Collections)
ABSA CASHFOCUS Default Format (Payments and Collections)
ABSA CASHFOCUS Short Format (Payments Only)
Citibank CITIDIRECT (Payments (ACH) and Collections (DD))
SmartPayrollLink
This solution pertains to integrating VIP Payroll and/or Praxis Payroll transactions with single or multiple SAP Business One companies. The product can be used with any Payroll system that can produce a fixed format output file.
This Integration Application will read a Payroll generated file from a directory specified by the user. The file will then be interrogated and journal entries will be made for the transactions of the configured companies. The journal entries for the accounts will correspond to the account codes in the Payroll system.
SmartAsset
Although SAP Business One has an Add-On that caters for Asset Management, SmartAsset is geared for fast implementation and uncomplicated Asset Procurement and Depreciation.
The configuration section of SmartAsset is a single screen mechanism and procurement is via the slightly augmented SAP Business One A/P Process.
Asset procurement
Depreciation
Asset tracking
Asset procurement
Assets are procured either by purchasing it through a slightly enhanced SAP Business One A/P process or by adding the Asset(s) to the SmartAsset Asset Register through a SAP Business One Journal.
The procured Assets in the Asset Register will derive the required GL Account and Method for Depreciation through an Asset Group Definition.
Assets can be managed in the Asset Register and the following can be changed for an existing Asset.
Remaining Life
Asset GL Accounts (for Transfer of Assets)
Asset Disposal
Asset Sale
SmartAsset utilizes the Asset Register as a single point of contact and Assets are not created as Business One “Items”.
Depreciation
Asset Depreciation is once again a one screen affair where the Asset Group(s) can be selected and the Depreciation Group(s). Depreciation can be done primarily for creation of a SAP Business One Depreciation Journal, but alternative depreciations (for differing depreciation periods) can also be done. An alternative deprecation will be done to a Journal Voucher.
SmartAsset has a detailed history of each item’s deprecation as and when it is journaled. Depreciation Types include Straight Line and Diminishing Value.
Tracking
The Add-On manages Asset Tracking and auditing with up to 6 levels of Asset Hierarchy Definition. Tracking and Location Audit Reports comes standard.
SmartUtils
This toolset will supplement & enhance SAP Business One functionality and processes.
Field values checking
Full unit checking
Unit of measure specification for item master data
Property filtering for reporting functionality
Inventory transfer warehouse security
Marketing document warehouse security
Automatic document creation & distribution
Field values checking
The Add-On performs checking on defined fields to ensure the fields are filled with values. These fields include
Documents Header System Fields
Documents Header User Defined Fields
Documents Item (Line) System Fields
Documents Item (Line) User Defined Fields
Full unit checking
SmartUtils will ensure that specified items will only be entered into documents in full units. No fractions will be allowed in the quantity field. This check pertains to
All Marketing Documents
Inventory Transaction Documents
Goods Receipt
Goods Issue
Stock Transfer
Unit of measure specification for item master data
When adding/updating a Master Item record, the Add-On will create combo boxes (drop down menus) for the Purchasing UOM value in the Purchasing Data tab and for the Sales UOM value in the Sales Data tab. The user can select (or enter) any one of the configured UOM values and the Add-On will ensure the validity of the entered value.
Property filtering for reporting functionality
The Add-On will present the user with a screen to define specific search criteria for Items. The search criteria will include:
Item Group
Warehouse
Manufacturer
Default Supplier
User defined fields on the Item Master
After specifying the search criteria, the user will commit the configuration and a single (user selected) property will be enabled by the Add-On. All items that falls into the selected criteria will have this property ticked. (All other items will not have this property ticked). When the selection process is complete, the user can then use this single property to enable creating of reports, search for items lists, etc.
Inventory transfer warehouse security
The Add-On will allow any SAP B1 Superuser to configure the access that SAP B1 users have to warehouses in terms of transferring inventory. Each SAP B1 user must be configured to allow the user to transfer inventory to a selected set of warehouses, from a selected set of warehouses. The warehouse security will be enforced in the Inventory Transfer screen. The Inventory Documents include Goods Receipts, Goods Issues and Inventory Transfers.
Marketing document warehouse security
The Add-On will allow any SAP B1 Superuser to configure the access that SAP B1 users have to warehouses in terms of stock access for Marketing Documents. Inserting stock items by means of Purchasing Documents or extracting stock items by means of Sales Documents will be marshaled using the same setup as set in the Inventory Transfer. Thus only users with “From” capability for a specific warehouse will be allowed to post marketing documents that extract stock items from a specific warehouse. Similarly, only users with “To” capability for a specific warehouse will be allowed to post marketing documents that inserts stock items into a specific warehouse.
Joel 2:1 - Blow ye the trumpet in Zion, and sound an alarm in my holy mountain: let all the inhabitants of the land tremble: for the day of the Lord cometh, for it is nigh at hand