The database "Accounting for cargo transportation" was developed for the dispatcher (forwarder) working for the Agent (organization, SP), which organizes and controls the cargo transportation for customers (Customers), carried out by Carriers. Maintaining the customer base (legal entities and individuals) - CUSTOMERS, CARRIERS, cars, drivers, shippers, consignees, drawing up contracts with customers and carriers for organizing freight forwarding services, applications, preparation of accounting documents (invoices, completed works, acts reconciliation, control of payment for the services provided. Formation of reports on "accounts receivable" with customers (total, confirmed (documents sent), overdue (payment deadline), on "payable" with carriers (general), formation of “accounts receivable” and “payables” with all counterparties. Formation of a financial report for the period to analyze the financial part of the Agent’s activities.
Ability to work with Access database in the network by several users.
Formation and printing of contracts with customers and carriers, as well as documents "power of attorney" is implemented on the basis of prepared templates (Microsoft Word files). The user can edit the contract template with the Customer or the Carrier as he pleases, then it is necessary to configure the connection of contracts with the data source. It is implemented using the merge tool (the main menu of Word - Mailings - Merge Wizard), at the third step of the wizard using the "browse" button, you must specify the data source. For contracts with Customers, this is the table “Agreement with the Customer” of the program file gp2010.accdb, for contracts with Carriers, this is the table under “Agreement with the Carrier”, for powers of attorney the table of powers of attorney. If the user has changed the location of the program (gp2010 and gp_be2010 files), moved to another folder or computer, then when opening Word files (contract templates and power of attorney), repeat the steps to connect the data source.
Printing invoices, certificates of completion, dispatch applications, acts of reconciliation with counterparties is carried out from the program.
https://my-files.ru/5gyqmc (формат базы Microsoft Access 2010 32-x)
https://my-files.ru/t4wdsg (формат базы Microsoft Access 2010 64-x)