Exercise Workbook

This workbook accompanies the Folks BackOffice ERP User Manual. Each lab walks a real-world scenario, asks you to perform the steps, and ends with self-check questions. Save your work after every step so a trainer can review your progress.

Before you start

1. You have a working login with SuperAdmin or a fully-scoped BackOffice role bundle.
2. The API and FE are both running locally (dotnet run in each).
3. Both solutions build with 0 errors.
4. The DB MasGen_ERP_DevV3 is restored with seed data — at least one Hotel, Airline, Tour Supplier, Visa Agent, Transfer Co. seeded.
5. Have a notebook open to record codes (Customer, Agent, Booking Ref, Proforma No, Invoice No, JV No) — these are referenced in later labs.

Skill levels

Conventions used in this workbook

Log in, walk the navbar, identify the four module groups (Reservation, Operations, Approval, Payments + Accounts/UM), and confirm your role.

1.1 First login

• Open the FE URL. Sign in with the trainer-provided credentials.
• Land on dashboard / DefaultPath of your role.
• Record your role from the top right.

1.2 Walk the modules

• Click each module group: Reservation, Operations, Approval, Payments, Accounts, UM.
• Sub-menus expand. Try the standard inbox page (Operations → Booking Inbox).

1.3 Standard page anatomy

• Open Reservation → Customer Registration. Identify: header toolbar, filter strip, grid, action column.

Self-check

• Q1.1  What does the SignalR connection do for the inbox pages?
• Q1.2  Where is your role's DefaultPath stored?
• Q1.3  If a sub-menu is hidden, which UM table is most likely missing a row?

Onboard one direct customer and one agent — both will book in subsequent labs.

2.1 Add a Customer (B2C)

• Open Reservation → Customer Registration. Add:

  • Name: Sarah Khan
  • Type: Individual
  • Country: UAE
  • Currency: AED
  • Reference Type: Walk-in
  • Phone: 050-2345678 · Email: sarah.khan@example.com
• Add Billing Info — Sheikh Zayed Rd, TRN TRN-S-100.
• Record Customer Code.

2.2 Add an Agent (B2B)

• Open Reservation → Agent Dictionary. Add:

  • Agent: Aman Travel Corp
  • Country: UAE · Currency: AED
  • Commission %: 10
  • Credit Limit: 50,000
  • Payment Terms: Net 30
  • TRN: TRN-A-200
• Record Agent Code.

Self-check

• Q2.1  What's the difference between a Customer and an Agent in pricing terms?
• Q2.2  A walk-in customer with no formal master row — where does their data go?
• Q2.3  What does Net 30 mean for the Agent's downstream invoice?

Book Sarah Khan into a Goa hotel for 4 nights. Map her guest profile to a specific room.

3.1 Create a PackageBooking shell

• Open Reservation → Package Booking → New. Customer = Sarah Khan; Booking Type = Individual.
• Record Booking Ref (e.g. PB-2026-0001).

3.2 Add Guest Info

• Add Sarah as a Guest. Passport K-1234567, expiry 2030-12-31, Adult.

3.3 Add Hotel Booking line

• In the package, switch to the Hotel tab. Pick Hotel = Goa Sea Resort; Room Type = Deluxe; Meal Plan = HB.
• Check-in 2026-08-15 · Check-out 2026-08-19 (4 nights).
• NetRate per night = 800 USD; Markup = 15%.

3.4 Map the guest to a room

• Open Guest Hotel Booking Details. Map Sarah → Room 1.
• Total = 4 × 800 × 1.15 = 3,680 USD; converted to AED at today's rate.

3.5 Save

• Save the package. Status moves to Saved.

Self-check

• Q3.1  What table actually links a Guest to a Room?
• Q3.2  Why was NetRate entered first?
• Q3.3  If passport expires before travel + 6 months, what does the system do?

Add a 4-segment round-trip from DXB to Goa via BOM, business class for the return.

4.1 Add the flight booking

• Open the package PB-2026-0001; switch to the Flight tab. Click Add Flight.

4.2 Add 4 segments

4.3 Per-segment rates

• Enter NetRate per segment. Markup 5%.
• Header total = sum of segments.

Self-check

• Q4.1  How are multiple segments stored? One row each, or a single row?
• Q4.2  A booking has 2 EK segments and 2 AI segments — does that need two FlightBooking headers, or one?

Add a Goa beach tour and pickup/drop transfers to the same package.

5.1 Tour booking

• Tour tab → Add. Tour name Goa Beach Day; date 2026-08-17; rate 80 USD/pax.
• Itinerary lines: Pickup 09:00, Calangute 10:00, Lunch 13:00, Anjuna 15:00, Return 18:00.
• Map Sarah as Guest Tour Booking → Yes.

5.2 Transfer — arrival

• Transfer tab → Add. Trip Type: Arrival. From: GOI Airport. To: Goa Sea Resort. Vehicle: Sedan; Pax 1.

5.3 Transfer — departure

• Add another row. Trip Type: Departure. From: Goa Sea Resort. To: GOI Airport. Sedan, 1 pax.

Self-check

• Q5.1  Why is a Tour stored separately from Hotel even though they're often booked together?
• Q5.2  What's the difference between a Round-trip transfer and two one-way transfers?

For an Aman Travel Corp group package, raise a 4-pax India tourist visa request.

6.1 New package for the agent

• New PackageBooking. Customer = Aman Travel Corp (agent). Type = Group.
• Record Booking Ref (e.g. PB-2026-0002).

6.2 Add 4 guests

6.3 Visa Request

• Visa tab → Add. Destination: India. Visa Type: Tourist (90-day).
• Add per-applicant detail rows for all 4 passports.
• Total = 4 × visa rate (excluding the infant if your config says so — check with trainer).

Self-check

• Q6.1  What table holds per-applicant visa rows?
• Q6.2  If passport K-202 expires in 4 months but travel is in 5 months, what does the system show?

For Aman Travel's family of 4 to Goa: hotel + flights + tour + visa + transfers — a full package.

7.1 Continue PB-2026-0002

You already have visa lines. Now add Hotel, Flight, Tour, Transfer.

7.2 Hotel — 7 nights, 2 rooms

• Goa Sea Resort, 2 Deluxe rooms, 2026-08-15 → 2026-08-22. Map Ahmed+Fatima → Room 1; Omar+Layla → Room 2.

7.3 Flights — 4 pax

• DXB→BOM→GOI on 08-15 (Y class); GOI→BOM→DXB on 08-22 (Y class). 4 pax each segment.

7.4 Tour — 2 days

• Goa Beach Day (08-17) + Old Goa Heritage Day (08-19). All 4 guests on both.

7.5 Transfers — arrival + inter-city + departure

• Arrival GOI Airport → Hotel; SUV.
• Inter-city Hotel → Old Goa → Hotel on 08-19; SUV.
• Departure Hotel → GOI Airport; SUV.

7.6 Save and review

• Package summary shows totals per service. Status = Saved.

Self-check

• Q7.1  What 5 link rows are in PackageBookingDetails for this booking?
• Q7.2  Does the system enforce that flight dates align with hotel dates?
• Q7.3  What's the total Net for the package (sum of NetRates × quantities)?

Submit the saved package; verify it appears in the Operations Inbox.

8.1 Submit

• From the package, click Submit. Status flips to Indented.
• SP BookingRequestIntend_Auto_Insert creates a row in BookingRequestIntend.

8.2 Confirm in Operations Inbox

• Open Operations → Booking Inbox. The booking appears.
• Note the service-mix flags (Hotel ✓ Flight ✓ Tour ✓ Visa ✓ Transfer ✓).

Self-check

• Q8.1  What two SPs together create the inbox row?
• Q8.2  If submit fails halfway, what state is the package left in?

As Operations, open the indent for PB-2026-0002. Walk every service tab.

9.1 Open the indent

• From Operations → Booking Inbox, click PB-2026-0002.

9.2 Each tab

• Hotel tab: 2 rooms × 7 nights, meal plan HB, NetRate per night.
• Flight tab: 4 segments, 4 pax each.
• Tour tab: 2 tour days, 4 pax.
• Visa tab: 4 applicants, India tourist 90-day.
• Transfer tab: 3 legs, all SUV, 4 pax.

9.3 Adjust hotel daily pricing

• Open IndentViewer_DailyHotelPricing. For 08-17 (peak weekend), bump rate +20%.
• Hotel total recomputes.

Self-check

• Q9.1  Which 5 SPs feed the 5 service-tab views?
• Q9.2  Why is the indent read-only on most fields but editable on rates?

Move PB-2026-0002 to the Quotation Desk, set commissions, submit to Approval.

10.1 Move to Quotation Desk

• From the indent, click Move to Quotation Desk.
• A row is added to QuotationDesk; status flips to In-Prep.

10.2 Set per-line commissions

• Open the desk for PB-2026-0002. For each service line, set Commission % (Hotel 10, Flight 5, Tour 15, Visa 10, Transfer 12).
• SellRate auto-computes per line.
• Record the total Net, Commission, Sell.

10.3 Add a remark

• In Remarks: "Family group; agent commission 10% applied; flexible on hotel category if needed."

10.4 Move to Approval

• Click Move to Approval.
• SP MovToQuotation_Insert writes a QuotationList row with status Ready for Proforma.

Self-check

• Q10.1  What is the difference between Markup and Commission?
• Q10.2  The desk shows an edit count per line — what's it for?
• Q10.3  What table tracks the turnaround time?

Switch role to Approver. Pick PB-2026-0002 from the inbox, generate the Proforma, send and chase up.

11.1 Approval Inbox

• Open Approval → Inbox. PB-2026-0002 appears with status Ready for Proforma.

11.2 Generate Proforma

• Click the row → Move to Proforma. SP Prepare_MovToProformaInvoice_Insert fires.
• A ProformaInvoice row exists. Status Draft.
• Record Proforma No.

11.3 Generate PDF & Send

• Click Generate PDF → Send. Status flips to Sent.

11.4 Chase-up

• Open Approval → Proforma Chase Up. Add a chase-up note: "Called Aman Travel; awaiting confirmation.". Status: Reminded.
• Two days later, mark Accepted (simulate customer confirmation).
• Generate-Customer-Invoice button is now enabled.

Self-check

• Q11.1  Why is the Proforma not posted to Accounts?
• Q11.2  What SP modifies the Proforma's status?
• Q11.3  A Proforma is sent on day 0; auto-expiry is what day?

Generate the legal invoice from the accepted proforma; record a part-payment; close the rest later.

12.1 Generate Customer Invoice

• Open Payments → Approved Proforma Inbox. Click Generate Invoice on PB-2026-0002.
• SP PaymentsInbox_GenerateInvoice_InvoiceList_Insert creates the invoice + lines + tax in one transaction.
• Record Invoice No.

12.2 Upload signed PDF

• Open the invoice → File Upload. Attach a (mock) signed PDF.

12.3 Record a 50% advance

• Open Payments → Process Invoice Payment Collection. Pick the invoice. Mode: Bank Transfer; Amount: 50% of total; Reference: BANK-TRX-9921.
• InvoiceList.Status flips to Partly Paid. SP Payments_AccountsGateWay_Customer_Insert fires; a row appears in the Gateway queue.

12.4 Settle the balance

• A few days later: another payment row, the remaining 50%, Mode = Bank.
• Status = Paid. Two Gateway candidates exist for this booking.

Self-check

• Q12.1  What stops you from generating the invoice before proforma is Accepted?
• Q12.2  Two payments → how many Gateway candidates are queued?
• Q12.3  Where is the PDF stored vs. its metadata?

The hotel's bill arrives — capture, line up, attach PDF, approve and pay.

13.1 Add a Supplier (if not seeded)

• Open Payments → Supplier. Add Goa Sea Resort Group if not present. Currency USD; Payment Terms Net 15.

13.2 Capture the voucher

• Open Payments → Process Vendor Voucher. Pick supplier; reference Booking PB-2026-0002.
• Add line: Hotel — 2 rooms × 7 nights × NetRate. Tax as per the supplier's invoice.
• Record Voucher No.

13.3 Attach PDF

• Use SupplierVoucherFileUpload to attach the supplier's PDF invoice.

13.4 Approve & Pay

• Approve the voucher (manager's role).
• Process payment — bank transfer to supplier.
• SP Payments_AccountsGateWay_Supplier_Insert fires; queued for Accounts to post as PV.

Self-check

• Q13.1  Why does the voucher need a Booking Ref link?
• Q13.2  If approval is rejected, what's the voucher's status?

As Accountant, post all candidates in the Gateway. Verify in Trial Balance and the Booking-to-GL drill.

14.1 Open Gateway

• Open Accounts → Accounts Gateway. You should see at least 3 candidates: 2 customer receipts (Lab 12) + 1 supplier payment (Lab 13).

14.2 Post each

• Click Post on the first customer receipt.
• Wrapped as RV: Bank Dr 50% / Hotel Revenue Cr / Flight Revenue Cr / Tour Revenue Cr / Visa Revenue Cr / Transfer Revenue Cr / VAT Output Cr.
• Repeat for the 2nd customer receipt and the supplier payment (PV).
• Record the 3 Transaction IDs.

14.3 Trial Balance

• Open Accounts → Reports → Trial Balance (today).
• Bank up by full customer payment, Hotel/Flight/Tour/Visa/Transfer Revenue up correspondingly, VAT Output up, Hotel Suppliers (control) up by supplier payable + paid out.

14.4 Booking-to-GL drill

• Open Accounts → Reports → Booking → GL. Filter by PB-2026-0002.
• All 3 transactions are listed with their detail lines.

Self-check

• Q14.1  Why does Hotel Revenue increase by only the SellRate × nights, not by the full payment?
• Q14.2  The supplier payment hits which two ledgers?
• Q14.3  What if you forget to post — does the customer-facing report still show "Paid"?

Run a fresh booking from enquiry through paid-and-posted, touching every module.

The scenario

A new corporate client, Crescent Logistics, asks for a 5-day Bali package for 6 staff. Hotel + Flights + 2 tours + visa + transfers. They want a quote in 2 hours and confirm same-day. Payment is 100% on confirmation. You walk it from new customer master through paid & ledger-posted.

Step list — keep notes!

• 09:00 — Add Customer Crescent Logistics with billing info, TRN.
• 09:15 — Add 6 Guests with passports.
• 09:30 — Build PackageBooking — Hotel (3 rooms × 5 nights, Bali Beach Resort), Flights (DXB↔DPS round-trip), 2 Tours, Visa-on-arrival × 6, 2 transfers (arrival + departure).
• 10:00 — Submit; appears in Operations Inbox.
• 10:15 — Operations: walk indent, verify hotel availability with supplier (mock).
• 10:30 — Operations: open Quotation Desk, set commissions, click Move to Approval.
• 10:45 — Approver: Generate Proforma, send PDF.
• 11:30 — Customer accepts. Approver clicks Accept → Generate Invoice button enables.
• 12:00 — Payments: Generate Customer Invoice (full), upload signed PDF, record full payment.
• 14:00 — Hotel sends bill same day. Capture Supplier Voucher, attach PDF, approve, pay.
• 16:00 — Open Gateway, post 1 customer receipt + 1 supplier payment.
• 16:30 — Trial Balance reflects: Bank Dr (full receipt), 5 revenue ledgers Cr, VAT Cr, Hotel COGS Dr, Bank Cr (supplier payment), Hotel Suppliers ledger zeroed (or balance due).

What you should have

• 1 new customer + 6 guests.
• 1 PackageBooking with 5-service mix.
• 1 quotation submitted, 1 proforma issued and accepted.
• 1 customer invoice fully paid.
• 1 supplier voucher captured, approved, paid.
• 2 Gateway transactions posted (RV + PV).

Self-check

• Q15.1  Where can you see the full audit trail of today's work for this booking?
• Q15.2  Net margin = Customer Sell − Supplier Cost. What ledgers reflect this?
• Q15.3  If the supplier had charged 200 USD more than the indent, where would you spot the discrepancy first?