Distribution

Please look at Purchase order 001712, vendor Reference SF2568 30 188920. Order total was for 960 units. Acumatica let me receive 2 times against the PO (receipt # 001484 and 001763)- both for the full amount of 960 units and then created two payables(017881 and 019617), both for the full amount of the order. This is a drop ship order, so the invoices created for the customer was double what it should have been. How do we correct this (on both AR and AP sides)  

Hello Everyone,What is the best practice for receiving inventory at landed cost when the freight is charged as a separate line item by the goods vendor?The distinction from using a Landed Cost document is that the freight is being charged by the goods vendor on the same invoice as the goods receipt, not from a separate freight vendor.  The following idea has been submitted, but wanted to check if anyone had a good process for this while under review.Thank you!Luke

Hello! We are just starting to use the Purchase Request / Requisition functionality and we wanted to automate the conversion of Requests → Requisitions. We are going to primarily use this functionality for three types of purchases:General Purchases: Non-SO related goods that can be used anywhere (can be multi-vendor) Quoted Purchases: Quoted goods that are specific to a SO and must be ordered by the quote. By Description Purchases: Typical PPE, Office Supplies, Software, etc. However, I am getting stuck when trying to create automation schedules for these goods. I am having trouble building an automation schedule that creates requisitions by the specific vendor (for general purchases) and another automation schedule that creates requisitions by the specific quote (for quoted purchases).  The two issues are, firstly, when I run an automation schedule for General Purchase requests, I find that regardless of the vendor, all processed lines get combined into one big requisition. The second

I am getting examples of null reference exception error for some event handlers in 25R2 such as the following:  [NullReferenceException: Object reference not set to an instance of an object.] PX.Data.Generic`2.SearchAdapted(TGenericDelegate genericHandler, IEnumerable`1 classicHandlers) +258 PX.Data.Generic`2.GetClassicHandler(TGenericDelegate handler, Boolean remove) +100 PX.Data.RowInsertingEvents.AddAbstractHandler(Action`1 handler) +88 PX.Objects.IN.GraphExtensions.LineSplittingExtension`4.SubscribeForSplitEvents() +198 PX.Objects.IN.GraphExtensions.KitAssemblyEntryExt.INKitLineSplittingExtension.SubscribeForSplitEvents() +18 PX.Objects.IN.GraphExtensions.LineSplittingExtension`4.Initialize() +309 PX.Objects.IN.GraphExtensions.KitAssemblyEntryExt.INKitLineSplittingExtension.Initialize() +18 PX.Data.PXGraph.CreateInstance(Type graphType, String prefix) +573 PX.Web.UI.PXBaseDataSource.CreateDataGraphAsSingleton(Type type) +593 PX.Web.UI.PXBaseDataSource.CreateDa

Hi Acumatica -Not sure the quickest way to relay this to you, but the update that you released overnight in the App Store is now unusable for automated warehouse operations.  We use the Pick, Pack, Ship function daily for our warehouse team, and a few of the iPads that we have set to ‘auto-update’ downloaded the new app and the screen is squished together so small that it is unusable for my team.  It would be great if you could address this quickly and release an update to fix the issue.Thank you.

We’re trying to configure Acumatica so that certain programming information — specifically the contractor’s email and phone number — is stored in the Customer record and then automatically printed on the Sales Order whenever a specific group of items is ordered.Has anyone implemented something similar? We would prefer to do this without a Customization Project. Any guidance would be greatly appreciated.

We need a way to track product continuity by stock item. This includes identifying the customer that purchased the stock item (can be free text but prefer to select actual) and the date through which we commit to keep offering this inventory.  I’m thinking I’ll end up using an attribute option but would love some other suggestions. Is this something restriction groups could be good for? 

I want to change the workflow on shipment and add a Button “READYFORPICKUP” in between Confirm shipment and prepare invoice.When CONFIRM SHIPMENT is clicked, A new Button (status) should appear,Once this button is clicked, then it should return to normal workflow and Prepare Invoice should be available.   Prepare Invoice should not be available until Ready for Pickup has been clicked.  I have tried to build this in the workflow, with mixed results.What is the best way to accomplish this.thanks 

 Hello,I’m having difficulty creating an import scenario to generate a Prepayment Invoice from the Sales Order screen.In the manual process, the user clicks the Prepayment Invoice button, which opens a pop-up window asking for the amount or percentage of the sales order. After confirming, the system navigates to the AR Invoice and Memo screen, automatically copying all relevant data from the Sales Order screen. At this point, the user simply needs to click Save to complete the creation of Prepayment Invoice.Please see screenshot below  the whole process.Based on the manual process, I attempted to create an import scenario. I tried using the Add Invoice Details object under the sales Order screen, but I noticed that this object does not include a Save Action. Could someone please advise or guide me on how to proceed with this . We need prepayment Invoice due to VAT requirement,   

Customer has multiple warehouses They are looking for a replenishment solution that would look to transfer before purchasing when availableHas anyone address this type of situation ?

How can we change the “Transaction Description” of the Invoice created with multiple installment terms.For example: we have created an invoice with Credit Terms as “5SPLITPAY” with Invoice total as 5,000. After invoice is released, 5 new invoices are created with “Transaction Description” as “Item Discount”, from where this text coming from, do we have any option to change this. Please help us. 

Hi everyone,I’m currently facing the following issue:I am adding several orders from the same customer to one shipment (open shipment → Add Order). This works fine as long as the orders have the same Order Type.However, when I try to add an order with a different Order Type, I get the following error message:“The order type cannot be selected. The value of the AR document type setting for this order type differs from the value of the same setting for the order types in the lines that have already been added to the shipment.”I can't figure out how to avoid this or where to change the settings to allow adding the order to the shipment.Has anyone experienced this issue or has a suggestion on how to solve it?Thanks in advance!

Hi All, I created and released a negative Move transaction in my Production Order accidentally. It has generated a Material transaction as well. Then I created a positive Move transaction hoping I could just reverse them that way, but the cost captured in Materials transaction were different.The Move transactions did not have impact on finished goods inventory. I am running some tests to work with reversing them, but how do I go about reversing these transactions properly? Many thanks in advance!Negative Move:Associated Negative Material: Positive Move: Associated Positive Material with different cost: 

I work for a metal service center selling corrosion-resistant metals products. If you are running Acumatica and work for a metal service center, please let me know I’d love to discuss with you! Thanks, Jonathan

I need to ship a Non-Stock Kit from multiple warehouses. Each component is in its own warehouse and I want to ship it directly from that warehouse without transfering it to the other.I am using the Multiple Warehouse feature of 24R2.I have 2 warehouses set up:W1 - Warehouse 1W2 - Warehouse 2Consider a Non-Stock Item Kit (NSK1) with 2 components. The qty avail for each component exists only at its default warehouse.COMP1 - Component 1 w/ default warehouse W1COMP2 - Component 2 w/ default warehouse W2When adding item NSK1 to a Sales Order you must choose a Warehouse. Selecting either W1 or W2 will not allow a Shipment to be created because "There is no stock available at the W1 warehouse for the COMP2 item" (or vice-versa). Batch processing orders to Create Shipments results in the same error in the trace log.Is it possible to ship components of a non-stock kit item from multiple warehouses?

I want to create a customer by passing the Numbering seq. The customer number CS0225. Attached are the Numbers currently we have space to add the mentioned. How ever when I checked the Manual Numbering seq and advise the team member to proceed of the customer creation, we are unable to process 

Is it possible to add the list of items that need to be counted from the online version to the mobile Scan and Count? Our team is basically counting blind not knowing what needs to be counted and where those parts are. Ideally, we wouldn’t have to use a computer to do a cycle count. 

 Hi,I’m trying to make the CustomerID selector field display as a hyperlink in the Modern UI, but it is not showing up as expected. Below is my code snippet. Could anyone help me identify what I might be missing or how to make it work?Code:DAC:#region CustomerID[PXDBInt()][PXUIField(DisplayName = "Customer ID",Enabled =false)][PXSelector(typeof(Search<BAccount.bAccountID,Where<BAccount.type,Equal<BAccountType.customerType>>>),    SubstituteKey = typeof(BAccount.acctCD),    DescriptionField = typeof(BAccount.acctName))]public virtual int? CustomerID { get; set; }public abstract class customerID : PX.Data.BQL.BqlInt.Field<customerID> { }#endregionHTML:<template>                    <field name="CustomerID" config-allow-edit.bind="true"></field></template>I also tried by adding config-type.bind="1" Thanks in advance.Premalatha N

Hey there,we do have the issue, that we have open orders for the same customer and want to merge the shipment.So for example customer 1 has 3 open orders and in each order are some items which are available in the warehouse and can be shipped. Now i want to have only one shipment for those items.Also possible is that we have a customer with 2 open orders and all items are available and should be send in only one shipment. Any ideas how i can do this? At the moment i have to create for each order a shipment.

Hi, How to delete UnAssigned Locations lines in Inventory Summary. In Inventory Summary data is not saving through direct tables.Can anyone Suggest me how to delete UnAssigned Location from Inventory Summary.Thanks,Giri.

We changed a stock item's posting class. One year later, it still uses the GL defined in the old one. Why?  The item and posting class Gl accounts are defined with the new accounts.  I’ve looked at the bill of material, the sales order, warehouse, location.  Nothing suggests that the old accounts should be hit.  This is happening for issues out of the warehouse but does not appear to affect receipts.

When I create credit return it show the error message like this.

Hello all,I would like to confirm whether it is a native Acumatica functionality that when a metafield in Shopify is not mapped in Acumatica, any data exported from Acumatica to Shopify will result in a blank value being passed to that unmapped metafield, even if there is data present in the corresponding field?Thanks.

Hello, We’ve been using Acumatica WMS for about two years now. We were initially excited about the picking functionality—using a smartphone via the Acumatica app, or a handheld scanner—but it has not lived up to our expectations. I’m curious if anyone is having success? Here are our pain points: In order to pick via the handheld, you also need a printed picking worksheet to know where to go and what to pick. Using the Review screen during the pick is inefficient to look back-and-forth between. I wish the picking screen would tell you more about where to go, what SKUs and quantities to pick, rather than leaving you “blind” to that information.  It is therefore much easier for our team to just use the printed picking worksheet to pick orders. Using the handheld takes much longer.  As far as I know there’s no way to simply mark a picking worksheet as “picked” in Acumatica. You have to actually scan everything (which takes forever). Therefore our team just deletes the picking worksheet aft

Hello,I am trying to drop ship an item that is serial tracked.  I have checked the Required for Drop-ship box in the Lot/Serial Class. I still cannot open Line Details to enter the serial number on the Sales Order screen, and get this error. The first place I can enter a serial number is on the Purchase Receipt. Is there a way to enter the serial number on the Sales Order screen for a drop ship item?