Đang Thực Hiện

156609 Access Front End - SQL BE

Access Front End, SQL Server back end.

Vendor Compliance Database - the database needs to collect claims that are split into two different categoies – Transportation and Merchant Claims. All claims are based on PO and if There is a claim on PO 123 on the Transportation side, then when you go to initiate a claim on the merchant side it should state a claim on the Transportation exist and populate with the Vendor name used on the other claim. There will need to be an authenticated log in system that will allow different user levels for example.

If a user logs in with an ID that has a manager level they can:

Add users

Add Claims

Delete Claims

Waive Claims

View Claims

If a user logs in with an ID that has a Waiver level they can:

View claims

Waive Claims

If a user logs in with an ID that has a researcher level they can:

View Claims

Merchant Side -

Vendor:

Department: (drop down)

Division (Drop down)

Reason for chargeback – list of reason with check box if they apply.

Cost of Charge back - List of Cost with amount in dollars and qty - The form should total the total amount the user selected:

Affected Skus: - Running table with data entry for skus listed. Form should calculate total units affected.

Attachment - We need to be able to add a zip file that will be copied to our shared drive. That way we can view them later.

Waived by: People of certain log-in rights can waive claims.

Transportation side –

Vendor:

Department: (drop down)

Division (Drop down)

Buyer (Drop Down)

Weight

Class

Cartons

Pro#

Invoice #

Carrier SCAC

Reason for chargeback – list of reason with check box if they apply.

Cost of Charge back - List of Cost with amount in dollars and qty - The form should total the total amount the user selected:

Affected Skus: - Running table with data entry for skus listed. Form should calculate total units affected.

Attachment - We need to be able to add a zip file that will be copied to our shared drive. That way we can view them later.

No WAIVING ON THIS SIDE.

Kỹ năng: Bất kì công việc gì, Microsoft Access, SQL

Xem thêm: transportation manager, sql data entry form, data front, cost microsoft sql server, access vendor database, sql microsoft access, microsoft access sql, back end server, back end database, all po, sql microsoft, sql based, sql access, po file, invoice front, Front, delete attachment, data entry sql, cost be, back end data, access rights, access manager, database invoice microsoft access, access delete, sql server front

Về Bên Thuê:
( 0 nhận xét )

Mã Dự Án: #1902794