Distribution

Hello,I am currently using template items and I created 4 matrix items from it.There are transactions on those items, but we would want to change the Sales UOM to something different.  But it is both gray out and in the Stock profile.  Is there any way to unlock the UOM to make this change and the Base UOM is each. Much thanks

Is there a way to disable shipment confirmation for scanner handler?

We deal with a lot of serialized equipment, often hundreds of units on a single order. When there is an error scanning or defective equipment, we’re stuck having to remove the picking worksheet and redo all the pick work for the entire order rather than just swap out a single serial. There’s gotta be a better way than this, that’s crazy to set it up to require all or nothing. 

Hello. I am seeking configuration templates that can be imported for various modules such as Finance, Distribution, Field Service, and CRM, specifically for the versions 2022 R2 or 2023 R1. If anyone possesses such templates and is willing to share them with me, I would be extremely grateful for your assistance. Thank you in advance!

Hi all,Anyone has idea about to use item class as conditions for an approval map?  I have item A. The item class is FLATWARE. I want to use item class as conditions in the approval map. 

We have a customer that has requested that the Related Items screen automatically open in the Sales Order screen if a user enters an inventory id that has related items to choose from.  Our developer has looked into this.  He was able to get the related items screen to automatically open but the changes that the dialog is supposed to apply are lost somehow because we are doing this in the middle of the row update.Has anyone been able to achieve this or have any advice?

Hey everyone,  We have a client adding stock at zero cost into the system using a receipt and then adjust the total cost per line item afterwards with an adjustment. I used to work on the customer side and that’s how we used to add stock not already in the ERP where we needed to add a cost separately. Basically, like an inventory adjustment for goods that have already been paid for. I’m not sure if that’s correct after looking at the GL transactions. Any insight?We are in the implementation phase and I don’t want this to go awry. I think I know the answer but I just wanted some professional insight. 

Where would I find information on 3 way PO matching in Acumatica?

We have a few confirmed shipments which have not generated inventory GL entries through the Update IN function. Further, when I review the shipment itself, the Update IN field is greyed out. The order type is set to Update IN on shipment confirmation, so I am not sure why the Update IN has not run for this order - additionally not sure why I am unable to run it manually through the shipment itself.FYI - The invoice associated with this order has not been released, it remains in Balanced status. 

Hello, in Sales Order GI, the customer CD and Customer Name are displayed from the SOOrder Object.Object:SOOrder and Data Field:CustomerID this gives us customer cd, but when we use same in if condition it is giving us customer DB ID. Can someone please help us. We know we can join BAccount table but can i get customer cd without joining BAccount table.=IIf([SOOrder.CustomerID] >0 , [SOOrder.CustomerID], '0') here the result is Customer DB ID

There is unexpected behavior in the Credit Card Processing for Sales (SO507000) screen that makes the Funds Hold Expiration Date field useless for any automation schedules. As an example, we want to run an Automation Schedule to capture any orders where the Funds Hold Authorization Date is today or earlier, so any card authorizations expiring can be captured automatically before they expire.  However if you create this condition in a schedule to only process those payments, it instead processes everything in the screen.   Another symptom of this can be seen in the screen when you try and filter on the Funds Hold Expiration Date column, nothing is filtered at all, and all payments are displayed (which explains why the Automation Schedule doesn’t process the correct payments).

Hi Acumatica Team, We just want to ask if there is a way to disable Warehouse Location in very transaction?Warehouse Location is not needed features. Warehouse Level is only needed in every transaction. Thank you!

When i am trying to conform the shipment the above error has occurred, so can any tell me why the error was coming and what the solution for that error. 

We have a client who does consignments on items and I am looking to see how others have handled this or if anyone has a direction on it?Thank you in advance. 

I have a customer with a very highly customized Sales Order Invoice form and needs to find a solution for improving the performance of printing the report.  The customizations are specific to an Order Type - format 1 prints for “RO” orders and format 2 prints for all other order types. Creating 2 unique report formats is one option however we would like a solution where the system automatically selects the correct report when the print action is selected.Please let me know if you have any ideas.Thanks!!Michelle

Hello Community,I have a scenario where the prospect not only does the local shipments but also does shipping of the items overseas. Was wondering how can we record the overseas shipments in Acumatica.The flow is like: SO→ Shipments forwarded to forwarding agencies (with invoice & packing list) → Customs Clearance → Delivery to the overseas customer.Thanks in advance.

I am looking for an explanation of these settings on the Ship Via Advanced Fulfilment Tab. 

Using the Fedex plugin on v2022 R1.  We get this error when clicking Confirm Shipment.  The Shop for Rates button works fine.  This is connecting to the Production Fedex account.When using the Test Fedex account, we don't get the error.  It seems there's a setting on the Production account that we're missing?

Hi all,I’m trying to create an import scenario that will help me remove all the categories in all the stock items. But I can’t find the action for delete. I have a file of stock items with their category description.Also, I would like to ask if there’s a way I can have an excel file from Acumatica that includes stock items with their category description? I’m trying the generic inquiry but doesn't seem to work.Thanks in advance.

Hi, I  recently did some research on Acumatica Surveys, I found out that the last release of surveys was compatible with 2021 R1 version of Acumatica. I also found a new tool that was released a year ago called Questionnaire designer an SSS productivity tool. I would like to know if anyone has tried this tool on Acumatica or know of any package for surveys/ questionnaires.

My customer averages 5000 to 6000 Sales Orders records per month, which means that when users go into the Sales Orders List screen (SO3010PL) which is a GI substitute list to find records, the All Records tab shows at the bottom a total (as of today 7/17) 7,784 PAGESwhich are over 155,000 records - SO and RC:They have always complaint about how slow Acumatica is finding records and it’s getting worst as the months go by. We have tried created Tabs, minimizing the quick search fields and so on w/o any luck.ALL RECORDS tab (that is one created by Default by Acumatica) cannot be modified as far as I have tried and we want to find a way to have a second “All Records” tab and all it does, where we can limit the amount of data to show, in this case by last 12 months- as the Default Tab, which is a check mark we know and shared so everyone can see it, as the second tab after the All Records tab no matter how many other Tabs we have, shared or not.The Sales Orders is one of the many PL they wi

I have a situation where a customer has raised a sales order for one item with a quantity of 10.    This line has been allocated a despatch has been created but not yet confirmed.   The customer then has a situation where one of the items cannot be despatched and only require a quantity of 9 to be despatched.   It does allow to amend the shiipped quantity but then reports and error advising the quantity shipped is greater than the quantity allocated.    The only way round this would be to cancel the despatch amend the allocated quantity on the sales order and then recreate the despatch.   Can anyone advise on settings/workarounds to avoid this long winded way of allowing the despatch quantity to be amended?   

If I have a wave pick worksheet with a set of shipments and a few of them are already done. How do I cancel the remainder of the worksheet?Below is a shot of the worksheet I’m trying to remove/cancel. Thank you everyone!

Hi Acumatica, Upon clicking of Prepare Invoice in SO with TR Type. The Invoice Status is already balance though the on hold check box in AR Preferences is enable. Is there a way to make it on hold? So that our approval for invoice might effect. Thanks !