Distribution

Is there some way in Acumatica to warn users, during entry, that the Inventory ID exist in another row?  ScenarioA clerk inputs a Sales Order, Invoice, or PO with numerous items, 30+, including Item A. Later on they get a request to ‘add’ Items B to the order but they inadvertently select Item A. So the order is now has two rows with Inventory ID Item A.  Required behavior:A popup prompt to notifying user that the Inventory ID already exist on the document Place a warning icon adjacent to the duplicate Inventory IDs        

Hi,An debit adjustment (which includes incorrect date) was released against a purchase return. To remove that particular incorrect debit adjustment from the purchase return, what can we do ? Thank youNawanjana

Hi,  How can I customize the process shipment action dropdown list to include a custom Packing Slip format that I've created?  Thanks

Hello,We have the following scenario:The customer sells clothes, the size and color variants were created.Matrix items were created successfully.Matrix Items createdNow it is necessary to create the barcodes for each item.We select the item from ‘Matrix Items’  tab.Selecting matrix itemThe system displays the inventory items screen with all fields populatedMatrix items populated in stock items screenThen, when we try to create the related barcode, we can select the desired option, but when we change the pointer to the alternate ID field, the system erases all the other fields on the screen:Alternate ID  selected Data in fields erasedSo, we can’t update the item.Is there any other way to do this? Thank you  

We would like to reverse physical counts entries, can it be done?I am aware that the journal entry can be reverse but how about the items?

We sell a build-to-order product with 8 weeks lead time.  We require a minimum 20% down payment (exceptions occur, so we must account for variations from 20%) of the full sale price before we begin the build.  Here is the desired workflow:Create Sales Order with full price of product Invoice 20% of the Sales Order amount Customer pays down payment invoice via email pay (secure portal 3rd party) Apply as a Payment/Prepayment on the Sales Order The Payment/Prepayment automatically applies to the final invoice at end of the buildThe problem is that I cannot create a down payment invoice for the 20% linked to the Sales Order.  I can send the Sales Order form with an email pay link on it, but it will be for the full amount.  We can tell our customer to only pay a certain amount, but the customer will have to manually modify the amount (because the payment amount for the customer will default to the full sale price).Is there a workflow to handle down payment invoices?

Hey TeamI am trying to create an SO Invoice (SO303000) for a confirmed Shipment on a Sales Order. I am trying to use Import Scenario. However the error throws an error without any description. Which generally mean the construct of the import scenario is not right.The import work if I don’t use ‘Add Order’Can anyone point our my mistake?  

How can we add outgoing shipping to cost of goods?  

I have some generic stock/non stock items set up for certain purchases.  The buyer changes the description based on what it is.  The correct description shows up in the PO once it is saved, but I cannot find this field in the POLine table.  I can add POLine.InventoryID_Description but this pulls the description from the stock item, not the PO Line.  How do I add the actual PO lin description to a GI?  This GI below uses POLine.InventoryID_Description, but I want it to show the actual PO Line description above. 

When Adding shipment to the SO Invoice by Add Order action we are getting this subjected error.Below is the trace.LINQ fallback! Consider rewriting your query. Graph: Wrapper.PX.Objects.SO.Cst_SOInvoiceEntry LINQ Model: value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.SO.SOOrderShipment]]) => Concat(value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.SO.SOOrderShipment]])) Base BQL: Select2<SOOrderShipment, InnerJoin<SOOrder, On<TypeArray<Field<SOOrderShipment.orderType>.IsRelatedTo<SOOrder.orderType>, Field<SOOrderShipment.orderNbr>.IsRelatedTo<SOOrder.orderNbr>>>, InnerJoin<SOOrderType, On<TypeArray<Field<SOOrderShipment.orderType>.IsRelatedTo<SOOrderType.orderType>>>, InnerJoin<SOShipment, On<SOShipment.shipmentNbr, Equal<SOOrderShipment.shipmentNbr>, And<SOShipment.shipmentType, Equal<SOOrderShipment.shipmentType>>>>>>, Where<SOOrderShipmen

Any partners have experience with Orbis DSD Route Accounting & Planning (POWERED BY COMPUTIME SOFTWARE LIMITED)?  If so, willing to share your experience at a high level?

Hello,I have a small issue with landed cost as some of the landed cost goes into the Landed Cost Variance Account and it does not show in the Inventory Valuation report and the Average Cost in the Stock Items.Does anyone know the workflow to correct this issue?The final bill of the landed cost cost is entered after we received our goods and we start selling them right away.Landed Cost Variance AccountThe expense account to be used for this stock item to record the landed cost difference that occurred if landed costs are allocated to an item that has been sold. Thanks,Nelson

We want to know how landed cost is computed. Does it show up under the item cost statistics as "average cost?"Does average cost equal landed cost?If not, where can I see landed cost?

Hello,We had keyed in a new item on the sales order. Since it was new, it had 0 cost and the ‘estimated margin’ column was calculated based on 0 cost and $200 price for margin $200.Now, we have manufactured the item and the stock item is valued at say, $100. But the Estimated Margin line remains at the old cost.Is there any way of forcing the Estimated Margin to update?

We have transfer orders that are being consumed by another production order.  Each line is marked complete, but the transfer orders are not being moved into Completed status.Can we simply cancel the Transfer Order after it’s done? 

Hi We want to restrict sales orders for users based on the items attached on the sales order. Up to now we are only able to restrict selecting items on the sales order but since users can view all the sales orders is able to view the other sales orders which attached the stock item. Here our users will be selling for same customers but different products. Amanda 

I’m trying to give a user permission to click “show all documents” on the customer details screen, but it doesn’t seem to work. What am I missing here? 

We would like to offer a discount on 2 or more of an identical item in a certain price class.What we want to do is have a discount of $1 per extra item applied when the customer orders 2 or more of any item in a specified price class. We do not want it to apply if the customer orders 1 of one item in the price class and 1 of another, it has to be more of the same item. Is this possible and if so, how would I go about setting it up?I have set up a discount code for a price class where 2 or more of the item will trigger a discount of $1 but it only does it once.  We would want each additional item to trigger a $1 discount. Thanks for any advice, Phil

Before our latest upgrade to V2023R2, which included upgrades for V2022R1 and V2022R2 the code below worked, now it doesn’t.  We learned our lesson to not skip multiple updates and in the meantime I am scrambling to fix code that once worked.The information on CreateShipment states a string operation parm is needed.  I went to GoTo Definition in SOOrderEntry Operation List and found that there are two options, I for Issue and R for Receipt.I do not know what the operation field does or how it affects the create shipment.   I also don’t know how to add the parm in a way the CreateShipment method will accept.CODE:SOOrderEntry.CreateShipment(adapter, order.ShipDate, Filter.Current.UserWhse); 

The USPS has recently changed its service packages of First Class, Parcel Select, and Retail Ground services. These services will now be offered under a new service called Ground Advantage. I noticed that the Ship Via choices for stamps.com and EasyPost do not support these recent changes. I have not seen any information from USPS about when they will be retiring these services, but I found a related article from EasyPost.  https://www.easypost.com/blog/2023-06-06-upcoming-usps-price-and-service-changes-in-july-2023Users will be able to buy USPS Ground Advantage shipments using the new "GroundAdvantage" service name or the legacy "First" or "ParcelSelect" service names through Jan 21, 2024, at which time the legacy service names will no longer be supported. https://faq.usps.com/s/article/USPS-Ground-Advantage 

How do I add an attribute to this screen?  I have already created the attribute but don’t know how to make it appear in the Stock Item screen.  

We are trying to work out how to automate the allocation of stock to orders which cannot be fully completed.There is no process to automatically “allocate” stock to orders.  It would be great if there was.Due to stock shortages and the need to keep customers happy our client has to manually allocate stock to orders which is very time consuming.  Some customers end up getting 10% of the order, some all of it if it is a very large order; there are many factors that come into play. Thanks 

I'm currently working on an integration project involving our Shipping Software and Acumatica, aiming to accurately reflect freight costs on shipment invoices. However, I've encountered an issue where despite receiving the correct freight cost data (e.g., 83.75) from our Shipping Software, Acumatica is consistently pulling the Freight Price as 0.00 onto the invoices.Does anyone know how to get the Freight Cost to pull down to the Freight Price automatically if the checkbox is set to Override Freight Price?  Acumatica Version 2023 R2  

Hi,  We’re currently exploring inventory planning software and are talking to the software companies listed on the Acumatica Marketplace. Has anyone used inventory planning software outside of the marketplace that successfully connected to Acumatica? 

I am getting an error when trying to delete an attribute value from the Lot/Serial Class.  It won’t let me delete it. I am unable to find where to “Inactivate” this attribute.  There is no option to inactivate this attribute on the Lot/Serial Class screen similar to the one on the Item Class screen.Anyone has any clues?