Discussion Forums

Get inspired and gain all the knowledge you need

10167 Topics

jesuscruz97
Freshman II
jesuscruz97Freshman II
asked in Distribution

Landed Costs - Type VAT Taxes

Does anyone know how the Landed Costs with Type - VAT Taxes work?I want to know how to configure and how it works. Thanks Jesus 

8
C
Varsity II
1 year ago
C
Jr Varsity II
ckwiat46Jr Varsity II
asked in Develop Customizations

Push notification - Inserted array is blank

Hoping someone can help guide me in the right direction. I have a basic GI with two tables (employee left joined with contact table). The GI has just a few fields in the result grid.I setup a push notification to push to a webhook. I’m seeing odd behavior, where the inserted array below is blank and only the deleted shows up.  Any idea what could be the cause of this issue and/or how to resolve?Thanks,Cory​​​​​​​ { "Inserted": [], "Deleted": [ { "Acu_Salesperson_ID__c": "1", "Acu_Status__c": "x", "Acu_CRM_Location__c": "xx", "Acu_First_Name__c": "xx", "Acu_Last_Name__c": "xx", "RECORD_NAME": "xx", "RECORD_ID": "12345" } ], "Query": "GINAME", "CompanyId": "COMP NAME", "Id": "4b38f85f-adcd-4814-a0f2-ed399f0687b7", "TimeStamp": 637827401083003674, "AdditionalInfo": { "PXPerformanceInfoStartTime": "03/13/2022 03:48:27" }}

3
Naveen Boga
Captain II
1 year ago
P
Varsity II
ppowellVarsity II
asked in Develop Customizations

Is it possible to have different button to be the default available on the same screen for different roles?

We are starting to look into User Roles and security and I have been looking but didn’t find anything that addresses this. Is it possible via a customization to have a different button be the main button on the same screen based on the user’s role. For example on the Shipments screen below: For the roles Customer Service and Warehouse:Customer Service:  ideally, the Print Shipment Confirmation would be highlighted in Green and be the main option, while Confirm Shipment would be hidden under the 3 dots.Warehouse:  Confirm Shipment highlighted in green as it is now, Print Shipment Confirmation hidden under the 3 dots 

1
Troy Vars
Varsity I
1 year ago
Freeman Helmuth
Varsity I
Freeman HelmuthVarsity I
asked in Develop Customizations

Get list of users in AD mapped roles

We’re using AD roles mapped to Acumatica roles for quite a few of our users.Trying to create a selector that gives us a list of users that have certain Acumatica roles, and not able to get the “active” roles. Acumatica does not store the mappings in UsersInRole or anywhere else that we can find.There are two possible paths to this we’ve found:Use PXSelectAllowedRoles from PX.SM Not sure how this DAC works or how to use it, but it appears to be the DAC that provides the mapped roles on the users screen. It is used in Access.cs Use  ActiveDirectoryProvider.GetUsersByGroupIDs(usergroups) or some other method of the ActiveDirectoryProvider. We haven’t completely explored this either.Does anyone have experience with trying to do this?

1
Troy Vars
Varsity I
1 year ago
C
Jr Varsity I
claytonsummersJr Varsity I
asked in Configuration and Installation

Recommendations for Document scanners that play nice with Device Hub

I’m looking for a stand alone document scanner for use in shipping to scan all documents that go into the box and then attach it to the shipment as a PDF file.I’ve tried a couple of different scanners (Lexmark and Kyocera) but they are not standalone and the TWAIN software does not play well with device hub as both require user input on the scanner and never sends the scanned document back to device hub. Any recommendations of scanners that have worked for you?  I’m current running 2020 R2, planning to upgrade to 2021 R1

3
C
Jr Varsity II
1 year ago
Chris Hackett
Community Manager
Chris HackettAcumatica Community Manager
posted in Community site discussions

Ask a Question, Get an Answer - Mar 7 - Mar 11, 2022

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share ***Quick reminder to join us for this upcoming community webcast!***Community Meetup - Distribution Show & Tell: Side Panels - Tue, Mar 15, 9:00 AM - 10:00 AM PT Shoutout to the following members who provided tips and assisted with unanswered questions this past week. Thank you for all your help!@BenjaminCrisman  @joelhoffman  @KurtBauer  @dbushert  @darylbowman  @nmansinha  @Mark Franks  @Naveen B  @alexk95  @cwise52  @pmccormack58  @amajors  @aaghaei  @rosenjon  @markusray17  @john25  @kenddb  @kbeatty21  @ltussing03  @Gabriel Michaud  @vkumar  @ray20  @deebhane  @jessica.pidgeon  @lauraj46  @lzettel  @ppowell  @praveen

0
Chris Hackett
Community Manager
1 year ago
K
kapil59
asked in Field Service

When activated 2FA for a user and after login in web instance, I m not able to get the notification on registered mobile.

When activated 2FA for a user and after login in web instance,  I m not able to get the notification on registered mobile.

3
K
Jr Varsity III
1 year ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs

Bill.Details[0].POOrderNbr: A PO is required for this Vendor Error

Hi, My application creates Bill in Acumatica via REST request URL : https://sandbox-21r2.acumatica.com/entity/ARTSEndpoint/18.200.001/BillBody : {  "VendorRef": {    "value": "19071450-21101"  },  "Description": {    "value": ""1\""  },  "Vendor": {    "value": "0600001521"  },  "Date": {    "value": "02/22/2022"  },   "Details": [    {      "InventoryID": {        "value": "OLIES"      },      "Project": {        "value": "X"      },      "TransactionDescription": {        "value": "Ly"      },      "Branch": {        "value": "FOHIL"      },      "POReceiptNbr": {        "value": "06007974"      },      "Qty": {        "value": 1.0      },      "UnitCost": {        "value": 23609.25      },      "Account": {        "value": "68010"      },      "Subaccount": {        "value": "4000000000"      },      "POReceiptLine": {        "value": 1      },      "rowNumber": {        "value": "1"      }    }  ]}If I change only vendor on another one it worksWhat causes such behavior that it work

6
I
Varsity I
1 year ago
J
Freshman I
jennifer39Freshman I
asked in Distribution

How can I add Alternate ID in PO Receipt Line?

Hello There,I wanted to see alternate ID on PO Receipt line, how can I do this?Thank youJennifer

3
Naveen Boga
Captain II
1 year ago
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs

422 Unprocessable Entity Error during request

Hi, My application creates Bill in Acumatica via REST request URL : https://NewAcumatica/entity/ARTSEndpoint/18.200.001/BillBody :{  "VendorRef": {    "value": "byIvan"  },  "Description": {    "value": "d \"1\""  },  "Vendor": {    "value": "AAVENDOR"  },  "Date": {    "value": "2/15/2022"  },          "Terms": {    "value": "NET15"  },"PostPeriod": {    "value": "06-2022"  },"CashDiscountDate": {    "value": "1/31/2022"  },  "DueDate": {    "value": "2/15/2022"  },  "Details": [    {      "InventoryID": {        "value": "AACOMPUT01"      },      "Project": {        "value": "X"      },         "TransactionDescription": {        "value": "Lysolays"      },      "Branch": {        "value": "PRODWHOLE"      },      "POReceiptNbr": {        "value": "PR001666"      },          "Type": {        "value": "Receipt"      },         "ReceiptQty": {        "value": "1"      },      "Qty": {        "value": 1.0      },      "UnitCost": {        "value": 23      },          "POReceiptLine": {  

4
I
Varsity I
1 year ago
M
Jr Varsity III
michael73Jr Varsity III
asked in Distribution

Attribute with selector cannot be added to Inventory Item Class

I am trying to add an Attribute that has a selector control type to an inventory ID. I set it up as follows:  I then go to the inventory ID class and try to select it but it is not available: Observations:If I change the attribute type to anything other than selector, it becomes available in the Class ID Attribute screen. I tested the selector by creating a user ID field and adding the selector to a user defined field. It worked as expected.Is there a restriction or issue with adding a selector type field to to inventory class id?

3
R
Freshman II
1 year ago
F
Freshman I
FarhanaM60Freshman I
asked in Develop Customizations

In BQl how to cast Int to string using Joins

Hi,I have two tables CSAttributeGroupInventoryItemam join with two columns entityclassid(String) and Itemclassid(Int)which are int and string but the data is samei can able to convert int to string in Sqlbut how to do same in BQlSelect * from CSAttributeGroup A Join InventoryItem B on A.EntityClassID = cast(B.ItemClassID as varchar(15))Or A.EntityClassID = B.LotSerClassIDWhere B.CompanyID =2 and A.CompanyID=2 and ( A.EntityClassID ='106' or A.EntityClassID='LREX') and B.InventoryID=10759Please Suggest me with the answersThank you

4
praveenpo
Semi-Pro I
1 year ago
G
Varsity II
girik06Varsity II
asked in Develop Customizations

How to change Text Field to Date Control Field Dynamically?

Hi,How to change the Text Field to Date Field dynamically based on Condition?Is there any approach to execute this type of scenarios?Thanks,Giri. 

2
G
Varsity II
1 year ago
saiful murad
Jr Varsity II
saiful murad
asked in Financials

Running Depreciation in one instance affects other tenants in the same instance?

Dear All,I was wondering if any of you encountered this issue. We hosted 1 instance for multiple tenants. When we run depreciation in Tenant A as well as Tenant B of the same instance, Acumatica will prompt an error “Another depreciation process is running.  Wait for completion.”  Is this a core issue in Acumatica? 

4
saiful murad
Jr Varsity II
1 year ago
shmaryarichler
Freshman II
shmaryarichlerFreshman II
asked in Financials

Report sorting

When running reports, for example, the Customer Summary Report I cannot get it to sort by name. It always sorts by the customer ID. I change the sort in the Additional Sort and Filters and  I’ve tried to change the sort in the report designer but it still won’t sort it the way I want. Any help will be appreciated. Thanks,

6
D
Jr Varsity II
1 year ago
M
Freshman II
Malinda278Freshman II
asked in Financials

Unit of measure conversion

Can someone let me know what the logic of the conversion of units of measure is. I have read the help area about 10 times and I must have a mental block as it seems to be the reverse of what I would expect for converting from one unit to another. i.e. I would think converting a box of 10 bottles to a base of 1 bottle would require the instructions to divide by 10 but the operand is multiply. I am feeling quite stupid about this so please be gentle.. 

7
R
Semi-Pro III
1 year ago
R
Semi-Pro III
rosenjonSemi-Pro III
asked in Distribution

Supplying Inventory Balances For Testing Purposes

Does anyone have thoughts on how I might supply inventory balances to the system externally without having to manage inflows (Purchase Receipts) and outflows (selling stock from the warehouse)?As we test transitioning from our old system, we’d like to use the balances from the old system but allow the new system to enforce order limits, etc.I’m guessing this is not a thing, but I’m curious if anyone has any clever tricks to make this work...

5
kandybeatty49
Captain II
1 year ago
M
Jr Varsity III
michael73Jr Varsity III
asked in Import and Export Scenarios

Automatically email or copy an exported file to a user

I’ve been using export scenarios to create and automatically sync vendor reports for a while and they all work fine. Now I need to do the same thing, except email or save a copy of the file to the user who needs to manually upload them.I’ve looked at business events and automatons but every avenue seems like a dead end. Is this possible and if so how?Thank you.

6
M
Jr Varsity III
1 year ago
R
Freshman I
rwhetsellFreshman I
asked in Configuration and Installation

Need multiple weight and volume UOM per company under one tenant

I’m hoping I’m just missing a setting, work around, or feature that enables this, but here is the scenario:One Tenant using the “Multiple Base Currencies” feature in 2021 R2, latest build Three companies, no branches USD Euro CZ Koruna Three warehouses Shared Stock ItemsThe non-US companies need metric measurements (KG and Liter) for weight and volume, but when I set these in one company it changes for all companies.Any suggestions appreciated!!

0
R
Freshman I
1 year ago
M
Freshman II
MalgorzataFreshman II
asked in Distribution

Outside processing without manufacturing mode

I would like to ask is it possible and how to set outside process (outsourcing) without manufacturing mode. Till now I found solutions only for manufacturers by creating Production Orders but what if there is no production onside and we ship a purchased item to the Vendor for an outside process (coating etc) and then afterwards we receive it back from Vendor ready to sell. How to organize that case in the system in order to calculate costs correctly and track the item?

2
R
Freshman I
1 year ago
J
Freshman I
jnowotnyFreshman I
asked in Payroll

How do you set up a 401k company match when you have both 401k and Roth Deferral?

Hello!Our company has employees who defer to both a traditional 401K and a 401K Roth.  Our company match is 50% of the deferrals, up to 3%.  How do I set this up so it takes both the 401k & Roth in to account?  If someone is deferring 6% to their 401K and 6% to their Roth, we want the max match to be 3% between the 2. Thank you in advance for any help!

1
mikedavidson07
Jr Varsity II
1 year ago
J
Freshman I
jnowotnyFreshman I
asked in Payroll

Can you have an earnings code with a set hourly rate?

Hello! Is there a way to have an earnings code set up, so every time hours are brought in, the systems pays the same rate?We have employees in school and when they are in class, they get paid $xx/hour, regardless of what their normal wage is. Thank you!

1
mikedavidson07
Jr Varsity II
1 year ago
C
Freshman I
CAMORRISONFreshman I
asked in Community site discussions

Accounts Payable

We received a PO in completely but we received multiple invoices and there is one where one item was not fully received on the invoice so it is on multiple invoices. How can we make and AP bill for those items?

1
Laura02
Captain II
1 year ago
P
Varsity I
podonnell11Varsity I
asked in Distribution

Scan and Transfer Different Warehouses

Hello everyone, I am playing around with the mobile app with warehouse management. I am trying to use the scan and transfer function to transfer between warehouses but the scan and transfer function seems to only allow transfer between locations in a single warehouse. Is there a way to bypass this? Is there any work-around? Thank you

2
P
Varsity I
1 year ago
D
Freshman II
danchFreshman II
asked in Develop Integrations with Web Services | APIs

Bill Payment Creation REST API

Hi All, Currently looking to automate a bill payment into Acumatica after processing the payment using an automated payment method for a client, I have seen that the only method is to create a “check” payment but this only creates a record of a payment not specifically against a bill, is there any way to create a payment that would be assigned to a specific bill ?Could we create a DebitAdj against a bill, documentation seems to be rather lacking in this area. Thanks

2
D
Freshman II
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved