Distribution

Anyone else have issues with autonumbering of duplicate lot/serial’s within the same class?  It seems the system sometimes doesn’t verify that the lot/serial is already used.  It’s infrequent but happens when we have production lines running at higher speeds, there for creating larger number of move transactions.   It is apparent it’s not the intent of the system, but wondering if others are seeing the issue 

Hi,I have created a two-step transfer for a single item with a quantity of 100 kg and subsequently generated a receipt to receive the items. However, in this scenario, the item absorbs moisture, resulting in a received quantity greater than 100 kg. When attempting to enter the actual received quantity, the system displays an error, since the entered quantity exceeds the in-transit quantity, and does not allow the transaction to be saved.Could you please advise if there is any method or configuration in Acumatica that would allow receiving more than the in-transit quantity under such circumstances?Thanks,Nadeeka

Can we create a pre-PO landed cost estimation process in Acumatica? Or is there something already available?We would need to be able to create a non-committal quotation or costing record not tied to a PO: Input supplier quotes (SKU-level or container-level). Add estimated freight, duty, and other costs. Calculate landed cost per item or shipment. Show final estimated unit cost before PO creation. Integrate with master stock list, vendors, currency and exchange rate. Convert to PO if approved.

When creating the kit assembly, the location assigned to the component lines is based on FIFO quantities. How come the lot number doesn’t auto-assign based on this same logic?

For the PO Error: The line cannot be deleted because one or multiple prepayment requests have been generated for this order. To proceed, delete prepayment requests first. I have tested out a few things of voiding the prepayment and removing the item on the prepayment, but is it possible to delete a PO Line with a Voided Prepayment attached? I cannot seem to have any luck. Thanks,RJ 

Looking for documentation to set up kits with options.Can kits be nested together?  We would like to be able to print quotes with the Kit number with the Options listed. Also has anyone been able to use the rules as well. Thanks,  

When an account has a document discount and we add a nonstock processing fee line to the sales order, the document discount percent changes.   It is taking what the document discount amount was prior to nonstock item being added and changing the document discount percentage.  Is there a fix for this?

We were wondering if anyone has ever had any experience with automating sales order processing in some fashion. We have a certain order type - EQ - which is a Quote document - that our sales team sends in to the Acumatica system. Whenever this order type enters the system, we would Acumatica to automatically “REMOVE HOLD” and then subsequently “EMAIL QUOTE”. Any ideas?   

Hi all, I just wonder if there is a way of reversing a pick confirmation without manually scan and transfer the lines individually. Someone made an error and accidentally confirmed the pick for a shipment that hasn’t been physically picked, and the whole stock on the order has been transferred to the van lane. We managed to rectify it with investigating where the stock was auto transferred from at the pick confirmation and we managed to manually transfer each lines back to their original locations, but it would be good to have a reverse option.

If i enter a Sales order for lets say QTY-10 of any item, mark it for PO, create a (non-dropship) purchase order, lower the QTY on the purchase order to 5. (lets say the vendor does not have the full amount)..i would think that i would see another line in the “Create Purchase Orders” screen for the remaining 5.. but nothing shows up… In order to make it show up i need to go back to the SO, Lower the QTY to 5, raise back to 10, and then i get the other 5 to show up in the CPO’s screen..Anyone know why this is? Seems like a bug.

Hi all,I have a client going live on Acumatica soon, and who wants to start using replenishment demand forecast models from day 1. Are there any information out there on importing sales history that will impact the replenishment calculations without impacting inventory o financials? Regards.  

I am attempting to import locations into one of our warehouses.  It is only allowing 10 characters for location ID but I was told 30 characters are available.  Where do I go to increase characters to allow all 30?

Is there a way on acumatica settings except customization to auto pull the default shipping intructions atleast “Ship Via” and “Shipping Terms” fields? Already tried things on Customer class and have default on this.  

Hi all,I was wondering if there is a way to get the system to calculate the unit price/cost by updating the ext price/costUpdating the Unit Price to $700 calculated the Ext. Price to $4,200However, updating the Ext. Price did not automatically update the Unit PriceIs it possible for this to happen?Thanks

We need to 0 the qty of an item that did not come in.When I create the receipt and change the Received Qty to 0, I get error: Quantity must be greater than 0.What is the right process to indicate a receipt is short?

Context:  We are matching purchase orders to vendor bills based on the amount. Since we are not implementing the inventory, we are not using the purchase receipts. The items used are non-stock items.Scenario: In our purchase order, we have a single line item with a quantity of 1 and the full amount entered. Our goal is to perform partial billing. We attempted to create a bill against the purchase order and tried changing the unit cost, because the Amount field is not editable. After releasing the bill, the Purchase Order status changed to Closed (cannot do any AP bill) . When reviewing the PO transaction details, the Billed Amount is shown, but the Unbilled Amount is not.  Question: Are there any steps we may have missed? Is there a known workaround  for this scenario?  Thank you in advance and appreciate your help.   

Hello Acumatica:I’m writing to inquire and discuss what companies are doing to capture data which is required, and will be required in states where EPR, Extended Producer Responsibility is being discussed.  Peerless-AV is beginning a study of what products we will need to report on all of our packaging, where it is being sold, and what our cost for compliance will be in each state.   One question is, what is Acumatica researching as far as solutions for EPR.  A second question is, how are companies handling this today? My understanding of the requirement is, the material that makes up our packaging will need to be broken down into the materials that fall under the requirement.  Then, based on how much of these materials are used in packaging a particular item, we will need to extend that to a project cost we will have to pay the governing body based on how much we ship to any particular state. Here is a website that discusses the regulations: https://epr.sustainablepackaging.org/ Is an

Hello,Created some custom boolean fields, but they are not displaying as checkboxes in the sales order, despite the control type being checkbox…. They are showing as text edit fields, then if you put anything in there they change to 'true'

When assembling stock kits using items that have lots assigned, is there a way to more efficiently do the lot assignment? Currently it seems like you have to go into the line details tab for every single item in the kit. We have some kits that may contain over 50 different items, all lot tracked. It is exceptionally tedious to have to click into line details for every single item to enter the lot.I understand that Acumatica is designed so that you could use multiple lots for an item where you have multiples of the item in the kit, so you can’t have the lot assignment field on the main kit assembly page. There is also no upload button on this page for doing the assignment more efficiently in a spreadsheet and uploading.

Hi! For items with fifo costing, is there a way to see what the actual margin would be on a sales order? The margins on sales orders screen use average costing so it's not helpful for my client. Also, I'm looking at Inventory Summary report and same thing it provides the average. Does anyone know where to find the current fifo cost before the items have been issued/shipped?

Customer uses their own trucks to deliver large shipments of construction materials to a job site. They are seeking a solution to collect a signature on BOL at the delivery, print and write back to the ACM shipment.Any thought of suggestions for a solution ? 

Hi everybody,is it possible to create a contract from a sales order? For example: I sell software for a monthly fee. I have the non-stock item “software usage” in my sales order. Can I now create a contract based on the sales order?Kind regardsMichael

Error: The Confirm Shipment action is not available in the Shipment: Shipment Nbr. = 000009 document at the moment. The document is being used by another process.When i am conforming the shippment the following error has occured.

Looking to see if the rest of the room has any creative ideas to accomplish this. We create orders with multiple pieces.  Some of the pieces are in stock and the other pieces may need to be sourced.  You can go in and allocate a serial number but it still allows another order to allocate it until someone tries to confirm a shipment (Hard transaction).  Then it stops you due to being allocated to multiple orders.   How can i allocate an item where it won’t allow someone else to choose/allocate it as well?  (Pack and Hold electronically).  

This question was asked 4 years ago.  I have the same issue.  However, I think the solution provided in this topic is frankly unacceptable.  Unless of course, I’m missing something obvious.Issue with displaying Inventory ID in mobile app | CommunityIn my GI, I am displaying the Inventory CD.  Looks great when viewing on the site.Per the link above, when the GI is displayed on the mobile app, the Description field is shown, not the inventory CD “by design”.  Well, that doesn’t seem like a good design.If I follow the old link, I have to uncheck the Expose to Mobile App and basically, rewrite the entire GI as a new mobile screen.  By exposing the GI to the mobile app, it is doing everything we want except for actually displaying an inventory id (cd).  There HAS to be some way to modify the GI results grid to show the Inventory CD in the mobile app without recreating the ENTIRE page on the web app.Has anyone else figured a workaround for this? EDIT:  I meant to create this in the Develop C