Audit history is stored in AuditHistory table. Here's a simple query reflecting a change I made to vendor contact and address: The problem is that ...

Is that something specific to Serial Tracked items? Lot Tracked items always default zero on Allocations. For me personally I never rely on defaults,...

Some of those DACs aren't actual tables - the trick unfortunately is going to be to workout which of the audit DACs exist in the database. AuditFilter...

We are importing Purchase Receipts with Lot numbers and it's a lot simpler than that and doesn't assume/require a Purchase Order either. Lot/Serial Nb...

Do you have any active proxies, web filters etc. that could be interfering with the connection?

I have no issues with selecting one Tenant as the "main" tenant for customisation projects management. The issue I have here is that I want to copy a ...

You add Inventory Items to Sales Orders - there is no link between Sales Orders and Kit Assembly. Sorry but I can't recommend a solution as what you'r...

Thanks for the reply @shawn-slavin. I found the section in S100 you mentioned: So this basically means it's not possible to use Publish to Multiple T...

So I tried the Publish to Multiple - from our test tenant to our new tenant. In the process I managed to unpublish our main customisation project from...

Awesome. I am so tired of deleting those rows from GI exports.

I remember having an issue like this before where my totals were doubling, tripling or whatever due to a join of another table. I solved it by dividin...

Hey Tim, I have to do this all again thanks to a Partner mishap. I really don't want to clone the security manually again. Using your suggested method...

One additional comment about Relative field - according to the help, it is only applicable to Date fields.

Perhaps time to re-evaluate your business process. Make 1 copy as a PDF and email it a many times as you want. Save a tree in the process. 🙂

Well I guess your only solution is to upgrade.

Unfortunately appears to have nil effect as in my test runs when doing a Calc with Relative enabled on To Period, all periods get calculated. Which is...

The issue isn’t solved, it remains the way it is in the base product. Customising to address base product issues doesn’t solve anything. The issue is ...

Not really sure how explaining this to you will solve my problem, but in a nutshell, we need to have a filter on Bills to filter out our conversion da...

Should be able to do this with the Format setting.

And on the Consolidations (GL.10.30.00) help it says:

Well seeing as Consolidations is for Actuals Ledgers, you are out of luck there.

Hey Juriy, I really appreciate the effort you went to coding a customisation, but I'm really against customising to fix issues in base product. Plus I...

That's really great to hear that you got it working!

Correct! I have reported it to our partner but i don't fancy the chances of it filtering through to Acumatica.

Nice theory, but it is flawed. If that was the issue, then Quick Checks would also share filters with Bills and Adjustments and Checks and Payments, b...

Ok well that's exactly what's happening for me and it means I have to manually reconcile all assets when we convert our data. Really unhappy about thi...

Because your example is already reconciled - you need an asset with Unreconciled Amount <> zero. 😀 Yes, for me when clicking Selected, Selecte...

It doesn't matter new or existing assembly, you still need to locate the Stock Component record by Inventory ID (F15503, 15503-PICK) before updating t...

You need to do it the same way I did - in other words, locate the record you want to update first via Inventory ID, then do the update. Checkout the ...

When you do it manually, do you need to insert a record into the Stock Components tab or is it already there? The IS that I wrote was for adding alloc...

Modern UI is a step backwards. Just enable Classic UI on your profile.

Try this yourself, open a Released (or any) Journal and add a Note - do you see the Save button ungray? Regardless of released or not, Adding a Note t...

<Dialog Answer> always goes before the action that triggers the dialog. And you need a save at the end of the IS or it will always error.

Surely you just need a basic query of Customer Sales by date and sale amount (ie. Customer, Date, Sale Amount) then you use that with Power BI and ask...

Yes I got it working but it's quite different from what you are trying to achieve. As always, try doing your IS manually in the same order you defined...

Idea has been updated, disappointing response:

@juriy-zaletsky I fail to see how your post adds any value to this topic, which if you had read the whole topic should have seen had been fully resolv...

Whenever IS fails, try doing exactly the same thing manually on the page.

Exactly what i don't want to do - to create additional classes for every combination of depr. method and useful life (and gl accounts) is crazy. Anywa...

It's not possible to do the type of comparison you are attempting inside a formula. To see why, add the field CustomerID to your query results and mou...

If you setup your own office 365 account as a System Email account and used it for sending, then sent emails should be recorded in your office 365 acc...

As in, the 1st item listed here:

Kristi, just to confirm Tim's post, are you using a Free or Pro Power BI?

Maybe add a Blog so it's easy to find? Will be even better when a GI can be used as the source and then you just need to setup your criteria in the GI...

So for use on Dashboards, each user would need to sign up with Power BI under their own account and then i could configure whatever is needed in their...

Does it require a Power BI Pro subscription to use? I just signed up to Power BI and automatically MS enrolled me in a 60 day Power BI Trial.