Distribution

Hi,In shipments screen Details Grid, I added Upload button and trying to update Existing data through Excel, It updating for only first line. Not updating for remaining lines.Below is the Code I gaveIn Aspx: AllowUpload=true for details gridIn Graph Extension:[PXImport(typeof(SOShipLine))]        [PXViewName(Messages.SOShipLine)]       public PXSelect<SOShipLine, Where<SOShipLine.shipmentNbr, Equal<Current<SOShipment.shipmentNbr>>>, OrderBy<Asc<SOShipLine.shipmentNbr, Asc<SOShipLine.sortOrder>>>> Transactions;Can anyone suggest on this to update all lines in grid.         

When I release purchase receipt with auto create bill check box, the discount amount in purchase and bill display difference value where currency not USD  

Simple question, can you prevent deletion/cancellation of a Sales Order if it is linked to a Production Order?  Can it be based on the status of the RO (released, started, completed)?  I have found this is a recent feature for linked POs, but am wondering why it wasn’t implemented for ROs as well, or if I am just missing something. 

A client has requested to enable the Currency option on the Opportunity screen even though a Business Account had not been selected.  This will add a lot of value on a multicurrency environment. 

The ask to be able to have the system search other warehouses for available product that can be transferred, if none exist, then recommend a PO be created.  Is this feasible without a customization Thank you in advance for your help

Looking for suggestion my customer has line level payment terms discount. So for certain items that are invoiced to them if the customer pays by end of 1st month they get 5% off if they pay by end of second month then they get 4%, third month 3% etc. This could be on top of the customer terms and there could be other items on the same invoice that dont have this line level payment terms discount. Any ideas i know it will need development.

I am having the issue that the system is still allowing negative inventory after the allow negative checkbox was unchecked on the class. I don’t believe the item gets updated when you change the class unless you change the item to a different class. Does anyone have any insight into this issue? 

When using the pick/pack/ship functions, the quantity on the scanner always defaults to 1 and the user has to manually push the button to change the quantity on the line to the actual picked quantity. This can become a very tedious when there are pages of shipping lines to be picked.There should be a setting in the Sales Order Preferences->Warehouse Management tab that allows the pick screen to default to the quantity on the shipment line.The purchase receipt screen has a similar option to set the default the receipt quantity to zero or to the PO order qty.

Hi all,Has anyone else encountered this issue:After implementing another entity in intercompany, when navigating to the Opportunities Form, i have noticed the “Order” Tab and “Invoice”  Tab has disappeared.the below is before intercompany functionalityAfter intercompany functionality.This is not a custom field, we have also ensured the Inventory Management feature has been enabled.Any help on the matter would be highly appreciated.

I have customers who do a large volume of drop shipping items to customers.They want to be able to invoice directly from the PO to close the purchase order, or to be able to mass process purchase orders like you can with sales orders:Mass create purchase receipt (default to the PO line order qty) Mass release purchase receipt (this can already be done) The preferred solution would be a check box on the stock item to not require PO receipt for the item if it is on a drop ship order. The workflow would behave like a nonstock item with the Receipt Required box unchecked.

I have created a generic enquiry to show the latest invoice age per customer but the ARInoice.DocDate seems to have a problem because my date values are all negative. My formula is =DATEDIFF('d',TODAY(),[ARInvoice.DocDate]). Could this be also because I’m grouping my data  This also impact my options to filter because I would like to only get invoices older than 90 days 

Hello!Is there a way in Acumatica to show all items that have had no activity in the past few years? Thank you!

We have a use case in Acumatica WMS where we have shipments that require more than one package to ship the products. In our environment, most line items of an order require a separate shipping box. We have our stock items set to auto-package by a quantity of 1 into a specific size shipper.  For shipments, when we create our wave pick list it all works fine. We can use Pick, Pack, Ship and in @pick mode we can select the correct qty, totes, lot/serial#s and confirm the pick list correctly. However, when we get to @pack mode, each shipment throws an error if there is more than one package (anything with multiple lines or a qty greater than 1). The specific error is “The Pack mode is in use. The 000179 shipment cannot be processed in the Pack mode because the shipment has two or more packages assigned.” For example, we create a shipment for an order of 3 cases of water. We create the picking worksheet (pick list), select the shipment from the Pick, Pack, Ship screen, follow prompts and Co

We do a lot of production, utilizing Acumaticas Kit Specifications/Kit Assembly. However, the cost on the Stock Item and Kit Specification rarely matches. Any reason why these 2 don’t match, when they should? Thanks!

A customer is a branch of a head office. Some invoices for the customer are billed to the head office and paid for by head office (purchase of equipment). Other invoices for the customer are billed to the branch and paid for by the branch (consumable items).If I setup the child / parent relationship, is there any way of choosing that some invoices are not the responsibility of the parent but of the child? ThanksKevin

Hi: I need to setup security by user in order to let some user create only 2-step Transfers. With this I can reduce the human error at the trasfer process.  Please let me know if someone has achieved this or if there is a way to do it.  Thanks,  Jesus. 

Just looking for confirmation and clarification for my client. 1. WIP?  I am looking for confirmation that once the ISSUE of components happens, the component is removed from the ON Hand Qty of the Component.  And that there is NOT a step to verify the count of materials on WIP?So my client would count only the components NOT issued to production orders.  2.Shipments? -They WOULD count Finished Goods on shipments, that have NOT left the building, correct.  They Update IN - has not been done, so these should still be ON HAND correct?  Thanks - the documentation in Acumatica for the Physical count isn’t clear on these topics.

I’m surprised this hasn’t been questioned/requested here before.Every customer of mine that uses Lot/Serial tracking has asked for an inquiry that tells them every product a lot or serial number when into. The only tool that’s available is the Inventory Lot/Serial History inquiry which is only a list of all of the transactions for that lot/serial number.The user has to open every transaction to determine where that product went, which can be hundreds of transactions in the case of a lot number.I’ve had conversations with VERY frustrated customers over the fact that there’s not an easy way to know what customers they need to contact if there is a product issue. That’s the whole point of tracking the items (their words).Am I overlooking a tool that already exists? Or does anyone have an inquiry they’ve developed for this purpose?Thank you!

Is there a way to convert a Stock Item to a Non-Stock Item? 

I am trying to Close the debit adjustment against credit adjustment.  Not sure where to change the curr. rate  

Screen : REQUEST (RQ.30.10)Is require to increment confidentiality and only allow to see ours transactions 

Hi all, after going live with Acumatica this week I realize we have our shipping rule configured wrong. Originally we had the shipping rule set on the customer class set to Back Order Allowed, which allows the sales order lines to ship multiple times based on available inventory. I realize now at the line level the shipping rule should be Ship Complete, so we only ship the line a single time when the full quantity is available. However I also noticed there is a shipping rule setting in the branches screen that is set to Cancel Remainder. I do not see those setting being applied anywhere, but was wondering if someone could clarify how the Shipping Rule field on two different screens can say two different things?Additionally I would like to know how to set sales order lines to ship complete, but have the back order status be applied to the order header if the full quantity is not available to ship. Also at the same time letting available lines to move to fulfillment if inventory is avail

I’m trying to prepare an invoice from a shipment, but I’m getting the following error.Here is a screenshot from the trace at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args) at System.Xml.Linq.XElement.set_Value(String value) at AmazonAcumatica.BZSOInvoiceEntryExt.InvoiceOrder(InvoiceOrderArgs args, InvoiceOrderDelegate baseMethod) at PX.Commerce.Objects.BCSOInvoiceEntryExt.InvoiceOrder(InvoiceOrderArgs args, InvoiceOrderDelegate handler) at PX.Objects.SO.SOOrderEntry.InvoiceOrder(Dictionary`2 parameters, IEnumerable`1 list, InvoiceList created, Boolean isMassProcess, ActionFlow quickProcessFlow, Boolean groupByCustomerOrderNumber) at PX.Objects.SO.SOOrderEntry.InvoiceOrders(List`1 list, Dictionary`2 arguments, Boolean massProcess, ActionFlow quickProcessFlow) at PX.Objects.SO.GraphExtensions.SOOrderEntryExt.Blanket.InvoiceOrders(List`1 list, Dictionary`2 arguments, Boolean massProcess, ActionFlow quickProcess

I am getting this error despite having the item in stock and availabe=le.The upgrades is a non-stock item, the Install is a service item. The FGSO item is a stock item which shows as available, but we can’t include it on a shipment. The shipping rule is Ship Complete.The FGSO item is the one blocking it but not sure why as the item is available and we are trying to create the shipment for today.

Using 2022R2.  Starting 9/5/23, the USPS via Stamps.com api doesn’t seem to be working correctly.  Acumatica is either sending the incorrect weight or Stamps.com is changing the weight.  The weight looks correct in Acumatica but wrong at Stamps.com (i.e. 3lbs vs 48lbs).  As a result, the incorrect (very) cost is being charged by Stamps.com and sent back to Acumatica.  The customer uses the Parcel Select Ground (now Ground Advantage).  Ideas?