Skip to main content

Discussion Forums

Get inspired and gain all the knowledge you need

10000 Topics
M
Freshman I
MComan62Freshman I
asked in Financials
Create AR Statement error

We have been creating statements for several months and today when we went to run statements we got an error ‘ Nullable object must have a value’ . I have checked the statement cycles and the preferences and have not found a problem. Any suggestions on what to check next?

294
M
Freshman I
S
Freshman I
SidduFreshman I
asked in Develop Customizations
How to Convert Extended DAC Fields in the Sales order screen classic to Modern UI

I have added a Extended DAC fields to the Sales order Screen And how to convert the Extended DAC fields into the Modern UI .

918
Vignesh Ponnusamy
Acumatica Moderator
J
Semi-Pro II
jzhuSemi-Pro II
asked in Reports and Generic Inquires
Sub Inquiry Error: Object reference not set to an instance of an object

Hi! I am merging two Generic Inquiries together to achieve the following: If the item on shipment is a kit item, display the component items of that kit, and the vendor inventory item of that component item. If the item on shipments is not a kit, then display it as is. Issue: While everything is pulling in and displaying correctly. I am unable to drill into the item if it is a kit, and unable to drill into its related component items. When I click on them, I would expect it to take me to the stock item screen, however, it gives me the error: Object reference not set to an instance of an object. If the item on shipment is not a kit item, I am able to click on the item and it does take me to the stock item screen. Any suggestions on what maybe causing this issue and where I should look at? Attached below Shipment Detail is the main GI.

375
lauraj46
Captain II
J
Freshman I
jrudolphFreshman I
asked in Field Service
Stock Item Image not showing on first tab on the ImageURL Field

We are currently using a REST API to import our images for stock items. But when we do, they show up on the second tab of the ImageURL field. Does anyone know why/how we can avoid this? This now makes our report look like there is no image within a stock item profile. Image 1: Shows no image. Image 2: After clicking Ctrl →, this is where we see the image.

162
J
Freshman I
M
Freshman I
MComan62Freshman I
asked in Financials
How to get rid of an outstanding Credit WO

We have created an extra Credit WO transaction and I am not having any luck zeroing it out. I have tried to apply it to a debit memo without success, When I try to reverse it, I get a zero transaction and it remains on the statement. What would be the best way to get rid of this?

110
M
Freshman I
L
Jr Varsity III
lairdtimJr Varsity III
asked in Reports and Generic Inquires
Using the same business event (and Imports) on multiple Generic Inquiries

I think I know the answer to this already (since the import scenarios tied to a business event have a data provider tied to the business event) but I figured I’d ask. I have two generic inquiries that present the same columns and data; one is based on serialized inventory while the other is based on non serialized. I have a business event that runs through these and does some automation (a couple of GL entries). The business event logic doesn’t matter whether it’s serialized or not; the formulas within the GIs are slightly different, though. I could probably consolidate them and have more complicated formulas, but I’m curious if there is a way to have a single business event that is tied to two separate GIs, without copying the business event (and the two import scenarios that it triggers, which is where the real magic happens).

161
BenjaminCrisman
Acumatica Employee
jessicapruitt
Freshman I
jessicapruittFreshman I
asked in Develop Integrations with Web Services | APIs
How to write an expression for Export Mapping of Stock and Template products?

I need to write a custom expression to map Brand from ERP to BigCommerce BrandID. it is custom since BigCommerce’s interval is a number and the ERP is a text format. We have a Substitution List designed to map the BrandID to the Brand Name too. The brand is located in Attributes, but I think it may need to be changed to Advanced for a customized expression. For the Substitution Lists, BCBrands is the name of the list. If anyone can point me in the direction for learning how to write the expressions too that would be great. I work in web development, so the expressions look familiar to JavaScript variable syntax.

80
jessicapruitt
Freshman I
I
Freshman I
ifelixFreshman I
asked in Develop Customizations
Confirmation box on Remove hold

Hi. I’m trying to include a confirmation message box with yes no on Remove Hold action button. If click yes then i want to change the status of the Remove hold. If click no then nothing should change. Here’s is my code. public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter); [PXOverride] public IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod) { ARInvoice row = Base.Document.Current; if(row.CustomerID != null && Base.Document.Ask("Are you sure you want to remove hold this?", MessageButtons.YesNo) != WebDialogResult.Yes) return adapter.Get(); return baseMethod(adapter); } When i click either yes or no in the confirmation box it gives me an error like this: How can i solve this please ?

1227
A
Captain II
A
Freshman I
anupusefulbiFreshman I
asked in Develop Customizations
Selector is appearing a textbox

I have created a Form and added Generic Inquiry as an Entry Screen. When ever I am Adding new record I am navigated to the main form screen From GI Problem :-- I have defined Account CD as Selector, But it is still a text box appearing on the screen

546
A
Captain II
K
Semi-Pro II
kokjietanSemi-Pro II
asked in Distribution
Calculate local carrier Freight Cost by No. of Packages?

Hello, Would like to inquire - is there any way of calculating the Freight Cost of local carriers by the number of packages on the Sales Order? Eg. each box = $15 freight cost, if the SO is to be auto-packed in 10 boxes, the freight cost should become $150. So far, I have only been able to calculate the Freight Cost by weight (per unit) or per shipment (net) for local carriers. Whereas our carriers charge directly based on packages, not weight.

1033
PatrickSchlenker90
Jr Varsity III
I
Freshman I
ImprovementManagerFreshman I
asked in Professional Services
Hubspot implementation partner

Hello, We are planning to implement HubSpot and integrate it with Acumatica. However, we require more than the standard out-of-the-box integration, as there are additional fields that need to be connected. Could anyone recommend an implementation partner with expertise in integrating Acumatica with HubSpot? Preferably based in the UK or Europe. Thank you.

30
I
Freshman I
S
Freshman I
seang84Freshman I
asked in Everything Else
Bank feed setup with Wells Fargo Commercial Banking (Vantage/CEO)

I’m trying to setup new bank feeds for WF commercial accounts but cannot find the right institution in Plaid or MX. An article from last year mentioned using the MX Bank Feed Type… but Wells Fargo CEO is not an option. Not sure if something changed on the MX side of things or I need to search for it a different way, I tried just about all I could think of. Using the Wells Fargo institution with my credentials does not work since the sign in page is different for commercial accounts.

351
ajmalnasir55
Acumatica Employee
S
Freshman I
scmaxim1Freshman I
asked in Community site discussions
Service Contracts/Contracts/Projects

How would you use Acumatica to track the cost of goods issued to a customer over the course of a year or more where the customer is billed monthly for services and stock items? Would you use projects? Service Contracts? Contracts? SP orders or Service orders? Or a combination of those features? Projects seems to be the only module that Acumatica advertises the ability to track cost and gross profit but it seems overkill for standard contractual businesses. It also doesn’t track cost in the cost budget from SP orders without some decent upfront configuration and maintenance of that configuration. Service Contracts/Service Orders doesn’t have the extensive report functionality that projects does and it doesn’t appear to have the ability to track the costs of issued materials from that service order on the service contract to get a good gross profit number the contracts module doesn't seem to allow the sale or issuance of stock items at all but it does seem to have all of the other functi

131
nhatnghetinh
Captain II
E
evillarosa62
asked in Distribution
SO Commission on Order level

Hello Acumatica Community :) Does anyone know if setting up commissions at the order level instead of the line item level is possible? OOTB commission system assigns commissions to each item in SalesOrder. I’m not sure if I missed a setup option that would allow me to assign it at the order level. Thanks!

322
ricoybanez
Jr Varsity III
jwojtyna
Freshman I
jwojtynaFreshman I
asked in Financials
Can a Debit Memo be Applied to an Invoice?

Hi Folks, I am new to Acumatica and loving it so far. I am going through the classes with my team and I didn’t see this exact topic in the community (my apologies if I missed it)! Is it possible to apply a debit memo to an invoice to INCREASE the amount of the invoice? Thank you! Jason

272
jwojtyna
Freshman I
WillH
Varsity II
WillHVarsity II
asked in Reports and Generic Inquires
SQL Data - Logintrace - What do the operation numbers stand for?

Hi all, I’m trying to figure out some user auditing that I don’t think I can reach via the UI. There’s an Operation column in LoginTrace, and it would be useful to know what the different numbers there might translate as. Does anyone have a key? (the particular numbers I just spotted are 2 & 4, 1 (Login)& 16 (Screen accessed/modified) I think I understand, though obviously I could be wrong.

463
WillH
Varsity II
L
Captain II
ltussing03Captain II
asked in Reports and Generic Inquires
Invalid field name error in Report Designer - Customer Statements -Terms

Adding the Terms defined on the customer to the customer Statement Report. AR641500 The Customer table is part of the standard report, but when I add any of the Terms_ID fields to the report I get an error saying it is invalid. Any thoughts? I have tried all 3 of these with the same results. This is under Customer in the tree shown in the image below.

252
L
Captain II
C
Freshman I
CAMORRISONFreshman I
asked in Field Service
GI Filters for Saturday/Sunday

I am creating a GI that gives me service orders that were created on Saturday and Sunday or after 4pm on weekdays. What do I use for filters??? I tried @weekstart+5 and @ week start+6 to get Saturday and Sunday but it doesn’t pull anything. I don’t even know where to start for the after 4pm on weekdays. Help!?

362
C
Freshman I
C
Freshman I
CAMORRISONFreshman I
asked in Field Service
SIGNED APPOINTMENT

Is there a way to move just the signature from the original appointment over to the edited version one once we have made our updates/changes to it?

60
C
Freshman I
K
Semi-Pro III
kyle90Semi-Pro III
asked in Retail
New Customer Location inherit Entity Usage type and Exemption from Default Location

Hoping someone else has a solution to an issue we’re having with customer tax exemption records and new locations We recently noticed that when a customer is setup with a Tax Exemption Number and Entity Usage Type those values are saved to their default customer location - However, when new customer locations are created, the values from the default location are not copied over to the new location We are using Avalara for a our tax provider and we have a BigCommerce store connected to both Avalara and Acuamtica - BigCommerce maintains a single Customer Tax Code (analogous to Entity Usage Type) at the customer record and all customer orders, regardless of address or location, are processed using this tax code and exemption. Acuamtica keeps this record at the location level and calculates only off the customer location values Because of the above, when a customer changes any of their shipping information online, the system creates a new location in Acumatica but the system then looses th

358
K
Semi-Pro III
M
Jr Varsity II
Mondeddula Madhu Venkat ReddyJr Varsity II
asked in Distribution
Error: Inserting 'Requisition' record raised at least one error. Please review the errors. Error: 'Creator' cannot be empty.

When I was Processing a requisition the following Error has occured Error: Inserting the 'Requisition' record raised at least one error. Please review the errors.Error: 'Creator' cannot be empty.

1222
S
Freshman I
S
Freshman I
SunnyM
asked in Financials
Tax zone error on PO.

Error: Inserting 'Purchase Order' record raised at least one error. Please review the errors. Tax Zone should be..ON. The warehouse and branch are both located in ON and the vendor is location in BC. Error appears from create PO from requisition. Anyway to turn off taxes completely or the work around this for a company with multiple different tax zones per warehouses/branches.

110
S
Freshman I
J
Freshman I
jacevedo58Freshman I
posted in Construction
Lien Waiver Through Date

Issue/Current Behavior: When Compliance Preferences (CL401000) > Through Date = Posting Period End Date, the lien waiver Through Date = end of the posting period of the Payment. Expected Behavior: When Compliance Preferences (CL401000) > Through Date = Posting Period End Date, the lien waiver Through Date = end of the posting period of the AP Bill. Source: Compliance Preferences (CL301000) > Through Date Posting Period End Date (default): The lien waiver is applicable through the last date of the posting period of the AP bill, which is specified in the Post Period box on the Bills and Adjustments form. Work Around: Replace Through Date with a formula to calculate the date of the last day of each month.

243
iqraharrison
Captain II
A
Freshman II
adaughenbaugh95Freshman II
asked in Configuration and Installation
Sales Order - Pickup Ready Notification

My business has some customers that come and pick up their orders. Shipping would like to automatically notify them once the order is picked and packed. Currently, we select Customer Pickup as ShipVia, it allocates, picks, packs, then sits in Shipping status until someone notifies Customer Service it is ready for pickup, then they contact the customer. Once the customer picks up the product it moves from Shipping to Completed - for inventory and order tracking purposes. I thought I just needed to create a conditional Automation Schedule based on Status and ShipVia for a Business Event for an Email Notification - (new type). It will not let me tie the Automation to the Business Event. I get this warning on the Automation Schedule, but as you can see my Business Event is set as active, and it is saved.

264
craig2
Pro I
VladS
Community Manager
VladSCommunity Manager
posted in Other Developer Topics
Save the date: Coffee & Code - Modern UI Apr 22

Hello all! Join us for first Coffee & Code event for the year - Modern UI, a webinar where Varthini Bhaskaran and Vignesh Ponnusamy dive into the modern UI and best practices. Moderated by Ekaterina Androsova. Grab a coffee and let’s talk code! Tue, Apr 2211:00 AM - 12:00 PM PDTOnline event Register here: Teams Webinar Thanks,

290
VladS
Community Manager

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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 — 2024  Acumatica, Inc. All rights reserved