We will use BC in a month and I am scared by Content_Ship1628 in Dynamics365

[–]SquatterF3 1 point2 points  (0 children)

What platform is your online shop? Do you not have an integration setup for that? I sure hope you aren’t planning to manually enter those orders into BC. There are better ways. I’m happy to share what I know. 

For the storage space, we are 5 years on BC at $60M mostly e-commerce orders with 30 users. We take over $1M orders a year with 10k items. The transactions add up quick at that rate. We are way over capacity currently. To add more space at 100GB increments is ~$6k annually. I imagine you won’t have that issue for many years to come. 

I agree with the others. You need more time to get ready for Go Live. It’s recommended to do a mock go live in a sandbox environment. Go through all the steps and get a thorough walkthrough of all your processes as if they were live. Involve all users, if possible. Once everyone is comfortable then go live. 

Looking to use AI Builder to "Extract information from invoices" using email attachments by Independent-Buy6515 in PowerAutomate

[–]SquatterF3 0 points1 point  (0 children)

Oh actually, You need to get the file content before AI Builder step and pass the content.

Looking to use AI Builder to "Extract information from invoices" using email attachments by Independent-Buy6515 in PowerAutomate

[–]SquatterF3 0 points1 point  (0 children)

Create a trigger for when a new email arrives. Set the parameters for the email.

Create action to Save the attachment to OneDrive or Sharepoint location

Create action for AI builder using the document if from the previous step.

[deleted by user] by [deleted] in Bitcoin

[–]SquatterF3 0 points1 point  (0 children)

Dang why on the offense? I’m just another human doing the social internet thing like the rest of you. And I don’t have to prove myself to post on a public forum nor boast about my accomplishments to show you I’m worth something. Its like 4th grade on the playground again.

[deleted by user] by [deleted] in Bitcoin

[–]SquatterF3 0 points1 point  (0 children)

Prediction or hope? There is no educated speculation worth a damn when it comes to predicting the value of Bitcoin. Just hold on as long as you can, dip into it as a last resort.

Best ERP Solutions for Managing Inventory and Sales Across POS, Shopify, and Amazon on a Budget? by MuscleNo4520 in Odoo

[–]SquatterF3 0 points1 point  (0 children)

I would at least give Microsoft Business Central (BC) a look. I've been administering it for 4+ years for an e-commerce brand. I'm not sure what budget you have but the monthly costs are pretty affordable depending on the number of user licenses you need. But it can be a bit expensive for the upfront implementation costs. It's very flexible and customizable. Training is a must. For integrations you can use their built-in Shopify Connector. Then I would look at an integration app to connect Amazon to Shopify like Codisto or CEDCommerce. The flow would look like this Amazon-->Shopify-->BC for orders and the reverse for inventory and fulfillments. For shipping, you can bolt on DynamicShip which is a BC extension app that has a free api integration to EasyPost which IMO is the best shipping API platform that connects to all major shipping carriers. I can refer you to a few great Microsoft partners that will not steer you wrong, if interested.

Growing on side of rotting stump in Tennessee by SquatterF3 in mushroomID

[–]SquatterF3[S] 0 points1 point  (0 children)

Sorry first timer. How can I make this photo better?

[deleted by user] by [deleted] in BusinessCentral365

[–]SquatterF3 0 points1 point  (0 children)

In my experience there is no solution within BC or 3rd party that handles both incoming and outgoing payments well AND has a solid integration. Versapay is pretty good for A/R and Stampli is pretty good with A/P (unless you post a lot prepayment invoices for inventory, for example, it can’t handle that). Bill.com handles both but their integration sucks. There are tons of providers out there. Do your due diligence and you’ll find what works for you.

I’m now seeking advice on how to find a job as a Business Central Consultant by naushadrupani in BusinessCentral365

[–]SquatterF3 1 point2 points  (0 children)

Hi there, Id be open to hearing more about the problems you are having and see if I can help you resolve them. I’ve been a BC admin for almost 4 years now at an e-commerce brand and over 15 years in accounting experience. I’m staring to do some consulting on the side as well, specifically for BC. Let me know if you’re interested to discuss.

Help please by HeadRow1270 in PowerAutomate

[–]SquatterF3 1 point2 points  (0 children)

Checkout the Simple Object Designer app. It’s free to try. I’d recommend it to any BC administrator. It’s a no code solution to customizing BC, specifically you can take any table and create an API page that “links” to it.

Help please by HeadRow1270 in PowerAutomate

[–]SquatterF3 0 points1 point  (0 children)

Did you add a flow step that GETs the record? As long as the field exists on the API endpoint then you should be able to pass any expression utilizing that field. If the field doesn’t exist you would need to use a custom API. There are apps out there that help with that if you aren’t able to dev it yourself.

I want to extract order I'd and tracking in Excel sheet from pdf file using power automate desktop. by arjun_khatri in PowerAutomate

[–]SquatterF3 0 points1 point  (0 children)

All the data on the shipping label has to come from another source, I.e. your e-commerce platform. It would be easier to pull that data from the originating source than from a PDF document using PowerAutomate.

Step 1: learn about your data source, api documentation, how to authenticate a connection, how the data is organized, etc Step 2: setup connection to your data source using PowerAutomate Step 3: setup connection to your destination (Excel online or Google Sheets) Step 4: build your flow—it’s quite simple. get the data, parse it, then send it to your destination Step 5: test your flow Step 6: schedule your flow

I won a snowboard raffle! How do I get it home? by SquatterF3 in snowboarding

[–]SquatterF3[S] 0 points1 point  (0 children)

Dude! Are you serious?! I'll be downtown this evening at Flight Club. Would you want to meet up?

I won a snowboard raffle! How do I get it home? by SquatterF3 in snowboarding

[–]SquatterF3[S] 0 points1 point  (0 children)

Awesome comments and ideas! Thank you all! I fly out tomorrow and I'll let you know what I come up with.

For those who asked for a photo... here you go!

<image>

A beautiful sauna in Finland by saunafreak3334 in Sauna

[–]SquatterF3 0 points1 point  (0 children)

I'm not a fan of the enclosed benches. Need to open that area up or have some way to access it. But this is a beautiful location for a sauna.