Inventory, Orders Management, Warehouse Operations
- 1,423 Topics
- 5,512 Replies
Hi,We are using the Receive and Put Away function in Acumatica.When we scan in the Regular Acumatica Application (on our desktop), there are three distinct sounds for:Correctly scanned barcode Scanning error Release actionProblemWhen we scan in the Acumatica mobile app, there is only sound for correctly scanned barcodes. There is no sound at all for the other two (scanning error and Release action). Is there a setting in the Acumatica mobile app to enable these two sounds?
Hi there,Let’s say that I am creating a picking worksheet record.On the Create Pick List screen I specify the max number of pickers is 1 and create a picking worksheet transaction. After I create a picking worksheet record I realize that I would like to have 2 pickers rather than 1 for this particular worksheet.Can I add a picker to the pickers tab of the Picking Worksheets screen after the worksheet has been created OOTB? Either this is should be customized?Thanks in advance!
Hi everyone, I’m implementing Requisitions / Purchasing and have run into a problem due to the following requirement: PO receipt needs to have a net 0.00 impact on the GL, because COGS/expense needs to wait until the AP bill is created. But also need subaccount to be editible on the AP bill. My solution was to put the same account as both PO Accrual and COGS on the non-stock item, so receipt is a wash. If I use the expense account for both, it shows up on the AP bill. But the subaccount is not editable on AP bill if the line is from a receipt. I see the reason for this because the AP bill should always debit the credited account/sub from receipt, but in this case the receipt already offsets itself. I believe the simplest workaround is to skip receiving since these are non-stock items, but I’ve been told that is not a viable option from their process perspective. Would love to hear any ideas! Thanks!
HiI have a requirement to record the serial numbers of a receiving batch at once using the serial number of the box/Cartoon.Example : One box of items contains 100 units which has 100 serial numbers. Without opening the box and scanning them item by item, need to receive 100 items with the 100 serial numbers by scanning a serial number available for the box. The supplier provides the 100 serial numbers and the box serial number in excel before we receive the shipment. How is this possible in Acumatica?Best Regards,Dulanjana
Cannot transfer items even there is sufficient available/ onhand qty. It validates against a hard qty
Hi, We have an item that shows that there are 73 units available and on-hand qty = 73 as well for a particular lot (inventory summary) However, when we are trying to do a transfer, and it won't allow us to transfer our more than 27 items.Ge the following error: IN Error: The document cannot be saved because the quantity of the MAIN-LBL-SANSBURY-TU-WCWEF-R item with the 000 PAR SAI T1810 ARLO CHARCL lot number is not sufficient for shipping in the D2 warehouse. To be able to save the document with the On Hold status, clear the Allocate Items in Documents on Hold check box on the General tab of the Inventory Preferences (IN101000) form. We could see that in the PX.Objects.IN.INSiteLotSerial, the hard available quantity for this material is 27. Where is this value set from? and this is where the validation gets triggered. What is the difference between hard availability and availability? Does anyone know what the issue here? Thank you!
I have a custom GI (attached) that shows SOs left joined to CRActivity. The purpose of this report (and join) is to find SOs that don’t have a task attached that has the name “Next Checkin”. This is how we make sure orders are being checked up on regularly.The full listing looks fine, but the filtered results show blank pages. If I skip forward a number of pages, it might show 1, 2, 10, or really any weird number of results. If I sort by SO number descending, all the non-blank results come to the top of the listing. However, adding a condition that eliminates all records with empty SO numbers, or SO numbers that are equal to ‘’ has no effect.Any thoughts on how to get rid of these blank records?
We have Avalara Tax and address validation set up and it is properly validating the address. However, even though the “Override Address Automatically” is checked, the address is not being overridden. It just gives the user the information and the user must override manually.Has anyone got this to work?For example, in the below case, we are expecting Acumatica to change the Zip code from 11201 to 11201-1000. Instead, Acumatica just gives the user the information in the tooltip. This is our configuration:
We created a Customer Sales Price specific to warehouse: Prices aimed to a particular warehouse.This is a Sales Price Worksheet. On a Sales Order for the customer the customer price for the warehouse updateOn at Project Quote for the same customer the sales price is not updating from the Sales Price worksheet. The Customer setup for shipping instructions is setup for a default warehouse.Is this correct that the Project quote does update on the warehouse setup for the customer
Hello Acumatica Community,As a boat manufacturer, we procure aluminum in bars and send them to an external company for cutting into sheets. How can we effectively track this process in Acumatica, to keep consistency with Item IDs and managing Unit of Measure (UOM) conversions seamlessly?Please share your insights. Thanks!
Hello Community, I have a custom screen for demand planning, they capture data in a range of two days. The SOs are shipped in a ranger of 2 days. I am building a dashboard that shows the actual orders against the demand table. The join is requested on date from the SOOrder table and date1 on the demand table. This join omits the data which should be linked to Date2. eg if there was actual 2 orders on the first requested on date and 3 on the second requested on date it won’t show 5 on the sum in the dashboard because the parameter is requested on date. Is there a way joining the tables such that requested on date is linked on both demand date1 and date2.Below is my joinThese are my dashboard parameteres
Hi All, I am currently experimenting with related Items.When selecting the Required Checkbox of Cross-Sell, I would expect that I cannot process the Sales Order without adding the Required Related Item.This does not seem to be true. Can somebody let me know what the intended functionality is if not requiring a User to add those Items?
Before knowing that Template/Matrix Items existed, and how they worked, a number of sets of various related Stock Items were created individually (most with associated BOMs). For simplification of maintenance and development moving forward, I would like to convert these existing related Stock Items to Matrix Items. Is there a prescribed methodology for doing so?
Our customer returned an item and we issued their money back. I did a RC to return the inventory item back, issued the CM and refunded the credit memo all for the full amount. However, they are paying a restocking fee so now I have a balance leftover. The CM is still showing as open. How do I close the loop and process the restocking fee?
Hello,In the Process Orders screen, set the action to “Create Shipments”:It shows all sales orders within the selection dates.Even if there is no quantity in inventory.Shippers want to use this screen to ship everything they can, and this screen if perfect for that. However, they only want to see what can actually be shipped. There is no quantity on hand or quantity available shown that you can filter on. Am I missing something here?Is there another screen that will allow them to see all SO lines with an available quantity that they can ship from?I could write a GI or something, but then they have to open to SO and ship from there. Shipping people shouldn’t need to ever open a sales order to ship it.Thanks!
I am wondering if Acumatica has the ability to do this:We have metal coils we purchase by the pound. We purchase different thicknesses and colors. All coils are the same width. We want to make templates of the coils so that we can order custom lengths for each one, but we do not want to create thousands of individual part numbers that would all have to be managed individually. Creating them using the matrix feature, all of them can be managed through the template item. The question comes in with the UOM conversions. As mentioned, we purchase these in pounds, but we will be selling these in each. The resulting sheets that will be cut down to the ordered length will vary in its dimension. A customer could order any length, what I need to figure out is how to cost that, based on the template item. I assume that I need to use the conversion table some how but I cannot figure out how to make it work correctly. Each matrix item created from the template would have a different weight, based o
When I’m creating a new vendor after the save event on the same vendor a pop-up note gets added automatically and I’ve not configured any notes to show up after saving the new vendor neither there is any customization for that. If someone has idea how the pop-up note auto populates at the time of save please do help e with the steps or how I can disable it.
What is the difference between the Non-Stock Kit Standard Cost and Non-Stock Kit Standard Cost Plus Stock Component Cost?Our current setting is Non-Stock Kit Standard Cost We have a new Kit item including a stocked and non stock components. The sale profitability only pull the cost of the non-stock component of $50, and exclude the cost of the stocked component of $3,160.50. From my understanding, this Ext. Cost from the Issue transaction should be pulled into the Cost on the Sales Profitability. Should I update the setting to Non-Stock Kit Standard Cost Plus Stock Component Cost?
We’ve recently gotten a new warehouse that will use a new order type. We want to be able to print the pick tickets directly to that warehouse only from that specific order type. I am unable to find directions to do this… I have added the new printers in device hub, they’re seen in Acumatica and active, I just cannot for the life of me figure this out.Thank you so much for taking the time to look at this
We want to create a report with item mages and send the report via a busines event. The report would have a customer’s prior item purchases with the each item’s image from the item’s “attributes”. Is there a way in the same report to have an item’s description, the item’s purchase history, and the the item’s image from item attributes in the same report?
I have Items pertaining to Different Item Class which i need to use diff GL account while Issuing Item . There is Already an Issue REASON CODE thats is getting used default whenever i make an Issue . How to stop using reason Code and use COGS Account from Posting class while Issuing the Item
Hey Folks, wondering if anyone has had any challenges with some of the “TOTALS” metrics on the SO. We are looking to understand how the Unshipped Amount is calculated on a SO because it does not match the formula presented:The formula per the HELP icon is:The sum of unshipped amounts calculated for the lines with nonzero unshipped quantities of stock items. The unshipped amount for each line is calculated as the amount in the Ext. Price column (after Line-level discounts were applied) divided by the line quantity (the Qty. column) and multiplied by the unshipped quantity (the Open Qty. column). At the moment of order creation when no item quantities are shipped, the amount is equal to the Line Total; this total does not include any freight amount. This box appears only if the Inventory feature is enabled on the Enable/Disable Features form.Metrics:As you can see the Unshipped Amount = 7,336.54 If you review the lines for the particular SO in question we see:It seems like the Unshipped
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.