Hi - We are in AB so have to utilize the AGLC integration for Keg deposits. We set up the deposit scheme for each product, however there is no ACTUAL deposit/return functionality built into this?!?! According to support, this all has to be done manually??
Here’s what I sent and what is needed:
We are using the AGLC work around for keg deposit “schemes” and it doesn’t seem to be working…Currently when we invoice keg purchases, the invoice is not showing the keg deposit amount (and it should break it out, similar to how the bottle deposits/recycling is broken out on can purchases).
More importantly, when kegs are RETURNED in the system, there should be keg CREDITS applied to the account/customer that we can then apply to future invoices.
I also don’t see where we can apply these credits to future invoices…I want/need to have control on how much of these credits to apply on any particular invoice.
These keg deposits should NOT be recorded as revenue on the initial invoice - they are a liability - and likewise when the kegs are returned, it goes against the liability.
Currently, I have to (figure out how to):
Create manual journal entries for EVERY keg we sell that will properly allocate the keg deposit to the liability account
Create a manual credit note for each keg returned
Ensure that the “credit note” is also syncing correctly to this liability account.
Hope that I can allocate these credit notes properly!?
Please help…this is a guaranteed issue and something will get lost
HI Cassandra - no real “solution” unfortunately. just the manual work arounds noted above. It kind of sucks, and I’m sure there will be issues and things missed along the way.
**Note we can’t use the keg scheme built into Breww b/c we’re in Alberta and have to use the AGLC integration which isn’t fully functional for these things. If you’re not in Alberta, then you won’t have an issue.
We’re in Alberta and making a credit for the keg deposits and adding it to the invoice but the invoice not reflecting the updated value is proving to be an issue for us as we take calls and sending a customer an invoice without the correct value they need to pay for AGLC is hard to explain.
We haven’t done an upload yet either so I’ll have to see how that looks with using credits since upload using K for keg credits not C for credits.
Replying for adding features required for AGLC for developers plz as per a convo with Connor
PDF invoice needs to have updated value when a credit is applied this currently isn’t a feature so when we send an invoice to a customer how are they supposed to know what the correct account to pay is. The process for order payment is confusing for AB.
Keg Credits need to appear on invoices and also be aware they are uploaded differently than a credit invoice**
Keg tracking scheme for AGLC probably needs to be looked at for deposits and credits
Not needed but a ship date column in the sales area would be awesome but we can work without it.
I did help to create the upload file with Beer30 so I know the process really well if you have questions or concerns.
Also to add that in the QBO (accounting) integrations, these keg deposits/credit should NOT be recorded as revenue, but as liabilities.
I TOTALLY second the updated invoice when credits are applied…this is an issue, especially b/c the “customer statement” only shows the “invoice price” owing, not what the customer ACTUALLY owes us.
Do you mean the Connect Weekly Sales by Licensee? If so, yes. It was frustrating the first few times but here’s my tips:
Make sure your pricing is updated/correct - LTO’s can be a pain and mess this up
When you upload the .csv for the weekly sales from connect, I ALWAYS upload a copy of the licensee master list - this ensures that if there is a new vendor that’s purchased through connect, they will get added (vs. giving you an error and having to redo)
Date should be the weekly sales report date - but NOTE THAT the delivery date will get marked as today (grrr). I’ll be putting in a feature request to have the delivery date marked as the invoice/payment date that we enter, but its not something that will happen ATM
Finally, while the deliveries are marked COMPLETE, they are not marked paid, so you’ll need to go into every invoice that sync’s to your accounting system, and mark them paid so that it clears them in Breww
Oh and sorry - if you mean upload our direct delivery sales to AGLC (LSA), no I don’t use that feature. I got too frustrated with errors when I first started and I haven’t gone back. I just enter invoices in LSA manually using the PDF invoice in Breww. Its a handy source for all the licencee numbers and product codes, and well, is the only place we can see if the amount invoiced to the customer is correct
Thanks for the Connect tips I have been putting off that transition because I wanted to focus on LSA stuff first so that’s a next week thing.
LSA upload file was run today we had some errors yesterday since we tried making keg credits into credit memos which doesn’t work most likely because credits require a previous invoice to be attached.
LSA dates were good (so far), I was worried it was running by invoiced dates which wouldn’t work with price change schedules and I manually added the keg credits into the file, it appeared to work just fine. I will report back with the payment next week.
ALSO Tanya if you need any assistance on the upload file I’ve been running it for 5 years I know a good chunk about how it runs and how it works with AGLC, I’d be happy to throw any tips out there for you. Hopefully I didn’t jinx myself. I’m at Village by the way.
We’re going to start looking into this very soon. Thanks for the useful discussion here! Once we get into the detailed plan of how to build this feature, I’m sure there will be some questions on how you’d like it to work, so I’ll post them here.
Also, @tanya-tucker, you mentioned about marking imported sales as paid. There is a relatively new setting that you can turn on to automatically import orders as paid.
If you head to your ALGC integration page in Breww and click the Update Settings button in the top right, you should see it. I hope this helps.
Welcome back keg credits and deposits are a big issue for us, we’re getting a ton of questions about it and its starting to worry me a bit. I’d love to chat when you’re all settled.
Yes - the manual credits aren’t even working The invoice isn’t getting updated when a credit is applied - even when the credit is applied before the invoice is issued
for the upload you can’t do a manual credit because it needs to be tied to an original invoice. Keg credits are done as no SKU and a K instead of an S or C.
Hey Cass, I’ve got a good idea of how I think it will work and made some progress getting it going which I can show you. It would be great to run you through this to double-check it will work correctly. I’ll send you a direct message to organise a call.
The invoice isn’t getting updated when a credit is applied - even when the credit is applied before the invoice is issued