Try building a GI for looking at the data. Note that only those customers with the class where you setup the Attribute will have a value for the Attri...

Found the glitch - removed the Query from the UI and added it back again and the issue resolved.

I fixed the performance issue. Now it runs sub-second but this message still remains. What's more messed up is the same query exists in both of our te...

I understood the requirement to be if there is a Discount on the page, then show the header but if no lines on the page have a discount then don't sho...

Sorry for saying but this requirement seems like an exercise in futility. If it were me I would make the column header static, and potentially show 0%...

Hi Lisa, you're welcome. I hope it works as it was only my theory. And yes, you can leave Workgroup blank.

Off the top of my head, try using "Employee from Document" for the 1st field, and "Reports to" from Employee table for the 2nd. Should look like th...

Only Power BI can refresh Power BI - you should try asking this question on the Power BI forum:/p>

Yes we used to have that problem but it was resolved for us by MYOB release (2020.3) - sorry not sure what Acumatica release that equates to. Anywa...

Good news. Wonder if this works when you use aggregates and groups.

No worries at all. Glad to have helped out.

You can't use Parameters with OData:/p> You need to design the Query to not rely on Parameters. Your current conditions will return no data if the p...

@richard We've been struggling with PO Receipts ever since they did this. So far no clear solution. I modified the PO Receipt report to put some amoun...

I can answer my own question now. Didnt have any luck with @Today, but it worked with =Today(). So formulas can be used in the Value columns of Filter...

My view so far of the other forum is people aren't as friendly or appreciative of the assistance received.

We talking Notification Templates? You'd need to check the HTML view to make sure there's no unneeded breaks. Perhaps paste the HTML if it's not too l...

@timrodman Thanks for that info. It will be good to be able to enter updated units costs on PO Receipts (again).

Tell the user to use Edge! 😉 Seriously, you need to stop using Internet Explorer. It's junk.

You can't. Set them up in a test tenant and verify before doing so in production. You can try voting here but it doesn't seem to be going anywhere. ...

If it were me, I'd edit the particular report and display DRAFT or whatever over the output if Hold is enabled. That would be the simplest to imple...

I got this to work with Payment Method ID specificed in the file.

Perhaps this is the issue?

Sorry @daniel but I've never used it. Have you tried reporting this to your MYOB Advanced Partner?

You'd need to do one edit manually first to confirm that the outcome is what you expected. For example, after changing the Inventory ID, some other co...

This is covered in the Integration Scenarios training on Open Uni. Specifically Example 2.5.2 (page 91) - Updating Detail Lines by Line Number (A...

What are you trying to import? I am not familiar with the "Create Matrix Items" process.

I think you're comparing transactional reports vs Ledger based ARM reports. You could write reports using Report Designer and build a suitable query t...

You'd need to setup an Actuals ledger with a daily calendar, in other words, a calendar where each period is one day only. This is a common requiremen...

You should be using the date fields that are on MasterFinPeriod, either StartDate (1st day of period) or FinDate (last day of period).

@charlescrf You'd need to create an Import Scenario to do it. Write a GI to export all the POs you want to update and then write an Import Scenario to...

@charlescrf That's really strange - the key for the PO is Order Type and Order Nbr and they look correct in your data. I can only suggest trying the d...

@kikitravel That's really strange indeed. Check that report above what is assigned for the Style property on the various fields in the report. I used ...

@charlescrf I just noticed a bug in your import scenario: The field should be OrderNbr not OrderType.

Unfortunately I don't think this is possible. It looks like the Report Style property "Back Color" is applied to the Cell's Fill Color and an empty va...

@jswartz The formula will only be applied during the actual import - so when you prepare it, you will see the entire value as one column but when you ...

@charlescrf Is it possible it's the OrderType that has an issue? What values do you have in 'PO Type'? I would check all field values from the input f...

Perhaps a screenshot of your import scenario might help.

We can't do that due to seperation of concerns - receipts are upon delivery by Purchaser, Bills are by AP Clerk. AP Clerk cannot modify receipts, only...

@jswartz You need to include a header record in your input file. Use the word "Data" for the record. example: DataABC123DEFABC456GHJ In my test ...

@jswartz As i said in my comment, import as one long string and extract the data in the import scenario. The schema would have a single field of type ...

You need to find the page ScanJobInfoMaint and grant access to it. It will likely be in a Hidden folder. I've never heard of that functionality so I...

Fixed: user profile had some corruption - fixed by deleting and recreating user.

It was there in 2019.1. They need to revert PO Receipts, they're a mess now. We are still struggling with the 2019.1 upgrade.

Glad to see all the support this idea has received. Thanks for your contribution @eric-velkly2. We're at 21 votes now!

This problem has been bugging me for ages. Previously I'd written some nasty GIs with complicated criteria to do matching on ranges of subaccounts. Wh...

Really nice solution @wyatt-erp. I didn't even know Attributes existed.