Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Function to get difference in time as HOURS and MINUTES

Trying to get the time difference from when a sales order was created and when it was shipped. The only function I could get was DateDiff. Is it possible to get the time in the format of “HOUR:MINUTE”? =DateDiff( 'MINUTE',[SOShipment.ConfirmedDateTime],[SOOrder.CreatedDateTime])*-1

5 minutes ago

FebriFreshman I

Develop Customizations

How to use subitems on the new screen ?

I Make New Scene I need List Subitem Input type , I make new DAC. I try to check the Subitem but no value if I press f3 Any . why is this even though the table subitem has a value ? This My new Screen Thi table My Sub item many value This My DAC Code using PX.Data;using PX.Objects.CS;using PX.Objects.IN;using PX.Objects.PO;using System;namespace Car{ [Serializable] [PXCacheName("DetailDAC")] public class DetailDAC: IBqlTable { #region DocumentID [PXDBString(30, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Document ID")] public virtual string DocumentID { get; set; } public abstract class documentID : PX.Data.BQL.BqlString.Field<documentID> { } #endregion #region InventoryID [PXDBInt] [PXUIField(DisplayName = "Inventory ID")] [PXSelector( typeof(Search<InventoryItem.inventoryID>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), Substit

20 minutes ago

jhutchinsonFreshman II

Manufacturing

Create Labor Transaction Navigation Link

Is there a way to create a navigation link on a GI to the “Create Labor Transaction” action?I currently have the navigation link to go to the “Labor” transaction screen, but the user has to add the labor transaction details.I want the Order Type, Production Order Number, Operation ID, Employee ID (based on user logged in), and Shift to auto-populate using the values from the GI so the user only has to enter the labor time and quantity if any.

20 minutes ago

Troy VarsSemi-Pro I

CRM

Omar GhaziAcumatica Moderator

Acumatica News & Updates

UPS Authentication and API Changes

⚠️ Update Dec 11, 2023: The OAuth 2.0 and new API changes have been rolled out to Acumatica starting with 2023 R1 Update 13 and 2023 R2 Update 4. Configuration steps for using the new API and OAuth 2.0 will be available in the Acumatica help files soon. In the meantime, follow this link to the UPS Rest Configuration guide. UPS recently published an announcement and how connection is established to their API. Partners or customer may have received the following notification. Acumatica is aware of this. Development work to address this change is being prioritized to address it in second-half of 2023.The changes impact the Acumatica direct UPS integration in 2 ways:New OAuth 2.0 for authentication. Since UPS is not issuing API access keys beginning June 5, 2023, which is how Acumatica performs authentication today, new customers or those in the process of implementation are immediately affected. The current workaround is to use our carrier aggregator integrations such as EasyPost or ShipE

Error when creating Purchase Order for Non-Stock Items

Hello, I am getting an error when trying to create a purchase order from my Production Order. The Purchase order contains two non-stock items and upon “Processing” the Purchase Order I get two errors, one for each item, and the PO is never created. This only appears to be issues with Non-Stock items. Thoughts?

1 hour ago

artFreshman I

Configuration and Installation

CreatePurchaseOrder through API

HiI’m trying to submit CreatePurchaseOrder through a WebService EndPoint, it return 204 message without adding any new line to my purchase order screenmy endpoint Thanks for your suggestions and advices

1 hour ago

manikantad18Captain II

Distribution

Vendor cross reference no populating when creating purchase orders from SO BUG in 22R1

If alternate IDs with the Global and Vendor part number types were specified on the Cross-Reference tab on the Stock Items (IN202500) form for a stock item and a purchase order was created for a sales order with this item, the system inserted the global alternate ID instead of the vendor part number in the Alternate ID column on the Details tab of the Purchase Orders (PO301000) form for the item Fixed in 22R1 Update 10 Build 22.110.0018.

2 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1803 topics
5925 Replies

Distribution

1735 topics
6634 Replies

Manufacturing

611 topics
2301 Replies

Construction

585 topics
1969 Replies

CRM

165 topics
489 Replies

Field Service

287 topics
931 Replies

Retail

457 topics
2028 Replies

Payroll

213 topics
726 Replies

Low Code | No Code Customizations or Integrations

228 topics
833 Replies

Develop Customizations

2431 topics
9784 Replies

Develop Integrations with Web Services | APIs

596 topics
2445 Replies

ISV Solutions

120 topics
497 Replies

Configuration and Installation

773 topics
2827 Replies

Reports and Generic Inquires

1778 topics
6899 Replies

Import and Export Scenarios

685 topics
2818 Replies

System Health and Performance

133 topics
482 Replies

Technology Partners and Customers

1 topic
0 Replies

Community site discussions

231 topics
435 Replies

Community Introductions

95 topics
281 Replies

Everything Else

730 topics
2409 Replies

News & Announcements

Acumatica News & Updates

111 topics
169 Replies

Events & Meet-ups

140 topics
85 Replies

Developer Newsletter

19 topics
0 Replies

44 topics
0 Replies

FebriFreshman I

Develop Customizations

How to use subitems on the new screen ?

20 minutes ago

jhutchinsonFreshman II

Manufacturing

Create Labor Transaction Navigation Link

20 minutes ago

artFreshman I

Configuration and Installation

CreatePurchaseOrder through API

1 hour ago

yuliya

Financials

pre-payment inventory plus shipping

Need a solution for the prepayment with inventory with 5% discount if paid in curtain time plus shipping.Out company created a shipping cost PO invoice separately from inventory. This helps us to understand what PO received/not received.I need to prepay inventory plus shipping cost. I cant add the shipping cost as an additional line to the inventory prepayment because we dont get discount on the shipping cost. What would be the best solution in this case? I hope I am clear with my problem :)

2 hours ago

dprinceFreshman I

Manufacturing

Regenerate Inventory Planning-object reference not set to an instance of an object

Hello all,Getting this error after the latest update.** Exception: Inventory Planning Error processing First Pass Detail. Type = Inventory Planning Requirement. Inventory ID = BLNK-22X64-29- GL. siteID = GST. Plan Date = 4/17/2024. Stock Qty = 880.0000. FP Record ID = 4368. BOM ID = BOM011160. Object reference not set to an instance of an object.We can delete the BOM entirely but it will just error on the next one. Here are shots of the trace log. Thoughts?

3 hours ago

BarbaraPietersen23Freshman II

Financials

Vendor error on stock item

Does anyone have a clue about this strange error message "Business Account is ."This is an error on a Vendor account when trying to add a Vendor Part Number to an Item.It makes no sense to me and tells me nothing. Any ideas?Thanks in Advance

4 hours ago

vidhurand43

Manufacturing

How to Create new Production Order for Scrapped quantities?

While doing production, some quantities are scraped. A new production order should be created for such scraped quantities with reference to existing production order. Is it possible to create new production order for the scrapped quantities with reference to existing production order?

4 hours ago

jhutchinsonFreshman II

Everything Else

Dashboard hover pop-up value placement problem

When I hover over a field value on a dashboard, the full value that pops up does not always appear in a visible location. I’m not sure why they move around and do not always appear right next to the mouse cursor of the field that I am hovering over. Has anyone else had this problem and is there a way to fix this? Please see attached pictures for example.

4 hours ago

gpineda64Jr Varsity III

Manufacturing

Unable to create a Shipment for Item when it was manufactured with a linked Production Order in a Warehouse different than the Sales Order Line

Set up:Client has 2 warehouses, MAIN and NRD All orders are shipped from MAIN, no exceptions. Certain Items are manufactured in NRD. Sales Order Lines are always created for the MAIN warehouse Sales Order Line Item is Marked for ProductionWorkflowProduction Manager (PM) creates MFG Work Order (WO) The new WO has MAIN warehouse, copied from the linked SO PM decides if the Item needs to be produced in NRD PM changes the WO warehouse to NRD System prompts the user if the SO Line should be changed to NRD PM selects NO (see step #11) At this point the WO is pointing to NRD and the SO Line to MAIN WO is completed Item is transported from NRD to MAIN and a 1-Step Inventory Transfer is released. Issue: The shipping team does not have visibility since the Order is not included in the Process Order screen SO501000 so Shipments are being missed If user opens SO to create Shipment: Error persists even after: User unlinks the WO from the SO Line User unchecks the Mark for Production in the

4 hours ago

arthia98Freshman I

Retail

24R1 - Shopify/BigCommerce Store configuration Results in "Index was outside the bounds of the array" error

Hi Team,We setup an instance of 24R1 (build 24.104.0008) and trying to configure Shopify store.But after providing configuration details when we are clicking save button, we are getting an error like: “Index was outside the bounds of the array”. Please find below screenshot for reference.Can you please review and suggest the possible root cause and resolution for the same. Thank you in advance!

4 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! April, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

snikomarov36has earned the badge Easy talker
jkasprzyk98has earned the badge Innovator

Show all badges

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded