A record of SQL queries and Crystal Report layouts developed for SAP Business One, covering account ledgers, check life cycles, purchasing workflow, batch tracking, and printable business documents.
SAP Business One queries developed for reporting and analysis.
Account transactions with running balances.
Open orders with batch status, allocated quantities, and stock on hand.
Purchase requests through quotations to orders, with status and delay in days.
Batch numbers, quantities, and availability by item and warehouse.
Full lifecycle of incoming checks.
Full lifecycle of outgoing checks.
Total money moved per customer or vendor.
Drafts versus final invoices and approval status.
Document counts by type and their share.
Historical item prices with percentage changes over time.
Report layouts created for SAP Business One business documents.
Printable sales invoice form.
Printable accounting entry form.
Printed check slip with converted date and amount in words.
Printable check payment confirmation.