Inventory, Orders Management, Warehouse Operations
- 1,324 Topics
- 5,125 Replies
The “Sold Since Functionality of Inventory Lookup in Sales Orders” seems doesn’t work properly. Any idea how to fix it?(In addition, sometimes the date picker is visible and some times It doesn’t).Used Acumatica version - 22R1Used data set - I100Relevant snaps are attached below:when All items radio button is selectedwhen Sold Since radio button is selected
Hello, My company has a generic inquiry they use to show when items will go on back order at the line item by using this comparison in the conditions tab of the generic inquiry.So we are wanting to see items where the quantity available is less than the quantity ordered. Simple enough. However, the QtyAvail from the InSiteStatus table seems to be subtracting the qty from the order quantity first, then making the comparison. Therefore, we are seeing items on this GI where they may be 400 available and 300 ordered. But the “Qty Avail” in the GI is saying 100 available, because it already pulled the 300 for that order. So it is showing that order on the report, even though that one is good. Any ideas on how to fix this, or maybe another better way to show items that are going to be put on Back Order? Thanks!
Hello,We use Pick, Pack, and Ship in our warehouse to process packages which ship via UPS.Recently we noticed the declared value on these packages is $0.0.Where does the system look for the value? (It would make sense for it to default from the MSRP field in the stock item.)I cannot find a setting/documentation that helps; Can’t imagine that the system expects it to be entered manually every time. Thanks for your help.
I have a bunch of Android Tablet users who would like to print .ZPL files from a Zebra Label Printer. Usually I use DeviceHub or a .bat file to get this moving, but Android doesn’t support .bat and it looks like DeviceHub isn’t supported either.How do we print .ZPL files to a label printer in the Android OS?
Client sells to Distributors, Chains, Retail Outlets. They can ship the same item in a Pallet, Master Pack, Inner Pack or Each. For the purposes of compliance, they have to provide the weight and dimension of each of the shipping methods, although the UOM on the SALE is EACH. We have Acumatica and Pace Jet and are looking to see if someone has tackled this before and is there a way to best handle this other than attributes?
We are not using WMS (yet). How do you handle shipping pallets and pallet costs? We have a mix of stock items that are finished goods and BOM-based goods so doing fixed overheads I don’t think would work. We have 7 different pallet sizes we have as stock items since we track inventory on them, cost and if we charge the customer for it. We also have mixed item pallets so while we know item X is 60 to a pallet, Adding Item A, B, C, D and E may not be 60 to a pallet any more due to variations in size of the box, etc. With our current system we have 1 stock item pallet. The sales person enters the sales order, adds the stock items and if we charge for the pallet they enter a price. When the warehouse picks/ships the order they add the pallet item to the sales order at $0 (unless sales person added it already with a price) and the quantity of pallets used. That follows through to the invoice and shows the pallet quantity and how much they were charged (if anything). With Acumatica we
Hello Everyone,I am playing around with various costing method scenarios in right now. Let’s say I enter a PO for 10 of an item at $100. This item is costed at FIFO. Let’s say the accompanying AP Bill is for $120. I understand there will be $20 going to PPV and $20 going to Purchase Accruals. The cost of the item stays at $10/unit even though the bill was for $120. Is there anyway to retroactively update that item’s cost to $12/unit for this PO/Receipt? If anyone has suggestions or ideas that would be great. Maybe there is an industry standard.Thanks
Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen. I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.
How do I find the last Date an item was physically counted in the system?For example:Item A was counted last on March 10th Item B was counted on February 14thIs there an inquiry like this? If not, does anyone know what data table would hold this information so I can make an inquiry? Thanks Everyone!
Hi All, We are the option of adjusting the Unit Price for a Sales Order after a Shipment was created and/or completed. In Sales Order status language in the Status of Shipping/Back Order/Complete.The Invoice won’t be created yet. And the goal is to have the Order and Invoice match up in case of Error on original Price Entry and it going through Approval without being caught. I tried Workflow Adjustments and Graph Extension on the SOOrderEntry Graph but wasn’t able to Enable the Unit Price field. I tried both Cury Unit Price and Unit Price. Any ideas on how to achieve this or is this something that Acumatica just doesn’t allow due to being too risky/invasive?
Hi, I have updated the Access right via Import scenario. It updated high level access security. Ex. We enabled Funds Transfers as view only, but, system allow us to do the reverse when i open the funds transfer form. Is there any possibility to restrict all the levels at once? Regards
One of my clients sells magazines. Historically their item MAGAZINESKU was purchased as a finished good from a single vendor who produced the entire item. Now, however, the magazine is being produced by two vendors. One produces the covers (COVERSKU) and the other produces the inside pages (INSIDESKU). These are still sold as the MAGAZINESKU item. What is the best way to go about purchasing COVERSKU and INSIDESKU then assembling them to create the finished good of MAGAZINESKU in inventory?If I was starting from a blank slate, this seems like a clear Stock Kit with Kit Assembly. However, MAGAZINESKU already exists as a Finished Good and it is NOT already setup as a KIT. I do not believe I can simply convert it to a kit. Acumatica Cloud ERP 2022 R1Build 22.114.0029 Distribution EditionThanks, David
We have a need to be able to put multiple replenishments on a single item within the same warehouse. Our case for it is that our inventory control teams need to be able to deliver an item to a production line (Warehouse) in different locations. We use a Warehouse in Acumatica for each production line. But we can’t apply a replenishment for that warehouse because we have a single item occur multiple times on that production line. So we have to use a 3rd party system to notify our inventory control team to deliver the items to the production line. We would love to be able to no longer use that system but rather utilize the replenishment through transfer feature in Acumatica. Any suggestions would be great!
Our company often receives one line on a PO across multiple deliveries, requiring multiple Purchase Receipts to complete the line.We would like to ease the AP workflow by using ‘Automatically create AP bills’, but we have found that Acumatica only allows one (unreleased) AP Bill for each PR. Our accountant has to manually find each purchase receipt, click ‘Create AP bill’, release the AP Bill, then move on to the next PR. For hundreds of PRs, this becomes rather tedious.Is there any setting to enable the creation of AP Bills from each PR one-to-one without having to release the AP bills beforehand?Preferably, AP bills would be automatically created each time Logistics releases the PR, then Accounts just needs to batch release using Release AP process.
Trying to import sales orders but some of the lines have invalid inventory ID’s that do not exist in Acumatica. I still need to import the lines that do but they all fail because of the inventory items that don’t exist. How can I skip invalid inventory line and get the rest of the file to import.The import works if I only import inventory ID’s that are in Acumatica.
We are trying to extract and update the base sales price using either ‘Sales price’ or in the ‘Sales price worksheet’ then using the copy prices option. When we click on the ‘create worksheet’ or ‘copy prices’ we get the below error:An error occurred during processing of the field UOM value LENGTH Error: UOM 'LENGTH' cannot be found in the system. Please verify whether you have proper access rights to this object.We have tried to change the UOM for the rows with Length but we just get the same error but with the UOM we changed it to mentioned.Any suggestions?
Hi,We would like to disable the access to the (+) button for manual addition of new lines in Purchase Receipts. All lines should be linked to a PO.However, we do not want to take away the (x) button for deleting lines, since the Purchase Receipt may require amendments after being created from the Purchase Order.I have not been able to disable the (+) button without also disabling the (x) button, as the Delete access right also gives access to creating new lines. Any ideas on how to implement this restriction?
Client has a 5 page Terms & Conditions for the want to have sent with their PO. It has word-level formatting which would be time consuming to replicate in report designer. I tried adding a PDF version of the T&C’s to the email template but it doesn’t carry over when I send a PO out of the system using that template.Outside of writing the report does anyone have an easier method of attaching a document to a template that isn’t a report?
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.