Solved

I want to populate  [AMBatch.BatNbr] as the report parameter. I have added the parameter in the schema but nothing is showing up on the report screen. Report Designer Setup for the ParameterThis is how I see this empty selector.  Report screenAny leads will appriciated.Thanks​​​​​​​

Hi. We are using Acumatica for time capture and payroll processing.When users are entering time, they should only be selecting cost codes that have Labor account groups setup for them in the cost budget. Right now, Acumatica will allow them to see and select all of the projects cost codes.To bypass this, we’ve created TASKS that only have Labor account group cost codes in it - then setting this to default task.The problem with that is there are multiple areas in Acumatica that the task then defaults to our Labor only task - so accounting has to change this each time.Would be ideal if there was a way for only certain account groups to be selected and seen at the time entry screen.

I’m currently using Acumatica 2023 R1. When I upload a vendor price worksheet with multiple lines, only the last line shows up. No issues with the sales price worksheet though.Has anyone had a similar issue and/or have a fix?Thanks!

Here is my scenario.I have a table that has a range of zip codes.  If the left 3 characters of the Ship Address zip code fall in the range of “lower” and “higher” I want to select that record.Example:Ship Address Zip is 100234.In my lookup table, the lower is 100 and the upper is 130.So the left 3 digits of the zip (100) falls in the range.In my BQL statement, I do not see a way to do an IsGreaterEqual using the string value.  It causes errors.This is what I want to do:ICSFSSScheduleLine item = SelectFrom<ICSFSSScheduleLine>    .InnerJoin<ICSFSSSchedule>    .On<ICSFSSSchedule.scheduleID.IsEqual<ICSFSSScheduleLine.scheduleID>>    .Where<ICSFSSScheduleLine.scheduleID.IsEqual<@P.AsString>    .And<ICSFSSScheduleLine.lower.IsGreaterEqual<@P.AsString>>    .And<ICSFSSScheduleLine.upper.IsLessEqual<@P.AsString>>    .And<ICSFSSSchedule.active.IsEqual<True>>>    .OrderBy<Asc<ICSFSSScheduleLine.lower>,     Asc<ICS

Hello, Is it possible to create an entity mapping for the Shopify store connector to create orders with different order types depending on certain criteria as it comes over from Shopify? I have the Shopify store set up with a default order type (WB), and then we also use the POS side. This has two order types for in store and ship to customer orders already set up.  However, we are starting to use other sales channels in our Shopify store and we don’t want all those orders from Shopify admin, online store, and other channels to ALL come through with the same order type. I’ve tried creating several different entity mappings to follow some logic with NO luck.    Any advice would be greatly appreciated!Thanks!

((BusinessAccountGraphBase<Customer, Customer, Where<PX.Objects.CR.BAccount.type, Equal<BAccountType.customerType>, Or<PX.Objects.CR.BAccount.type, Equal<BAccountType.combinedType>>>>) graph).BAccount.Insert(m); BusinessAccountGraphBase is missing and so how to find code that equal above 

Hi All, I want to set up the required input project if the warehouse is "PENDING."I set it up like below, but it's not working; even if the field Project is marked with an asterisk or star, the system still allows it to save.Please advise where I am wrong  

Our customer banks with CIBC (Canada). We were successful at adding MX and landing on the login screen that asks for card no. and password. There is also a link to the institution’s website. The issue at hand is 1) the customer uses an account no., a personal PIN no., and a token that updates once a minute, and 2) the customer uses a business portal that is different from the mapped institution’s website. What should we do with their setup?  

Is there a dashboard or report that shows our users time active in Acumatica?  For example, it would show the number of hours the users are in Acumatica by day, week or month. 

Hello all,I have been trying to revoke the RELEASE access right/button from the Reconciliation Statements form for the role of CA Clerk, but it is not getting implemented.What is it that I am missing?

I have an open payment for a Sales Order in Acumatica.  Currently, Applied To Order is set to 0.00 for the payment attached to the order.  I would like to change this value to the unpaid balance.  I can easily do this in SOAP.  For REST, I am using the following URL in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/Payment However, I am constantly getting the following error:"Inserting  'AR Payment' record raised at least one error. Please review the errors.; ARAccountID: 'AR Account' cannot be empty.; ARSubID: 'AR Subaccount' cannot be empty." Here’s is the body I’m passing:{        "ReferenceNbr": { "value": "598089" },        "PaymentRef": {"value": "5006956/4/23/2024 8:18:10 AM" },        "AppliedToOrder": {"value": 200.00},        "CashAccount": {"value": "01010"},        "PaymentAmount": {"value": 200.00},        "PaymentMethod": {"value": "CASH"}}

Can you merge duplicate items into one item number?The intent is to preserve the history of both items in one (These items should have always been one) Quantities of both items should be summed together into 1 fieldMerging of duplicate entries can already be done in Acumatica for Business Accounts and Customers, I am looking for largely the same thing for items.Can this be done?

Can you merge duplicate items into one item number?The intent is to preserve the history of both items in one (These items should have always been one) Quantities of both items should be summed together into 1 fieldMerging of duplicate entries can already be done in Acumatica for Business Accounts and Customers, I am looking for largely the same thing for items.I posted this in the wrong forum earlier.Can this be done?

We have individual SKUs that ship in more than one box.  In the Acumatica pick, pack, and ship process, the Acumatica workflow seems only to accommodate one box / one shipping label per SKU.  How can we print multiple shipping labels for a multiple-box SKU?  We do not have Acumatica WMS.  Your help is greatly appreciated. 

Hi Team,We have across an issue with SF sync where multiple SF Sync Record Id’s are being created for the same record. Highlighted row is the correct sync record id, but whenever automation schedule for User sync runs its adding additional sync record id’s for the same record. Any thoughts?

Hi,I am still struggling to find the right report in the system to show the project information. What I need is a report that show the budget amount and the actual amount by project task. I look through the report section in Project but nothing fit. What I am doing now is to copy the information from the revenue budget tab and cost budget tab under “Project” to Excel and create a report myself. Not sure I miss anything. Thank you.Regards,Raymond

Ok, this is a VERY new error on me.Doing some testing in my development server and I came across this error below in the screenshot I have never seen before, nor do I even know where the start to fix it.It showed up when I click “TEST” and the UID number changes every time I click TEST. Does anyone have any idea what to point me to, to resolve this?  

Hi,Although we grant full access to Manage Financial Periods screen to the user role, the unposted transactions cannot be viewed by the relevant role. This issue was come after the upgrade. Is there any solution to resolve this ?Thank you

Hi all, I am trying to update emails on the customer screen. On some customers I get this error: Account 19303 is a control account for AP. Please select an account configured as a control account for AR.I can see that the error customers has the 19303 account selected. So what am I missing?thxDries 

HelloIs it possible to use Related Items in the same way that you can on the Sales Order screen SO301000 with the Sales Quote screen CR304500.ThanksMatt

I have a client who wants a simple modification to the PO receipts workflow where upon successful release of the PO Receipt, they want the system to automatically print the PO Receipt form.Has anyone been successful in adding an “Auto Run” modification to RT workflow?  Based on what I see, we can only duplicate the Print Receipt on the toolbar after the receipt is released.

Hi all. Does anyone know how to reclassify transactions using an import scenario? Your help will be much appreciated, thank you. Regards.

 Hi group,When cursor reaches the last editable cell, it creates a new rowDo you know if it's possible to prevent adding new row automaticly at the end of a row (when pressing enter) in grids of acumatica? People have "Insert" right(not delete), they can Cancel the row after an unvolontary inserting but it's little bit anoying Thanks =) 

If a customer has a low user timeout (30 min) for security reasons does this affect the ability for Device Hub to run for an extended time with no print jobs?Customer is having issues with only printing a few times per day on Device HUb and they feel like they need to restart DH to get the jobs to print?  Could this be the user timeout?Has anyone had this issues?  Is there a best practice to configure Device Hub that will only be used once or twice a day or so?  (note these are print jobs on daily automation schedule) Thank you 

Any idea why the average cost of each stock item doesn’t pull through to the BOM Unit Cost?  Anybody know how I can get this pulled in?