How to set up your BrewNinja Account and to use the DSWR for your weekly LDB submission.
Prerequisites
Your company is in British Columbia.
Getting there
Overview
You can use BrewNinja's DSWR export and directly upload it in to your BCLDB Portal for all the sales reported for the week. This way you don't have to create individual doc 60's for each sale.
Report Breakdown
| REPORT COLUMN | BREWNINJA DATA |
| Store Number | Warehouse Number |
| Transaction Type | Sale or Refund |
|
Transaction Date |
Completed Date of Sales Order |
| Invoice Reference Number | Sales Order Number |
| Original Invoice Number | Manual input - Applicable to refunds only - The original invoice that the refund was from |
| Customer_Number | Business Partner Licensee Number |
| Customer_Type | Business Partner Category ( LIC / LRS / MOS etc) See LDB Site for more information |
| Payment_Method | Manual Input - Left blank to indicate cash payment. |
| SKU | Product Sku - Licensed Product Code |
| Quantity | Quantity Per Sku on Sales Order |
| Price | Price per Line Item |
| Container Deposit | Deposit per Line Item |
| Total Doc Amount | Total Price of Sale |
| Return Reason Code | Manual Input |
Quick Setup Tips
- Make sure all customer files have the correct Customer Type in Business Partner Category. To adjust BrewNinja Category list, head to Setup--> Categories --> Business Partners.
- BrewNinja comes preloaded with LIC, LRS, MOS Categories.
- Ensure all registered Product Skus have Licensed Product Code filled in.
- Ensure Warehouses have your Store Number included.
- When performing a Taproom Transfer to be included into the DSWR, make sure to select Create Sales Order.
Helpful Links
https://www.bcldb.com/doing-business-ldb/direct-sales-reporting