Distribution

Dear Connections,I have a question about paperless picking because I am now unable to finish it even if the picking volume is smaller than the shipment volume.In some circumstances, the shipment quantity can be "10." Actually, I have the necessary (Oh-hand =10 Qty) shipping quantity in my warehouse. Unfortunately, "2" pieces were broken. In order for me to choose only "8" quantity. As of right now, the process was interrupted at the picking level. The "complete line level" option that mobile apps have does not help me finish my selection procedure.Can anyone offer advice? Thank You RegardsRam 

Hello Community,I have been trying to let the system recalculate the values upon Currency Overriding in the Invoices & Memos (AR301000) form. Here, when I override the value from USD to KHR, the Detail Total doesn’t get calculated. Would like to know if I am missing out here something. Kindly guide me.Thanks in Advance.​​​​​​​

HiWe have very strict controls in place around purchasing, and have realised that users can receipt lines that do not come from a PO (direct purchase receipts).  How do we prevent this, is there a switch that we can switch off to prevent it, or is our only option to remove the “+” off the line using roles?

Good Morning all,   we are in the beginning stages of Acumatica; my question here is on the process to send out a PO to the supplier/vendor.We are currently having to -create a PO   approval process  when fully approved we manually print our PO manually send it to supplier/vendor  and finally manually maintain confirmations to track order. is there a way like other ERP systems to have Acumatica auto generate and auto send PO to email on file? if anyone can provide literature or details on this. 

On a Sales Order, I am able to set an item as mark for PO and create a drop ship PO that is linked to the SO line. Am I able to go backwards - create a drop ship PO (manually, not through the SO) and then link back to the SO? 

I have a created an assignment map for Purchase Requests and assigned it to the Purchase Requisition preferences. No matter how I configure it when I create a request it doesn’t assign it to the workgroup. I can see other areas where Assignment maps are used require a a process to be run to assign the owner and workgroups. . For example, Cases, Contacts, and Opportunities. No such process exists for assigning requests. Any idea on how I can get this to work? 

Good Day, I am just a newbie here. Can someone explain to me what this error message means?I am trying to check the “Release LC IN adjustment automatically” but every time I am trying to save it this error appears.  

Hi ,Version -22R1Added one Custom Ware house Selector Client wants to Change the Custom Selector of Warehouse When he changed the Selector Value According to the value in the Detail level three fields data has to change   Tried Modified data view using delegate but it is not affecting and tried writing code in Row Selected event then also it is not working please suggest me with the Solution         INReplenishmentFilterExt ext = filter.GetExtension<INReplenishmentFilterExt>();        if (filter.ReplenishmentSiteID != ext.UsrPurchaseWarehouse)        {                foreach (INReplenishmentItem item in Base.Records.Select())            {                INReplenishmentItem Rep = PXSelectJoin<INReplenishmentItem, LeftJoin<INItemClass,                On<INReplenishmentItem.FK.ItemClass>>,        Where<INReplenishmentItem.siteID, Equal<Required<INReplenishmentItem.siteID>>,            And2<Where<                Current<INReplenishmentFilter.ite

When a user enters in a Customer, Vendor, Contact, Ship to Address, (anywhere where the zip code is part of the address);  the user would like to enter address line 1, zip code, and then have it auto populate the City, State and Country.  We are converting a client from Sage and they are showing how the process works.

Hello Everyone.I would like to understand the functionality of Avg cost in sales order I have reviewed the Stock Item Price cost and observed that avg cost is 256.85 but in My sales order when the SKU is selected it is showing 303.50Further, I verified and observed the avg cost value is coming from the inventory summary- Estimated cost columnJust want to understand why the estimated cost value is not updated on the avg cost details under that SKU or else do we have functional calculations on this?Any thoughts on this? Also, share the article if you have anything related to this. Notes: All receipts are released, No pending transactions for this item with the respective purchasing side

Can holdiays be blacked out when putting in an order so that we do not have a ship date of a date we are not in the office?  

Hello,  We had our ACM set up via a third party so have had little training on any sort of customisations.  How do we change the invoice layout they have created for us? We need to add our own bank details on there so customers can pay us! 

 We are currently working with a client who wants to configure a vendor-consigned workflow in Acumatica using the out-of-the-box functionality. However, we have encountered a challenge in setting up the workflow due to the accounting treatment of consigned inventory usage. When the vendor's consigned stock is consumed in a production order, the system creates a Journal Entry that hits the Cost of Goods Sold account. But when we subsequently bill the vendor for the inventory used, the Accounts Payable bill also hits an expense account, resulting in a double recording of the cost. Any suggestions on how to manage such a scenario in Acumatica. 

Hello,trying to add a document level discount to a SO Import Scenario where the SO could have multiple lines. Not sure exactly where to put the discount in order of operations, but i’ve been trying to follow the order of tabs in SO screen.   I have also tried to put the discount above the ‘line details’. In this example the SO will have 2 lines, and i’m getting following error on the 2nd row (this example puts the discount after the ‘line details’ are entered - see XML):  I have attached the XML for reference. Any help is appreciated!Cheers,k2​​​​​​​

Does anyone know how to make the Qty to Supply field in Prepare Replenishment round down?  Currently any decimal amounts for parts with a UOM of ‘EACH’ is round up to the nearest whole amount. We would like it to round down.  Is there a way to do this? 

After setting the Payables Price Settings to fixed for "0" months, I can still only see the last vendor purchase price that was used to purchase from a Vendor. On the Inventory Stock Item - again I can only see the last Inventory price that was processed by the system. Since by implication the preferences indicate that the vendor purchase prices are retained, please advise where the list of those retained prices are for dealing with a vendor (It cannot be in the stock transaction history, as that does not relate to the Vendor)?

I know how to create volume-based price breaks for individual items in the Sales Prices worksheet. However, it would be a lot more convenient if we could set volume-based price breaks at the item class level. For example, if the customer orders over 1000 lbs, then reduce the base price by 10%.Is it possible to do this in Acumatica?

We operate a wholesale business where all of our customers are assigned a discount level off of our list price.  Some customers also have customer specific prices on a few items that we have negotiated.  This was a simple structure to manage in quickbooks using pricing rules but seems to be very complex to set up in acumatica.  Wondering if anyone else has come up with a good way to make this work in acumatica.Our challenges:Utilizing Sales price worksheets we can set up a worksheet for each discount level using customer price classes.  We can also set up a customer specific worksheet for the special pricing some customers receive. Both of these function perfectly.  Our problem is that we add items on a daily basis and using the above method we will have to manually create a new price worksheet for every new item we create.  Utilizing Discount codes we can set up a discount code for each discount level and assign those to our customers however these discounts apply to everything includ

Currently when using the scan and issue or scan materials screen, Acumatica defaults to adding 1 unit to the line that you have scanned. In our industry, nearly everything is weighed out and we need our operators to always enter the qty that is on their scale. Is there a way to adjust the settings in Acumatica to default to setting the qty in the scanning modules?

Is there a way to record in a purchase receipt the country of origin of parts received? Sometimes I’ll order parts from a vendor and I won’t find out what the country of origin is until I look over the packing list. 

HICan someone please tell me why is there a default Sales account and Subaccount on Sales Order type screen?and that it takes preference over Item's Posting classes?What is the logic behind that?  

I have queried both tables separately but can’t find anything that matches between the two.Thanks for your help 

Hello Everyone!I have query, hope you guys can help me out. We have an existing inventory list, all of which LREX is not enabled...but now we want to enable the LREX monitoring, is this possible? What are the conditions e.g. should the qty be zero? is it set in the PO stage of getting new qty of the inventory item? Are there any more conditions? Also how can I apply the LREX monitoring to the existing qty of items? Thanks in advance!Kind regards,Mrivera67

Introduction:I wanted to pull a specific list of inventory items from a generic inquiry.  Problem: I tried to use "Is In" operator for a condition. However, it does not seem to work as expected. (I tried various combination while profiling and could not get the SQL to translate to [column] in ('test123', 'test456', 'test789')) If there is a way to use the "Is In" operator, please share. Solution:Add a parameter to enter the list of items. (Set the Schema Field to InventoryItem.Body for maximum characters) In Result Tab, add a column that utilizes "InStr()" to search for the InventoryCD in the parameter field. (Convert to CDec() for better filtering)Paste a list of item numbers and filter the formula column “greater than” zero. I hope this helps.