• by ASP Microcomputers / From / August 21, 2018 /

    How does the Multiple Databases configuration option work?

    This option is used where, for accounting or other purposes, a company has two separate trading entities that share the same warehouse.

    The following needs to be setup correctly:

    1. A separate database for each trading entity is required.
    2. The Warehouse and Locations must be the same in both databases (as they share the same physical locations). ASPluris will draw the locations only from the first database.
    3. The ABM users should be the same in both databases.
    4. Product codes have to be different in both databases.  The same product cannot exist in both databases.
    5. Orders (sales/receive etc) should have different prefixes for each database.

    From the scanner operator point of view, everything will work as if there is only one large database.  Orders can be dispatched / combined and submitted etc.  The operator can pick orders based on a customer which could be multiple orders from different databases.  After picking, ASPLuris creates separate transactions for each database.

    For order grouping, the customer/supplier names have to match.  Codes are looked up during the processing of the order so they can be different.  ASPluris works out which database needs to be processed based on the order number or product code (transfer etc), then the transaction is processed as per normal.