I dont know of a way out of the box, but you can use a business event to trigger an import scenario that will accomplish this. If you create an idea, ...

Yes, unfortunately for us it was backwards as well. Good luck with the upgrade.

Acumatica suggested i create an idea. Please vote if you think it can be useful!

They wanted to remove the financial aspect form what was supposed to be a warehouse document. (Page 89 - ). Personally, we suffered very much from t...

@DavidEichner Were you able to figure out a solution for this?

The "@@" does not seem to work in this case. I don't know why, but I achieved this through hard coding the line number of the desired payment method .

@chris Are you referring to AR203500? I do not see an option for configuring a schedule to pay the total open AR amount ( whatever it may be each mont...

Ah that is too bad. But yes, looks like you got the right idea.

This one is a bit tricky. You need to use @@ to define the record you are looking to change, but if you use @@LocationID it will not work because that...

I did mean Fields. Although of course you need parameters as well. Ill share relevant screenshots of a working notifications which sends out the SOinv...

In case you haven't figured it out. We had a similar issue and Acumatica support told me to remove every field on the fields tab except what was actua...

I made sure of that and tried it on inventory ID This is my current scenario:

Tried that. It creates a new po receipt line for each of the allocation lines instead of going into the @@Inventory ID and splitting the qty in alloca...

@royce-lithgo Were you ever successful importing allocation lines to an existing PO receipt? I am trying to modify existing PO receipts which t have ...

Thanks. We have information that needs to be in the body of email.

Thanks for the tips. For us, each branch uses different carrier and has different shipping ETA and other unique terms which is all in the body of the ...

@royce-lithgo, have you used branches as a condition in Automation notifications? I did not see that option and had to use currency as a condition whi...

Yes. We use automation notifications with a condition that the invoice is released.

Very helpful post. Thank you!

I don't know if there are any more 'special' ones, but other number will correspond to actual line numbers. On the target document.

In these cases I resort to combining queries in Excel via Odata. GI is inadequate here. I think they were talking about allowing use of GIs as tables...

Voted

Can you upload both examples?

We use an export scenario to export data on schedule to an FTP location, then import scenarios on schedule to bring the exported data as transactions ...

If you can't figure out the joins, you can always use subreports to get non-joined data.

Good luck!

Who knew! This is very helpful. I have also noticed that the report designer allows more characters than what the report version screen displays, so i...

I have been running this on schedule daily for months ( as well as reindexing for the global which seems to get massed up every time a large operation...

Hi, In our case, the Thermal Printer Batch File wouldn't work, since we are printing out the label as an image on a report with other information. So ...

Has anyone figured our how to add a dynamic date filter ( @ monthsstart for example )? i left the date parameters blank and it populates the default ...

Some points that might explain it, or at least narrow down what the cause of the issue is hereb Are users receiving Inventory with an Inventory rece...

Got it.You can also edit the report to have an empty main report with the same sub report called twice.

Just print 2 copies in the browser print screen?

Looks like a grouping issue. If you attach a screen shot of each tab in the GI setting or the xml file there is more chance that people can help you.

what error are you getting ? what version are you on? i believe the ExtCost field was removed in 2018R2.

If you are looking to get just total sales by createdById then you do not need to add the line item(soline in your example) Also, you should use the ...

You can use the Hour() & minute () functions. Yes agreed, it would be nice it the local time zone was taken into consideration. Had an issue with...

I wonder if the new enhancement in 2018R2 would affect this you issue. "AC-113845: The Acumatica Report Designer export algorithm has been enhanced to...

Holding the cntrl button while clicking should help. Doesn't answer your question technically, but hopefully solves the problem.

I hit reply to @timrodman when asking what was anticipated. sorry for the confusion. now i know to use quote instead of reply if i am responding to an...

Was just about to post that solution! There were 2 issue with the original formula.: 1. As you mentioned, i couldn't use the Id from Artran. so i join...

correct mycustomer is the customer ID, not the description or a parameter.

oh interesting Which of the failed examples are you suggesting this for? I tried that in all 3 and i get "Error: A field with the name Mycustomer ...

Adding on to the original question: Can i aggregate with an If condition? Example: To get the Qty sold of each item i use the ARTran table, group by I...

As in, it is more simple than anticipated?

Not sure how that happened... thanks for pointing that out. I don't see an option to edit the old post anymore, so here is the correct screensho...

Finally heard back. You setup a key field to let the system know which line to delete ( '@@FiledName' accomplishes this) Then on the next line, ...

😮 Good luck!